public void ShouldBeAbleToPersistAndRecall()
{
using (var db = new TempDBLocalDb())
{
var runner = new MigrationsRunner(db.ConnectionString, Console.WriteLine);
runner.MigrateToLatest();
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
// first, put your left leg in
var item= ItemBuilder.BuildRandom();
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
context.Items.Add(item);
context.SaveChangesWithErrorReporting();
}
// shake it all about
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
var persisted = context.Items.FirstOrDefault(o => o.ItemId == item.ItemId);
Assert.IsNotNull(persisted);
Assert.AreEqual(item.ItemId, persisted.ItemId);
Assert.AreEqual(item.Description, persisted.Description);
Assert.AreEqual(item.Mimetype, persisted.Mimetype);
Assert.AreEqual(item.Photo, persisted.Photo);
}
//---------------Test Result -----------------------
}
}
/// <summary>
/// Execute database migration. Migrations are executed only if they were enabled in constructor.
/// </summary>
public void Migrate()
{
if (ConnectionSettings.AutoMigrate && (MigrationsRunner != null))
{
MigrationsRunner.MigrateAsync().Wait();
}
}
void Application_Start(object sender, EventArgs e)
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
GlobalConfiguration.Configure(WebApiConfig.Register);
GlobalConfiguration.Configuration
.Formatters
.JsonFormatter
.SerializerSettings
.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
GlobalConfiguration.Configuration
.Formatters
.JsonFormatter
.SerializerSettings
.ContractResolver = new CamelCasePropertyNamesContractResolver();
RouteConfig.RegisterRoutes(RouteTable.Routes);
var apiContainer = new Container();
apiContainer.ConfigureApi();
var mvcContainer = new Container();
mvcContainer.ConfigureMvc();
MigrationsRunner.RunMigrations();
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
Database.SetInitializer(new MigrateDatabaseToLatestVersion <ApplicationDbContext, Configuration>());
MigrationsRunner.DoDbUpdate();
}
private static void MigrateDatabase()
{
var connectionName = "LendingLibrary.Domain.LendingLibraryDbContext";
CreateDb();
var connectionString = ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
var migrationsRunner = new MigrationsRunner(connectionString);
migrationsRunner.MigrateToLatest();
}
public Helper(Database database, string folderName)
{
_database = database;
var options = new MigrationOptions();
options.AddAssemblyScriptsProvider(
Assembly.GetExecutingAssembly(),
$"Kros.KORM.UnitTests.Resources.ScriptsForRunner.{folderName}");
Runner = new MigrationsRunner(_database, options);
}
protected override void OnStart()
{
MigrationsRunner.Run();
AreaRegistration.RegisterAllAreas();
var pathProvider = new EmbeddedResourceVirtualPathProvider();
pathProvider.AddNamespaceMapping("/Views/Account", "Brandy.Security.Web.Views.Account");
HostingEnvironment.RegisterVirtualPathProvider(pathProvider);
RegisterGlobalFilters(GlobalFilters.Filters);
RegisterRoutes(RouteTable.Routes);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//var windsorBootstrapper = new WindsorBootstrapper();
var windsorContainer = InitContainer();
ControllerBuilder.Current.SetControllerFactory(new ControllerFactory(windsorContainer));
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
var migrationsRunner = new MigrationsRunner(connectionString);
migrationsRunner.MigrateToLatest();
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//var windsorBootstrapper = new WindsorBootstrapper();
var windsorContainer = InitContainer();
ControllerBuilder.Current.SetControllerFactory(new ControllerFactory(windsorContainer));
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
var migrationsRunner = new MigrationsRunner(connectionString);
migrationsRunner.MigrateToLatest();
}
public void Configuration(IAppBuilder app)
{
var container = StructuremapMvc.StructureMapDependencyScope.Container;
MigrationsRunner.Run(container); // Executa o migrations com os parametros do container configurados
//Adiciona as configurações do NHibernate para criação de sessão, repositories etc
container.Configure(c => c.AddRegistry(new NHibernateRegistry(container)));
ConfigureOAuth(app);
GlobalConfiguration.Configure(WebApiConfig.Register);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
Automapper.Setup();
app.UseCors(Microsoft.Owin.Cors.CorsOptions.AllowAll);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterAuth();
try
{
MigrationsRunner.MigrateToLatest();
}
catch
{
// Wait for user tables to be initialized. This won't happen a second time.
// (Migrations are run after initializing the tables.)
}
}
private static void AddMigrations()
{
Console.Write("Enter migration name: ");
var migrationName = Console.ReadLine();
if (string.IsNullOrEmpty(migrationName))
{
Console.WriteLine("No name specified, quitting");
return;
}
var targetProjectFile = Environment
.GetEnvironmentVariable("TARGET_PROJECT_FILE");
var migrationsOutputDirectory = Environment
.GetEnvironmentVariable("MIGRATIONS_OUTPUT_DIRECTORY");
var migrationInfo = MigrationsRunner.CreateMigrations(
migrationName,
migrationsOutputDirectory,
(output) => new ResXResourceWriter(output));
UpdateProjectFile(targetProjectFile, migrationInfo);
}
public void ShouldBeAbleToPersistAndRecall()
{
using (var db = new TempDBLocalDb())
{
var runner = new MigrationsRunner(db.ConnectionString, Console.WriteLine);
runner.MigrateToLatest();
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
// first, put your left leg in
var person = CreatePerson();
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
context.People.Add(person);
context.SaveChangesWithErrorReporting();
}
// shake it all about
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
var persisted = context.People.FirstOrDefault(o => o.PersonId == person.PersonId);
Assert.IsNotNull(persisted);
Assert.AreEqual(person.Email, persisted.Email);
Assert.AreEqual(person.FirstName,persisted.FirstName);
Assert.AreEqual(person.PersonId,persisted.PersonId);
Assert.AreEqual(person.Surname,persisted.Surname);
Assert.AreEqual(person.PhoneNumber,persisted.PhoneNumber);
Assert.AreEqual(person.Photo,persisted.Photo);
}
//---------------Test Result -----------------------
}
}
public static void Main(string[] args)
{
MigrationsRunner.SetupDatabase();
CreateHostBuilder(args).Build().Run();
}
public UmbracoDbOAuthRefreshTokenStore()
{
MigrationsRunner.RunMigrations(CurrentVersion, SubProductName);
}
public CompositeDBMigrator(string connectionString, bool logMigrations)
{
_logMigrations = logMigrations;
_schemaImporter = new DbSchemaImporter(connectionString, SomeDBSchema.DB_SCHEMA);
_migrationsRunner = new MigrationsRunner(connectionString, LogMigration);
}
private void MigrateDatabaseWith(string connectionString)
{
var runner = new MigrationsRunner(connectionString);
runner.MigrateToLatest();
}
public CompositeDBMigrator(string connectionString, bool logMigrations)
{
_logMigrations = logMigrations;
_migrationsRunner = new MigrationsRunner(connectionString, LogMigration);
}
public UmbracoDbOAuthClientStore()
{
MigrationsRunner.RunMigrations(CurrentVersion, SubProductName);
}
private void Create()
{
MigrationsRunner.MigrateToLatest(DbConnString);
}
public CompositeDBMigrator(string connectionString, bool logMigrations)
{
_logMigrations = logMigrations;
_schemaImporter = new DbSchemaImporter(connectionString, SomeDBSchema.DB_SCHEMA);
_migrationsRunner = new MigrationsRunner(connectionString, LogMigration);
}
private static void UpdateDatabase()
{
MigrationsRunner.ApplyMigrations();
}