Minimal express api

models.ts

import { Model, model, connect, primary } from 'mysql-records'
import { createHash } from 'crypto'

const dbc = connect('localhost', 'mysql-user', 'mysql-password', 'mysql-db')

@model(dbc, 'users')
export class User extends Model {
    @primary id: number
    username: string
    password: string

    static setPassword(user: User, newPassword: string) {
        user.password = createHash('sha256').update(newPassword).digest('hex')
    }
}

server.ts

import * as express from 'express'
import * as logger from 'morgan'
import * as compression from 'compression'
import * as bodyparser from 'body-parser'

import { User } from './models'
const eapp = express()

eapp.use(logger("dev"))
    .use(compression())
    .use(bodyparser.urlencoded())
    .use(bodyparser.json())

eapp.get('/api/v1/users', async (req, rsp) => {
    const users = await User.all()
    rsp.status(200).json(users.map(user => ({ ...user, password: undefined })))
})

eapp.listen(8000)