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())
