def _setup_db(cursor):
cmd = cursor
t = NameTable('themes', ['theme'])
cmd.execute('create table %s' % t)
cmd.execute(insert('themes', {'theme': 'themebase'}))
t = ThemeTable('themebase')
cmd.execute('create table %s' % t)
cols = [x.name for x in t.columns]
#print cmd.tables()
q1 = insert(
'themebase',
dict(
zip(cols,
['fg', 'black', 'seashell', 'black', 'sky blue', 'plum'])))
q2 = insert(
'themebase',
dict(
zip(cols,
['bg', 'cyan3', 'seashell', 'cyan4', 'light coral', 'grey'])))
q3 = insert(
'themebase',
dict(
zip(cols, [
'base', 'light sea green', 'lavender', 'azure3', 'yellow',
'aquamarine'
])))
q4 = insert(
'themebase',
dict(
zip(cols,
['text', 'wheat', 'black', 'black', 'black', 'dark violet'])))
map(cmd.execute, [q1, q2, q3, q4])
def _setup_db(cursor):
cmd = cursor
t = NameTable('themes', ['theme'])
cmd.execute('create table %s' %t)
cmd.execute(insert('themes', {'theme':'themebase'}))
t = ThemeTable('themebase')
cmd.execute('create table %s' %t)
cols = [x.name for x in t.columns]
#print cmd.tables()
q1 = insert('themebase',
dict(zip(cols, ['fg', 'black', 'seashell', 'black', 'sky blue', 'plum'])))
q2 = insert('themebase',
dict(zip(cols, ['bg', 'cyan3', 'seashell',
'cyan4', 'light coral', 'grey'])))
q3 = insert('themebase',
dict(zip(cols, ['base', 'light sea green',
'lavender', 'azure3', 'yellow', 'aquamarine'])))
q4 = insert('themebase',
dict(zip(cols, ['text', 'wheat', 'black',
'black', 'black', 'dark violet'])))
map(cmd.execute, [q1, q2, q3, q4])
def insert(self, table, adict):
"perform simple insert"
query = insert(table, adict)
#print query
self.execute(query)
