import pandas as pd
import os
import cx_Oracle
df=pd.read_csv('D:\Oracle_Account\DATA\Python_Work\SQL_STMT_Read\SQL_List.csv')
df2=pd.DataFrame()
dfusers=pd.read_csv('D:\Oracle_Account\DATA\Python_Work\SQL_STMT_Read\Rquired_Users.csv',dtype=str)
Userlist = dfusers.OurUsers.values.tolist()
Userlist
res=str(Userlist)[1:-1]
print(res)
type(res)
dsn_tns = cx_Oracle.makedsn('localhost', '1531', 'XE')
conn=cx_Oracle.connect(user='abc', password='def', dsn=dsn_tns)
for i in range(0,3):
query=df.loc[i,'sql_quries']
query=query.format(res)
print(query)
df2= pd.read_sql(query, conn)
df2.to_csv("D:\\Oracle_Account\\DATA\Python_Work\\SQL_STMT_Read\\"+str(i)+".csv", index = True, header=True)
conn.close()
No comments:
Post a Comment