MySqlStatisticsRepository
in package
MySQL repository for statistics queries.
Provides database access for learning statistics.
Tags
Table of Contents
Methods
- getLanguageCount() : int
- Get language count.
- getLanguageList() : array<int, array<string, mixed>>
- Get list of languages with IDs and names.
-
getTermActivityByDay()
: array{active: array
- Get term activity grouped by language and days ago.
- getTermCountsByLanguageAndStatus() : array<string, array<int, int>>
- Get term counts grouped by language and status.
- getTermsCreatedByDay() : array<int, array<int, int>>
- Get terms created grouped by language and days ago.
Methods
getLanguageCount()
Get language count.
public
getLanguageCount() : int
Return values
int —Number of languages
getLanguageList()
Get list of languages with IDs and names.
public
getLanguageList() : array<int, array<string, mixed>>
Returns records with LgID (int) and LgName (string) fields.
Return values
array<int, array<string, mixed>> —Language records
getTermActivityByDay()
Get term activity grouped by language and days ago.
public
getTermActivityByDay() : array{active: array>, known: array>}
Return values
array{active: arraygetTermCountsByLanguageAndStatus()
Get term counts grouped by language and status.
public
getTermCountsByLanguageAndStatus() : array<string, array<int, int>>
Return values
array<string, array<int, int>> —Term counts indexed by language ID and status
getTermsCreatedByDay()
Get terms created grouped by language and days ago.
public
getTermsCreatedByDay() : array<int, array<int, int>>
Return values
array<int, array<int, int>> —Terms by language ID and days since creation