def setUp(self):
# conxStr = 'DRIVER=SQLite3 ODBC Driver;Database=sqllite.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;'
dbPath = ":memory:"
# self.db = DB(dbPath)
self.db = DB(user="******",
passwd="MySQL-root-0",
db="zander_test_database",
host="127.0.0.1",
port=3306)
self.db.debug = False
try:
self.db.drop_table('users')
except:
# table doesn't exist
pass
userTable = self.db.create_table('users', 'id integer',
'name varchar(100)',
'nickname varchar(100)')
userTable.insert(0, 'Amy', 'amy')
userTable.insert(1, 'William', 'bill')
userTable.insert(2, 'Charles', 'charlie')
userTable.insert(3, 'Denise', 'denise')
