def tst_test_rows_with_index1_with_lob(p_count, p_blob):
ret = {}
rows = StaticDataLayer.execute_sp_rows(
"call tst_test_rows_with_index1_with_lob(%s, %s)", p_count, p_blob)
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_with_lob(p_count, p_blob):
ret = {}
rows = StaticDataLayer.execute_sp_rows(
"call tst_test_rows_with_key1_with_lob(%s, %s)", p_count, p_blob)
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_with_lob(p_count, p_blob):
return StaticDataLayer.execute_sp_rows(
"call tst_test_rows1_with_lob(%s, %s)", p_count, p_blob)
def tst_test_rows1(p_count):
return StaticDataLayer.execute_sp_rows("call tst_test_rows1(%s)",
p_count)