executeQuery<T>(query: string, params?: any[]): Promise<T | null>
Type Parameters
- T
Parameters
- query: string
- Optionalparams: any[]
Returns Promise<T | null>
Inherited from BaseDAO.executeQuery
- Defined in src/dao/db/BaseDao.ts:83

`Protected`executeQueryMultiple

executeQueryMultiple<T>(query: string, params?: any[]): Promise<T[]>
Type Parameters
- T
Parameters
- query: string
- Optionalparams: any[]
Returns Promise<T[]>
Inherited from BaseDAO.executeQueryMultiple
- Defined in src/dao/db/BaseDao.ts:97

getAverageStatisticForStreamAndType

getAverageStatisticForStreamAndType(
stream_id: number,
stream_statistic_type_id: number,
): Promise<number>
Parameters
- stream_id: number
- stream_statistic_type_id: number
Returns Promise<number>
Implementation of IStreamAnalyticsDAO.getAverageStatisticForStreamAndType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:10

getDailyStatisticsForStreamAndType

getDailyStatisticsForStreamAndType(
    stream_id: number,
    stream_statistic_type_id: number,
    start_date: Date,
    end_date: Date,
): Promise<StreamStatsInTimeWithType[]>
Parameters
- stream_id: number
- stream_statistic_type_id: number
- start_date: Date
- end_date: Date
Returns Promise<StreamStatsInTimeWithType[]>
Implementation of IStreamAnalyticsDAO.getDailyStatisticsForStreamAndType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:57

getHourlyStatisticsForStreamAndType

getHourlyStatisticsForStreamAndType(
    stream_id: number,
    stream_statistic_type_id: number,
    start_date: Date,
    end_date: Date,
): Promise<StreamStatsInTimeWithType[]>
Parameters
- stream_id: number
- stream_statistic_type_id: number
- start_date: Date
- end_date: Date
Returns Promise<StreamStatsInTimeWithType[]>
Implementation of IStreamAnalyticsDAO.getHourlyStatisticsForStreamAndType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:46

getMaxStatisticForStreamAndType

getMaxStatisticForStreamAndType(
stream_id: number,
stream_statistic_type_id: number,
): Promise<number>
Parameters
- stream_id: number
- stream_statistic_type_id: number
Returns Promise<number>
Implementation of IStreamAnalyticsDAO.getMaxStatisticForStreamAndType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:19

getMinStatisticForStreamAndType

getMinStatisticForStreamAndType(
stream_id: number,
stream_statistic_type_id: number,
): Promise<number>
Parameters
- stream_id: number
- stream_statistic_type_id: number
Returns Promise<number>
Implementation of IStreamAnalyticsDAO.getMinStatisticForStreamAndType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:28

getSumStatisticForStreamAndType

getSumStatisticForStreamAndType(
stream_id: number,
stream_statistic_type_id: number,
): Promise<number>
Parameters
- stream_id: number
- stream_statistic_type_id: number
Returns Promise<number>
Implementation of IStreamAnalyticsDAO.getSumStatisticForStreamAndType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:37

getTopStreamsByStatisticType

getTopStreamsByStatisticType(
    stream_statistic_type_id: number,
    limit: number,
    start_date: Date | null,
    end_date: Date | null,
): Promise<StreamStatsInTimeWithType[]>
Parameters
- stream_statistic_type_id: number
- limit: number
- start_date: Date | null
- end_date: Date | null
Returns Promise<StreamStatsInTimeWithType[]>
Implementation of IStreamAnalyticsDAO.getTopStreamsByStatisticType
- Defined in src/dao/db/StreamAnalyticsDAO.ts:68

`Protected`mapCacheError

mapCacheError(error: any): DaoError
Parameters
- error: any
Returns DaoError
Inherited from BaseDAO.mapCacheError
- Defined in src/dao/db/BaseDao.ts:47

`Protected`mapError

mapError(error: any): DaoError
Parameters
- error: any
Returns DaoError
Inherited from BaseDAO.mapError
- Defined in src/dao/db/BaseDao.ts:60

`Protected`mapPostgresError

mapPostgresError(error: any): DaoError
Parameters
- error: any
Returns DaoError
Inherited from BaseDAO.mapPostgresError
- Defined in src/dao/db/BaseDao.ts:16

`Protected`scalar

scalar<T = any>(query: string, params?: any[]): Promise<T>
Type Parameters
- T = any
Parameters
- query: string
- Optionalparams: any[]
Returns Promise<T>
Inherited from BaseDAO.scalar
- Defined in src/dao/db/BaseDao.ts:109

Class StreamAnalyticsDAO

Hierarchy (View Summary)

Implements

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns StreamAnalyticsDAO

Properties

Protected Readonlydb

Methods

ProtectedexecuteQuery

Type Parameters

Parameters

Returns Promise<T | null>

ProtectedexecuteQueryMultiple

Type Parameters

Parameters

Returns Promise<T[]>

getAverageStatisticForStreamAndType

Parameters

Returns Promise<number>

getDailyStatisticsForStreamAndType

Parameters

Returns Promise<StreamStatsInTimeWithType[]>

getHourlyStatisticsForStreamAndType

Parameters

Returns Promise<StreamStatsInTimeWithType[]>

getMaxStatisticForStreamAndType

Parameters

Returns Promise<number>

getMinStatisticForStreamAndType

Parameters

Returns Promise<number>

getSumStatisticForStreamAndType

Parameters

Returns Promise<number>

getTopStreamsByStatisticType

Parameters

Returns Promise<StreamStatsInTimeWithType[]>

ProtectedmapCacheError

Parameters

Returns DaoError

ProtectedmapError

Parameters

Returns DaoError

ProtectedmapPostgresError

Parameters

Returns DaoError

Protectedscalar

Type Parameters

Parameters

Returns Promise<T>

Settings

On This Page

`Protected` `Readonly`db

`Protected`executeQuery

`Protected`executeQueryMultiple

`Protected`mapCacheError

`Protected`mapError

`Protected`mapPostgresError

`Protected`scalar