public void BuildQuery_OnePK_ShouldReturnValidQuery()
{
// Arrange
var command = new ReadCommand
(
new TableSchema
{
Name = "Orders",
Columns = new List <Column>
{
new Column
{
Name = "Id",
PkOrdinalPosition = 1
},
new Column
{
Name = "Name"
}
}
},
new List <object>
{
1
},
new List <object>
{
10
}
);
var columns = new List <Column>
{
new Column
{
Name = "Id",
PkOrdinalPosition = 1
},
new Column
{
Name = "Name"
}
};
// Act
var result = SourceDataReader.BuildQuery(command, columns);
// Assert
Assert.AreEqual("select `Id`,`Name` from `Orders` where (`Id` >= @from_0) and (`Id` < @to_0)", result);
}
