penk

Just quick update on this. Last night I did get some coding time in after blog-posting. The fix this time was a problem with Create Registrant that was throwing SQL errors all over the place. Turns out I never actually completed writing the DAO for the Registrant data object, and the create() method was broken in a ton of interesting ways.

There's still a twitch in restoring the state to the editor after creation - it's not reloading the new registrant into the sessionspace after creation, so you end up with a sort of 'blank' registrant screen. Exiting and coming back shows the new entry, so it is creating it, just isn't reloading.

I'm sort of worried about keeping history right now. The old code did everything in the history table programmatically - so whenever I made a change to a registrant's information, I had to make a call to logEntry() to create a new history record. So, naturally, there was some inconsistencies in the logging. It also didn't help that the history table was critical information. It was part informational, part auditing. In fact, some parts of CONGO used the history table to recalculate statistics and status on registrants. (Note - that is SO not going to be in the rewrite).

Anyway - regarding logging, I'm looking into learning MySQL triggers to have registrant history updated automatically whenever a change happens. That way I don't have to always remember to put in a logging call. We'll see if this is viable (for instance, how does the trigger know what the ID of the operator is? The one who is actually making the change?)

Stay tuned. :)

Cloned from: Planet Geek!
Category: Programming-fu
Full article & comments: Link (Comment ticker:

)