public void AutomaticallyCreatesMetadataTable()
{
var runner = new SchemaMigrationRunner(store, new SchemaDiffer());
runner.Run();
configuration.Tables.ShouldContainKey("HybridDb");
store.Database.RawQuery<int>("select top 1 SchemaVersion from HybridDb").Single().ShouldBe(0);
}
public void DoesNothingGivenNoMigrations()
{
CreateMetadataTable();
var runner = new SchemaMigrationRunner(store, new FakeSchemaDiffer());
runner.Run();
database.QuerySchema().Single().Key.ShouldBe("HybridDb"); // the metadata table and nothing else
}
public void DoesNothingWhenTurnedOff()
{
DisableMigrations();
CreateMetadataTable();
var runner = new SchemaMigrationRunner(store, new SchemaDiffer());
runner.Run();
configuration.Tables.ShouldNotContainKey("HybridDb");
store.Database.RawQuery<int>("select top 1 SchemaVersion from HybridDb").Any().ShouldBe(false);
}
public void DoesNothingGivenNoMigrations()
{
CreateMetadataTable();
var runner = new SchemaMigrationRunner(store, new FakeSchemaDiffer());
runner.Run();
var schema = store.Database.QuerySchema();
schema.Count.ShouldBe(1);
schema.ShouldContainKey("HybridDb"); // the metadata table and nothing else
}
public void RunsProvidedSchemaMigrations()
{
CreateMetadataTable();
UseMigrations(new InlineMigration(1,
new CreateTable(new Table("Testing", new Column("Id", typeof (Guid), isPrimaryKey: true))),
new AddColumn("Testing", new Column("Noget", typeof (int)))));
var runner = new SchemaMigrationRunner(store, new FakeSchemaDiffer());
runner.Run();
var tables = database.QuerySchema();
tables.ShouldContainKey("Testing");
tables["Testing"]["Id"].ShouldNotBe(null);
tables["Testing"]["Noget"].ShouldNotBe(null);
}
public void DoesNotRunProvidedSchemaMigrationsOnTempTables(TableMode mode)
{
Use(mode);
UseTableNamePrefix(Guid.NewGuid().ToString());
CreateMetadataTable();
UseMigrations(new InlineMigration(1,
new CreateTable(new Table("Testing", new Column("Id", typeof(Guid), isPrimaryKey: true))),
new AddColumn("Testing", new Column("Noget", typeof(int)))));
var runner = new SchemaMigrationRunner(store, new FakeSchemaDiffer());
runner.Run();
var tables = store.Database.QuerySchema();
tables.ShouldNotContainKey("Testing");
}
public void DoesNotRunSchemaMigrationTwice()
{
CreateMetadataTable();
var command = new CountingCommand();
UseMigrations(new InlineMigration(1, command));
var runner = new SchemaMigrationRunner(store, new FakeSchemaDiffer());
runner.Run();
runner.Run();
command.NumberOfTimesCalled.ShouldBe(1);
}
public void SetsRequiresReprojectionOnTablesWithNewColumns()
{
Document<Entity>();
Document<AbstractEntity>();
Document<DerivedEntity>();
Document<OtherEntity>();
store.Initialize();
using (var session = store.OpenSession())
{
session.Store(new Entity());
session.Store(new Entity());
session.Store(new DerivedEntity());
session.Store(new DerivedEntity());
session.Store(new OtherEntity());
session.Store(new OtherEntity());
session.SaveChanges();
}
var runner = new SchemaMigrationRunner(store,
new FakeSchemaDiffer(
new AddColumn("Entities", new Column("NewCol", typeof(int))),
new AddColumn("AbstractEntities", new Column("NewCol", typeof(int)))));
runner.Run();
store.Database.RawQuery<bool>("select AwaitsReprojection from Entities").ShouldAllBe(x => x);
store.Database.RawQuery<bool>("select AwaitsReprojection from AbstractEntities").ShouldAllBe(x => x);
store.Database.RawQuery<bool>("select AwaitsReprojection from OtherEntities").ShouldAllBe(x => !x);
}
public void RollsBackOnExceptions()
{
CreateMetadataTable();
try
{
var runner = new SchemaMigrationRunner(store,
new FakeSchemaDiffer(
new CreateTable(new Table("Testing", new Column("Id", typeof (Guid), isPrimaryKey: true))),
new ThrowingCommand()));
runner.Run();
}
catch (Exception)
{
}
store.Database.QuerySchema().ShouldNotContainKey("Testing");
}
public void DoesNotRunUnsafeSchemaMigrations()
{
CreateMetadataTable();
UseMigrations(new InlineMigration(1, new UnsafeThrowingCommand()));
var runner = new SchemaMigrationRunner(store,
new FakeSchemaDiffer(new UnsafeThrowingCommand()));
Should.NotThrow(() => runner.Run());
}
