in scripts/glue_script/run_redshift_benchmark.py [0:0]
def run_sequential_task(self):
for i in range(1,self.num_runs+1):
st = time.time()
self.root.info("Start %s round sequential query test"%i)
for j in range(1,self.num_sql_files+1):
queryPath = self.sql_file_root+"query"+str(j) +".sql"
self.root.info("Start %s run" %queryPath)
# open querySQL x
queryFile = open(queryPath,'r')
querySQL = queryFile.read()
# Thread run sql
self.rs_select(querySQL,queryPath,'sequential',i)
et=time.time()
tt=round(et - st, 3)
self.root.info("ROUND SUCCESS: %s round concurrent test and took %s seconds in total"%(i, tt))
self.result_summary=self.result_summary.append(pd.Series([self.test_name,'total',i,'sequential',st,et,tt],index=['testName','query','round','testType','startTime','endTime','elapseSeconds']),ignore_index=True)