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);
}
public App(
ILogger <App> logger,
DataMoverSettings dataMoverSettings,
SourceDataReader sourceDataReader,
DatabasePublisher publisher,
ReadCommandGenerator readCommandGenerator,
SchemaCopier schemaCopier)
{
_logger = logger;
_dataMoverSettings = dataMoverSettings;
_sourceDataReader = sourceDataReader;
_publisher = publisher;
_readCommandGenerator = readCommandGenerator;
_schemaCopier = schemaCopier;
}
public override Type GetFieldType(int ordinal) => SourceDataReader.GetFieldType(ordinal);
public override bool Read() => SourceDataReader.Read();
public override Task <bool> IsDBNullAsync(int ordinal, CancellationToken cancellationToken) => SourceDataReader.IsDBNullAsync(ordinal, cancellationToken);
public override string GetString(int ordinal) => SourceDataReader.GetString(ordinal);
public override int GetValues(object[] values) => SourceDataReader.GetValues(values);
public override short GetInt16(int ordinal) => SourceDataReader.GetInt16(ordinal);
public override long GetInt64(int ordinal) => SourceDataReader.GetInt64(ordinal);
public override byte GetByte(int ordinal) => SourceDataReader.GetByte(ordinal);
public override char GetChar(int ordinal) => SourceDataReader.GetChar(ordinal);
public override Task <bool> NextResultAsync(CancellationToken cancellationToken)
{
ResultIndex++;
return(SourceDataReader.NextResultAsync(cancellationToken));
}
public override bool GetBoolean(int ordinal) => SourceDataReader.GetBoolean(ordinal);
public override bool NextResult()
{
ResultIndex++;
return(SourceDataReader.NextResult());
}
public override string ToString() => SourceDataReader.ToString();
public override Task <bool> ReadAsync(CancellationToken cancellationToken) => SourceDataReader.ReadAsync(cancellationToken);
public override float GetFloat(int ordinal) => SourceDataReader.GetFloat(ordinal);
public override long GetChars(int ordinal, long dataOffset, char[] buffer, int bufferOffset, int length) => SourceDataReader.GetChars(ordinal, dataOffset, buffer, bufferOffset, length);
public override Guid GetGuid(int ordinal) => SourceDataReader.GetGuid(ordinal);
public override string GetDataTypeName(int ordinal) => SourceDataReader.GetDataTypeName(ordinal);
public override int GetInt32(int ordinal) => SourceDataReader.GetInt32(ordinal);
public override DateTime GetDateTime(int ordinal) => SourceDataReader.GetDateTime(ordinal);
public override int GetOrdinal(string name) => SourceDataReader.GetOrdinal(name);
public override decimal GetDecimal(int ordinal) => SourceDataReader.GetDecimal(ordinal);
public override object GetValue(int ordinal) => SourceDataReader.GetValue(ordinal);
public override TextReader GetTextReader(int ordinal) => SourceDataReader.GetTextReader(ordinal);
public override bool IsDBNull(int ordinal) => SourceDataReader.IsDBNull(ordinal);
public override IEnumerator GetEnumerator() => SourceDataReader.GetEnumerator();
public override double GetDouble(int ordinal) => SourceDataReader.GetDouble(ordinal);
public override object InitializeLifetimeService() => SourceDataReader.InitializeLifetimeService();
