diff options
author | Christian Pointner <equinox@helsinki.at> | 2011-03-21 15:27:07 (GMT) |
---|---|---|
committer | Christian Pointner <equinox@helsinki.at> | 2011-03-21 15:27:07 (GMT) |
commit | 46348e1cd2782a701134b030be7452910ba2c46e (patch) | |
tree | db5dad68ca369d55380b4dc4a59ebc0ba223b3bb /nopsyncd/tempstorage.lua | |
parent | a57ad1b134763b55f9dcc0a63e6995a66bcc2a7d (diff) |
moved sqlite based tempstorage to mysql based playlog
Diffstat (limited to 'nopsyncd/tempstorage.lua')
-rw-r--r-- | nopsyncd/tempstorage.lua | 90 |
1 files changed, 0 insertions, 90 deletions
diff --git a/nopsyncd/tempstorage.lua b/nopsyncd/tempstorage.lua deleted file mode 100644 index 4ae437a..0000000 --- a/nopsyncd/tempstorage.lua +++ /dev/null @@ -1,90 +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 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 VARCHAR(16) 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:getLastCart() - local cur, err = self.con:execute("SELECT cart from (SELECT cart,timestamp,MAX(timestamp) AS tsmax FROM now) where timestamp = tsmax") - if cur == nil then - return nil, err - end - - local cart = cur:fetch() - if cart == nil then cart = 0 end - return cart -end - -function tempstorage:insertMusic(timestamp, cart, len, title, artist, album) - cart = tonumber(cart) - len = tonumber(len) - if cart < 400000 or cart > 450000 then - poolnum = 0 - else - poolnum = math.floor(cart/1000) - 399 - end - -- usage of undocumented escape function... - local cur, err = self.con:execute("INSERT into now VALUES(" .. self.con:escape(timestamp) .. ", " .. cart .. ", " .. len .. ", 'Musikpool " .. poolnum .. "', '" .. self.con:escape(title) .. "', '" .. self.con:escape(artist) .."', '" .. self.con:escape(album) .. "', 1)") - if cur == 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 |