public Game(DateTime when, Sport sport, Team team1, Team team2)
{
this.when = when;
this.sport = sport;
this.team1 = team1;
this.team2 = team2;
}
public virtual void TestSelectUnCommitedObject4()
{
DeleteBase(BaseName);
// Create instance
var sport = new Sport("volley-ball");
IOdb odb = null;
try
{
// Open the database
odb = Open(BaseName);
// Store the object
odb.Store(sport);
}
finally
{
if (odb != null)
{
// Close the database
odb.Close();
}
}
// Create instance
var volleyball = new Sport("volley-ball");
// Create 4 players
var player1 = new Player("olivier", new DateTime(), volleyball);
var player2 = new Player("pierre", new DateTime(), volleyball);
var player3 = new Player("elohim", new DateTime(), volleyball);
var player4 = new Player("minh", new DateTime(), volleyball);
// Create two teams
var team1 = new Team("Paris");
var team2 = new Team("Montpellier");
// 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(new DateTime(), volleyball, team1, team2);
odb = null;
try
{
// Open the database
odb = Open(BaseName);
// Store the object
odb.Store(game);
}
finally
{
if (odb != null)
{
// Close the database
odb.Close();
}
}
try
{
// Open the database
odb = Open(BaseName);
IQuery query = odb.Query<Player>();
query.Descend("name").Constrain((object) "olivier").Equal();
var players = query.Execute<Player>();
Println("\nStep 3 : Players with name olivier");
var i = 1;
// display each object
while (players.HasNext())
Println((i++) + "\t: " + players.Next());
}
finally
{
if (odb != null)
{
// Close the database
odb.Close();
}
}
try
{
// Open the database
odb = Open(BaseName);
// Let's insert a tennis player
var agassi = new Player("André Agassi", new DateTime(), new Sport("Tennis"));
var oid = odb.Store(agassi);
IQuery query = odb.Query<Player>();
query.Descend("favoriteSport.name").Constrain((object) "volley-ball").Equal();
var players = query.Execute<Player>();
Println("\nStep 4 : Players of Voller-ball");
var i = 1;
// display each object
while (players.HasNext())
Println((i++) + "\t: " + players.Next());
}
finally
{
if (odb != null)
{
// Close the database
odb.Close();
}
}
DeleteBase(BaseName);
}
public virtual void TestDeletingOneElementOfTheList()
{
if (!testNewFeature)
return;
var baseName = GetBaseName();
DeleteBase(baseName);
var odb = Open(baseName);
var t1 = new Team("team1");
t1.AddPlayer(new Player("player1", new DateTime(), new Sport("sport1")));
t1.AddPlayer(new Player("player2", new DateTime(), new Sport("sport2")));
odb.Store(t1);
odb.Close();
odb = Open(baseName);
var query1 = odb.Query<Team>();
var teams = query1.Execute<Team>();
var team = teams.GetFirst();
AssertEquals(2, team.GetPlayers().Count);
var query = odb.Query<Player>();
var players = query.Execute<Player>();
var p1 = players.GetFirst();
odb.Delete(p1);
odb.Close();
AssertEquals(1, team.GetPlayers().Count);
}
public virtual void SetTeam2(Team team2)
{
this.team2 = team2;
}
public virtual void SetTeam1(Team team1)
{
this.team1 = team1;
}
