背景
经常需要连接数据库,统计数据并导出成excel
安装
在pypi上找到合适的module包,windows 64位,python3.7.6版本,需下载cx_Oracle-7.3.0-cp37-cp37m-win_amd64.whl,执行’pip install cx_Oracle-7.3.0-cp37-cp37m-win_amd64.whl’ 安装module
脚本
import cx_Oracle
def connectOracle():
db_ip = '192.168.0.110'
service_name = 'newmbdb'
user_name = 'query'
password = 'query'
conn=cx_Oracle.connect(user_name+"/"+password+"@//"+db_ip+":1521/"+service_name)
return conn
def query_max_period(conn):
max_period = '20200110'
db_cursor = conn.cursor()
sql_cmd = 'SELECT max(statistics_period) FROM log_statistics'
db_cursor.execute(sql_cmd)
result = db_cursor.fetchone()
if result:
if result[0] >= 0:
max_period = result[0]
db_cursor.close()
print("max_period :" + str(max_period))
return max_period
if __name__ == "__main__":
conn = connectOracle()
max_period = query_max_period(conn)
conn.close()