# 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)
Beispiel #3
0
# 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)