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
list.default_duration > 0 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)
query = f"""
SELECT request_id,
update_time,
list.title as nom,
requests.number,
voting_title,
[values].title,
value as file
FROM [values], requests, list
{main_foto_join}
WHERE list.id = topic_id
AND request_id = requests.id
AND status != 'disapproved'
AND type IN ('file', 'image')
AND card_code IN ({not_scene_card_codes})
{main_foto_where}
ORDER BY request_id
"""
def preprocess(num, dir_name, file_name):
new_dir_name = '' # No subdirectory for each file
new_file_name = re.sub(r'[^\wа-яА-Я]+', '-', dir_name).strip('-')
new_file_name = str(num) + '. ' + new_file_name
return False, new_dir_name, new_file_name
d = Downloader(preprocess)
if d.get_lists(db_path, query):
print('\nDownloading files...')
d.download_files(folder_path, d.DOWNLOAD_UPDATED_REQUESTS)
