db.cursor.execute(statement)
print "OK"
def setup_preferences(self):
print
print "setup default preferences:"
for key, value in default_preferences.iteritems():
print "set '%s' to '%s'" % (key, value)
db.insert(
table = "preferences",
data = {"type": key, "value": value}
)
try:
setup_sql(db, table_data)
except Exception, e:
print "Error:", e
print "Make rollback!"
db.rollback()
else:
db.commit()
print "\nget_tables():", db.get_tables()
print
print "everything ready!"
#!/usr/bin/python
# -*- coding: UTF-8 -*-
"""
Dumps all PyDown Tables
"""
import sys, time
from PyDown.database import SQL_wrapper
dbtyp = "sqlite"
databasename = ":memory:"
databasename = "SQLiteDB/PyDownSQLite.db"
db = SQL_wrapper(sys.stdout, dbtyp, databasename)
print "dbtyp.......:", db.dbtyp
print "databasename:", db.databasename
print "paramstyle..:", db.paramstyle
print "placeholder.:", db.placeholder
tables = db.get_tables()
print "\nget_tables():", tables
for table in tables:
print "-" * 79
db.dump_table(table)
db.cursor.execute(statement)
print "OK"
def setup_preferences(self):
print
print "setup default preferences:"
for key, value in default_preferences.iteritems():
print "set '%s' to '%s'" % (key, value)
db.insert(
table = "preferences",
data = {"type": key, "value": value}
)
try:
setup_sql(db, table_data)
except Exception, e:
print "Error:", e
print "Make rollback!"
db.rollback()
else:
db.commit()
print "\nget_tables():", db.get_tables()
print
print "everything ready!"
#!/usr/bin/python
# -*- coding: UTF-8 -*-
"""
Dumps all PyDown Tables
"""
import sys, time
from PyDown.database import SQL_wrapper
dbtyp="sqlite"
databasename=":memory:"
databasename="SQLiteDB/PyDownSQLite.db"
db = SQL_wrapper(sys.stdout, dbtyp, databasename)
print "dbtyp.......:", db.dbtyp
print "databasename:", db.databasename
print "paramstyle..:", db.paramstyle
print "placeholder.:", db.placeholder
tables = db.get_tables()
print "\nget_tables():", tables
for table in tables:
print "-"*79
db.dump_table(table)
