User:Pathoschild/Automated metadata reporting

(Don't mind this page, just a note to self.)

Goal

Automated maintenance and creation of index pages, author pages, report pages, and other lists based on {{header}} and {{author}} data.

Method

Read all pages on Wikisource (or local copy thereof), extracting the metadata based on HTML markup;
create comprehensive database of metadata;
regularly read new pages and edits, update database, and update pages appropriately;
update author pages with works attributed to them but not listed;
create customizeable index/report pages using an editable subpage, mockup:

<report>
	<title>Wikisource:Ancient_authors</title>
	<query>SELECT author_name,author_birth,author_death FROM authors WHERE category LIKE "Ancient_authors"</query>
	<format>* [[Author:<author_name/>|]] (<author_birth/>–<author_death/>)</format>
</report>

Various ideas

Dynamic report pages

<report>
	<title>Author:<author_name/></title>
	<query>SELECT author_name,work_title,work_date FROM authors LEFT JOIN works on author_name=work_author ORDER BY author_name</query>
	<format>* [[<work_title/>|]] (<work_date/>)</format>
</report>

Indexes report

incomplete indexes, without ToC, publisher, date, etc.
indexes ordered by size / number of pages