Python: How to execute a SQL file or command
- by Mestika
Hi,
I have this Python script:
import sys
import getopt
import timeit
import random
import os
import re
import ibm_db
import time
from string import maketrans
runs=5
queries=50
file = open("results.txt", "a")
for r in range(5):
print "Run %s\n" % r
os.system("python reads.py -r1 -pquery1.sql -q50 -sespec")
file.write('END QUERY READ…