private void ReadAndVerify(
string expectedType,
int?expectedLength,
int?expectedPrec,
int?expectedScale)
{
_reader.Read(new List <string>()
{
TableName
}, out int tableCounter, out int errorCounter);
DbSchema.GetRawColumnDefinition(TableName, "col1", out string type, out int length, out int prec, out int scale);
type.ToLower().Should().Be(expectedType);
if (expectedLength.HasValue)
{
length.Should().Be(expectedLength.Value);
}
if (expectedPrec.HasValue)
{
prec.Should().Be(expectedPrec.Value);
}
if (expectedScale.HasValue)
{
scale.Should().Be(expectedScale.Value);
}
}
private static void CopyIn(IDbContext dbContext, IArgumentCollection settings, List <string> tables)
{
IALogger logger = new ConsoleLogger();
IAReader reader = AReaderFactory.CreateInstance(dbContext, logger);
reader.Directory = settings["Folder"].Value;
if (settings["MaxDegreeOfParallelism"].IsSet)
{
reader.MaxDegreeOfParallelism = int.Parse(settings["MaxDegreeOfParallelism"].Value);
}
if (settings["BatchSize"].IsSet)
{
reader.BatchSize = int.Parse(settings["BatchSize"].Value);
}
if (settings["UseCollation"].IsSet)
{
reader.Collation = settings["UseCollation"].Value;
}
if (settings["DataFileSuffix"].IsSet)
{
reader.DataFileSuffix = settings["DataFileSuffix"].Value;
}
if (settings["SchemaFileSuffix"].IsSet)
{
reader.SchemaFileSuffix = settings["SchemaFileSuffix"].Value;
}
reader.CreateClusteredIndex = settings["CreateClusteredIndex"].IsSet;
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
int totalTables;
int failedTables;
reader.Read(tables, out totalTables, out failedTables);
int totalViews = 0;
int failedViews = 0;
if (settings["View"].IsSet)
{
CreateViews(dbContext, out totalViews, out failedViews, logger);
}
stopWatch.Stop();
logger.Write("");
logger.Write(string.Format("{0} tables created.", totalTables));
if (failedTables > 0)
{
logger.Write(string.Format("Found {0} tables with errors", failedTables));
}
logger.Write(string.Format("{0} views created.", totalViews));
if (failedViews > 0)
{
logger.Write(string.Format("Found {0} views with errors", failedViews));
}
logger.Write(string.Format("Total time: {0}", stopWatch.Elapsed));
}
private void Read()
{
IAReader reader = AReaderFactory.CreateInstance(DbContext);
reader.Directory = Directory;
int totalTables;
int failedTables;
reader.Read(new List <string> {
TestTable
}, out totalTables, out failedTables);
}
protected void WriteAndRead()
{
_writer.Directory = Directory;
_writer.Write(new List <string> {
TestTable
});
DbSchema.DropTable(TestTable);
_reader.Directory = Directory;
int totalTables;
int failedTables;
_reader.Read(new List <string> {
TestTable
}, out totalTables, out failedTables);
}