Skip to main content
Version: 2.2

Single Data Type

The Data entity is quite special as it is an implementation of the EAV pattern.

It permits to have key/value kind of data stored in an SQL database, which is not really possible by default.

These data and their initial values are stored in the defaultData variable in the src/entities/Data.ts file, and you can add as much key/value as you want.

To interact with them, we've created a custom repository for the Data entity with very simple set, get and update methods. All of these methods are strongly typed thanks to the infered types of the initial values.

Usage example:

@Discord()
@injectable()
export default class PingCommand {

constructor(
private db: Database
) {}

@Slash({
name: 'ping'
})
async pingHandler() {

const dataRepo = this.db.get(Data)

const isInMaintenance = dataRepo.get('maintenance') // -> false

await dataRepo.set('maintenance', true) // -> true

await dataRepo.update('maintenance', (currentValue) => !currentValue) // -> false

await dataRepo.set('maintenance', 'foo') // -> ERROR: Type 'string' is not assignable to type 'boolean'
}

}

Here are the built-in key/value data:

KeyTypeDefault valueDescription
maintenancebooleanfalseActual maintenance state of the bot
lastMaintenanceDateDate.now()Timestamp of the last maintenance
lastStartupDateDate.now()Timestamp of the last startup of the bot