利用python向mysql數(shù)據(jù)庫插入timestamp
利用python向mysql數(shù)據(jù)庫插入timestamp
def insert_install_service_info(serviceName,nodeID,nodeIP='9.42.83.54'):
? ?conn = MySQLdb.connect(host='172.17.46.15',user='root',passwd='huxin2010')
? ?curs = conn.cursor()
? ?serviceNode = {}
? ?try:
? ? ? ?conn.select_db('nodeInfo')
? ?except Exception:
? ? ? ?logger.error("the database you find does not exist!")
? ?try:
? ? ? ?sql = "insert into service3 values('NULL',%s,%s,%s,%s)"
? ? ? ?now = datetime.datetime.now()
? ? ? ?now = now.strftime("%Y-%m-%d %H:%M:%S")
? ? ? ?values = [serviceName,nodeID,nodeIP,now]
? ? ? ?curs.execute(sql,values)
? ?except Exception:
? ? ? ?logger.error("error: insert data fail")
? ?conn.commit()
? ?curs.close()
? ?conn.close()
標(biāo)簽：
