require("mysqloo")

local DATABASE_HOST = "localhost"
local DATABASE_PORT = 3308
local DATABASE_NAME = "test"
local DATABASE_USERNAME = "root"
local DATABASE_PASSWORD = "1234"

function printQuery(query)
  PrintTable(query:getData())
end

function afterConnected(database)
  local query1 = database:query("SELECT ID, Name, Cost FROM test WHERE Cost > 0.50")
  query1.onData = function(Q,D) print("Q1") PrintTable(D) end
  query1.onSuccess = printQuery
  query1.onError = function(Q,E) print("Q1") print(E) end
  query1:start()

  local query2 = database:query("SELECT ID, Name, Cost FROM test")
  query2.onData = function(Q,D) print("Q2") PrintTable(D) end
  query2.onError = function(Q,E) print("Q1") print(E) end
  query2:start()
end

function connectToDatabase()
  local databaseObject = mysqloo.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME, DATABASE_PORT)
  databaseObject.onConnected = afterConnected
  databaseObject:connect()
end