public void TestUpdateWhenOnlyOneLevelUpdates()
{
FilledCircle myCircle = new FilledCircle();
TransactionCommitterStub committer = new TransactionCommitterStub();
committer.AddBusinessObject(myCircle);
committer.CommitTransaction();
myCircle.SetPropertyValue("Colour", 4);
var myUpdateSql = new UpdateStatementGenerator(myCircle, DatabaseConnection.CurrentConnection).Generate();
Assert.AreEqual(1, myUpdateSql.Count());
}
public void TestUpdateStatementExcludesNonPersistableProps()
{
const string newPropName = "NewProp";
MockBO bo = StatementGeneratorTestHelper.CreateMockBOWithExtraNonPersistableProp(newPropName);
bo.SetPropertyValue(newPropName, "newvalue323");
bo.SetPropertyValue("MockBOProp2", "dfggjh");
UpdateStatementGenerator gen = new UpdateStatementGenerator(bo, DatabaseConnection.CurrentConnection);
var statementCol = gen.Generate();
var sqlStatements = statementCol.ToList();
Assert.AreEqual(1, sqlStatements.Count);
ISqlStatement statement = sqlStatements[0];
Assert.IsFalse(statement.Statement.ToString().Contains(newPropName));
}
public void TestUpdateStatementExcludesNonPersistable_InheritanceProps()
{
//---------------Set up test pack-------------------
const string nonPersistablePropertyName = "NonPersistableProp";
FilledCircleNoPrimaryKey.GetClassDefWithSingleInheritanceHierarchy_NonPersistableProp(nonPersistablePropertyName);
var filledCircle = new FilledCircleNoPrimaryKey();
filledCircle.Props[nonPersistablePropertyName].Value = TestUtil.GetRandomString();
var gen = new UpdateStatementGenerator(filledCircle, DatabaseConnection.CurrentConnection);
//---------------Execute Test ----------------------
var sqlStatementCollection = gen.Generate();
//---------------Test Result -----------------------
var sqlStatements = sqlStatementCollection.ToList();
Assert.AreEqual(1, sqlStatements.Count);
var sqlStatement = sqlStatements[0];
var sql = sqlStatement.Statement.ToString();
Assert.IsFalse(sql.Contains(nonPersistablePropertyName));
}
/// <summary>
/// Returns an "update" sql statement list for updating this object
/// </summary>
/// <returns>Returns a collection of sql statements</returns>
private IEnumerable <ISqlStatement> GetUpdateSql()
{
var gen = new UpdateStatementGenerator(_busObj, DatabaseConnection.CurrentConnection);
return(gen.Generate());
}
/// <summary>
/// Returns an "update" sql statement list for updating this object
/// </summary>
/// <returns>Returns a collection of sql statements</returns>
private IEnumerable<ISqlStatement> GetUpdateSql()
{
var gen = new UpdateStatementGenerator(_busObj, DatabaseConnection.CurrentConnection);
return gen.Generate();
}
