# Eigene Module from PyDown.database import SQL_wrapper default_preferences = { "bandwith": "5", # KB/s } db = SQL_wrapper(sys.stdout, dbtyp="sqlite", databasename="SQLiteDB/PyDownSQLite.db") print "\ninstall Database\n" print "dbtyp.......:", db.dbtyp print "databasename:", db.databasename print "paramstyle..:", db.paramstyle print "placeholder.:", db.placeholder print table_data = { "activity": """CREATE TABLE $$activity ( id INTEGER PRIMARY KEY, username VARCHAR(50) NOT NULL, item VARCHAR(254) NOT NULL,
#!/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)
# Eigene Module from PyDown.database import SQL_wrapper default_preferences = { "bandwith": "5", # KB/s } db = SQL_wrapper(sys.stdout, dbtyp="sqlite", databasename="SQLiteDB/PyDownSQLite.db") print "\ninstall Database\n" print "dbtyp.......:", db.dbtyp print "databasename:", db.databasename print "paramstyle..:", db.paramstyle print "placeholder.:", db.placeholder print table_data = { "downloads": """CREATE TABLE $$downloads ( id INTEGER PRIMARY KEY, username VARCHAR(50) NOT NULL, item VARCHAR(254) NOT NULL,
#!/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)