public void Can_GetData()
{
var target = new OracleSqlReader();
var dataTable = target.GetData(connectionString, "SELECT PERSON_ID, first_name , last_name\n from TEST_USER.Person ");
dataTable.Tables.Should().NotBeEmpty();
dataTable.Tables[0].Rows.Should().NotBeEmpty();
}
public void CanUploadTable()
{
var manifestObject = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.manifest.xepdb1.json");
var sql = GetJsonFile <TargetSql>(_inputRoot, "xepdb1.target.person.json");
var data = CreateTable();
var target = new OracleSqlWriter();
target.UploadTable(connectionString,
sql.SetupTempDml,
manifestObject.manifest.tables[0],
data,
new List <string> {
sql.UpdateFromTempDml, sql.ClearTempDml
});
var reader = new OracleSqlReader();
var result = reader.GetData(connectionString, $"select * from TEST_USER.Person");
result.Tables.Should().NotBeEmpty();
result.Tables[0].Rows.Should().NotBeEmpty();
}