diff options
author | Christian Pointner <equinox@helsinki.at> | 2011-03-16 00:54:52 (GMT) |
---|---|---|
committer | Christian Pointner <equinox@helsinki.at> | 2011-03-16 00:54:52 (GMT) |
commit | fba23d62b11f361af19eae4cf545f946c17b97a5 (patch) | |
tree | c02ac491b450ac3bd0f2261f8b5f593a7e8e964d /nopsyncd/db.lua | |
parent | 2edacdcb0ac14a1e3ab8d6f6bc2a56f81783a88a (diff) |
added rddb lookup
Diffstat (limited to 'nopsyncd/db.lua')
-rw-r--r-- | nopsyncd/db.lua | 52 |
1 files changed, 0 insertions, 52 deletions
diff --git a/nopsyncd/db.lua b/nopsyncd/db.lua deleted file mode 100644 index ffdefed..0000000 --- a/nopsyncd/db.lua +++ /dev/null @@ -1,52 +0,0 @@ --- --- 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.sqlite3" - -local db = {} - -function db:init() - local err - - self.env, err = luasql.sqlite3() - if self.env == nil then - return nil, err - end - - self.con, err = self.env:connect("nopsync.db") - if self.con == nil then - return nil, err - end - - local ret, err = self.con:setautocommit(true) - if ret == nil then - return nil, err - end - - local rows, err = self.con:execute("CREATE TABLE IF NOT EXISTS now (timestamp INT PRIMARY KEY ASC NOT NULL, cart INT NOT NULL, len INT, showtitle VARCHAR(255), title VARCHAR(255), artist VARCHAR(255), album VARCHAR(255), ismusic BOOLEAN)") - if rows == nil then - return nil, err - end - - return true -end - -return db |