python:200526-pyDB-001.003, insert, 단건(oracle)

# DB-003, python DB insert
import pandas as pd 
import cx_Oracle
import time 
# conn=cx_Oracle.connect("scott/tiger@192.168.182.1:1521/xe")

# def save_data():

db = conn=cx_Oracle.connect("scott/tiger@192.168.182.1:1521/xe")
try:
    cr = db.cursor()
except:
    print('database connection faile')

# # insert into emp(
# EMPNO    =7500
# ENAME    ='ALLEN'
# JOB      ='SALESMAN'
# MGR      =7698
# HIREDATE ='SYSDATE'
# SAL      =1600
# COMM     =300
# DEPTNO   =30

# # insert into emp(
EMPNO    ='7500'
ENAME    ='ALLEN'
JOB      ='SALESMAN'
MGR      ='7698'
HIREDATE ='82/01/24'
# Get_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
SAL      ='1600'
COMM     ='300'
DEPTNO   ='30'
# # ) values('7500','ALLEN','SALESMAN','7698',SYSDATE,'1600','300','30');

# table_sql= "insert into emp('"+EMPNO+"','"+ENAME+"','"+JOB+"','"+MGR+"','"+"to_timestamp('" + Get_time + "','yyyy-mm-dd hh24:mi:ss')"+"','"+SAL+"','"+COMM+"','"+DEPTNO + "')"
table_sql= "insert into emp values('"+EMPNO+"','"+ENAME+"','"+JOB+"','"+MGR+"','"+HIREDATE+"','"+SAL+"','"+COMM+"','"+DEPTNO + "')"
print(table_sql)
cr.execute(table_sql)
print("table is ok")

cr.close()
db.commit()
db.close()
    
# # if __name__ == '__main__':
# # save_data()