public void Create_two_heroes_store_them_and_then_retrive()
{
const string dbFileName = "game.db";
const double mageAttackValue = 3.3;
const double mageDefenseValue = 3.4;
const double warriorAttackValue = 4.4;
const double warriorDefenseValue = 2.2;
// create two objects
IHero mage = new Mage("Merlin", mageAttackValue, mageDefenseValue);
IHero warrior = new Warrior("Conan", warriorAttackValue, warriorDefenseValue);
// store them
using (var odb = OdbFactory.Open(dbFileName))
{
odb.Store(mage);
odb.Store(warrior);
}
// retrieve them by classes and by interface
using (var odb = OdbFactory.Open(dbFileName))
{
// work with mages
var query2 = odb.Query<Mage>();
var mages = query2.Execute<Mage>();
foreach (var hero in mages)
Console.WriteLine(hero);
Assert.That(mages, Has.Count.EqualTo(1));
Assert.That(mages.GetFirst().Attack, Is.EqualTo(mageAttackValue));
Assert.That(mages.GetFirst().Defense, Is.EqualTo(mageDefenseValue));
// work with warriors
var warriors = odb.QueryAndExecute<Warrior>();
foreach (var hero in warriors)
Console.WriteLine(hero);
Assert.That(warriors, Has.Count.EqualTo(1));
Assert.That(warriors.GetFirst().Attack, Is.EqualTo(warriorAttackValue));
Assert.That(warriors.GetFirst().Defense, Is.EqualTo(warriorDefenseValue));
Console.WriteLine("Start working with IHero interface.");
// work with heroes
var heroes = odb.QueryAndExecute<IHero>();
foreach (var hero in heroes)
Console.WriteLine(hero);
Assert.That(heroes, Has.Count.EqualTo(2));
}
}
public void Using_insert_trigger()
{
var mage = new Mage("Merlin", 3.3, 3.4);
var myTrigger = new MyTrigger();
using (var odb = OdbFactory.Open(DbName))
{
odb.TriggerManagerFor<Mage>().AddInsertTrigger(myTrigger);
odb.Store(mage);
}
Assert.That(myTrigger.BeforeInvoked, Is.True);
Assert.That(myTrigger.AfterInvoked, Is.True);
using (var odb = OdbFactory.Open(DbName))
{
var query = odb.Query<Mage>();
var merlin = query.Execute<Mage>().GetFirst();
Assert.That((object) merlin.Attack, Is.EqualTo(3.3 + 1.1));
}
}