public void Can_convert_ModelWithFieldsOfNullableTypes()
{
var model = ModelWithFieldsOfNullableTypes.Create(1);
var toModel = Serialize(model);
ModelWithFieldsOfNullableTypes.AssertIsEqual(toModel, model);
}
public void Can_Serialize_populated_model_of_NullableTypes()
{
var model = ModelWithFieldsOfNullableTypes.Create(1);
var json = JsonSerializer.SerializeToString(model);
var fromJson = JsonSerializer.DeserializeFromString <ModelWithFieldsOfNullableTypes>(json);
ModelWithFieldsOfNullableTypes.AssertIsEqual(model, fromJson);
}
public void Can_insert_and_select_from_ModelWithFieldsOfNullableTypes_table()
{
using (var db = OpenDbConnection())
{
db.CreateTable <ModelWithFieldsOfNullableTypes>(true);
var row = ModelWithFieldsOfNullableTypes.Create(1);
db.Insert(row);
var rows = db.Select <ModelWithFieldsOfNullableTypes>();
Assert.That(rows, Has.Count.EqualTo(1));
ModelWithFieldsOfNullableTypes.AssertIsEqual(rows[0], row);
}
}
public void Can_insert_and_select_from_ModelWithFieldsOfNullableTypes_table()
{
using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open())
{
db.CreateTable <ModelWithFieldsOfNullableTypes>(true);
var row = ModelWithFieldsOfNullableTypes.Create(1);
db.Insert(row);
var rows = db.Select <ModelWithFieldsOfNullableTypes>();
Assert.That(rows, Has.Count.EqualTo(1));
ModelWithFieldsOfNullableTypes.AssertIsEqual(rows[0], row);
}
}
public void Can_DeleteNonDefaults_entity_with_nullable_DateTime()
{
db.DropAndCreateTable <ModelWithFieldsOfNullableTypes>();
var row = ModelWithFieldsOfNullableTypes.Create(1);
row.NDateTime = null;
db.Save(row);
row = db.SingleById <ModelWithFieldsOfNullableTypes>(row.Id);
var rowsAffected = db.DeleteNonDefaults(row);
Assert.That(rowsAffected, Is.EqualTo(1));
row = db.SingleById <ModelWithFieldsOfNullableTypes>(row.Id);
Assert.That(row, Is.Null);
}
public void Can_DeleteNonDefaultsAll_entity_with_nullable_DateTime()
{
db.DropAndCreateTable <ModelWithFieldsOfNullableTypes>();
var rows = 3.Times(i => ModelWithFieldsOfNullableTypes.Create(i));
rows.Each(x => x.NDateTime = null);
db.SaveAll(rows);
db.Save(ModelWithFieldsOfNullableTypes.Create(3)); // extra row shouldn't be deleted
rows = db.SelectByIds <ModelWithFieldsOfNullableTypes>(rows.Map(x => x.Id));
var rowsAffected = db.DeleteNonDefaults(rows.ToArray());
Assert.That(rowsAffected, Is.EqualTo(rows.Count));
rows = db.SelectByIds <ModelWithFieldsOfNullableTypes>(rows.Map(x => x.Id));
Assert.That(rows.Count, Is.EqualTo(0));
}