public virtual void Test_Can_Do_Order_By()
{
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
});
TestItemPrimaryKey item = dStore.Query <TestItemPrimaryKey>().OrderBy(R => R.ID).First();
Assert.IsNotNull(item);
}
public virtual void Test_Can_Do_Join_And_Return_Aggregate_Object()
{
TestItemPrimaryKey newItem = new TestItemPrimaryKey()
{
Name = "Hello", ID = Guid.NewGuid().ToString()
};
dStore.InsertObject(newItem);
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
dStore.InsertObject(new TestItemForeignKeyWithString()
{
FKeyField = newItem.ID, ID = Guid.NewGuid().ToString()
});
var result = from i in dStore.Query <TestItemForeignKeyWithString>()
join x in dStore.Query <TestItemPrimaryKey>() on i.FKeyField equals x.ID
select new
{
i.ID,
x.Name,
x.Date
};
result.ToList().ForEach(R => Assert.IsTrue(!string.IsNullOrEmpty(R.Name)));
}
public override void Test_Can_Modify_Column_Type()
{
TypeInfo ti1 = dstore.TypeInformationParser.GetTypeInfo(typeof(TestItemPrimaryKey));
Assert.IsTrue(ti1 != null);
TestItemPrimaryKey tipk = new TestItemPrimaryKey();
tipk.ID = Guid.NewGuid().ToString();
tipk.Date = "2010-11-20";
tipk.Name = "Hello";
dstore.InsertObject(tipk);
TypeInfo ti2 = dstore.TypeInformationParser.GetTypeInfo(typeof(TestItemPrimaryKeyDateFieldDifferentType));
Assert.IsTrue(ti2 != null);
}
public virtual void Test_Will_Not_Modify_Column_With_Option_Off()
{
dstore.SchemaValidator.CanUpdateColumns = false;
DatabaseTypeInfo ti1 = dstore.Connection.CommandGenerator.TypeParser.GetTypeInfo(typeof(TestItemPrimaryKey));
Assert.IsTrue(ti1 != null);
TestItemPrimaryKey tipk = new TestItemPrimaryKey();
tipk.ID = "1";
tipk.Date = "11/20/2010";
tipk.Name = "Hello";
dstore.InsertObject(tipk);
dstore.SchemaValidator.TableValidator.OnObjectModified += (sender, args) =>
{
Assert.IsTrue(false);
};
DatabaseTypeInfo ti2 = dstore.Connection.CommandGenerator.TypeParser.GetTypeInfo(typeof(TestItemPrimaryKeyDateFieldDifferentType));
Assert.IsTrue(ti2 != null);
}
public virtual void Test_Can_Modify_Column_Type()
{
int columnsModified = 0;
DatabaseTypeInfo ti1 = dstore.TypeInformationParser.GetTypeInfo(typeof(TestItemPrimaryKey));
Assert.IsTrue(ti1 != null);
TestItemPrimaryKey tipk = new TestItemPrimaryKey();
tipk.Date = "11/20/2010";
tipk.Name = "Hello";
dstore.InsertObject(tipk);
dstore.SchemaValidator.TableValidator.OnObjectModified += (sender, args) =>
{
columnsModified++;
};
DatabaseTypeInfo ti2 = dstore.TypeInformationParser.GetTypeInfo(typeof(TestItemPrimaryKeyDateFieldDifferentType));
Assert.IsTrue(ti2 != null);
Assert.IsTrue(columnsModified > 0);
}
