Monday, October 2, 2017

This weekend I worked 9 hours on how to make the SQL for AccountingReport more efficient. It was about Using aggregates within a Subquery expression. Now finally I can check in. Here is a summary of the changes:

  • Fixed the Gateway timeout problem in lino_xl.lib.ledger.AccountingReport by optimizing the SQL query.

  • The restore.py file created by dump2py now calls resetsequences after loading the dump. Because it doesn’t take much time, and because forgetting it can cause frustration.

  • atelier.rstgen had a problem for rendering the empty_column columns. Fixed (but just a hack, to be reviewed).

I continued to hunt some failures under Python 3

  • TypeError: Problem installing fixture ‘…demo_bookings.py’: argument must of text type (282196028)