def test():
conn = db.getconn()
c= conn.cursor()
sql = "select * from TDCHARGE_SH_UNICOM_INFO"
c.execute(sql)
for o in c.fetchall():
print o
def getfee(start,end):
conn= db.getconn()
c = conn.cursor()
d= wapperVisit(start,end)
print d
sql1 = "SELECT * FROM (SELECT TO_CHAR(T .CREATE_TIME, 'yyyy-mm-dd') D, COUNT(T .UPDATE_TYPE) c FROM TDCHARGE_SH_UNICOM_INFO T WHERE T .UPDATE_TYPE = 1 and t.CREATE_TIME BETWEEN to_date('"+start+"', 'yyyy-mm-dd') and to_date('"+end+"', 'yyyy-mm-dd') GROUP BY TO_CHAR(T .CREATE_TIME, 'yyyy-mm-dd') ) t1 LEFT JOIN(SELECT TO_CHAR(T .CREATE_TIME, 'yyyy-mm-dd') D, COUNT(T .UPDATE_TYPE) c FROM TDCHARGE_SH_UNICOM_INFO T WHERE T .UPDATE_TYPE = 2 and t.CREATE_TIME BETWEEN to_date('"+start+"', 'yyyy-mm-dd') and to_date('"+end+"', 'yyyy-mm-dd') GROUP BY TO_CHAR(T .CREATE_TIME, 'yyyy-mm-dd'))t2 ON t1.D=t2.D ORDER BY T1.D"
c.execute(sql1)
l=[]
for o in c.fetchall():
one = {}
one['date']=o[0]
t = d.get(o[0])
if not t:
one['pv']=0
one['uv']=0
one['pvconvert']=0
one['uvconvert']=0
else:
one['pv']=t['pv']
one['uv']=t['uv']
one['pvconvert']=round(float(o[1])/float(one['pv'])*100,2)
one['uvconvert']=round(float(o[1])/float(one['uv'])*100,2)
one['dinggou']=o[1]
if o[3] :
one['tuiding']= o[3]
else:
one['tuiding']=0
#one['jingdinggou']=int(one['tuiding'])/int(one['dinggou']) * 100
l.append(one)
c.close()
conn.close()
return l
def getcount():
conn = db.getconn()
c = conn.cursor()
sql = "select UPDATE_TYPE ,count(ID) from TDCHARGE_SH_UNICOM_INFO GROUP BY UPDATE_TYPE"
c.execute(sql)
res = c.fetchall()
d={}
for one in res:
if one[0]==1:
d['dinggou']=one[1]
else:
d['tuiding']= one[1]
c.close()
conn.close()
return d
