1 // Copyright Jerome Benoit. 2021-2024. All Rights Reserved.
3 import { MikroORM
as MariaDbORM
, type Options
as MariaDbOptions
} from
'@mikro-orm/mariadb'
4 import { MikroORM
as SqliteORM
, type Options
as SqliteOptions
} from
'@mikro-orm/sqlite'
6 import { type PerformanceRecord
, type Statistics
, StorageType
} from
'../../types/index.js'
7 import { Constants
} from
'../../utils/index.js'
8 import { Storage
} from
'./Storage.js'
10 export class MikroOrmStorage
extends Storage
{
11 private readonly storageType
: StorageType
12 private orm
?: SqliteORM
| MariaDbORM
14 constructor (storageUri
: string, logPrefix
: string, storageType
: StorageType
) {
15 super(storageUri
, logPrefix
)
16 this.storageType
= storageType
17 this.dbName
= this.getDBName()
20 public async storePerformanceStatistics (performanceStatistics
: Statistics
): Promise
<void> {
22 this.setPerformanceStatistics(performanceStatistics
)
23 await this.orm
?.em
.upsert({
24 ...performanceStatistics
,
25 statisticsData
: Array.from(performanceStatistics
.statisticsData
, ([name
, value
]) => ({
29 } satisfies PerformanceRecord
)
31 this.handleDBStorageError(
34 Constants
.PERFORMANCE_RECORDS_TABLE
39 public async open (): Promise
<void> {
41 if (this.orm
== null) {
42 switch (this.storageType
) {
43 case StorageType
.SQLITE
:
44 this.orm
= await SqliteORM
.init(this.getOptions() as SqliteOptions
)
46 case StorageType
.MARIA_DB
:
47 case StorageType
.MYSQL
:
48 this.orm
= await MariaDbORM
.init(this.getOptions() as MariaDbOptions
)
53 this.handleDBStorageError(this.storageType
, error
as Error)
57 public async close (): Promise
<void> {
58 this.clearPerformanceStatistics()
60 if (this.orm
!= null) {
61 await this.orm
.close()
65 this.handleDBStorageError(this.storageType
, error
as Error)
69 private getDBName (): string {
70 if (this.storageType
=== StorageType
.SQLITE
) {
71 return `${Constants.DEFAULT_PERFORMANCE_DIRECTORY}/${Constants.DEFAULT_PERFORMANCE_RECORDS_DB_NAME}.db`
73 return this.storageUri
.pathname
.replace(/(?:^\
/)|(?:\
/$
)/g
, '')
76 private getOptions (): SqliteOptions
| MariaDbOptions
{
79 entities
: ['./dist/types/orm/entities/*.js'],
80 entitiesTs
: ['./src/types/orm/entities/*.ts'],
81 clientUrl
: this.getClientUrl()
85 private getClientUrl (): string | undefined {
86 switch (this.storageType
) {
87 case StorageType
.SQLITE
:
88 case StorageType
.MARIA_DB
:
89 case StorageType
.MYSQL
:
90 return this.storageUri
.toString()