Package com.cyran.tp.server.orders
Interface CardsRepository
- All Superinterfaces:
org.springframework.data.repository.CrudRepository<CreditCard,java.lang.Integer>
,org.springframework.data.jpa.repository.JpaRepository<CreditCard,java.lang.Integer>
,org.springframework.data.jpa.repository.JpaSpecificationExecutor<CreditCard>
,org.springframework.data.repository.PagingAndSortingRepository<CreditCard,java.lang.Integer>
,org.springframework.data.repository.query.QueryByExampleExecutor<CreditCard>
,org.springframework.data.repository.Repository<CreditCard,java.lang.Integer>
public interface CardsRepository extends org.springframework.data.jpa.repository.JpaRepository<CreditCard,java.lang.Integer>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CreditCard>
Credit cards repository for making query to cards table
- Author:
- Jakub Perdek
-
Method Summary
Modifier and Type Method Description java.util.List<CreditCard>
findAll()
Gets all credit cardsCreditCard
getCreditCard(java.lang.String iban)
Selects card according ibanvoid
insertCreditCard(java.lang.String iban, java.lang.String valid, java.lang.String cvc)
Inserts new credit card to databseMethods inherited from interface org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save
Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush
Methods inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor
count, findAll, findAll, findAll, findOne
-
Method Details
-
getCreditCard
@Query(value="SELECT * FROM cards WHERE iban = ?1 LIMIT 1", nativeQuery=true) CreditCard getCreditCard(java.lang.String iban)Selects card according iban- Parameters:
iban
- - iban of the card- Returns:
- credit card with given iban
-
insertCreditCard
@Query(value="INSERT INTO cards(iban, valid, cvc) VALUES (?1, ?2, ?3)", nativeQuery=true) @Modifying @Transactional void insertCreditCard(java.lang.String iban, java.lang.String valid, java.lang.String cvc)Inserts new credit card to databse- Parameters:
iban
- - iban for a cardvalid
- - validation code for cardcvc
- - cvc code for a card
-
findAll
java.util.List<CreditCard> findAll()Gets all credit cards- Specified by:
findAll
in interfaceorg.springframework.data.repository.CrudRepository<CreditCard,java.lang.Integer>
- Specified by:
findAll
in interfaceorg.springframework.data.jpa.repository.JpaRepository<CreditCard,java.lang.Integer>
- Returns:
- all credit cards from database
-