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