Database/query2csv, Database/query2json, Database/query2tt2:
if the query contained comments with placeholders they would be
added to the count and would usually cause the script to request
'-dbarg=ARG' values be added. Now the SQL has all comments
stripped to avoid this.
Database/hosts_list.tpl, Database/hosts_showcount.sqlite.sql: examples
of using 'query2tt2'
Database/query2csv, Database/query2json, Database/query2tt2: minor bug
fix relating to '-dbarg=ARG' option
Database/edit_episode: updated a message
Database/query2csv, Database/query2tt2: updated both scripts to handle
SQLite and MySQL databases; both take (almost) the same options;
both query a database in a similar way with arguments to match
placeholders; 'query2tt2' takes a TT² template and options to feed
to it; converted the database connection section to a function
'db_connect'; both have comprehensive POD documentation.
Database/query2tt2: comment and documentation updates; use of Perl's
try/catch.
InternetArchive/.make_metadata.cfg: added comments for readability
InternetArchive/make_metadata: bug fix needed now that all shows on the HPR server have
a directory with assets under it.
InternetArchive/repair_assets: new Bash script in development. Collects
assets from the IA and uploads them to a new directory on the HPR
server. Will run 'fix_asset_links' (to repair asset links for their
new directories) once it is ready.
InternetArchive/repair_item: Bash script which was originally written to
run on 'borg' and upload files to a new IA item when the uploads
timed out. Now enhanced to upload missing files recovered from the
HPR backup disk, such as transcripts.
