gendb2.py

text/plain

Download

#!/usr/bin/python

import pg

c=pg.connect("marcin")

for i in range(1,2):
  qs = "drop table tt2_%d"%i
  print qs
  c.query(qs )
  qs = "create table tt2_%d (ntt int, nttext int, ntttext varchar(50) )"%i
  print qs
  c.query(qs )
  for j in range(1,1000000):
    qs = "insert into tt2_%d values(%d, %d, '%d%d%d')"%(i,j,j,j,j,j)
    print qs
    c.query(qs )