tebzito176
Postgres Migration Crashes Servers after deleting plugin
public class DesignTimeDbContextFactory : IDesignTimeDbContextFactory<ApplicationDbContext>
{
private const string AspNetCoreEnvironment = "ASPNETCORE_ENVIRONMENT";
public ApplicationDbContext CreateDbContext(string[] args)
{
var connectionString = string.Empty;
var s = Environment.GetEnvironmentVariable(AspNetCoreEnvironment);
if (s == "Development")
{
var configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
.Build();
connectionString = configuration.GetConnectionString("DefaultConnection");
}
var builder = new DbContextOptionsBuilder<ApplicationDbContext>();
var databaseUrl = Environment.GetEnvironmentVariable("DATABASE_URL");
builder.UseNpgsql(string.IsNullOrEmpty(databaseUrl) ? connectionString : databaseUrl);
return new ApplicationDbContext(builder.Options);
}
//build the connection string from the environment. i.e. Heroku
private static string BuildConnectionString(string databaseUrl)
{
var databaseUri = new Uri(databaseUrl);
var userInfo = databaseUri.UserInfo.Split(':');
var builder = new NpgsqlConnectionStringBuilder
{
Host = databaseUri.Host,
Port = databaseUri.Port,
Username = userInfo[0],
Password = userInfo[1],
Database = databaseUri.LocalPath.TrimStart('/'),
SslMode = SslMode.Require,
TrustServerCertificate = true
};
return builder.ToString();
}
}
114 replies
