使用Knex在构造函数中建立数据库连接

Question

我正在尝试将下面的knex连接实现为等效的DB类。我搜索了一下，但没有找到任何示例实现。

var knex = require('knex')({
client: 'pg',
connection: {
host: '127.0.0.1',
user: 'your_database_user',
password: 'your_database_password',
database: 'myapp_test'
},
pool: { min: 0, max: 7 }
})

Answer 1

let knex = require("knex");
class Database {

constructor(connection) {
this.connection = connection;
}

connect(option = {}) {
this.instance = knex(Object.assign(this.connection, option));
}
}

let db = new Database({
connection: {
host: '127.0.0.1',
user: 'your_database_user',
password: 'your_database_password',
database: 'myapp_test'
}
});
db.connect({
pool: { min: 0, max: 7 },
client: 'pg'
});