public void testInsertWithValues() {
final String fname = "Jack";
final String lname = "Sparrow";
Criterion lastNameSparrow = TestModel.LAST_NAME.eqCaseInsensitive(lname);
TestModel shouldBeNull = database.fetchByCriterion(TestModel.class, lastNameSparrow, TestModel.PROPERTIES);
assertNull(shouldBeNull);
Insert insert = Insert.into(TestModel.TABLE).columns(TestModel.FIRST_NAME, TestModel.LAST_NAME).values(fname,
lname);
CompiledStatement compiled = insert.compile(database.getCompileContext());
verifyCompiledSqlArgs(compiled, 2, fname, lname);
assertEquals(2, database.insert(insert));
TestModel shouldNotBeNull = database.fetchByCriterion(TestModel.class, lastNameSparrow, TestModel.PROPERTIES);
assertNotNull(shouldNotBeNull);
assertEquals(fname, shouldNotBeNull.getFirstName());
assertEquals(lname, shouldNotBeNull.getLastName());
}