四
01
记于2012年愚人节温暖的下午
早晨起床的时候心情之沮丧着实是很配合即将到来的清明节。出门又逢上地铁故障，大批苦逼上班族滞留，导致在车终于开来的时候，我是被挤成饺子馅儿样才塞进了轨道交通2号线。那时我几乎认定了，今天是甭想做出点啥了…
午饭之后决定对自己降低要求，完成一个小任务~经过几下折腾与不耻上问，实现了利用pyodbc访问Teradata.因为怕把mentor的数据弄出什么岔子，自己在数据库新建了一张表(有呀嘛有权限)，把昨晚整理的数据更新了进去。
无代码无真相…
#coding=utf-8
import pyodbc
#reading data into a dict
UPL = open('C:\\rainywh269\\work\\20120401\\UPL.txt')
dic = {}
for line in UPL:
prtnr_id = line.split()[0]
yn = line.split()[1]
dic[prtnr_id] = yn
#connecting to Teradata
conn = pyodbc.connect('DRIVER={Teradata}; DBCNAME=CARACAL; UID=rianywh269;PWD=rainywh269;QUIETMODE=YES;')
cursor = conn.cursor()
#my queries
q_create = 'CREATE TABLE p_***_t.wh_ps_tmp_t AS p_***_t.amy_***_lkp with data;'
q_alter = 'ALTER TABLE p_***_t.wh_ps_tmp_t ADD document_YN VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC;'
q_update = 'UPDATE p_cac_t.wh_ps_tmp_t SET document_YN = ? where prtnr_id = ?'
q_sel = 'sel * from p_***_t.wh_ps_tmp_t'
cursor.execute(q_create)
cursor.execute(q_alter)
for k in dic.keys():
cursor.execute(q_update,dic[k],k)
#Don't don't forget commit()!!!!
conn.commit()
#validation of the manipulation
cursor.execute(q_sel)
row = cursor.fetchone()
print row
#closing connection
cursor.close()
print 'Happy April Fool!'
import pyodbc
#reading data into a dict
UPL = open('C:\\rainywh269\\work\\20120401\\UPL.txt')
dic = {}
for line in UPL:
prtnr_id = line.split()[0]
yn = line.split()[1]
dic[prtnr_id] = yn
#connecting to Teradata
conn = pyodbc.connect('DRIVER={Teradata}; DBCNAME=CARACAL; UID=rianywh269;PWD=rainywh269;QUIETMODE=YES;')
cursor = conn.cursor()
#my queries
q_create = 'CREATE TABLE p_***_t.wh_ps_tmp_t AS p_***_t.amy_***_lkp with data;'
q_alter = 'ALTER TABLE p_***_t.wh_ps_tmp_t ADD document_YN VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC;'
q_update = 'UPDATE p_cac_t.wh_ps_tmp_t SET document_YN = ? where prtnr_id = ?'
q_sel = 'sel * from p_***_t.wh_ps_tmp_t'
cursor.execute(q_create)
cursor.execute(q_alter)
for k in dic.keys():
cursor.execute(q_update,dic[k],k)
#Don't don't forget commit()!!!!
conn.commit()
#validation of the manipulation
cursor.execute(q_sel)
row = cursor.fetchone()
print row
#closing connection
cursor.close()
print 'Happy April Fool!'
After that,虽然积压的事情们都没有什么进展，心情倒是扶摇直上，一如回家路上的烂漫小樱花了~~
坐等某人带我去吃石锅拌饭和芋贵人~
顺祝大家伙儿节日开心!
@German Center