#!/usr/local/bin/python
import psycopg2
conn = psycopg2.connect(database = "policy_pro", user = "policy_opr", password = "eWEeFZTGS5PkviKW", host = "10.200.18.1", port="3433")
print "Open database success"
cur = conn.cursor()
psql0 = "select template_id from signcreat.t_sign_template t where template_signature_type='01' and template_id > 1386 order by template_id"
cur.execute(psql0)
psqla = cur.fetchall()
# print psqla
i=0
j=56360526
for a in psqla:
psql = " select count(p.bill_no) from signcreat.t_sign_policy p where p.template_id = %s ; " % a[0]
cur.execute(psql)
rows = cur.fetchone()
j = j + rows[0]
print a[0], rows[0], j
i = i+1
print 'end'
# import os
# import time
#
# psql = ''' psql -h 10.200.18.1 -p 3433 -U policy_opr -d policy_pro -c " select count(p.bill_no) from signcreat.t_sign_policy p where p.template_id = 128 and is_del = '1' " '''
# a= os.popen(psql,'r')
# print a.read()
import psycopg2
conn = psycopg2.connect(database = "policy_pro", user = "policy_opr", password = "eWEeFZTGS5PkviKW", host = "10.200.18.1", port="3433")
print "Open database success"
cur = conn.cursor()
psql0 = "select template_id from signcreat.t_sign_template t where template_signature_type='01' and template_id > 1386 order by template_id"
cur.execute(psql0)
psqla = cur.fetchall()
# print psqla
i=0
j=56360526
for a in psqla:
psql = " select count(p.bill_no) from signcreat.t_sign_policy p where p.template_id = %s ; " % a[0]
cur.execute(psql)
rows = cur.fetchone()
j = j + rows[0]
print a[0], rows[0], j
i = i+1
print 'end'
# import os
# import time
#
# psql = ''' psql -h 10.200.18.1 -p 3433 -U policy_opr -d policy_pro -c " select count(p.bill_no) from signcreat.t_sign_policy p where p.template_id = 128 and is_del = '1' " '''
# a= os.popen(psql,'r')
# print a.read()