Narratives 2025-03-24 to 2025-03-28
to : Martin Holmes
Minutes: 330
On Wednesday, GN and I wrote and tested a Python script which dumps all the databases as SQL and XML, and also dumps three tables from each in CSV format. Got this working and tested, and supplemented it with a local script to pull the dumped content into the repo for safe-keeping. There’s more work to do here, but we’re making progress.
On Thursday, checked the dumps and confirmed they were good, and then started work on some XSLT to generate the exact CSVs as produced by the AdaptiveDB so we don’t have to run complicated dump code on the server.
On Friday, finished and tested the XSLT, then renamed the CSVs in the repo and ran the script to update them all. Updated the server cron job so it’s only dumping databases in SQL and XML. Phase one is done; we just now need to figure out how best to let CB run these scripts (since Java/Saxon will be needed for the XSLT).