av一区二区在线观看_亚洲男人的天堂网站_日韩亚洲视频_在线成人免费_欧美日韩精品免费观看视频_久草视

您的位置:首頁技術文章
文章詳情頁

基于python連接oracle導并出數據文件

瀏覽:4日期:2022-07-27 10:24:06

python連接oracle,感覺table_list文件內的表名,來卸載數據文件

主腳本:

import osimport loggingimport sysimport configparserimport subprocessimport cx_Oracle#判斷輸入參數個數class param(): def check_para(self): if len(sys.argv) != 1: print('請輸入正確的參數:yyyymmdd') exit(1) else: print('繼續執行')#根據配置文件獲取登錄信息class get_dbini(): def get_db(self): config=configparser.ConfigParser() filepath='db.ini' if os.path.exists(filepath): config.read_file(open(filepath)) dbinfo=[config.get('db_oracle','username'), config.get('db_oracle','password'), config.get('db_oracle','ip'), config.get('db_oracle','dbsid')] else: loginfo.info('沒有那個配置文件') sys.exit(4) #聲明使用全局變量 global username,password,ip,dbsid username=dbinfo[0] password=dbinfo[1] ip=dbinfo[2] dbsid=dbinfo[3] loginfo.info(username+password+ip+dbsid) #導出表數據class exp_date(): def exp_table(self): with open(’table_list’,’r’) as f: list = f.readlines() for i in list: tablename = i.rstrip(’n’) exportquery=’sqluldr2 user=’+username+’/’+password+’@’+ip+’:1521/’+dbsid+’ query='select * from ’+tablename+’;' head=no file=’+tablename+’.dat field=0x03 record=0x030x0a safe=yes’ loginfo.info('開始導出數據: exportquery= '+exportquery) flag= subprocess.check_call(exportquery,shell=True) loginfo.info(flag) #打印日志class log_set(): def logger_set(self): logger=logging.getLogger(’mylogger’) logger.setLevel(logging.DEBUG) fh=logging.FileHandler(’a.log’,’w’) fh.setLevel(logging.INFO) ch=logging.StreamHandler() ch.setLevel(logging.ERROR) formatter = logging.Formatter(’%(asctime)s -%(name)s -%(levelname)s - %(message)s’) fh.setFormatter(formatter) ch.setFormatter(formatter) logger.addHandler(fh) logger.addHandler(ch) return loggerif __name__==’__main__’: loginfo=log_set().logger_set() param().check_para() get_dbini().get_db() exp_date().exp_table()

DB配置文件內容:

db.ini

[db_oracle]username=c##scottpassword=tigerip=192.168.1.250dbsid=orcl

表名字的配置文件:

table_list

BONUSDEPTEMPLEAD_TABLESALGRADET1TB_USERTESTXGJXGJ_2

運行結果:

[oracle@master2 tmp]$ python3 c.py 繼續執行0 rows exported at 2019-01-22 17:51:51, size 0 MB.output file BONUS.dat closed at 0 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.4 rows exported at 2019-01-22 17:51:52, size 0 MB.output file DEPT.dat closed at 4 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.12 rows exported at 2019-01-22 17:51:52, size 0 MB.output file EMP.dat closed at 12 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.10 rows exported at 2019-01-22 17:51:52, size 0 MB.output file LEAD_TABLE.dat closed at 10 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.5 rows exported at 2019-01-22 17:51:52, size 0 MB.output file SALGRADE.dat closed at 5 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.5 rows exported at 2019-01-22 17:51:52, size 0 MB.output file T1.dat closed at 5 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.10 rows exported at 2019-01-22 17:51:52, size 0 MB.output file TB_USER.dat closed at 10 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.8 rows exported at 2019-01-22 17:51:52, size 0 MB.output file TEST.dat closed at 8 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.9 rows exported at 2019-01-22 17:51:52, size 0 MB.output file XGJ.dat closed at 9 rows, size 0 MB.0 rows exported at 2019-01-22 17:51:52, size 0 MB.8 rows exported at 2019-01-22 17:51:52, size 0 MB.output file XGJ_2.dat closed at 8 rows, size 0 MB.

查看日志:

[oracle@master2 tmp]$ more a.log2019-01-22 17:51:51,858 -mylogger -INFO - c##scotttiger192.168.1.250orcl2019-01-22 17:51:51,858 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from BONUS;' head=no file=BONUS.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:51,949 -mylogger -INFO - 02019-01-22 17:51:51,949 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from DEPT;' head=no file=DEPT.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,038 -mylogger -INFO - 02019-01-22 17:51:52,038 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from EMP;' head=no file=EMP.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,129 -mylogger -INFO - 02019-01-22 17:51:52,129 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from LEAD_TABLE;' head=no file=LEAD_TABLE.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,299 -mylogger -INFO - 02019-01-22 17:51:52,300 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from SALGRADE;' head=no file=SALGRADE.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,401 -mylogger -INFO - 02019-01-22 17:51:52,402 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from T1;' head=no file=T1.datfield=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,490 -mylogger -INFO - 02019-01-22 17:51:52,490 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from TB_USER;' head=no file=TB_USER.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,578 -mylogger -INFO - 02019-01-22 17:51:52,578 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from TEST;' head=no file=TEST.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,665 -mylogger -INFO - 02019-01-22 17:51:52,665 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from XGJ;' head=no file=XGJ.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,771 -mylogger -INFO - 02019-01-22 17:51:52,771 -mylogger -INFO - 開始導出數據: exportquery= sqluldr2 user=c##scott/tiger@192.168.1.250:1521/orcl query='select * from XGJ_2;' head=no file=XGJ_2.dat field=0x03 record=0x030x0a safe=yes2019-01-22 17:51:52,856 -mylogger -INFO - 0

以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持好吧啦網。

標簽: Python 編程
相關文章:
主站蜘蛛池模板: 午夜精品一区二区三区在线 | 麻豆av在线 | 精品在线一区 | 中文字幕高清视频 | 天天爽天天操 | 国产精品免费看 | 亚洲精品国产一区 | 久草影视在线 | 久久伊人免费视频 | 欧美日韩中文字幕在线播放 | av手机在线免费观看 | 精品久久久久久亚洲精品 | 91精品国产欧美一区二区成人 | 五月天婷婷久久 | 中文字幕视频在线看 | 久久久精品高清 | 午夜噜噜噜 | 亚洲国产精品久久久久婷婷老年 | 日韩美女在线看免费观看 | 欧美一区2区三区4区公司 | www.狠狠干| 国产成人麻豆免费观看 | 国产精品久久久久久久久久妞妞 | 精品国产一级 | 国产成人在线播放 | 欧美成人一区二区 | 综合久久综合久久 | 97caoporn国产免费人人 | 欧美理论片在线观看 | 精品蜜桃一区二区三区 | 精品国产免费一区二区三区演员表 | 国内精品视频在线观看 | 密室大逃脱第六季大神版在线观看 | 粉嫩av久久一区二区三区 | 国产三级| 天天成人综合网 | 日韩电影一区 | 国产一级免费在线观看 | 欧美激情精品久久久久久 | 91在线观看视频 | 伊人伊人|