public void UpdateStringSqlTest()
{
Configuration cfg = new Configuration();
ISessionFactory factory = cfg.BuildSessionFactory();
ISessionFactoryImplementor factoryImpl = (ISessionFactoryImplementor) factory;
SqlUpdateBuilder update = new SqlUpdateBuilder(factoryImpl.Dialect, factoryImpl);
update.SetTableName("test_update_builder");
update.AddColumns(new string[] {"intColumn"}, NHibernateUtil.Int32);
update.AddColumns(new string[] {"longColumn"}, NHibernateUtil.Int64);
update.AddColumn("literalColumn", false, (ILiteralType) NHibernateUtil.Boolean);
update.AddColumn("stringColumn", 5.ToString());
update.SetIdentityColumn(new string[] {"decimalColumn"}, NHibernateUtil.Decimal);
update.SetVersionColumn(new string[] {"versionColumn"}, (IVersionType) NHibernateUtil.Int32);
update.AddWhereFragment("a=b");
SqlCommandInfo sqlCommand = update.ToSqlCommandInfo();
Assert.AreEqual(CommandType.Text, sqlCommand.CommandType);
string falseString = factoryImpl.Dialect.ToBooleanValueString(false);
string expectedSql =
"UPDATE test_update_builder SET intColumn = ?, longColumn = ?, literalColumn = " + falseString + ", stringColumn = 5 WHERE decimalColumn = ? AND versionColumn = ? AND a=b";
Assert.AreEqual(expectedSql, sqlCommand.Text.ToString(), "SQL String");
SqlType[] actualParameterTypes = sqlCommand.ParameterTypes;
Assert.AreEqual(4, actualParameterTypes.Length, "Four parameters");
SqlType[] expectedParameterTypes = new SqlType[]
{
SqlTypeFactory.Int32,
SqlTypeFactory.Int64,
SqlTypeFactory.Decimal,
SqlTypeFactory.Int32
};
Assert.AreEqual(expectedParameterTypes[0], actualParameterTypes[0], "firstParam Type");
Assert.AreEqual(expectedParameterTypes[1], actualParameterTypes[1], "secondParam Type");
Assert.AreEqual(expectedParameterTypes[2], actualParameterTypes[2], "thirdParam Type");
Assert.AreEqual(expectedParameterTypes[3], actualParameterTypes[3], "fourthParam Type");
}
private SqlCommandInfo GenerateVersionIncrementUpdateString()
{
SqlUpdateBuilder update = new SqlUpdateBuilder(Factory.Dialect, Factory);
update.SetTableName(GetTableName(0));
if (Factory.Settings.IsCommentsEnabled)
{
update.SetComment("forced version increment");
}
update.AddColumn(VersionColumnName, VersionType);
update.SetIdentityColumn(IdentifierColumnNames, IdentifierType);
update.SetVersionColumn(new string[] { VersionColumnName }, VersionType);
return update.ToSqlCommandInfo();
}
