rely on the lookup method to ensure DRY use of mysql usage
add tests, support resetting stats, and check for missing parameters on update