update api and models to new version of db, also create convenience methods