add connection properties for test database and update test database sql to reflect generated_id field in assertions.
finished adding generated_id support for assertions; added basic test coverage for assertions and for generated_id updates for assertions and publications