public void RunBeforeAnyTestsInThisAssembly()
{
var dbInitialiser = new DatabaseInitialiser();
// ReSharper disable once ConvertToConstant.Local
var shouldDropAndCreateDatabase = true;
// ReSharper disable once ConditionIsAlwaysTrueOrFalse
if (!shouldDropAndCreateDatabase)
{
return;
}
dbInitialiser.Publish(true);
var scriptsBasePath = AppDomain.CurrentDomain.BaseDirectory + @"\Scripts\";
var scriptFilePaths = new[]
{
scriptsBasePath + "InsertPerson.sql",
scriptsBasePath + "InsertEmployerContact.sql",
scriptsBasePath + "InsertEmployer.sql",
scriptsBasePath + "InsertProvider.sql",
scriptsBasePath + "InsertVacancyOwnerRelationship.sql",
scriptsBasePath + "InsertAgencyUser.sql",
scriptsBasePath + "InsertProviderUser.sql"
};
dbInitialiser.Seed(scriptFilePaths);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, DatabaseContext context)
{
// Vaste measurement per anchor aanmaken indien de db leeg is
DatabaseInitialiser.Initialize(context);
/// Disabled MQTT
//app.UseHangfireServer();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseCors(builder =>
builder.AllowAnyOrigin()
.AllowAnyHeader()
.AllowAnyMethod());
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public void RunBeforeAnyTestsInThisAssembly()
{
var dbInitialiser = new DatabaseInitialiser();
//control db initialisation and seeding through these two bools
var shouldDropCreateDB = true;
if (shouldDropCreateDB)
{
dbInitialiser.Publish(true);
var seedScripts = new string[]
{
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertContactPreferenceType.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertPersonType.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertPersonTitleType.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertPerson.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertEmployerContact.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertEmployer.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertVacancyProvisionRelationshipStatusType.sql",
AppDomain.CurrentDomain.BaseDirectory + "\\Scripts\\InsertVacancyOwnerRelationship.sql"
};
dbInitialiser.Seed(seedScripts);
//dbInitialiser.Seed(SeedData.Providers);
dbInitialiser.Seed(SeedData.ProviderUsers);
dbInitialiser.Seed(SeedData.AgencyUsers);
//dbInitialiser.Seed(SeedData.Vacancies());
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseCors("all");
app.UseAuthentication();
app.UseAuthorization();
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "My API V1");
});
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
var context = _services.BuildServiceProvider().GetService <DataContext>();
DatabaseInitialiser.Initialise(context);
}
public void Setup()
{
var options = new DbContextOptionsBuilder <DataContext>()
.UseInMemoryDatabase(databaseName: "Users")
.Options;
context = new DataContext(options);
DatabaseInitialiser.Initialise(context);
}
public void Setup()
{
_dbPath = _dbPathStart + Guid.NewGuid().ToString() + _dbPathExtension;
_initialiser = new DatabaseInitialiser
{
DatabasePath = _dbPath
};
_initialiser.EnsureDatabaseExists();
_handler = new EvolutionDatabaseHandler(_dbPath, _createCommandPath);
}
private static void CreateDbIfNotExists(IHost host)
{
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
var context = services.GetRequiredService <ApplicationDbContext>();
DatabaseInitialiser.Initialise(context);
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred creating the DB.");
}
}
}
public WebSite(Client client, HttpListenerContext context) : base(client, context)
{
this.LoadConfiguration();
WebSite.Database = new DatabaseMySql(this.connectionString);
//Create tables if they don't exists
DatabaseInitialiser.CreateDatabase(WebSite.Database);
string[] parsedArgs = WebHelper.GetUrlArguments(this.Context.Request.Url.Segments);
string controller = string.Empty;
if (parsedArgs.Length == 0)
{
controller = DEFAULT_ROUTE;
}
else if (parsedArgs[0] == string.Empty)
{
controller = DEFAULT_ROUTE;
}
else
{
controller = parsedArgs[0];
}
if (routes.ContainsKey(controller))
{
this.controller = routes[controller]();
}
else
{
Error();
return;
}
}
public static void InitialiseWebSecurity()
{
DatabaseInitialiser <Db> .InitialiseWebsecurity();
}
// Use this for initialization
void Start()
{
var initialiser = new DatabaseInitialiser();
initialiser.EnsureDatabaseExists();
}
public void SetUp()
{
databaseInitTestObject = new DatabaseInitialiser("EmployeeList.txt");
}
