diff options
Diffstat (limited to 'nopsyncd/rddb.lua')
-rw-r--r-- | nopsyncd/rddb.lua | 71 |
1 files changed, 71 insertions, 0 deletions
diff --git a/nopsyncd/rddb.lua b/nopsyncd/rddb.lua new file mode 100644 index 0000000..1a16a4d --- /dev/null +++ b/nopsyncd/rddb.lua @@ -0,0 +1,71 @@ +-- +-- 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" + +local rddb = {} + +function rddb:init() + local err + + self.env, err = luasql.mysql() + if self.env == nil then + return nil, err + end + + -- TODO: read /etc/rd.conf for connection info + self.con, err = self.env:connect("rivendell", "rivendellro", "lldrivenro", "127.0.0.1") + if self.con == nil then + return nil, err + end + + return true +end + +function rddb:getCartInfo(cartnum) + -- TODO: SQL Injections!!! + local cur, err = self.con:execute("select TITLE,ARTIST,ALBUM from CART where NUMBER = " .. 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() + + 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 |