def is_existed(stockId, report_date, errorType): mycursor = mydb.cursor() mycursor.execute(sqlIsExisted, (stockId, report_date, errorType)) result = mycursor.fetchall() mydb.commit() if (len(result) > 0): return True else: return False
def is_existed(sql, stockId, data): mycursor = mydb.cursor() mycursor.execute(sqlIsExisted, (stockId, data[0])) result = mycursor.fetchall() mydb.commit() if (len(result) > 0): return True else: return False
def save(stockId, report_date, errorType): data = [] now = datetime.datetime.now() now = now.strftime("%Y-%m-%d %H:%M:%S") data.append(now) data.append(stockId) data.append(report_date) data.append(errorType) data.append(0) if (is_existed(stockId, report_date, errorType)): print("存储股票代码:" + stockId + "," + report_date + "期错误日志已存在") else: mycursor = mydb.cursor() mycursor.execute(sqlInsert, data) mydb.commit() print("存储股票代码:" + stockId + "," + report_date + "期错误日志成功")
def save(sql, data): mycursor = mydb.cursor() mycursor.execute(sql, data) mydb.commit()
def save(sql, data): mycursor = mydb.cursor() mycursor.execute(sql, data) mydb.commit() print(mycursor.lastrowid)