Dockerize app for deployment and development

3 files changed, 13 insertions, 10 deletions

diff --git a/backend/Elements.Backend/Elements.Backend.csproj b/backend/Elements.Backend/Elements.Backend.csproj
index 787d048..426b45a 100644
--- a/backend/Elements.Backend/Elements.Backend.csproj
+++ b/backend/Elements.Backend/Elements.Backend.csproj
@@ -4,7 +4,7 @@
     <TargetFramework>net7.0</TargetFramework>
     <Nullable>enable</Nullable>
     <ImplicitUsings>enable</ImplicitUsings>
-    <UserSecretsId>dae266ca-b349-4b87-a992-5470f9dd635d</UserSecretsId>
+    <DebugType>portable</DebugType>
   </PropertyGroup>
 
   <ItemGroup>
@@ -17,6 +17,7 @@
     </PackageReference>
     <PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite" Version="7.0.12" />
     <PackageReference Include="Microsoft.VisualStudio.Web.CodeGeneration.Design" Version="7.0.10" />
+    <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="7.0.11" />
     <PackageReference Include="Swashbuckle.AspNetCore" Version="6.4.0" />
   </ItemGroup>
 
diff --git a/backend/Elements.Backend/Program.cs b/backend/Elements.Backend/Program.cs
index f7b9b4b..6804d1a 100644
--- a/backend/Elements.Backend/Program.cs
+++ b/backend/Elements.Backend/Program.cs
@@ -14,13 +14,11 @@ builder.Services.AddControllers().AddJsonOptions(options =>
     options.JsonSerializerOptions.PropertyNamingPolicy = JsonNamingPolicy.CamelCase;

 });

 

-if (builder.Environment.IsDevelopment())

+builder.Services.AddDbContext<ApplicationDbContext>(options =>

 {

-    builder.Services.AddDbContext<ApplicationDbContext>(options =>

-    {

-        options.UseSqlite("Data Source=elements.db");

-    });

-}

+    options.UseNpgsql(Environment.GetEnvironmentVariable("ELEM_DB_CONN_STR") ??

+                         "Server=database;Port=5432;Database=elements;User Id=elements;Password=elementspass");

+});

 

 builder.Services

 .AddAuthentication(options =>

@@ -52,6 +50,12 @@ builder.Services.AddHostedService(
 

 var app = builder.Build();

 

+using (var scope = app.Services.CreateScope())

+{

+    ApplicationDbContext context = scope.ServiceProvider.GetRequiredService<ApplicationDbContext>();

+    context.Database.Migrate();

+}

+

 app.UseHttpsRedirection();

 

 app.UseAuthentication();

diff --git a/backend/Elements.Backend/Properties/launchSettings.json b/backend/Elements.Backend/Properties/launchSettings.json
index 0a48056..1114d6c 100644
--- a/backend/Elements.Backend/Properties/launchSettings.json
+++ b/backend/Elements.Backend/Properties/launchSettings.json
@@ -12,9 +12,7 @@
     "http": {

       "commandName": "Project",

       "dotnetRunMessages": true,

-      "launchBrowser": true,

-      "launchUrl": "swagger",

-      "applicationUrl": "http://localhost:5102",

+      "applicationUrl": "http://0.0.0.0:5102",

       "environmentVariables": {

         "ASPNETCORE_ENVIRONMENT": "Development"

       }