static void Main(string[] args) { MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().ConnectionString(x => x.Is(ConnectionStrings.Get())); DatabaseDeployer dd = null; ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration) .Build(cfg => { dd = new DatabaseDeployer(cfg); }); dd.Drop(); Console.WriteLine(""); Console.WriteLine("Database dropped."); Thread.Sleep(1000); dd.Create(); Console.WriteLine(""); Console.WriteLine("Database created."); ISession session = sessionFactory.OpenSession(); using (ITransaction tx = session.BeginTransaction()) { dd.Seed(new List<IDataSeeder> { //add data seeders here. new UserSeeder(session) }); tx.Commit(); } session.Close(); sessionFactory.Close(); Console.WriteLine(""); Console.WriteLine("Seed data added."); Thread.Sleep(2000); }
public static void Main(string[] args) { IHost host = CreateHostBuilder(args).Build(); DatabaseDeployer databaseDeployer = (DatabaseDeployer)host.Services.GetService(typeof(DatabaseDeployer)); databaseDeployer.DeployAsync().Wait(); host.Run(); }
private void DeployDatabase(IConfigurationRoot configuration) { _connectionString = configuration.GetConnectionString("DefaultConnection"); _databaseDeployer = new DatabaseDeployer(_connectionString, "Sql\\Schema.sql", "Sql\\Procedures.sql"); bool isDBCreated = _databaseDeployer.ExecuteReader("IF (OBJECT_ID ('dbo.GetBalance', 'P') IS NULL) SELECT 0 ELSE SELECT 1;", IsDatabaseCreated); if (!isDBCreated) { _databaseDeployer.DeployAsync().Wait(); } }
public void SetUp() { var connectionFactory = TestUtilities.GetIntegrationConnectionFactory(); var logger = TestUtilities.GetMockLogger(); var databaseDeployer = new DatabaseDeployer(new DatabaseMigratorFactory(connectionFactory), new ExceptionMigrationResultHandler(logger.Object)); var serverRepository = new ServerRepository(connectionFactory); var refreshServerService = new RefreshServerService(logger.Object, new ResourceServerRepository(connectionFactory)); var administrationInstallationRepository = new AdministrationInstallationRepository(connectionFactory); this.administrationInstallationService = new AdministrationInstallationService(databaseDeployer, serverRepository, refreshServerService, administrationInstallationRepository); }
public void SetUp() { var connectionFactory = TestUtilities.GetIntegrationConnectionFactory(); var sql = new SqlServerRepository(connectionFactory); var hashConverter = new LegacyHashConversionService(); var tabService = new TabService(new TabRepository(connectionFactory), new RelativityOneService(sql.ConfigurationRepository)); this.textLogger = new TextLogger(); var dbDeployer = new DatabaseDeployer( new DatabaseMigratorFactory(connectionFactory), new ErrorOnlyMigrationResultHandler(this.textLogger)); this.applicationInstallationService = new ApplicationInstallationService(connectionFactory, sql, hashConverter, tabService, dbDeployer, this.textLogger); }
static void Main(string[] args) { MsSqlConfiguration databaseConfiguration = MsSqlConfiguration.MsSql2008.ShowSql().ConnectionString(x => x.FromConnectionStringWithKey("Rainfall")); DatabaseDeployer dd = null; ISessionFactory sessionFactory = new SessionFactoryBuilder(new MappingScheme(), databaseConfiguration) .Build(cfg => { dd = new DatabaseDeployer(cfg); }); using (var sess = sessionFactory.OpenSession()) { using (IDbCommand cmd = sess.Connection.CreateCommand()) { cmd.ExecuteSqlFile("dropForeignKeys.sql"); cmd.ExecuteSqlFile("dropPrimaryKeys.sql"); cmd.ExecuteSqlFile("dropTables.sql"); } } Console.WriteLine(""); Console.WriteLine("Database dropped."); //Thread.Sleep(1000); dd.Create(); Console.WriteLine(""); Console.WriteLine("Database created."); ISession session = sessionFactory.OpenSession(); using (ITransaction tx = session.BeginTransaction()) { dd.Seed(new List<IDataSeeder> { //add data seeders here. //new SeedAlamanacDays(session) new SeedCity(session) }); tx.Commit(); } session.Close(); sessionFactory.Close(); Console.WriteLine(""); Console.WriteLine("Seed data added."); //Thread.Sleep(2000); }
private static IServiceProvider GetServiceProvider() { IConfigurationRoot config = new ConfigurationBuilder() .AddJsonFile("appsettings.json") .Build(); string connectionStr = config.GetConnectionString("DefaultConnection"); DatabaseDeployer databaseDeployer = new DatabaseDeployer(connectionStr, "Sql\\Schema.sql", "Sql\\Procedures.sql", "Sql\\Initialization.sql"); databaseDeployer.DeployAsync().Wait(); SchoolManagerDb schoolManagerDb = new SchoolManagerDb(connectionStr); StudentService studentService = new StudentService(schoolManagerDb); ServiceCollection services = new ServiceCollection(); services.AddSingleton <ISchoolManagerDb>(x => schoolManagerDb); services.AddSingleton <IStudentService>(x => studentService); return(services.BuildServiceProvider()); }
} // Only used for 'AdminScriptsInstalled' #endregion public AdministrationInstall() { //register the prerender event this.PreRender += Page_PreRender; var logger = new TextLogger(); _pageModel = new AdministrationInstallationModel(); var connectionFactory = new HelperConnectionFactory(ConnectionHelper.Helper()); this.sqlServerRepository = new SqlServerRepository(connectionFactory); _serverRepository = new ServerRepository(connectionFactory); var databaseDeployer = new DatabaseDeployer( new DatabaseMigratorFactory(connectionFactory), new ExceptionMigrationResultHandler(logger)); var administrationInstallationRepository = new AdministrationInstallationRepository(connectionFactory); var refreshServerService = new RefreshServerService(logger, new ResourceServerRepository(connectionFactory)); _service = new AdministrationInstallationService(databaseDeployer, _serverRepository, refreshServerService, administrationInstallationRepository); _authService = new AuthenticationServiceFactory().GetService(); }
public override Response Execute() { // Initialize application install service -- TODO -- use DI to create kernel and get correct implementation if (this.parallelizationInstallationService == null) { // Build up application installation service var logger = new TextLogger(); var connectionFactory = new HelperConnectionFactory(this.Helper); var sqlRepo = new SqlServerRepository(connectionFactory); var hashConverter = new LegacyHashConversionService(); var tabRepository = new TabRepository(connectionFactory); var relativityOneService = new RelativityOneService(sqlRepo.ConfigurationRepository); var tabService = new TabService(tabRepository, relativityOneService); var databaseMigratorFactory = new DatabaseMigratorFactory(connectionFactory); var databaseDeployer = new DatabaseDeployer(databaseMigratorFactory, new ErrorOnlyMigrationResultHandler(logger)); var applicationInstallationService = new ApplicationInstallationService(connectionFactory, sqlRepo, hashConverter, tabService, databaseDeployer, logger); var toggleProvider = new PdbSqlToggleProvider(connectionFactory); var forceDeparallelization = toggleProvider.IsEnabled <DatabaseDeploymentDeparallelizationToggle>(); if (forceDeparallelization) { // Build up the service that checks for version var versionCheckService = new VersionCheckService(new PdbVersionRepository(connectionFactory), logger); this.parallelizationInstallationService = new SingletonDatabaseInstallationService(applicationInstallationService, versionCheckService, new TimeService(), logger); } else { // Build up the service that actually runs the install process this.parallelizationInstallationService = new DefaultDatabaseInstallationService(applicationInstallationService); } } // Install the application var appInstallResponse = this.parallelizationInstallationService.InstallApplication(this.Helper.GetActiveCaseID()).GetAwaiter().GetResult(); // Return response return(new Response { Message = appInstallResponse.Message, Success = appInstallResponse.Success }); }