Interface SymbolAliasRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<SymbolAlias, Long>, org.springframework.data.jpa.repository.JpaRepository<SymbolAlias, Long>, org.springframework.data.repository.ListCrudRepository<SymbolAlias, Long>, org.springframework.data.repository.ListPagingAndSortingRepository<SymbolAlias, Long>, org.springframework.data.repository.PagingAndSortingRepository<SymbolAlias, Long>, org.springframework.data.repository.query.QueryByExampleExecutor<SymbolAlias>, org.springframework.data.repository.Repository<SymbolAlias, Long>

@Repository
public interface SymbolAliasRepository
extends org.springframework.data.jpa.repository.JpaRepository<SymbolAlias, Long>

Data-access layer for SymbolAlias.

Version:

3.0.6

Author:

Stephen Prizio

Method Summary

Modifier and Type	Method	Description
SymbolAlias	findSymbolAliasByAliasAndDataSource(String alias, DataSource dataSource)	Looks up a SymbolAlias by its alias and data source.
SymbolAlias	findSymbolAliasByAliasAndSymbol(String alias, Symbol symbol)	Looks up a SymbolAlias by its alias and symbol.
List<SymbolAlias>	findSymbolAliasesByAlias(String alias)	Returns a List of SymbolAlias for the given exact alias.
List<SymbolAlias>	findSymbolAliasesByAliasLike(String alias)	Returns a List of SymbolAlias for the given alias.
List<SymbolAlias>	findSymbolAliasesByAliasType(SymbolAliasType aliasType)	Returns a List of SymbolAlias for the given SymbolAliasType.
List<SymbolAlias>	findSymbolAliasesByDataSource(DataSource dataSource)	Returns a List of SymbolAlias for the given DataSource.
List<SymbolAlias>	findSymbolAliasesBySymbol(Symbol symbol)	Returns a List of SymbolAlias for the given Symbol.

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

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

findAll, findAllById, saveAll

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

findAll

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

findAll

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

count, exists, findAll, findBy, findOne

Method Details

findSymbolAliasByAliasAndSymbol

SymbolAlias findSymbolAliasByAliasAndSymbol(String alias,
 Symbol symbol)

Looks up a SymbolAlias by its alias and symbol.

Parameters:

alias - alias

symbol - Symbol

Returns:

SymbolAlias

findSymbolAliasByAliasAndDataSource

SymbolAlias findSymbolAliasByAliasAndDataSource(String alias,
 DataSource dataSource)

Looks up a SymbolAlias by its alias and data source.

Parameters:

alias - alias

dataSource - DataSource

Returns:

SymbolAlias

findSymbolAliasesBySymbol

List<SymbolAlias> findSymbolAliasesBySymbol(Symbol symbol)

Returns a List of SymbolAlias for the given Symbol.

Parameters:

symbol - Symbol

Returns:

List of SymbolAlias

findSymbolAliasesByAlias

List<SymbolAlias> findSymbolAliasesByAlias(String alias)

Returns a List of SymbolAlias for the given exact alias.

Parameters:

alias - alias

Returns:

List of SymbolAlias

findSymbolAliasesByAliasLike

@Query(value="SELECT sa.*\nFROM symbol_aliases sa\nWHERE similarity(sa.alias::text, CAST(:alias AS text)) > 0.2\nORDER BY similarity(sa.alias::text, CAST(:alias AS text)) DESC LIMIT 1000\n",
       nativeQuery=true)
List<SymbolAlias> findSymbolAliasesByAliasLike(@Param("alias")
 String alias)

Returns a List of SymbolAlias for the given alias.

Parameters:

alias - alias

Returns:

List of SymbolAlias

findSymbolAliasesByAliasType

List<SymbolAlias> findSymbolAliasesByAliasType(SymbolAliasType aliasType)

Returns a List of SymbolAlias for the given SymbolAliasType.

Parameters:

aliasType - SymbolAliasType

Returns:

List of SymbolAlias

findSymbolAliasesByDataSource

@Query("SELECT sa\nFROM SymbolAlias sa\nJOIN FETCH sa.symbol s\nWHERE sa.dataSource = :dataSource\nORDER BY s.name ASC, sa.alias ASC\n")
List<SymbolAlias> findSymbolAliasesByDataSource(@Param("dataSource")
 DataSource dataSource)

Returns a List of SymbolAlias for the given DataSource.

Parameters:

dataSource - DataSource

Returns:

List of SymbolAlias