connection.ts

import knex from 'knex';
import path from 'path';
const configuration = require("../../knexfile");

let config;

    if(process.env.NODE_ENV === 'production'){
        config =  configuration.production;
    }else{
        config =  configuration.development;
    }



const connection = knex(config);

export default connection;

knexfile.ts

import path from 'path';

module.exports = {
    development: {
        client: 'sqlite3',
        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,
    },

    production: {
        client: 'mysql',
        connection: {
            host : 'host',
            database: 'banco',
            user: 'usuario',
            password: 'senha'
        },
        pool: {
            min: 2,
            max: 10
        },
        migrations: {
            directory: path.resolve(__dirname,'src','database','migrations')
        },
        seeds: {
            directory: path.resolve(__dirname,'src','database','seeds')
        },
    }
};