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 cards
    CreditCard getCreditCard​(java.lang.String iban)
    Selects card according iban
    void insertCreditCard​(java.lang.String iban, java.lang.String valid, java.lang.String cvc)
    Inserts new credit card to databse

    Methods 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

    Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

    findAll

    Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

    count, exists, 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 card
      valid - - validation code for card
      cvc - - cvc code for a card
    • findAll

      java.util.List<CreditCard> findAll()
      Gets all credit cards
      Specified by:
      findAll in interface org.springframework.data.repository.CrudRepository<CreditCard,​java.lang.Integer>
      Specified by:
      findAll in interface org.springframework.data.jpa.repository.JpaRepository<CreditCard,​java.lang.Integer>
      Returns:
      all credit cards from database