# coding:utf-8
from db.mysql_db import Mysql
db = Mysql()
sql = '''
select table_name from information_schema.tables where table_schema='ilot'
'''
# ORACLE数据库查询语句:select TABLE_NAME from all_tables where owner='11111'
result = db.run_sql2(sql)
result_list = []
for table_name in result:
sql2='''
select * from %s
'''%table_name[0]
if table_name[0] in ('act_hi_varinst','m_coupon_history'):
continue
print(sql2)
result2 = db.run_sql2(sql2)
for line in result2:
if "agent_unbind2" in line:
result_list.append(table_name[0])
break
print(result_list)