Page History

...

• An instance of Runnable that periodically saves messages to the Oracle DB

Image Modified

• Eli wrote a great PL/SQL procedure that hides (almost) all the details

  Code Block
  BEGIN MPS_HISTORY.MPS_HISTORY_PKG.DML_%s1 (%s2); END;

• %s1 = table name
• %s2 = CSVs in the same order as in the schema with following caveats:
  • top-to-bottom = left-to-right
  • ignore the ID column
  • replace the FKs with enums from the referenced table

edu.stanford.slac.mpshist.MessageServer

...