knexfile.ts

const path = require('path');

module.exports = {
    development: {
        client: 'sqlite3',
        connection: ":memory:",
        // connection: {
        //    filename: path.resolve(__dirname, 'src', 'database', 'database.sqlite'),
        // },
        migrations: {
            directory: path.resolve(__dirname, 'src', 'database', 'migrations'),
        },
        seeds: {
            directory: path.resolve(__dirname, 'src', 'database', 'seeds'),
        },
        useNullAsDefault: true,
    },
    test: {
        client: 'sqlite3',
        connection: ":memory:",
        migrations: {
            directory: path.resolve(__dirname, 'src', 'database', 'migrations'),
        },
        seeds: {
            directory: path.resolve(__dirname, 'src', 'database', 'seeds'),
        },
        useNullAsDefault: true,
    }
}