require 'src.lang.lua.sqlite3'

db = sqlite3.open("chat.db")

data = {
  room = db:prepare "SELECT * FROM room WHERE id=:id";
  load_code = db:prepare "SELECT source FROM code WHERE name=:name";
  store_code = db:prepare "insert into code (name, source) values (:name, :source)"
}

data.store_code:bind('adder', [[print('yeah!')]]):exec()
data.load_code:bind('adder')

for row in data.load_code:rows() do
  local mod = loadstring(row.source)
  mod()
end

db:exec("DELETE FROM code")

db:close()

handler = {}
handler.members = {}
handler.count = 0

function handler:chat_speak(from, msgid, target, more, mtype, time, data)
  -- needs to be [bswb -> from_key, from_name, "from", message in data
  print("CHAT RAN: ",from,msgid,target,more,mtype,time,data)

  if self.members[from] then
    for member in pairs(self.members) do
      utu.send(member, msgid, target, more, mytpe, data)
    end
  else
    self.members[from] = true
    self.count = self.count + 1
    print("new user registered, " .. tostring(self.count) .. " total")
  end

  return true
end

function handler:chat_logout(from, msgid, target, more, mtype, time, data)
  print("CHAT LOGOUT: ",from,msgid,target,more,mtype,time,data)
  if self.members[from] then
    print("logging out user")
    self.count = self.count - 1
    self.members[from] = nil
  end

  -- this disconnects the user
  return false
end