static void TestGeneral()
{
var thing = new Thing()
{
Name = "Albert",
Aaaa = "This is thing1."
};
var thing2 = new Thing()
{
Name = "Ben",
Aaaa = "This is thing2."
};
var thing3 = new Thing()
{
Name = "Calamity",
Aaaa = "This is thing3."
};
var betterThing = new BetterThing()
{
Name = "BetterAlbert",
Aaaa = "Better description"
};
//Initialize DB
EzDb ezDb = new EzDb("Test.db", OperationModes.TAGLESS);
//Test table conditional creation
ezDb.VerifyType <Thing>();
ezDb.VerifyType <BetterThing>();
//Test Insert
var listOfThings = new List <Thing>();
listOfThings.Add(thing);
listOfThings.Add(thing2);
ezDb.Insert(listOfThings);
ezDb.Insert(thing3);
ezDb.Insert(betterThing);
//Test Select
Thing selectedThing = ezDb.SelectSingle <Thing>(thing3.Id);
var allThings = ezDb.SelectAll <Thing>();
//Test Update
thing.Aaaa = "this is an updated thing";
ezDb.Update(thing);
//Test Delete
ezDb.Delete(thing);
//Test RawNonQuery
ezDb.ExecuteRawNonQuery("UPDATE Things SET Description = 'Ben5' WHERE Name = 'Ben'");
//Test RawQuery
IEnumerable <Thing> things = ezDb.ExecuteRawQuery <Thing>("SELECT * FROM Things");
}
static void TestTagless()
{
//Initialize DB
EzDb ezDb = new EzDb("Test.db", OperationModes.TAGLESS);
var tagless = new Tagless()
{
Name = "Ihavenotag",
Description = "A tag have not.",
listOfStrings = new List <string>()
{
"one", "two", "three", "four"
},
listofInts = new List <int>()
{
1, 2, 3, 4
}
};
ezDb.VerifyType <Tagless>();
ezDb.Insert(tagless);
var allTagless = ezDb.SelectAll <Tagless>();
}