// [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]); }