def test_generate_new_job(self): # given: dbfile = '%s/dbfile.db' % self.tmp_folder persistence = SqlitePersistence(dict(options={'database': dbfile}), meta()) # when: db_id = persistence.generate_new_job() # then: self.assertEqual(len(query_db(dbfile, 'SELECT 1 FROM job')), 2) self.assertEqual(len(query_db(dbfile, 'SELECT 1 FROM job WHERE id = %s' % db_id)), 1)