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/tempstorage.lua | |
parent | 2edacdcb0ac14a1e3ab8d6f6bc2a56f81783a88a (diff) |
added rddb lookup
Diffstat (limited to 'nopsyncd/tempstorage.lua')
-rw-r--r-- | nopsyncd/tempstorage.lua | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/nopsyncd/tempstorage.lua b/nopsyncd/tempstorage.lua new file mode 100644 index 0000000..f034647 --- /dev/null +++ b/nopsyncd/tempstorage.lua @@ -0,0 +1,62 @@ +-- +-- 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 tempstorage = {} + +function tempstorage: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 + +function tempstorage:close() + if self.con then + self.con:close() + end + + if self.env then + self.env:close() + end +end + +return tempstorage |