keighty/virtual_playbill

var Database = require('../config/db')
var schema = require('../config/schema')
var database = new Database()
var tableName = 'user'
var query

module.exports = {
  db: database,

  all: function (cb) {
    query = ['SELECT * from', tableName, ';'].join(' ')
    this.db.performQuery(query, cb)
  },

  get: function (id, cb) {
    query = ['SELECT * from', tableName, 'WHERE id =', id, ';'].join(' ')
    this.db.performQuery(query, cb)
  },

  add: function (user, cb) {
    var values = schema.getTableValues(tableName, user)

    query = ['INSERT into', tableName, 'VALUES (null,', values, ');'].join(' ')
    this.db.performQuery(query, cb)
  },

  delete: function (id, cb) {
    query = ['DELETE FROM', tableName, 'WHERE ID=', id, ';'].join(' ')
    this.db.performQuery(query, cb)
  },

  getPerformances: function (id, cb) {
    query = [
      'SELECT performance.*',
      'FROM user_performance',
      'JOIN performance',
      'ON performance.id = user_performance.performanceId',
      'WHERE userId =',
      id,
    ].join(' ')
    this.db.performQuery(query, cb)
  },
}