public void UpdateQueryWithNullThrowsException()
{
// Skip this test if the Dll doesn't support the extended SQLITE_CONSTRAINT codes
using (TestDb db = new TestDb()) {
db.CreateTable <NotNullNoPK> ();
try {
db.Execute("insert into \"NotNullNoPK\" (AnotherRequiredStringProp, RequiredIntProp, RequiredStringProp) values(?, ?, ?)",
new object[] { "Another required string", 123, "Required string" });
db.Execute("update \"NotNullNoPK\" set AnotherRequiredStringProp=?, RequiredIntProp=?, RequiredStringProp=? where ObjectId=?",
new object[] { "Another required string", 123, null, 1 });
}
catch (NotNullConstraintViolationException) {
return;
}
catch (SQLiteException ex) {
if (SQLite3.LibVersionNumber() < 3007017 && ex.Result == SQLite3.Result.Constraint)
{
Inconclusive();
return;
}
}
catch (Exception ex) {
Assert.Fail("Expected an exception of type NotNullConstraintViolationException to be thrown. An exception of type {0} was thrown instead.", ex.GetType().Name);
}
Assert.Fail("Expected an exception of type NotNullConstraintViolationException to be thrown. No exception was thrown.");
}
}