def get_all_rows_cond(conditions):
'''
带条件的查询，返回事实表和扩展的的联合查询结果
:param : conditions={'ts.num=':'总期数','ts.num>':'从哪个起','ts.num<':'到哪个为止','rownum<=':'总数'}
:return: 返回cur运行结果
'''
sql='''select ts.num,
ts.r1,
ts.r2,
ts.r3,
ts.r4,
ts.r5,
ts.r6,
ts.b1,
ts.sum1,
te.red_lianhaoshu,
te.red_shouweikuadu,
te.prime_reds,
te.odd_reds,
te.red_weihe,
te.vertical_blue,
te.horizontal_span1,
te.horizontal_span2,
te.horizontal_span3,
te.horizontal_span4,
te.horizontal_span5,
te.vertical_red1,
te.vertical_red2,
te.vertical_red3,
te.vertical_red4,
te.vertical_red5,
te.vertical_red6
from tssqshishibiao_ext te, t_ssq_shishibiao ts
where ts.num = te.id '''
if conditions:
s=dict_2_str_all(conditions)
if s :
sql =sql+ ' and '+s
sql += ' order by ts.num desc '
else:
sql+=' and rownum<=100 order by ts.num desc '
print sql
else:
sql+=' and rownum<=100 order by ts.num desc '
#print sql
cur=SqlConn()
ssq1=cur.execute(sql)
cur.close()
return ssq1
def get_all_rows():
'''
查询100条事实表和扩展表联合查询的结果
:return:
'''
sql_context='''select ts.num,
ts.r1,
ts.r2,
ts.r3,
ts.r4,
ts.r5,
ts.r6,
ts.b1,
ts.sum1,
te.red_lianhaoshu,
te.red_shouweikuadu,
te.prime_reds,
te.odd_reds,
te.red_weihe,
te.vertical_blue,
te.horizontal_span1,
te.horizontal_span2,
te.horizontal_span3,
te.horizontal_span4,
te.horizontal_span5,
te.vertical_red1,
te.vertical_red2,
te.vertical_red3,
te.vertical_red4,
te.vertical_red5,
te.vertical_red6
from tssqshishibiao_ext te, t_ssq_shishibiao ts
where ts.num = te.id and rownum<=100'''
vorder=' order by ts.num desc'
# print sql_context
cur=SqlConn()
ssq1=cur.execute(sql_context+vorder)
cur.close()
return ssq1