diff options
author | Christian Pointner <equinox@helsinki.at> | 2011-03-30 01:13:17 (GMT) |
---|---|---|
committer | Christian Pointner <equinox@helsinki.at> | 2011-03-30 01:13:17 (GMT) |
commit | a4f9323b1550715446453c6015a4e2df48f98855 (patch) | |
tree | 21c4e2e21dfc5c7fee3a68c4db2a833d777961ea /rhnop-server/rddb.lua | |
parent | 3af25a5734457ff5aca954b2452cd32d274dbd26 (diff) |
moved to new names (rhnop-client and server)
Diffstat (limited to 'rhnop-server/rddb.lua')
-rw-r--r-- | rhnop-server/rddb.lua | 75 |
1 files changed, 75 insertions, 0 deletions
diff --git a/rhnop-server/rddb.lua b/rhnop-server/rddb.lua new file mode 100644 index 0000000..c8037a9 --- /dev/null +++ b/rhnop-server/rddb.lua @@ -0,0 +1,75 @@ +-- +-- rhnop +-- +-- Copyright (C) 2011 Christian Pointner <equinox@helsinki.at> +-- +-- This file is part of rhnop. +-- +-- rhnop is free software: you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation, either version 3 of the License, or +-- any later version. +-- +-- rhnop is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with rhnop. If not, see <http://www.gnu.org/licenses/>. +-- + +require "luasql.mysql" + +conf = require "conf" + +local rddb = {} + +function rddb:init() + local err + + self.env, err = luasql.mysql() + if self.env == nil then + return nil, err + end + + self.con, err = self.env:connect(conf.rddb_db, conf.rddb_user, conf.rddb_pwd, conf.rddb_host, conf.rddb_port) + if self.con == nil then + return nil, err + end + + return true +end + +function rddb:getCartInfo(cartnum) + local cur, err = self.con:execute("select TITLE,ARTIST,ALBUM from CART where NUMBER = " .. self.con:escape(cartnum)); + if cur == nil then + return nil, err + end + + if cur:numrows() ~= 1 then + return nil, "nothing found in rivendell db" + end + + local results = {} + results, err = cur:fetch(results, "a") + cur:close() + + if results.TITLE == nil then results.TITLE = "" end + if results.ARTIST == nil then results.ARTIST = "" end + if results.ALBUM == nil then results.ALBUM = "" end + + return results, err +end + +function rddb:close() + if self.con then + self.con:close() + end + + if self.env then + self.env:close() + end +end + +return rddb |