Zagadka's Site

Off to work as usual. Hope I get a seat. I'm keen to do some more work on my invoice parser/query tool.

It's a tool used to parse ACCPAC for DOS invoices and stick their contents in a database in a sensible schema that I can report on. Once I can reproduce an invoice, the most basic function - I can move to phase 2, integrating parsing of the payments report and collating that with the invoices in several management reports. This involves porting one of my previous scripts from PHP/MySQL to Python/Postgres. Phase 3 is integration of internet orders data into the bargain. (Python, PHP, Javascript)

Once at work, I'm on a customer job. Writing a database synchronisation script thats designed to replicate a MySQL database into Postgres based around a FIFO table in the MySQL DB. FIFO Records are created by triggers in the MySQL database. The script needs some smarts because of the convoluted way that the developers of the software based around this database do updates. Apparently they didn't know about update - or weren't prepared to plumb in the necessary mechanics to allow the software to decided that it's updating. Their solution: DELETE the record and INSERT every time... Joy.

brewbox (fridge control server) seems to be working away happily - although I haven't connected the controller yet. I need to test the compressor lag routine in the control script. I want to make sure it works before I plug the fridge into it, in case I damage the fridges compressor by turning it on straight after it's been turned off.