var ORM = require('thin-orm'),
sqlite3 = require('sqlite3').verbose(),
db = new sqlite3.Database(':memory:'),
async = require('async');
ORM.table('wines')
.columns(['id', 'name', 'year', 'grapes', 'country', 'region', 'description', 'picture']);
var driver = ORM.createDriver('sqlite', { db: db });
var winesClient = ORM.createClient(driver, 'wines');
populateDB();
exports.findById = function(req, res) {
console.log('Retrieving wine: ' + req.params.id);
winesClient.findById(req.params.id, res);
};
exports.findAll = function(req, res) {
winesClient.findMany({}, res);
};
exports.addWine = function(req, res) {
var wine = req.body;
console.log('Adding wine: ' + JSON.stringify(wine));
winesClient.create({ data: wine }, res);
};
exports.updateWine = function(req, res) {
var id = req.params.id;
createClient: function (table) {
return promiseize(orm.createClient(driver, table));
},