public void NewTableTest(SqlEngineVersion version)
{
_sqlExecuterTestAdapter.Check(version);
var dd = new TestDatabaseSimple();
_sqlExecuterTestAdapter.InitializeAndCreate(version.UniqueName, dd);
var context = new Context
{
Settings = TestHelper.GetDefaultTestSettings(version),
Logger = TestHelper.CreateLogger()
};
var migrationGenerator = SqlGeneratorFactory.CreateMigrationGenerator(version, context);
var executer = _sqlExecuterTestAdapter.GetExecuter(version.UniqueName);
var databaseMigrator = new DatabaseMigrator(executer, migrationGenerator);
var tableNew = new TableNew
{
SchemaAndTableName = "NewTableToMigrate"
};
((SqlTable)tableNew).AddInt32("Id", false).SetPK().SetIdentity();
new PrimaryKeyNamingDefaultStrategy().SetPrimaryKeyName(tableNew.Properties.OfType <PrimaryKey>().First());
((SqlTable)tableNew).AddNVarChar("Name", 100);
dd.AddTable(tableNew);
databaseMigrator.NewTable(tableNew);
}
public void NewTable(TableNew tableNew)
{
var sql = MigrationGenerator.CreateTable(tableNew);
Executer.ExecuteNonQuery(sql);
}
public virtual string CreateTable(TableNew tableNew)
{
// TODO Properties (PKs, FKs, Indexes, Defaults, Descriptions)
return(Generator.CreateTable(tableNew));
}
