#pragma warning disable IDE1006 // Naming Styles
public void _020_DropTable(SqlEngineVersion version)
#pragma warning restore IDE1006 // Naming Styles
{
_sqlExecuterTestAdapter.Check(version);
_sqlExecuterTestAdapter.Initialize(version.UniqueName);
var table = new SqlTable("HierarchyFromCsvToSqlTests");
var generator = SqlGeneratorFactory.CreateGenerator(version, _sqlExecuterTestAdapter.GetContext(version));
var sql = generator.DropTable(table);
var result = _sqlExecuterTestAdapter.ExecuteNonQuery(version.UniqueName, sql);
if (result != null)
{
Assert.Inconclusive(result);
}
}
#pragma warning disable IDE1006 // Naming Styles
public void _010_GenerateScriptAndCreateTable(SqlEngineVersion version)
#pragma warning restore IDE1006 // Naming Styles
{
_sqlExecuterTestAdapter.Check(version);
_sqlExecuterTestAdapter.InitializeAndCreate(version.UniqueName);
var dd = new DatabaseDefinition(null, new[] { MsSqlVersion.MsSql2016.GetTypeMapper(), OracleVersion.Oracle12c.GetTypeMapper(), SqLiteVersion.SqLite3.GetTypeMapper() });
var table = new SqlTable("HierarchyFromCsvToSqlTests");
var column = table.AddInt32("Id");
column.Properties.Add(new Identity(column)
{
Increment = 1, Seed = 1
});
table.AddNVarChar("Name", 100);
dd.AddTable(table);
var context = new Context
{
Settings = TestHelper.GetDefaultTestSettings(version),
Logger = TestHelper.CreateLogger()
};
var generator = SqlGeneratorFactory.CreateGenerator(version, context);
var sql = generator.CreateTable(table);
var result = _sqlExecuterTestAdapter.ExecuteNonQuery(version.UniqueName, sql);
if (result != null)
{
Assert.Inconclusive(result);
}
}
public void DropAll(
[Option(LongName = "connectionString", ShortName = "c")]
string connectionString,
[Option(LongName = "sqlType", ShortName = "t")]
string sqlType
)
{
var version = SqlEngineVersions.GetVersion(sqlType);
var connString = new NamedConnectionString("", version.ProviderName, connectionString, version.VersionString);
var context = CreateContext(version);
var generator = SqlGeneratorFactory.CreateGenerator(version, context);
var executer = SqlExecuterFactory.CreateSqlExecuter(connString, generator);
var dc = new DatabaseCreator(null, executer);
dc.DropAllViews();
dc.DropAllForeignKeys();
dc.DropAllTables();
// TODO needs databasedefinition
// dc.DropAllSchemas();
}