oracle 的insert操作

oracle的insert操作

 

import threading
import time
import cx_Oracle
import random
'''
前提：在oracle中设置主键字段自增
'''
def try_to_connect_and_insert():
        username="source_db"
        userpwd="gpadmin"
        host="*.*.*.*"
        port=1521
        dbname="orcl"
        dsn=cx_Oracle.makedsn(host,port,dbname)
        try:
                connection=cx_Oracle.connect(username,userpwd,dsn)
                connection.autocommit=True
                for i in range(1000, 2001):
                    s = str(i)
                    score = str(round((random.randint(50, 100) + random.random())))
                    sql = "insert into oracle2gpt values(%s,'o2g%s',%s,to_date('2020-05-02 15:42:56','yyyy-mm-dd hh24:mi:ss'))" % (
                    s, s, score)
                # sql="insert into oracle2gpt(SID,SNAME,SCORE,CREATE_DATE) VALUES(9999,'s9999',88.8,to_date('20200121','yyyymmdd'))"
                    cursor=connection.cursor()
                    cursor.execute(sql)
                    print(i)
                cursor.close()
                connection.close()
        except Exception as e:
                print(e)


if __name__ == '__main__':
        for i in range (10):
                T = threading.Thread(target=try_to_connect_and_insert)
                T.start()
                time.sleep(1)