qgen.py

import time
import sys
import os

cmd = "./dsqgen -QUIET Y -DIALECT netezza -SCALE 100000 -TEMPLATE crash.tpl -DIRECTORY ../query_templates"

template1 = '''
define C= ulist(random(1, {}, uniform),5);

select 
  [C.1],
  [C.2],
  [C.3],
  [C.4],
  [C.5]
;
'''

template2 = '''
define C= random(1, {}, uniform);

select [C] ;
'''

for i in range(100000000,4800000000,100000000):
  s = template1.format(i)

  f= open("../query_templates/crash.tpl","w")
  f.write(s)
  f.close()

  start = time.time()
  os.system(cmd)
  print("{}\t{}".format(i, time.time() - start))