From 84aca1791d43ae5a65bd88747636e418b380ad64 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Mon, 28 May 2018 20:18:20 +0200 Subject: reconsidering datasets component... stub in api client --- app/server/db/bookshelf.js | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 app/server/db/bookshelf.js (limited to 'app/server/db/bookshelf.js') diff --git a/app/server/db/bookshelf.js b/app/server/db/bookshelf.js new file mode 100644 index 0000000..27d9dbb --- /dev/null +++ b/app/server/db/bookshelf.js @@ -0,0 +1,24 @@ +const knex = require('knex')({ + client: 'mysql2', + connection: { + host : process.env.DB_HOST, + user : process.env.DB_USER, + password : process.env.DB_PASS, + database : process.env.DB_NAME, + charset : 'utf8', + typecast : function (field, next) { + console.log(field.type) + if (field.type == 'BLOB') { + return field.string() + } + return next() + } + } +}) + +const bookshelf = require('bookshelf')(knex) + +module.exports = { + bookshelf: bookshelf, + knex: knex, +} -- cgit v1.2.3-70-g09d2