#coding:utf-8
#!/usr/bin/python
import cx_Oracle
import sys
import os
m=sys.argv[1]
sql="select a.mobile,b.city_name from (select mobile,city_id from dw_cmmb_user_"+m+" where show_flag=1 group by mobile,city_id) a, (select * from dim_areacode where province_id=551) b where a.city_id=b.city_id group by a.mobile,b.city_name order by b.city_name"
db_conn=cx_Oracle.connect(admin/admin@hello')
cur=db_conn.cursor()
cur.execute(sql)
rows=cur.fetchall()
filename="/apps/aspbi/hello/anhui_"+m+".csv"
f=open(filename,'w')
for mobile,city_name in rows:
line=",".join([mobile,city_name])
f.write(line+'\n')
f.close()
db_conn.close()
