public void WhereNull()
{
var db = new SQLiteConnection(TestPath.CreateTemporaryDatabase());
db.CreateTable <NullableIntClass>();
var withNull = new NullableIntClass
{
NullableInt = null
};
var with0 = new NullableIntClass
{
NullableInt = 0
};
var with1 = new NullableIntClass
{
NullableInt = 1
};
var withMinus1 = new NullableIntClass
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results =
db.Table <NullableIntClass>().Where(x => x.NullableInt == null).OrderBy(x => x.ID).ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(withNull, results[0]);
}
public void WhereNull()
{
var db = new OrmTestSession();
db.CreateTable <NullableIntClass>();
var withNull = new NullableIntClass {
NullableInt = null
};
var with0 = new NullableIntClass {
NullableInt = 0
};
var with1 = new NullableIntClass {
NullableInt = 1
};
var withMinus1 = new NullableIntClass {
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results = db.Table <NullableIntClass>().Where(x => x.NullableInt == null).OrderBy(x => x.Id).ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(withNull, results[0]);
}
public void WhereNull()
{
SQLiteConnection db = new SQLiteConnection(Path.GetTempFileName());
db.CreateTable <NullableIntClass>();
NullableIntClass withNull = new NullableIntClass()
{
NullableInt = null
};
NullableIntClass with0 = new NullableIntClass()
{
NullableInt = 0
};
NullableIntClass with1 = new NullableIntClass()
{
NullableInt = 1
};
NullableIntClass withMinus1 = new NullableIntClass()
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results = db.Table <NullableIntClass>().Where(x => x.NullableInt == null).OrderBy(x => x.ID).ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(withNull, results[0]);
}
public void WhereNull()
{
var db = TestDb.GetMemoryDb();
db.CreateTable <NullableIntClass>();
NullableIntClass withNull = new NullableIntClass()
{
NullableInt = null
};
NullableIntClass with0 = new NullableIntClass()
{
NullableInt = 0
};
NullableIntClass with1 = new NullableIntClass()
{
NullableInt = 1
};
NullableIntClass withMinus1 = new NullableIntClass()
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results = db.Table <NullableIntClass>().Where(x => x.NullableInt == null).OrderBy(x => x.ID).ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(withNull, results[0]);
}
public void NullableScalarInt()
{
var db = new SQLiteConnection(TestPath.CreateTemporaryDatabase());
db.CreateTable <NullableIntClass>();
var withNull = new NullableIntClass
{
NullableInt = null
};
var with0 = new NullableIntClass
{
NullableInt = 0
};
var with1 = new NullableIntClass
{
NullableInt = 1
};
var withMinus1 = new NullableIntClass
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
var actualShouldBeNull = db.ExecuteScalar <int?>("select NullableInt from NullableIntClass order by ID limit 1");
var actualShouldBe0 = db.ExecuteScalar <int?>("select NullableInt from NullableIntClass order by ID limit 1 offset 1");
var actualShouldBe1 = db.ExecuteScalar <int?>("select NullableInt from NullableIntClass order by ID limit 1 offset 2");
var actualShouldBeMinus1 = db.ExecuteScalar <int?>("select NullableInt from NullableIntClass order by ID limit 1 offset 3");
Assert.AreEqual(null, actualShouldBeNull);
Assert.AreEqual(0, actualShouldBe0);
Assert.AreEqual(1, actualShouldBe1);
Assert.AreEqual(-1, actualShouldBeMinus1);
}
public void WhereNotNull()
{
var db = new SQLiteConnection(new SQLitePlatformTest(), TestPath.GetTempFileName());
db.CreateTable <NullableIntClass>();
var withNull = new NullableIntClass
{
NullableInt = null
};
var with0 = new NullableIntClass
{
NullableInt = 0
};
var with1 = new NullableIntClass
{
NullableInt = 1
};
var withMinus1 = new NullableIntClass
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results =
db.Table <NullableIntClass>().Where(x => x.NullableInt != null).OrderBy(x => x.ID).ToArray();
Assert.AreEqual(3, results.Length);
Assert.AreEqual(with0, results[0]);
Assert.AreEqual(with1, results[1]);
Assert.AreEqual(withMinus1, results[2]);
}
public void NullableScalarInt()
{
var db = new SQLiteConnection(new SQLitePlatformTest(), TestPath.CreateTemporaryDatabase());
db.CreateTable<NullableIntClass>();
var withNull = new NullableIntClass
{
NullableInt = null
};
var with0 = new NullableIntClass
{
NullableInt = 0
};
var with1 = new NullableIntClass
{
NullableInt = 1
};
var withMinus1 = new NullableIntClass
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
var actualShouldBeNull = db.ExecuteScalar<int?>("select NullableInt from NullableIntClass order by ID limit 1");
var actualShouldBe0 = db.ExecuteScalar<int?>("select NullableInt from NullableIntClass order by ID limit 1 offset 1");
var actualShouldBe1 = db.ExecuteScalar<int?>("select NullableInt from NullableIntClass order by ID limit 1 offset 2");
var actualShouldBeMinus1 = db.ExecuteScalar<int?>("select NullableInt from NullableIntClass order by ID limit 1 offset 3");
Assert.AreEqual(null, actualShouldBeNull);
Assert.AreEqual(0, actualShouldBe0);
Assert.AreEqual(1, actualShouldBe1);
Assert.AreEqual(-1, actualShouldBeMinus1);
}
public void NullableInt()
{
SQLiteConnection db = new SQLiteConnection(TestPath.GetTempFileName());
db.CreateTable<NullableIntClass>();
NullableIntClass withNull = new NullableIntClass() { NullableInt = null };
NullableIntClass with0 = new NullableIntClass() { NullableInt = 0 };
NullableIntClass with1 = new NullableIntClass() { NullableInt = 1 };
NullableIntClass withMinus1 = new NullableIntClass() { NullableInt = -1 };
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results = db.Table<NullableIntClass>().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 WhereNull()
{
var db = new SQLiteConnection(new SQLitePlatformTest(), TestPath.GetTempFileName());
db.CreateTable<NullableIntClass>();
var withNull = new NullableIntClass
{
NullableInt = null
};
var with0 = new NullableIntClass
{
NullableInt = 0
};
var with1 = new NullableIntClass
{
NullableInt = 1
};
var withMinus1 = new NullableIntClass
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results =
db.Table<NullableIntClass>().Where(x => x.NullableInt == null).OrderBy(x => x.ID).ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(withNull, results[0]);
}
public override bool Equals(object obj)
{
NullableIntClass other = (NullableIntClass)obj;
return(this.ID == other.ID && this.NullableInt == other.NullableInt);
}
public void WhereNull()
{
var db = new OrmTestSession();
db.CreateTable<NullableIntClass>();
var withNull = new NullableIntClass {NullableInt = null};
var with0 = new NullableIntClass {NullableInt = 0};
var with1 = new NullableIntClass {NullableInt = 1};
var withMinus1 = new NullableIntClass {NullableInt = -1};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results = db.Table<NullableIntClass>().Where(x => x.NullableInt == null).OrderBy(x => x.Id).ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(withNull, results[0]);
}
public void NullableInt()
{
var db = new SQLiteConnection(new SQLitePlatformTest(), TestPath.CreateTemporaryDatabase());
db.CreateTable<NullableIntClass>();
var withNull = new NullableIntClass
{
NullableInt = null
};
var with0 = new NullableIntClass
{
NullableInt = 0
};
var with1 = new NullableIntClass
{
NullableInt = 1
};
var withMinus1 = new NullableIntClass
{
NullableInt = -1
};
db.Insert(withNull);
db.Insert(with0);
db.Insert(with1);
db.Insert(withMinus1);
NullableIntClass[] results = db.Table<NullableIntClass>().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]);
}
