public void TestInsertMultiplePostgreSql() { Third third = new Third(); third.ThirdStuff = "lalala"; Second s = new Second(); s.Age = 456; s.Quantity = 43; s.AttachTableMetadata(third); First first = new First(); first.Name = "Gogu"; first.AttachTableMetadata(s); List <ExecutionQuery> list = SqlGenerator.GenerateMultipleInsertQueries(DatabaseServer.PostgreSql, first); foreach (ExecutionQuery var in list) { Console.WriteLine(var.Query); } Assert.IsTrue(list.Count > 0); }
public void TestCreateMultiple() { Third third = new Third(); third.ThirdStuff = "lalala"; Second s = new Second(); s.Age = 456; s.Quantity = 43; s.AttachTableMetadata(third); First first = new First(); first.Name = "Gogu"; first.AttachTableMetadata(s); firstPersistent.Create(first); }
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(); }