mysql-models v0.1.13

MySQL Models

Strongly typed repositories for MySQL transactions.

Example

import { newConnection, newRepository } from 'mysql-models'
import moment from 'moment'

const conn = newConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'test_db',
    debug: process.env.ENV !== 'PROD',
})

export interface Post {
    id: number
    title: string
    body: string
    dateCreated: moment.Moment
}

const postRepo = newRepository<Post, MySQLPost>({
    tableName: 'post',
    conn,
    schema: {
        id: {
            column: 'id',
            primary: true,
        },
        title: { column: 'title' },
        body: { column: 'body' },
        dateCreated: {
            column: 'date_created',
            toMySqlVal: m => m.format('YYYY-MM-DD HH:mm:ss'),
            fromMySqlVal: s => moment(s as string),
        },
    },
})

const post = await postRepo.findOne({ id: 1 })