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; }