public static void ChildCollectionShouldHaveCorrectValues()
{
SqlClientRegistrar.Register <DaoReferenceObject>();
string childName = "Name_".RandomString(3);
DaoReferenceObject d = new DaoReferenceObject();
d.StringProperty = "".RandomString(8);
d.Commit();
var child = d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.AddNew();
child.Name = childName;
d.Commit();
d = DaoReferenceObject.OneWhere(f => f.Id == d.Id);
Expect.AreEqual(1, d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.Count);
Expect.AreEqual(child.Name, d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId[0].Name);
child = DaoReferenceObjectWithForeignKey.OneWhere(f => f.Id == d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId[0].Id);
Expect.AreEqual(childName, child.Name);
Expect.IsNotNull(child.DaoReferenceObjectOfDaoReferenceObjectId);
Expect.AreEqual(child.DaoReferenceObjectOfDaoReferenceObjectId.Id, d.Id);
}
public static void DeleteShouldDeleteChildren()
{
SqlClientRegistrar.Register <DaoReferenceObject>();
DaoReferenceObject parent = new DaoReferenceObject();
parent.StringProperty = "Parent_".RandomString(3);
parent.Commit();
var d1 = parent.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.AddNew();
d1.Name = "".RandomString(3);
var d2 = parent.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.AddNew();
d2.Name = "".RandomString(3);
parent.Commit();
Expect.IsNotNull(d2.Id);
DaoReferenceObject check = DaoReferenceObject.OneWhere(c => c.Id == parent.Id);
DaoReferenceObjectWithForeignKey check2 = DaoReferenceObjectWithForeignKey.OneWhere(c => c.Id == d2.Id);
Expect.AreEqual(2, check.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.Count);
Expect.IsNotNull(check2);
check.Delete();
check2 = DaoReferenceObjectWithForeignKey.OneWhere(c => c.Id == d2.Id);
Expect.IsNull(check2);
}
public static void ParentOfCollectionShouldBeRootDao()
{
SqlClientRegistrar.Register(Db.For <DaoReferenceObject>().ServiceProvider);
DaoReferenceObject d = new DaoReferenceObject();
d.StringProperty = "".RandomString(8);
d.Commit();
DaoReferenceObjectWithForeignKey dfk = d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.AddNew();
Expect.AreSame(d, d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.Parent);
}
public static void AddShouldSetAssociation()
{
SqlClientRegistrar.Register(Db.For <DaoReferenceObject>().ServiceProvider);
DaoReferenceObject d = new DaoReferenceObject();
d.StringProperty = "".RandomString(8);
d.Commit();
DaoReferenceObjectWithForeignKey test = new DaoReferenceObjectWithForeignKey();
Expect.IsNull(test.DaoReferenceObjectId);
d.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.Add(test);
Expect.IsNotNull(test.DaoReferenceObjectId);
Expect.AreEqual(test.DaoReferenceObjectId, d.Id);
}
public static void ChildSetsShouldBeFull()
{
SqlClientRegistrar.Register <DaoReferenceObject>();
DaoReferenceObject parent = new DaoReferenceObject();
parent.StringProperty = "Parent";
parent.Commit();
DaoReferenceObjectWithForeignKey child = parent.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.AddNew();
child.Name = "Monkey";
parent.Commit();
Expect.IsNotNull(child.Id);
DaoReferenceObject check = DaoReferenceObject.OneWhere(c => c.Id == parent.Id);
Expect.IsNotNull(check);
Expect.AreEqual(1, check.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.Count);
}
public static void UnCommittedParentShouldThrowOnChildAdd()
{
bool thrown = false;
try
{
SqlClientRegistrar.Register <DaoReferenceObject>();
DaoReferenceObject parent = new DaoReferenceObject();
parent.StringProperty = "Parent";
DaoReferenceObjectWithForeignKey child = parent.DaoReferenceObjectWithForeignKeyCollectionByDaoReferenceObjectId.AddNew();
child.Name = "".RandomString(8);
parent.Commit();
}
catch (InvalidOperationException ioe)
{
thrown = true;
Out(ioe.Message, ConsoleColor.Cyan);
}
Expect.IsTrue(thrown);
}
public object[] Where(QiQuery query)
{
return(DaoReferenceObjectWithForeignKey.Where(query).ToJsonSafe());
}
