public void TestBoolean()
{
var tmpFile = TestPath.GetTempFileName();
var db = new DbAcs(tmpFile);
db.buildTable();
for (int i = 0; i < 10; i++)
{
db.Insert(new VO()
{
Flag = (i % 3 == 0), Text = String.Format("VO{0}", i)
});
}
// count vo which flag is true
Assert.AreEqual(4, db.CountWithFlag(true));
Assert.AreEqual(6, db.CountWithFlag(false));
Debug.WriteLine("VO with true flag:");
foreach (var vo in db.Query <VO>("SELECT * FROM VO Where Flag = ?", true))
{
Debug.WriteLine(vo.ToString());
}
Debug.WriteLine("VO with false flag:");
foreach (var vo in db.Query <VO>("SELECT * FROM VO Where Flag = ?", false))
{
Debug.WriteLine(vo.ToString());
}
}
public void TestBoolean()
{
var sqlite3Platform = new SQLitePlatformTest();
string tmpFile = TestPath.CreateTemporaryDatabase();
var db = new DbAcs(sqlite3Platform, tmpFile);
db.buildTable();
for (int i = 0; i < 10; i++)
{
db.Insert(new VO
{
Flag = (i % 3 == 0),
Text = String.Format("VO{0}", i)
});
}
// count vo which flag is true
Assert.AreEqual(4, db.CountWithFlag(true));
Assert.AreEqual(6, db.CountWithFlag(false));
Debug.WriteLine("VO with true flag:");
foreach (VO vo in db.Query <VO>("SELECT * FROM VO Where Flag = ?", true))
{
Debug.WriteLine(vo.ToString());
}
Debug.WriteLine("VO with false flag:");
foreach (VO vo in db.Query <VO>("SELECT * FROM VO Where Flag = ?", false))
{
Debug.WriteLine(vo.ToString());
}
}
public void TestBoolean()
{
var sqlite3Platform = new SQLitePlatformTest();
string tmpFile = TestPath.CreateTemporaryDatabase();
var db = new DbAcs(sqlite3Platform, tmpFile);
db.buildTable();
for (int i = 0; i < 10; i++)
{
db.Insert(new VO
{
Flag = (i%3 == 0),
Text = String.Format("VO{0}", i)
});
}
// count vo which flag is true
Assert.AreEqual(4, db.CountWithFlag(true));
Assert.AreEqual(6, db.CountWithFlag(false));
Debug.WriteLine("VO with true flag:");
foreach (VO vo in db.Query<VO>("SELECT * FROM VO Where Flag = ?", true))
{
Debug.WriteLine(vo.ToString());
}
Debug.WriteLine("VO with false flag:");
foreach (VO vo in db.Query<VO>("SELECT * FROM VO Where Flag = ?", false))
{
Debug.WriteLine(vo.ToString());
}
}
public void TestBoolean()
{
var tmpFile = Path.GetTempFileName();
var db = new DbAcs(tmpFile);
db.buildTable();
for (int i = 0; i < 10; i++)
db.Insert(new VO() { Flag = (i % 3 == 0), Text = String.Format("VO{0}", i) });
// count vo which flag is true
Assert.AreEqual(4, db.CountWithFlag(true));
Assert.AreEqual(6, db.CountWithFlag(false));
Console.WriteLine("VO with true flag:");
foreach (var vo in db.Query<VO>("SELECT * FROM VO Where Flag = ?", true))
Console.WriteLine(vo.ToString());
Console.WriteLine("VO with false flag:");
foreach (var vo in db.Query<VO>("SELECT * FROM VO Where Flag = ?", false))
Console.WriteLine(vo.ToString());
}