def tst_test_rows_with_index1(p_count):
ret = {}
rows = StaticDataLayer.execute_sp_rows(
"select tst_test_rows_with_index1(%s::int)", p_count)
for row in rows:
if row['tst_c01'] in ret:
if row['tst_c02'] in ret[row['tst_c01']]:
ret[row['tst_c01']][row['tst_c02']].append(row)
else:
ret[row['tst_c01']][row['tst_c02']] = [row]
else:
ret[row['tst_c01']] = {row['tst_c02']: [row]}
return ret
def tst_test_rows_with_key1(p_count):
ret = {}
rows = StaticDataLayer.execute_sp_rows(
"select tst_test_rows_with_key1(%s::int)", p_count)
for row in rows:
if row['tst_c01'] in ret:
if row['tst_c02'] in ret[row['tst_c01']]:
if row['tst_c03'] in ret[row['tst_c01']][row['tst_c02']]:
raise Exception('Duplicate key for %s.' % str(
(row['tst_c01'], row['tst_c02'], row['tst_c03'])))
else:
ret[row['tst_c01']][row['tst_c02']][
row['tst_c03']] = row
else:
ret[row['tst_c01']][row['tst_c02']] = {row['tst_c03']: row}
else:
ret[row['tst_c01']] = {row['tst_c02']: {row['tst_c03']: row}}
return ret
def tst_test_rows1(p_count):
return StaticDataLayer.execute_sp_rows(
"select tst_test_rows1(%s::int)", p_count)
def tst_test_rows1_with_lob(p_count, p_blob):
return StaticDataLayer.execute_sp_rows(
"select tst_test_rows1_with_lob(%s::int, %s::bytea)", p_count,
p_blob)
def tst_test_percent_symbol():
return StaticDataLayer.execute_sp_rows(
"select tst_test_percent_symbol()")
