python 抽取数据
来源:互联网 发布:编程机器人2在线 编辑:程序博客网 时间:2024/06/06 19:51
# -*- coding: utf-8 -*-import cx_Oraclefrom pprint import pprintimport csvimport timeimport reimport binasciiconn = cx_Oracle.connect('system/oracle@192.168.137.2/serv')cursor = conn.cursor()table_name="t300"owner="system"f = open(table_name+".csv", "w")writer = csv.writer(f, lineterminator="\n", quoting=csv.QUOTE_NONNUMERIC)xsql="select COLUMN_NAME from dba_tab_columns where table_name=upper("+"'"+table_name+"'"+")and owner=upper("+"'"+owner+"'"+")"+" "+"order by column_id asc"print xsqlr = cursor.execute(xsql)columns=[];for (col,) in r: print col columns.append(col)ysql="select COLUMN_NAME,DATA_TYPE from dba_tab_columns where table_name=upper("+"'"+table_name+"'"+")and owner=upper("+"'"+owner+"'"+")"+" "+"order by column_id asc"d={}r = cursor.execute(ysql)m=0arr1=[]for j in r: #print j if (j[1]=='RAW'): print j[1] arr1.append(m) else: pass m = m + 1print arr1print '------------------'exportOracleSql="SELECT ";for i in range(0, len(columns)): if i != len(columns) - 1: exportOracleSql=exportOracleSql+columns[i]+',' else: exportOracleSql = exportOracleSql + columns[i]exportOracleSql=exportOracleSql+" "+"from"+" "+owner+"."+table_nameprint exportOracleSqlcursor.execute("alter session set nls_date_format='yyyy-mm-dd'")s1 = cursor.execute(exportOracleSql)for row in s1: #print type(row) s2=[] for i in range(0,len(row)): if (i in arr1): #print (binascii.b2a_hex(row[i])) s2.append(binascii.b2a_hex(row[i])) #writer.writerow( binascii.b2a_hex(row[i])) else: #print row[i] s2.append(row[i]) #writer.writerow(row[i]) print s2 writer.writerow(s2)f.close()cursor.close()close__ = conn.close()
阅读全文
0 0
- python 抽取数据
- Python-mysql 抽取数据 脚本
- 数据抽取
- Kettle数据抽取---增量抽取
- Python 爬虫 正则抽取网页数据和Scrapy简单使用
- python将mysql表中数据抽取到另一个mysql库中,持续更新抽取到oracle中
- python 抽取信息
- Python 随机数抽取
- python爬虫抽取武侠小说
- python脚本抽取patch
- caffe -- Python特征抽取
- Structure数据抽取异常
- 数据抽取,转换,加载
- ETL(数据抽取)[转]
- ssis数据增量抽取
- 数据抽取问题记录
- ETL(数据抽取)
- ETL数据抽取策略
- 高斯、中值、均值、双边滤波
- 一段代码样本
- 操作系统进程
- 如何在页面正确展示表中存储的html
- 合格的字符串
- python 抽取数据
- js无缝滚动
- JDK动态代理为什么必须用接口
- opencv 绘制H-S直方图
- git merge 和 git rebase 小结
- Nifi读取Hive中数据然后再写入新Hive数据库表操作
- 倒计时
- android插件式换肤和应用内换肤
- 解决html的textarea表单里x变为emoji表情问题