Package com.bytedesk.ai.statistic_token

Interface StatisticTokenRepository

All Superinterfaces:

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

public interface StatisticTokenRepository
extends org.springframework.data.jpa.repository.JpaRepository<StatisticTokenEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<StatisticTokenEntity>

Nested Class Summary

Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T extends Object>

Method Summary

Modifier and Type	Method	Description
Boolean	existsByUid(String uid)
List<StatisticTokenEntity>	findByOrgUidAndAiModelTypeAndDeletedFalse(String orgUid, String aiModelType)	Find AI token statistics by organization and AI model type
Optional<StatisticTokenEntity>	findByOrgUidAndAiProviderAndAiModelTypeAndDateAndHourAndDeletedFalse(String orgUid, String aiProvider, String aiModelType, String date, Integer hour)	Find AI token statistics by organization, date and hour
List<StatisticTokenEntity>	findByOrgUidAndAiProviderAndDeletedFalse(String orgUid, String aiProvider)	Find AI token statistics by organization and AI provider
List<StatisticTokenEntity>	findByOrgUidAndDateAndAiModelTypeOrderByHour(String orgUid, String date, String aiModelType)	Get hourly AI token statistics by organization, date and AI model type Returns data grouped by hour for a specific date and AI model type
List<StatisticTokenEntity>	findByOrgUidAndDateAndAiProviderOrderByHour(String orgUid, String date, String aiProvider)	Get hourly AI token statistics by organization, date and AI provider Returns data grouped by hour for a specific date and AI provider
List<StatisticTokenEntity>	findByOrgUidAndDateAndDeletedFalse(String orgUid, String date)	Find AI token statistics by organization and date
List<StatisticTokenEntity>	findByOrgUidAndDateBetweenAndDeletedFalse(String orgUid, String startDate, String endDate)	Find AI token statistics by organization, date range
List<StatisticTokenEntity>	findByOrgUidAndDateOrderByHour(String orgUid, String date)	Get hourly AI token statistics by organization and date Returns data grouped by hour for a specific date
Optional<StatisticTokenEntity>	findByOrgUidAndTypeAndDeletedFalse(String orgUid, String type)
Optional<StatisticTokenEntity>	findByUid(String uid)
BigDecimal	getTotalCostByOrgUidAndDateRange(String orgUid, String startDate, String endDate)	Get total cost by organization and date range
Long	getTotalTokensByOrgUidAndDateRange(String orgUid, String startDate, String endDate)	Get total token consumption by organization and date range

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.jpa.repository.JpaSpecificationExecutor

count, delete, exists, findAll, findAll, findAll, findAll, findBy, findOne

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

findByUid

Optional<StatisticTokenEntity> findByUid(String uid)

existsByUid

Boolean existsByUid(String uid)

findByOrgUidAndTypeAndDeletedFalse

Optional<StatisticTokenEntity> findByOrgUidAndTypeAndDeletedFalse(String orgUid,
 String type)

findByOrgUidAndAiProviderAndAiModelTypeAndDateAndHourAndDeletedFalse

Optional<StatisticTokenEntity> findByOrgUidAndAiProviderAndAiModelTypeAndDateAndHourAndDeletedFalse(String orgUid,
 String aiProvider,
 String aiModelType,
 String date,
 Integer hour)

Find AI token statistics by organization, date and hour

findByOrgUidAndDateAndDeletedFalse

List<StatisticTokenEntity> findByOrgUidAndDateAndDeletedFalse(String orgUid,
 String date)

Find AI token statistics by organization and date

findByOrgUidAndDateBetweenAndDeletedFalse

@Query("SELECT s FROM StatisticTokenEntity s WHERE s.orgUid = :orgUid AND s.date BETWEEN :startDate AND :endDate AND s.deleted = false")
List<StatisticTokenEntity> findByOrgUidAndDateBetweenAndDeletedFalse(@Param("orgUid")
 String orgUid,
 @Param("startDate")
 String startDate,
 @Param("endDate")
 String endDate)

Find AI token statistics by organization, date range

findByOrgUidAndAiProviderAndDeletedFalse

List<StatisticTokenEntity> findByOrgUidAndAiProviderAndDeletedFalse(String orgUid,
 String aiProvider)

Find AI token statistics by organization and AI provider

findByOrgUidAndAiModelTypeAndDeletedFalse

List<StatisticTokenEntity> findByOrgUidAndAiModelTypeAndDeletedFalse(String orgUid,
 String aiModelType)

Find AI token statistics by organization and AI model type

getTotalTokensByOrgUidAndDateRange

@Query("SELECT SUM(s.totalTokens) FROM StatisticTokenEntity s WHERE s.orgUid = :orgUid AND s.date BETWEEN :startDate AND :endDate AND s.deleted = false")
Long getTotalTokensByOrgUidAndDateRange(@Param("orgUid")
 String orgUid,
 @Param("startDate")
 String startDate,
 @Param("endDate")
 String endDate)

Get total token consumption by organization and date range

getTotalCostByOrgUidAndDateRange

@Query("SELECT SUM(s.totalCost) FROM StatisticTokenEntity s WHERE s.orgUid = :orgUid AND s.date BETWEEN :startDate AND :endDate AND s.deleted = false")
BigDecimal getTotalCostByOrgUidAndDateRange(@Param("orgUid")
 String orgUid,
 @Param("startDate")
 String startDate,
 @Param("endDate")
 String endDate)

Get total cost by organization and date range

findByOrgUidAndDateOrderByHour

@Query("SELECT s FROM StatisticTokenEntity s WHERE s.orgUid = :orgUid AND s.date = :date AND s.deleted = false ORDER BY s.hour ASC")
List<StatisticTokenEntity> findByOrgUidAndDateOrderByHour(@Param("orgUid")
 String orgUid,
 @Param("date")
 String date)

Get hourly AI token statistics by organization and date Returns data grouped by hour for a specific date

findByOrgUidAndDateAndAiProviderOrderByHour

@Query("SELECT s FROM StatisticTokenEntity s WHERE s.orgUid = :orgUid AND s.date = :date AND s.aiProvider = :aiProvider AND s.deleted = false ORDER BY s.hour ASC")
List<StatisticTokenEntity> findByOrgUidAndDateAndAiProviderOrderByHour(@Param("orgUid")
 String orgUid,
 @Param("date")
 String date,
 @Param("aiProvider")
 String aiProvider)

Get hourly AI token statistics by organization, date and AI provider Returns data grouped by hour for a specific date and AI provider

findByOrgUidAndDateAndAiModelTypeOrderByHour

@Query("SELECT s FROM StatisticTokenEntity s WHERE s.orgUid = :orgUid AND s.date = :date AND s.aiModelType = :aiModelType AND s.deleted = false ORDER BY s.hour ASC")
List<StatisticTokenEntity> findByOrgUidAndDateAndAiModelTypeOrderByHour(@Param("orgUid")
 String orgUid,
 @Param("date")
 String date,
 @Param("aiModelType")
 String aiModelType)

Get hourly AI token statistics by organization, date and AI model type Returns data grouped by hour for a specific date and AI model type