public void GetNumberSelect_Test()
{
var sqlWriterCommandText = new SqlWriterCommandText();
string result = sqlWriterCommandText.GetNumberSelect(SqlWriterCommandTextGeneratorTest.CatalogueName,
SqlWriterCommandTextGeneratorTest.Schema, SqlWriterCommandTextGeneratorTest.TableName,
SqlWriterCommandTextGeneratorTest.ColumnName);
string expected = $"Select MAX([{SqlWriterCommandTextGeneratorTest.ColumnName}]) From" +
$" [{SqlWriterCommandTextGeneratorTest.CatalogueName}].[{SqlWriterCommandTextGeneratorTest.Schema}].[{SqlWriterCommandTextGeneratorTest.TableName}];";
Assert.AreEqual(expected, result);
}
public void GetStringSelect_Test()
{
var sqlWriterCommandText = new SqlWriterCommandText();
string result = sqlWriterCommandText.GetStringSelect(SqlWriterCommandTextGeneratorTest.CatalogueName,
SqlWriterCommandTextGeneratorTest.Schema, SqlWriterCommandTextGeneratorTest.TableName,
SqlWriterCommandTextGeneratorTest.ColumnName);
string expected = $"Select Max([{SqlWriterCommandTextGeneratorTest.ColumnName}])" +
$" from [{SqlWriterCommandTextGeneratorTest.CatalogueName}].[{SqlWriterCommandTextGeneratorTest.Schema}].[{SqlWriterCommandTextGeneratorTest.TableName}]" +
$" where [{SqlWriterCommandTextGeneratorTest.ColumnName}] not like '%[^A-Z]%' And LEN([{SqlWriterCommandTextGeneratorTest.ColumnName}])" +
$" = (Select Max(Len([{SqlWriterCommandTextGeneratorTest.ColumnName}]))" +
$" From [{SqlWriterCommandTextGeneratorTest.CatalogueName}].[{SqlWriterCommandTextGeneratorTest.Schema}].[{SqlWriterCommandTextGeneratorTest.TableName}]" +
$" where [{SqlWriterCommandTextGeneratorTest.ColumnName}] not like '%[^A-Z]%' );";
Assert.AreEqual(expected, result);
}
public SqlWriterCommandTextGenerator(IAttributeDecorator attributeDecorator, SqlWriterCommandText sqlWriterCommandText)
{
this.attributeDecorator = attributeDecorator;
this.sqlWriterCommandText = sqlWriterCommandText;
}
