nzbToMedia/core/utils/download_info.py
2019-04-07 17:44:25 -04:00

30 lines
855 B
Python

from __future__ import (
absolute_import,
division,
print_function,
unicode_literals,
)
import datetime
from six import text_type
from core import logger, main_db
database = main_db.DBConnection()
def update_download_info_status(input_name, status):
msg = 'Updating DB download status of {0} to {1}'
action = 'UPDATE downloads SET status=?, last_update=? WHERE input_name=?'
args = [status, datetime.date.today().toordinal(), text_type(input_name)]
logger.db(msg.format(input_name, status))
database.action(action, args)
def get_download_info(input_name, status):
msg = 'Getting download info for {0} from the DB'
action = 'SELECT * FROM downloads WHERE input_name=? AND status=?'
args = [text_type(input_name), status]
logger.db(msg.format(input_name))
return database.select(action, args)