def do_setUp(self, curs=None): curs.execute('DROP TABLE IF EXISTS %s' % self.T.table) curs.execute('CREATE TABLE %s (id serial, PRIMARY KEY (id), name varchar, client_ids integer[])' % self.T.table) for i in xrange(10): values = [j for j in xrange(i, i + 3)] q = Insert(self.T.table, {'name': '%d' % i, 'client_ids': values}) curs.execute(*q.glue())
def register_patch(self, curs, name): q = Insert(self.table, {'name': name, 'path': self.path, 'date': datetime.now()}) curs.execute(*q.glue())
def fill_table(self, table, num_records=5, curs=None): for i in xrange(num_records): q = Insert(table, {'name': i, 'date': datetime.now()}) curs.execute(*q.glue())