/*
          .d88888b                     dP       oo
          88.    "'                    88
          `Y88888b. .d8888b.  88d888b. 88d888b. dP 88d888b. .d8888b.
                `8b 88'  `88  88'  `88 88'  `88 88 88'  `88 88'  `88
          d8'   .8P 88.  .88  88.  .88 88    88 88 88       88.  .88
           Y88888P  `88888P8  88Y888P' dP    dP dP dP       `88888P8
          ooooooooooooooooooo~88~oooooooooooooooooooooooooooooooooooo
                              dP                    Saphira API: SQL

            Version: Saphira Developmental      Author: Chartax
            Contact: Chartax@gmail.com          Web: N/A

            Saphira is the property of Chartax. Do not distribute. All rights reserved.
*/

// This API module should be used to manage SQL databases, connections, etc. within Saphira.

require("mysqloo")

local DATABASE_HOST = "localhost"
local DATABASE_PORT = 3306
local DATABASE_NAME = "saphira"
local DATABASE_USERNAME = "root"
local DATABASE_PASSWORD = "BAS3bal1"

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

local SteamID = "STEAM_0:1:8422618"

function afterConnected(database)
  local query1 = database:query("SELECT accountName FROM saphira_account WHERE steamId = '"..SteamID.."'")
  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()
end

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

connectToDatabase()