/usr/share/pyshared/freevo/util/dbutil.py is in python-freevo 1.9.2b2-4.2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 | # -*- coding: iso-8859-1 -*-
# -----------------------------------------------------------------------
# Sqlite database wrapper
# -----------------------------------------------------------------------
# $Id: dbutil.py 11905 2011-11-14 21:54:46Z adam $
#
# Notes:
# Todo:
#
# -----------------------------------------------------------------------
# Freevo - A Home Theater PC framework
# Copyright (C) 2002 Krister Lagerstrom, et al.
# Please see the file freevo/Docs/CREDITS for a complete list of authors.
#
# This program 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 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of MER-
# CHANTABILITY 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 this program; if not, write to the Free Software Foundation, Inc.,
# 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
# -----------------------------------------------------------------------
import logging
logger = logging.getLogger("freevo.util.dbutil")
import os, traceback
import config
# helper functions
def tracknum(track):
"""
Extract the track numbers from a mmpython result
"""
trackno = -1
trackof = -1
if track:
trackno = inti(track.split('/')[0])
if track.find('/') != -1:
trackof = inti(track.split('/')[1])
return (trackno, trackof)
def escape(sql):
"""
Escape a SQL query in a manner suitable for sqlite
"""
if sql:
sql = sql.replace("'", "''")
return sql
else:
return 'null'
def inti(a):
ret = 0
if a:
try:
ret = int(a)
except ValueError, e:
print '"%s": %r' % (a, e)
traceback.print_exc()
return ret
try:
import sqlite
except:
_debug_('Python SQLite not installed!', DINFO)
class MetaDatabase:
""" Class for working with the database """
def __init__(self):
sqlite_major_version = sqlite._sqlite.sqlite_version_info()[0]
DATABASE = os.path.join(config.FREEVO_CACHEDIR, 'freevo.db%i' % sqlite_major_version)
self.db = sqlite.connect(DATABASE, client_encoding=config.LOCALE)
self.cursor = self.db.cursor()
def runQuery(self, query, close=False):
"""Execute a sql query on the database"""
try:
_debug_('query=%s' % (query))
self.cursor.execute(query)
except TypeError:
traceback.print_exc()
return False
if close:
# run a single query then close
result = self.cursor.fetchall()
self.db.commit()
self.db.close()
return result
else:
return self.cursor.fetchall()
def close(self):
"""close the database, committing any open transactions first"""
if not self.db.closed:
self.db.commit()
self.db.close()
def commit(self):
"""commit transactions"""
self.db.commit()
def checkTable(self, table=None):
if not table:
return False
# verify the table exists
self.cursor.execute('SELECT name FROM sqlite_master where name="%s" and type="table"' % table)
if not self.cursor.fetchone():
return None
return table
|