summaryrefslogtreecommitdiff
path: root/nopsyncd/db.lua
diff options
context:
space:
mode:
authorChristian Pointner <equinox@helsinki.at>2011-03-16 00:54:52 (GMT)
committerChristian Pointner <equinox@helsinki.at>2011-03-16 00:54:52 (GMT)
commitfba23d62b11f361af19eae4cf545f946c17b97a5 (patch)
treec02ac491b450ac3bd0f2261f8b5f593a7e8e964d /nopsyncd/db.lua
parent2edacdcb0ac14a1e3ab8d6f6bc2a56f81783a88a (diff)
added rddb lookup
Diffstat (limited to 'nopsyncd/db.lua')
-rw-r--r--nopsyncd/db.lua52
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