Sequelize

Sequelize ORM connector

$3

``ts
import { join } from 'path';
import { tmpdir } from 'os';
import { container, Core, inject, Types } from '@biorate/inversion';
import { Config, IConfig } from '@biorate/config';
import {
ISequelizeConnector,
SequelizeConnector as BaseSequelizeConnector,
} from '@biorate/sequelize';
import { Table, Column, Model, DataType } from '@biorate/sequelize';

const connectionName = 'db';

// Create model
@Table({
tableName: 'test',
timestamps: false,
})
export class TestModel extends Model {
@Column({ type: DataType.CHAR, primaryKey: true })
key: string;

@Column(DataType.INTEGER)
value: number;
}

// Assign models with sequelize connector
class SequelizeConnector extends BaseSequelizeConnector {
protected readonly models = { [connectionName]: [TestModel] };
}

// Create Root class
export class Root extends Core() {
@inject(SequelizeConnector) public connector: ISequelizeConnector;
}

// Bind dependencies
container.bind(Types.Config).to(Config).inSingletonScope();
container.bind(SequelizeConnector).toSelf().inSingletonScope();
container.bind(Root).toSelf().inSingletonScope();

// Merge config
container.get(Types.Config).merge({
Sequelize: [
{
name: connectionName,
options: {
logging: false,
dialect: 'sqlite',
storage: join(tmpdir(), 'sqlite-test.db'),
},
},
],
});

// Example
(async () => {
await container.get(Root).$run();
// Drop table if exists
await TestModel.drop();
// Create table
await TestModel.sync();
// Create model item
await TestModel.create({ key: 'test', value: 1 });
// Create find model item by key
const data = await TestModel.findOne({ where: { key: 'test' } });
console.log(data.toJSON()); // { key: 'test', value: 1 }
})();
``

$3

- Documentation can be found here - docs.

$3

See the CHANGELOG

$3

MIT

Copyright (c) 2021-present Leonid Levkin (llevkin)