//multiple deletes
public void TestDeleteMultipleAccess()
{
fpo = new FirstPersistentObject(DatabaseServer.Access, SharedData.access, this.first);
PersistentObjectAccessTEST pp = new PersistentObjectAccessTEST();
pp.TestCreateMultiple();
DatabaseField field = this.first.TableFields[0];
QueryCriteria qc = new QueryCriteria(this.first.TableName, this.first.TableFields[0]);
qc.Add(CriteriaOperator.Max, this.first.TableFields[0]);
object pk = fpo.GetValue(qc);
First ft = (First)fpo.GetTableMetadata(pk);
List <ExecutionQuery> listQueries = SqlGenerator.GenerateMultipleDeleteQueries(DatabaseServer.Access, ft);
foreach (ExecutionQuery var in listQueries)
{
Console.WriteLine(var.Query);
}
Assert.IsTrue(listQueries.Count > 0);
}
public void Init()
{
Configuration.ReadConfigurationFromConfigFile();
ctm = new CategoryTableMetadata();
cpo = new CategoryPersistentObject(DatabaseServer.Access, SharedData.access, ctm);
firstTable = new First();
firstPersistent = new FirstPersistentObject(DatabaseServer.Access, SharedData.access, firstTable);
}
public void Init()
{
Configuration.ReadConfigurationFromConfigFile();
ctm = new CategoryTableMetadata();
cpo = new CategoryPersistentObject(DatabaseServer.Oracle, SharedData.sqlserver, ctm);
firstTable = new First();
firstPersistent = new FirstPersistentObject(DatabaseServer.Oracle, SharedData.sqlserver, firstTable);
//prepare the database
}
public void ExecuteMultipleOperationsInTransaction()
{
Session s = Session.CreateNewSession(DatabaseServer.SqlServer, SharedData.sqlserver);
CategoryTableMetadata ctm = new CategoryTableMetadata();
CategoryPersistentObject persistent = new CategoryPersistentObject(s, ctm);
First first = new First();
FirstPersistentObject fp = new FirstPersistentObject(s, first);
Third third = new Third();
third.ThirdStuff = "lalala";
Second sp = new Second();
sp.Age = 456;
sp.Quantity = 43;
sp.AttachTableMetadata(third);
first.Name = "Crocodilu";
first.AttachTableMetadata(sp);
s.BeginTransaction();
QueryCriteria qc = new QueryCriteria(ctm.TableName, ctm.TableFields[0]);
qc.Add(CriteriaOperator.Max, ctm.TableFields[0]);
//get the last one
CategoryTableMetadata[] ct = (CategoryTableMetadata[])persistent.GetTableMetadata(qc);
persistent.Delete(ct[0]);
CategoryTableMetadata cc = new CategoryTableMetadata();
cc.CategoryName = "fluffy";
cc.Description = "tingling";
persistent.Create(cc);
fp.Create(first);
List <ExecutionQuery> scc = s.Queries;
for (int i = 0; i < scc.Count; i++)
{
Console.WriteLine(scc[i]);
}
s.Commit();
}
public QueryCriteriaTest()
{
psqlserver = new FirstPersistentObject(DatabaseServer.SqlServer, SharedData.sqlserver, this.first);
msqlserver = new FirstPersistentObject(DatabaseServer.MySQL, SharedData.mysql, this.first);
pAccess = new FirstPersistentObject(DatabaseServer.Access, SharedData.access, this.first);
}
