_ = require 'underscore'

tables = {}

class SqlMem

  constructor: ->

  Select: (table, fields, where, options, done) ->
    if where.id? and typeof where.id is 'string'
      where.id = parseInt where.id

    res = _(tables[table]).where(where)

    done null, res

  Insert: (table, fields, done) ->
    tables[table].push fields

    fields.id = tables[table].length
    done null, tables[table].length

  Update: (table, fields, where, done) ->
    row = _(tables[table]).findWhere(where)

    _(row).extend fields

    done()

  Delete: (table, where, done) ->
    tables[table] = _(tables[table]).reject (item) -> item.id is where.id
    done null, 1

  _Reset: ->
    tables = {}

module.exports = (config) ->
  new SqlMem()

module.exports.AddTable = (name) ->
  if !(tables[name]?)
    tables[name] = []
  tables[name]