public void FilterOperations_preserves_add_foreign_key_when_no_create_table()
{
var addForeignKey = new AddForeignKeyOperation(
"Pony",
"BFFK",
new[] { "FriendId" },
"Pony",
new[] { "Id" },
false);
var operations = new MigrationOperation[] { addForeignKey };
var generator = CreateGenerator();
var result = generator.FilterOperations(operations);
Assert.Equal(new[] { addForeignKey }, result);
}
public void Create_migration_metadata()
{
var targetModel = new Metadata.Model();
var upgradeOperations = new MigrationOperation[0];
var downgradeOperations = new MigrationOperation[0];
var migration
= new MigrationMetadata("000000000000001_Name")
{
TargetModel = targetModel,
UpgradeOperations = upgradeOperations,
DowngradeOperations = downgradeOperations,
};
Assert.Equal("000000000000001_Name", migration.MigrationId);
Assert.Same(targetModel, migration.TargetModel);
Assert.Same(upgradeOperations, migration.UpgradeOperations);
Assert.Same(downgradeOperations, migration.DowngradeOperations);
}
public void FilterOperations_preserves_add_foreign_key_when_create_table_but_no_fk()
{
var createTable = new CreateTableOperation(
new Table(
"Pony",
new[] { new Column("Id", typeof(long)), new Column("FriendId", typeof(long)) }));
var addForeignKey = new AddForeignKeyOperation(
"Pony",
"BFFK",
new[] { "FriendId" },
"Pony",
new[] { "Id" },
false);
var operations = new MigrationOperation[] { createTable, addForeignKey };
var generator = CreateGenerator();
var result = generator.FilterOperations(operations);
Assert.Equal(new MigrationOperation[] { createTable, addForeignKey }, result);
}
public void FilterOperations_removes_add_foreign_key_when_corresponding_create_table()
{
var friendId = new Column("FriendId", typeof(long));
var id = new Column("Id", typeof(long));
var pony = new Table("Pony", new[] { id, friendId });
pony.AddForeignKey(new ForeignKey("BFFK", new[] { friendId }, new[] { id }));
var createTable = new CreateTableOperation(pony);
var addForeignKey = new AddForeignKeyOperation(
"Pony",
"BFFK",
new[] { "FriendId" },
"Pony",
new[] { "Id" },
false);
var operations = new MigrationOperation[] { createTable, addForeignKey };
var generator = CreateGenerator();
var result = generator.FilterOperations(operations);
Assert.Equal(new[] { createTable }, result);
}
private string Generate(MigrationOperation operation)
{
return CreateGenerator().Generate(new[] { operation }).First().Sql;
}
private static SqlStatement Generate(MigrationOperation migrationOperation)
{
var sqlGenerator = new Mock<MigrationOperationSqlGenerator>(new RelationalTypeMapper()) { CallBase = true };
return sqlGenerator.Object.Generate(new[] { migrationOperation }).Single();
}
private static SqlStatement Generate(MigrationOperation migrationOperation)
{
var sqlGenerator = new SqlServerMigrationOperationSqlGenerator(new SqlServerTypeMapper());
return sqlGenerator.Generate(new[] { migrationOperation }).Single();
}
private IEnumerable<SqlStatement> CreateCreateOperations()
{
// TODO Check DbConnection.Database always gives us what we want
var databaseName = _connection.DbConnection.Database;
var operations = new MigrationOperation[]
{
new CreateDatabaseOperation(databaseName)
};
var masterCommands = _sqlGenerator.Generate(operations);
return masterCommands;
}
private IEnumerable<SqlStatement> CreateDropCommands()
{
var operations = new MigrationOperation[]
{
// TODO Check DbConnection.Database always gives us what we want
new DropDatabaseOperation(_connection.DbConnection.Database)
};
var masterCommands = _sqlGenerator.Generate(operations);
return masterCommands;
}
