knexfile.js
require("dotenv").config();
module.exports = {
development: {
client: 'sqlite3',
useNullAsDefault: true,
connection: {
filename: './db/studium_test.db3',
},
migrations: {
directory: './db/migrations'
},
seeds: {
directory: './db/seeds/test'
},
pool: {
afterCreate: (conn, done) => {
conn.run('PRAGMA foreign_keys = ON', done);
},
},
useNullAsDefault: true
},
test: {
client: 'sqlite3',
useNullAsDefault: true,
connection: {
filename: './db/studium_test.db3',
},
migrations: {
directory: './db/migrations'
},
seeds: {
directory: './db/seeds/test'
},
pool: {
afterCreate: (conn, done) => {
conn.run('PRAGMA foreign_keys = ON', done);
},
},
useNullAsDefault: true
},
production: {
client: 'pg',
connection: process.env.DATABASE_URL,
migrations: {
directory: './db/migrations'
},
seeds: {
directory: './db/seeds/production'
},
useNullAsDefault: true
}
}