deepkit: simple database example

app.ts

#!/usr/bin/env ts-node-script
import 'reflect-metadata';
import { Application, KernelModule } from '@deepkit/framework';
import { http } from '@deepkit/http';
import { entity, t } from '@deepkit/type';
import { Database } from '@deepkit/orm';
import { SQLiteDatabaseAdapter } from '@deepkit/sqlite';

@entity.name('user')
class User {
    @t.autoIncrement.primary public id: number = 0;

    constructor(
        @t public username: string,
    ) {
    }
}

class SQLiteDatabase extends Database {
    constructor() {
        super(new SQLiteDatabaseAdapter(':memory:'), [User]);
    }
}

@http.controller()
class MyWebsite {
    constructor(protected db: SQLiteDatabase) {
    }

    @http.POST('/user')
    async addUser(@http.body() user: User) {
        await this.db.persist(user);
        return "Added " + user.id;
    }

    @http.GET('/user')
    @t.array(User)
    async getUsers() {
        return await this.db.query(User).find();
    }
}

Application.create({
    providers: [],
    controllers: [MyWebsite],
    imports: [
        KernelModule.configure({
            databases: [SQLiteDatabase],
            migrateOnStartup: true,
        })
    ]
}).run();

Usage:

$ curl http://localhost:8080/user -H "Content-Type: application/json" --data '{"username": "peter"}'
Added 1
$ curl http://localhost:8080/user -H "Content-Type: application/json" --data '{"username": "peter"}'
Added 2
$ curl http://localhost:8080/user -H "Content-Type: application/json" --data '{"username": "peter"}'
Added 3
curl http://localhost:8080/user
[{"id":1,"username":"peter"},{"id":2,"username":"peter"},{"id":3,"username":"peter"}]