public void UploadTable_LoadTest()
{
int recordCount = 500000;
var data = CreateTable("Post", recordCount);
var manifestObject = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.job.adventureWorks.json");
var sql = GetJsonFile <TargetSql>(_inputRoot, "adventureWorks.target.customer.json");
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start(); // start timer
var target = new MsSqlWriter();
target.UploadTable(connectionString,
sql.SetupTempDml,
manifestObject.manifest.tables[1],
data,
new List <string> {
sql.UpdateFromTempDml, sql.ClearTempDml
});
stopwatch.Stop(); // end timer
var ElapsedDuration = stopwatch.Elapsed; // this is the elapsed duration now for updating RecordsCount records in table database
WriteLogCsvFile(new CsvLogger {
TestDate = DateTime.Now, NoOfRecords = recordCount, TimeElapsed = ElapsedDuration
});
}
public void Can_BulkCopy()
{
var data = CreateTable();
var manifestObject = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.job.adventureWorks.json");
var inputSqlQueries = GetJsonFile <TargetSql>(_inputRoot, "adventureWorks.target.customer.json");
MsSqlWriter target = new MsSqlWriter();
target.ExecuteSqlText(connectionString, inputSqlQueries.SetupTempDml);
var outputnoOfRecord = target.BulkCopy(connectionString, manifestObject.manifest.tables[1], data);
data.Rows.Count.Should().Be(outputnoOfRecord);
}
public void UploadTable_SetupSource()
{
var data = CreateTable("Pre", 500000);
var manifestObject = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.job.adventureWorks.json");
var table = manifestObject.manifest.tables[1];
table.temp_name = table.qualified_table_name; //initializing Table-TempName with CustomerATeam Table
var target = new MsSqlWriter();
target.ExecuteSqlText(connectionString, new List <string> {
$"truncate table {table.temp_name}"
}); // Cleaning the CustomerATeam Table first before adding these records with data
var outputnoOfRecord = target.BulkCopy(connectionString, table, data); // This call should copy records from data to CustomerATeam directly.
data.Rows.Count.Should().Be(outputnoOfRecord);
}
public void CanUploadTable()
{
var manifestObject = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.job.adventureWorks.json");
var inputSqlQueries = GetJsonFile <TargetSql>(_inputRoot, "adventureWorks.target.customer.json");
var data = CreateTable();
var target = new MsSqlWriter();
target.UploadTable(connectionString,
inputSqlQueries.SetupTempDml,
manifestObject.manifest.tables[1],
data,
new List <string> {
inputSqlQueries.UpdateFromTempDml, inputSqlQueries.ClearTempDml
});
var reader = new MsSqlReader();
var result = reader.GetData(connectionString, $"select * from SalesLT.CustomerATeam");
result.Tables.Should().NotBeEmpty();
result.Tables[0].Rows.Should().NotBeEmpty();
}
public MsSqlQueryProvider()
{
SqlWriter = new MsSqlWriter();
}
public MsSqlMetadataProvider()
{
TypeConverter = new MsSqlTypeConverter();
SqlWriter = new MsSqlWriter();
}
public MsSqlQueryProvider()
{
TypeConverter = new MsSqlTypeConverter();
SqlWriter = new MsSqlWriter();
}