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)