public void Test_perf_of_query_without_index()
{
OdbFactory.Delete("index1perf.ndb");
using (var odb = OdbFactory.Open("index1perf.ndb"))
{
for (var i = 0; i < 5000; i++)
{
var player = new Player("Player" + i, DateTime.Now, new Sport("Sport" + i));
odb.Store(player);
}
}
var stopwatch = new Stopwatch();
stopwatch.Start();
using (var odb = OdbFactory.OpenLast())
{
var query = odb.Query<Player>();
query.Descend("Name").Constrain((object) "Player20").Equal();
var count = query.Execute<Player>().Count;
Assert.That(count, Is.EqualTo(1));
}
stopwatch.Stop();
Console.WriteLine("Elapsed {0} ms", stopwatch.ElapsedMilliseconds);
stopwatch.Reset();
stopwatch.Start();
using (var odb = OdbFactory.OpenLast())
{
var query = odb.Query<Player>();
query.Descend("Name").Constrain((object) "Player1234").Equal();
var count = query.Execute<Player>().Count;
Assert.That(count, Is.EqualTo(1));
}
stopwatch.Stop();
Console.WriteLine("Elapsed {0} ms", stopwatch.ElapsedMilliseconds);
stopwatch.Reset();
stopwatch.Start();
using (var odb = OdbFactory.OpenLast())
{
var query = odb.Query<Player>();
query.Descend("Name").Constrain((object) "Player4444").Equal();
var count = query.Execute<Player>().Count;
Assert.That(count, Is.EqualTo(1));
}
stopwatch.Stop();
Console.WriteLine("Elapsed {0} ms", stopwatch.ElapsedMilliseconds);
stopwatch.Reset();
stopwatch.Start();
using (var odb = OdbFactory.OpenLast())
{
var query = odb.Query<Player>();
query.Descend("Name").Constrain((object) "Player3211").Equal();
var count = query.Execute<Player>().Count;
Assert.That(count, Is.EqualTo(1));
}
stopwatch.Stop();
Console.WriteLine("Elapsed {0} ms", stopwatch.ElapsedMilliseconds);
}
private static void Step2()
{
// Create instance
var volleyball = new Sport("volley-ball");
// Create 4 players
var player1 = new Player("julia", DateTime.Now, volleyball);
var player2 = new Player("magdalena", DateTime.Now, volleyball);
var player3 = new Player("jacek", DateTime.Now, volleyball);
var player4 = new Player("michal", DateTime.Now, volleyball);
// Create two teams
var team1 = new Team("Krakow");
var team2 = new Team("Skawina");
// Set players for team1
team1.AddPlayer(player1);
team1.AddPlayer(player2);
// Set players for team2
team2.AddPlayer(player3);
team2.AddPlayer(player4);
// Then create a volley ball game for the two teams
var game = new Game(DateTime.Now, volleyball, team1, team2);
using (var odb = OdbFactory.Open(TutorialDb5MinName))
odb.Store(game);
}
public void Add_index_then_query()
{
OdbFactory.Delete("index1.ndb");
using (var odb = OdbFactory.Open("index1.ndb"))
{
var fields = new[] { "Name" };
odb.IndexManagerFor<Player>().AddUniqueIndexOn("nameIndex", fields);
for (var i = 0; i < 50; i++)
{
var player = new Player("Player" + i, DateTime.Now, new Sport("Sport" + i));
odb.Store(player);
}
}
using (var odb = OdbFactory.OpenLast())
{
var query = odb.Query<Player>();
var count = query.Execute<Player>().Count;
Assert.That(count, Is.EqualTo(50));
}
}
public void AddPlayer(Player player)
{
Players.Add(player);
}
private static void Step4Soda()
{
using (var odb = OdbFactory.Open(TutorialDb5MinName))
{
var agassi = new Player("André Agassi", DateTime.Now, new Sport("Tennis"));
odb.Store(agassi);
var query = odb.Query<Player>();
query.Descend("FavoriteSport").Descend("_name")
.Constrain("volley-ball").Equal();
var players = query.Execute<Player>();
Console.WriteLine("\nStep 4 (Soda): Players of Voller-ball");
foreach (var player in players)
Console.WriteLine("\t{0}", player);
Assert.That(players, Has.Count.EqualTo(4));
}
}
