summaryrefslogtreecommitdiff
path: root/rhnop-server/rddb.lua
diff options
context:
space:
mode:
Diffstat (limited to 'rhnop-server/rddb.lua')
-rw-r--r--rhnop-server/rddb.lua80
1 files changed, 0 insertions, 80 deletions
diff --git a/rhnop-server/rddb.lua b/rhnop-server/rddb.lua
deleted file mode 100644
index 9626632..0000000
--- a/rhnop-server/rddb.lua
+++ /dev/null
@@ -1,80 +0,0 @@
---
--- rhnop
---
--- Copyright (C) 2011-2014 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/>.
---
-
-luasql = 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
-
- local ret, err = self.con:execute("SET CHARACTER SET utf8")
- if ret == 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