public void VerifyMethodNamesAreRecorded()
{
var provider = new RecordingProvider();
provider.RenameColumn("Table", "OldColumn", "NewColumn").ToList();
CollectionAssert.AreEquivalent(new[] { "RenameColumn" }, provider.Methods.ToList());
}
public void VerifyNewObjectNamesAreRecorded()
{
var provider = new RecordingProvider();
provider.CreateTable("Table", new[] { new CreatedColumn("Column", new DataType(DbType.Boolean, 0, 0), false, true, string.Empty, false, null) }, "MyPK").ToList();
CollectionAssert.AreEquivalent(new[] { "Table", "Column", "MyPK" }, provider.NewObjectNames.ToList());
}
public void VerifyNewObjectNamesAreRecorded()
{
var provider = new RecordingProvider();
// ReSharper disable ReturnValueOfPureMethodIsNotUsed : needed to force enumeration
provider.CreateTable(new TableName("Table", null), new[] { new CreatedColumn("Column", new DataType(DbType.Boolean), false, true, string.Empty, false, null, false) }, "MyPK").ToList();
// ReSharper restore ReturnValueOfPureMethodIsNotUsed
CollectionAssert.AreEquivalent(new[] { "Table", "Column", "MyPK" }, provider.NewObjectNames.ToList());
}
public void VerifyMethodNamesAreRecorded()
{
var provider = new RecordingProvider();
// ReSharper disable ReturnValueOfPureMethodIsNotUsed : needed to force enumeration
provider.RenameColumn(new TableName("Table", null), "OldColumn", "NewColumn").ToList();
// ReSharper restore ReturnValueOfPureMethodIsNotUsed
CollectionAssert.AreEquivalent(new[] { "RenameColumn" }, provider.Methods.ToList());
}
public void VerifyDateTypesAreRecorded()
{
var provider = new RecordingProvider();
provider.CreateTable("Table", new[]
{
new CreatedColumn("Primary Key Column", new DataType(DbType.Int32, 0, 0), false, true, string.Empty, false, null),
new CreatedColumn("Identity Column", new DataType(DbType.Int64, 0, 0), false, false, string.Empty, true, null),
new CreatedColumn("Column", new DataType(DbType.String, 0, 0), false, false, string.Empty, false, null),
}, "MyPK").ToList();
CollectionAssert.AreEquivalent(new[]
{
new UsedDataType(new DataType(DbType.Int32, 0, 0), true, false),
new UsedDataType(new DataType(DbType.Int64, 0, 0), false, true),
new UsedDataType(new DataType(DbType.String, 0, 0), false, false),
}, provider.DataTypes.ToList());
}
public void VerifyDateTypesAreRecorded()
{
var provider = new RecordingProvider();
provider.CreateTable(new TableName("Table", null), new[]
{
new CreatedColumn("Primary Key Column", new DataType(DbType.Int32), false, true, string.Empty, false, null, false),
new CreatedColumn("Identity Column", new DataType(DbType.Int64), false, false, string.Empty, true, null, false),
new CreatedColumn("Column", new DataType(DbType.String, 10), false, false, string.Empty, false, null, false),
// ReSharper disable ReturnValueOfPureMethodIsNotUsed : needed to force enumeration
}, "MyPK").ToList();
// ReSharper restore ReturnValueOfPureMethodIsNotUsed
CollectionAssert.AreEquivalent(new[]
{
new UsedDataType(new DataType(DbType.Int32), true, false),
new UsedDataType(new DataType(DbType.Int64), false, true),
new UsedDataType(new DataType(DbType.String, 10), false, false),
}, provider.DataTypes.ToList());
}
public static MigrationReport Create(Database database, string migrationName)
{
// execute changes in 'database' against a RecordingProvider
var recordingProvider = new RecordingProvider();
var translator = new CommandsToSqlTranslator(recordingProvider);
string error = string.Empty;
try
{
translator.TranslateToSql(database, null).ToList(); // .ToList() is important to effectively trigger the iteration
}
catch (InvalidCommandException x)
{
error = x.Message;
}
// create MigrationReport
return(new MigrationReport(migrationName, error, recordingProvider));
}
public static MigrationReport Create(Database database, string migrationName, IMigrationContext context)
{
// execute changes in 'database' against a RecordingProvider
var recordingProvider = new RecordingProvider();
var translator = new CommandsToSqlTranslator(recordingProvider);
string error = string.Empty;
try
{
// ReSharper disable ReturnValueOfPureMethodIsNotUsed
translator.TranslateToSql(database, context).ToList(); // .ToList() is important to effectively trigger the iteration
// ReSharper restore ReturnValueOfPureMethodIsNotUsed
}
catch (InvalidCommandException x)
{
error = x.Message;
}
// create MigrationReport
return(new MigrationReport(migrationName, error, recordingProvider));
}
