summaryrefslogtreecommitdiff
path: root/nopsyncd/db.lua
diff options
context:
space:
mode:
authorChristian Pointner <equinox@helsinki.at>2011-03-15 23:59:01 (GMT)
committerChristian Pointner <equinox@helsinki.at>2011-03-15 23:59:01 (GMT)
commit2edacdcb0ac14a1e3ab8d6f6bc2a56f81783a88a (patch)
tree0e5a55193fec325db1edd0b38afa58a6ea7609aa /nopsyncd/db.lua
parentc0479f190fd22d7e6a2fa81f9eda2bd79a4b87b6 (diff)
added temp storage (db)
Diffstat (limited to 'nopsyncd/db.lua')
-rw-r--r--nopsyncd/db.lua52
1 files changed, 52 insertions, 0 deletions
diff --git a/nopsyncd/db.lua b/nopsyncd/db.lua
new file mode 100644
index 0000000..ffdefed
--- /dev/null
+++ b/nopsyncd/db.lua
@@ -0,0 +1,52 @@
+--
+-- 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