my python 第一帖 访问oracle数据库

frhwezsguj

　　学习python第一帖
　　项目中需要自动往oracle中插入随机数据，原来是用procedure弄得，但在toad中一个procedure执行需要占用整个窗口，有多个procedure，需要多个窗口。 所以想用脚本语言来替代，选择了python。纪念之！
　　
　　#!/usr/bin/env python
#
#
import cx_Oracle;
import sys;
import time,datetime;
import random;
 
TT_ALARM_RAISETIME = datetime.datetime(2008, 8, 2, 12, 30, 25)
IncidentNum = 60000000001;
SERVICEID = '987654321';
counter = 0;
　　
   
while(True):
    IncidentID='SOS'+str(IncidentNum);
    TTNONCOMPELLINGDURATION=1
    TTCOMPELLINGDURATION = random.randint(0,5);
    SERVICEID=random.randint(1,100);
    ranNum=random.randint(1,100);
    TT_ALARM_RAISETIME = TT_ALARM_RAISETIME+ datetime.timedelta(seconds=60)
    if ranNum>10:
        OPENCODE='closed';
    else:
        OPENCODE='open - idle';
        
        
    try:
        my_conn = cx_Oracle.connect("DEMO6","DEMO6","BEAVER.iyunv.com")
        my_cursor = my_conn.cursor();
        nowTime = datetime.datetime.now()
        #SYSTEMMODTIME = time.strftime('%Y-%m-%d %H:%M:%S', nowTime)
        #SYSTEMMODTIME=datetime.strptime(nowTime, "%Y-%m-%d %H:%M:%S")
        SYSTEMMODTIME= str(nowTime)[0:19]
       
        #print("SYSTEMMODTIME==", SYSTEMMODTIME)
      
        sql="""insert into INCIDENTSM1(INCIDENT_ID, TT_ALARM_RAISETIME,TT_COMPELLING_DURATION, TT_NON_COMPELLING_DURATION, RESOLUTION_CODE, OPEN, SERVICE_ID, SYSMODTIME) values('%s',to_date('%s', 'YYYY-MM-DD HH24:MI:SS'), %s, %s,'3.SAHIS HASARLARI', 'closed', '%s', to_date('%s', 'YYYY-MM-DD HH24:MI:SS')) """ % (IncidentID,TT_ALARM_RAISETIME, TTCOMPELLINGDURATION, TTNONCOMPELLINGDURATION, SERVICEID, SYSTEMMODTIME)
        print("sql==", sql)
        my_cursor.execute(sql)
        my_conn.commit()
      
    except:
        sys.stderr.write("execute sql error\n")
    finally:
        my_cursor.close();
        my_conn.close();
    IncidentNum+=1