get-scene-files.py

#!/usr/bin/python3
# -*- coding: utf-8 -*-
# Author: Himura Kazuto <himura@tulafest.ru>

import os
from lib.config import read_config
from lib.downloader import Downloader

config = read_config()
db_path = config['db_path']
folder_path = config['folder_path']

query = f"""
    SELECT request_id,
           update_time,
           list.title as nom,
           requests.number,
           voting_title,
           [values].title as file_type,
           value as file
    FROM [values], requests, list
    WHERE   list.id = topic_id AND
            request_id = requests.id AND
            type IN ('file', 'image') AND
            (default_duration > 0 OR card_code = 'AGR') AND
            status != 'disapproved'
    ORDER BY [values].title
"""


def preprocess(num, name, file_name):
    skip_files_with = config['not_scene_files']
    skip_by_field = any([s in file_name for s in skip_files_with])
    dir_name = f'№{num}. {name}'
    return skip_by_field, dir_name, file_name


d = Downloader(preprocess)

if d.get_lists(db_path, query):
    print('\nDownloading files...')
    d.download_files(folder_path, d.DOWNLOAD_UPDATED_REQUESTS, flat=False)