python连接Teradata数据库

84 阅读 0 评论 56 点赞

我是靠谱客的博主开心草丛，最近开发中收集的这篇文章主要介绍python连接Teradata数据库，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

#!C:/Profile
#-*-coding:utf-8-*-
import os
import datetime
import pyodbc
import pandas as pd
path = ''
os.chdir(path)
date_fw = (datetime.date.today() + datetime.timedelta(days=-1)).strftime('%Y%m%d')[4:8]
pyodbc.pooling = False
db_conn = pyodbc.connect('DRIVER={Teradata};DBCNAME=IP;UID=USERID;PWD=PASSWORD;QUIETMODE=YES;',ansi=True,autocommit=True)
cur = db_conn.cursor()
query = ""
cur.execute(query)
getrowount = lambda cur:cur.rowcount if hasattr(cur,'rowcount') else -1
#取行数
getfields = lambda cur:[dcrp[0] for dcrp in cur.description] if hasattr(cur,'description') else None
#取字段
gettypes = lambda cur:[str(dcrp[1]) for dcrp in cur.description] if hasattr(cur,'description') else None #取字段类型
raw_data = cur.fetchall()
data = pd.DataFrame(np.array(raw_data),columns=getfields(cur)) #输出结果
data = cursor.fetchone()

转载于:https://www.cnblogs.com/king-cobra-rko/p/11166885.html