public void Can_BulkCopy()
        {
            var data = CreateTable();

            var manifestObject  = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.manifest.mysql.json");
            var inputSqlQueries = GetJsonFile <TargetSql>(_inputRoot, "mysql.target.ateam.json");

            MySqlWriter target = new MySqlWriter();

            target.ExecuteSqlText(connectionString, inputSqlQueries.SetupTempDml);                             //Temp Table Created at this stage {ex8_temp_ATeam}

            var outputNOfRecords = target.BulkCopy(connectionString, manifestObject.manifest.tables[0], data); // copy records into temp. table {ex8_temp_ATeam}

            data.Rows.Count.Should().Be(outputNOfRecords);
        }
Esempio n. 2
0
        public void UploadTable_SetupSource()
        {
            var data           = CreateTable("Pre", 500000);
            var manifestObject = GetJsonFile <DatabaseJobManifest>(_inputRoot, "database.manifest.mysql.json");
            var table          = manifestObject.manifest.tables[0];

            table.temp_name = table.qualified_table_name;  //initialized Table-TempName with ATeam Table

            var target = new MySqlWriter();

            target.ExecuteSqlText(connectionString, new List <string> {
                $"truncate table {table.temp_name}"
            });                                                                    // Cleaning the ATeam Table first before adding these records with data

            var outputnoOfRecord = target.BulkCopy(connectionString, table, data); // This call should copy records from data to ATeam directly.

            data.Rows.Count.Should().Be(outputnoOfRecord);
        }