// [Description("Create a table with a nullable int column then insert and select against it")]
public void NullableFloat()
{
var db = new OrmTestSession();
db.CreateTable <NullableFloatClass>();
var withNull = new NullableFloatClass {
NullableFloat = null
};
var with0 = new NullableFloatClass {
NullableFloat = 0
};
var with1 = new NullableFloatClass {
NullableFloat = 1
};
var withMinus1 = new NullableFloatClass {
NullableFloat = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table <NullableFloatClass>().OrderBy(x => x.Id).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
public void ReadRow_AutoMappedNullableFloat_Success()
{
using var importer = Helpers.GetImporter("Doubles.xlsx");
ExcelSheet sheet = importer.ReadSheet();
sheet.ReadHeading();
// Valid cell value.
NullableFloatClass row1 = sheet.ReadRow <NullableFloatClass>();
Assert.Equal(2.2345f, row1.Value);
// Empty cell value.
NullableFloatClass row2 = sheet.ReadRow <NullableFloatClass>();
Assert.Null(row2.Value);
// Invalid cell value.
Assert.Throws <ExcelMappingException>(() => sheet.ReadRow <NullableFloatClass>());
}
public void NullableFloat()
{
var db = new SQLiteConnection(TestPath.CreateTemporaryDatabase());
db.CreateTable <NullableFloatClass>();
var withNull = new NullableFloatClass
{
NullableFloat = null
};
var with0 = new NullableFloatClass
{
NullableFloat = 0
};
var with1 = new NullableFloatClass
{
NullableFloat = 1
};
var withMinus1 = new NullableFloatClass
{
NullableFloat = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table <NullableFloatClass>().OrderBy(x => x.ID).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
public void NullableFloat()
{
SQLiteConnection db = new SQLiteConnection(Path.GetTempFileName());
db.CreateTable <NullableFloatClass>();
NullableFloatClass withNull = new NullableFloatClass()
{
NullableFloat = null
};
NullableFloatClass with0 = new NullableFloatClass()
{
NullableFloat = 0
};
NullableFloatClass with1 = new NullableFloatClass()
{
NullableFloat = 1
};
NullableFloatClass withMinus1 = new NullableFloatClass()
{
NullableFloat = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table <NullableFloatClass>().OrderBy(x => x.ID).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
public void NullableFloat()
{
var db = TestDb.GetMemoryDb();
db.CreateTable <NullableFloatClass>();
NullableFloatClass withNull = new NullableFloatClass()
{
NullableFloat = null
};
NullableFloatClass with0 = new NullableFloatClass()
{
NullableFloat = 0
};
NullableFloatClass with1 = new NullableFloatClass()
{
NullableFloat = 1
};
NullableFloatClass withMinus1 = new NullableFloatClass()
{
NullableFloat = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table <NullableFloatClass>().OrderBy(x => x.ID).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
public void ReadRow_CustomMappedNullableFloat_Success()
{
using var importer = Helpers.GetImporter("Doubles.xlsx");
importer.Configuration.RegisterClassMap <CustomNullableFlatClassMap>();
ExcelSheet sheet = importer.ReadSheet();
sheet.ReadHeading();
// Valid cell value.
NullableFloatClass row1 = sheet.ReadRow <NullableFloatClass>();
Assert.Equal(2.2345f, row1.Value);
// Empty cell value.
NullableFloatClass row2 = sheet.ReadRow <NullableFloatClass>();
Assert.Equal(-10, row2.Value);
// Invalid cell value.
NullableFloatClass row3 = sheet.ReadRow <NullableFloatClass>();
Assert.Equal(10, row3.Value);
}
// [Description("Create a table with a nullable int column then insert and select against it")]
public void NullableFloat()
{
var db = new OrmTestSession();
db.CreateTable<NullableFloatClass>();
var withNull = new NullableFloatClass {NullableFloat = null};
var with0 = new NullableFloatClass {NullableFloat = 0};
var with1 = new NullableFloatClass {NullableFloat = 1};
var withMinus1 = new NullableFloatClass {NullableFloat = -1};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table<NullableFloatClass>().OrderBy(x => x.Id).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
public void NullableFloat()
{
SQLiteConnection db = new SQLiteConnection(Path.GetTempFileName());
db.CreateTable<NullableFloatClass>();
NullableFloatClass withNull = new NullableFloatClass() { NullableFloat = null };
NullableFloatClass with0 = new NullableFloatClass() { NullableFloat = 0 };
NullableFloatClass with1 = new NullableFloatClass() { NullableFloat = 1 };
NullableFloatClass withMinus1 = new NullableFloatClass() { NullableFloat = -1 };
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table<NullableFloatClass>().OrderBy(x => x.ID).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
public override bool Equals(object obj)
{
NullableFloatClass other = (NullableFloatClass)obj;
return(this.ID == other.ID && this.NullableFloat == other.NullableFloat);
}
public void NullableFloat()
{
var db = new SQLiteConnection(new SQLitePlatformTest(), TestPath.CreateTemporaryDatabase());
db.CreateTable<NullableFloatClass>();
var withNull = new NullableFloatClass
{
NullableFloat = null
};
var with0 = new NullableFloatClass
{
NullableFloat = 0
};
var with1 = new NullableFloatClass
{
NullableFloat = 1
};
var withMinus1 = new NullableFloatClass
{
NullableFloat = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableFloatClass[] results = db.Table<NullableFloatClass>().OrderBy(x => x.ID).ToArray();
Assert.AreEqual(4, results.Length);
Assert.AreEqual(withNull, results[0]);
Assert.AreEqual(with0, results[1]);
Assert.AreEqual(with1, results[2]);
Assert.AreEqual(withMinus1, results[3]);
}
