def delete_failed_sg_in_db(main_id_sg): """delete sg-main if register sg-content fails""" lib_cm.message_write_to_console(ac, u"delete_failed_sg_in_db with nr: " + str(main_id_sg)) ACTION = ("DELETE FROM SG_HF_MAIN WHERE SG_HF_ID = " + str(main_id_sg) + " ROWS 1") db.dbase_connect(ac) if db.db_con is None: err_message = (u"Error General: " "No connection to db for delete_failed_sg_in_db") lib_cm.error_write_to_file(ac, err_message) return None try: db_cur = db.db_con.cursor() db_cur.execute(ACTION) db.db_con.commit() db.db_con.close() log_message = u"Loeschen der Sendung bei Fehlschlag SG_CONT.. " db.write_log_to_db_a(ac, log_message, "e", "write_also_to_console") except Exception, e: err_message = u"Error 2 delete_failed_sg_in_db: %s" % str(e) #db.write_log_to_db_a(ac, err_message , "x", "write_also_to_console" ) lib_cm.error_write_to_file(ac, err_message) db.write_log_to_db(ac, ac.app_errorslist[3], "x") db.db_con.rollback() db.db_con.close() return None
def delete_tweet_log_in_db_log(): """delete old Logs in DB-log""" lib_cm.message_write_to_console(ac, u"delete_tweet_log_in_db_log") date_log_back = (datetime.datetime.now() + datetime.timedelta(days=- 1)) c_date_log_back = date_log_back.strftime("%Y-%m-%d %H:%M") ACTION = ("DELETE FROM TWITTER_LOGS WHERE TW_LOG_TIME < '" + c_date_log_back + "'") db.dbase_log_connect(ac) if db.db_log_con is None: err_message = u"No connect to db for delete_tweet_log_in_db_log" lib_cm.error_write_to_file(ac, err_message) return None try: db_log_cur = db.db_log_con.cursor() db_log_cur.execute(ACTION) db.db_log_con.commit() db.db_log_con.close() log_message = (u"Loeschen der Tweetlogs " "in DB-Log-Tabelle die von gestern sind") db.write_log_to_db(ac, log_message, "e") except Exception, e: lib_cm.message_write_to_console(ac, log_message + u"Error 2 delete_tweet_log_in_db_log: %s</p>" % str(e)) err_message = (log_message + u"Error 2 delete_tweet_log_in_db: %s" % str(e)) lib_cm.error_write_to_file(ac, err_message) db.db_log_con.rollback() db.db_log_con.close() return None
def delete_tweet_log_in_db_log(): """delete old Logs in DB-log""" lib_cm.message_write_to_console(ac, u"delete_tweet_log_in_db_log") date_log_back = (datetime.datetime.now() + datetime.timedelta(days=-1)) c_date_log_back = date_log_back.strftime("%Y-%m-%d %H:%M") ACTION = ("DELETE FROM TWITTER_LOGS WHERE TW_LOG_TIME < '" + c_date_log_back + "'") db.dbase_log_connect(ac) if db.db_log_con is None: err_message = u"No connect to db for delete_tweet_log_in_db_log" lib_cm.error_write_to_file(ac, err_message) return None try: db_log_cur = db.db_log_con.cursor() db_log_cur.execute(ACTION) db.db_log_con.commit() db.db_log_con.close() log_message = (u"Loeschen der Tweetlogs " "in DB-Log-Tabelle die von gestern sind") db.write_log_to_db(ac, log_message, "e") except Exception, e: lib_cm.message_write_to_console( ac, log_message + u"Error 2 delete_tweet_log_in_db_log: %s</p>" % str(e)) err_message = (log_message + u"Error 2 delete_tweet_log_in_db: %s" % str(e)) lib_cm.error_write_to_file(ac, err_message) db.db_log_con.rollback() db.db_log_con.close() return None