new migration, logs added

danielbednarz · Apr 28, 2022 · df8c3ab · df8c3ab
1 parent 7f5ab47
commit df8c3ab
Show file tree

Hide file tree

Showing 11 changed files with 207 additions and 35 deletions.
diff --git a/CloudDrive.Dictionaries/CloudDrive.Dictionaries.csproj b/CloudDrive.Dictionaries/CloudDrive.Dictionaries.csproj
@@ -0,0 +1,9 @@
+<Project Sdk="Microsoft.NET.Sdk">
+
+  <PropertyGroup>
+    <TargetFramework>net6.0</TargetFramework>
+    <ImplicitUsings>enable</ImplicitUsings>
+    <Nullable>enable</Nullable>
+  </PropertyGroup>
+
+</Project>
diff --git a/CloudDrive.Dictionaries/Enums/OperationType.cs b/CloudDrive.Dictionaries/Enums/OperationType.cs
@@ -0,0 +1,14 @@
+using System.ComponentModel.DataAnnotations;
+
+namespace CloudDrive.Dictionaries
+{
+    public enum OperationType
+    {
+        [Display(Name = "Dodawanie")]
+        Add = 0,
+        [Display(Name = "Aktualizacja")]
+        Update = 1,
+        [Display(Name = "Usuwanie")]
+        Remove = 2
+    }
+}
diff --git a/CloudDrive.Domain/CloudDrive.Domain.csproj b/CloudDrive.Domain/CloudDrive.Domain.csproj
@@ -7,4 +7,8 @@
     <Nullable>enable</Nullable>
   </PropertyGroup>
 
+  <ItemGroup>
+    <ProjectReference Include="..\CloudDrive.Dictionaries\CloudDrive.Dictionaries.csproj" />
+  </ItemGroup>
+
 </Project>
diff --git a/CloudDrive.Domain/Models/FileOperationsLogs.cs b/CloudDrive.Domain/Models/FileOperationsLogs.cs
@@ -0,0 +1,13 @@
+using CloudDrive.Dictionaries;
+
+namespace CloudDrive.Domain
+{
+    public class FileOperationsLogs
+    {
+        public Guid Id { get; set; }
+        public OperationType OperationType { get; set; }
+        public DateTime Date { get; set; }
+        public Guid UserFileId { get; set; }
+        public virtual UserFile UserFile { get; set; } 
+    }
+}
diff --git a/CloudDrive.Domain/Models/UserFile.cs b/CloudDrive.Domain/Models/UserFile.cs
@@ -6,6 +6,9 @@ public class UserFile
         public string Name { get; set; }
         public long Size { get; set; }
         public long FileVersion { get; set; }
+        public string RelativePath { get; set; }
         public DateTime CreatedDate { get; set; }
+        public DateTime UpdatedDate { get; set; }
+        public virtual ICollection<FileOperationsLogs> FileOperationsLogs { get; set; }
     }
 }
diff --git a/CloudDrive.EntityFramework/Contexts/MainDatabaseContext.cs b/CloudDrive.EntityFramework/Contexts/MainDatabaseContext.cs
@@ -17,12 +17,14 @@ public MainDatabaseContext(DbContextOptions options) : base(options)
         // dotnet ef database update
 
         public DbSet<UserFile> Files { get; set; }
+        public DbSet<FileOperationsLogs> FileOperationsLogs { get; set; }
 
         protected override void OnModelCreating(ModelBuilder modelBuilder)
         {
             base.OnModelCreating(modelBuilder);
 
             modelBuilder.Entity<UserFile>().HasKey(x => x.Id);
+            modelBuilder.Entity<FileOperationsLogs>().HasKey(x => x.Id);
         }
     }
 }
diff --git a/CloudDrive.EntityFramework/Migrations/MainDatabaseMigrations/20220314192017_Init.cs b/CloudDrive.EntityFramework/Migrations/MainDatabaseMigrations/20220314192017_Init.cs
diff --git a/...igrations/20220314192017_Init.Designer.cs → ...igrations/20220428173942_Init.Designer.cs b/...igrations/20220314192017_Init.Designer.cs → ...igrations/20220428173942_Init.Designer.cs
diff --git a/CloudDrive.EntityFramework/Migrations/MainDatabaseMigrations/20220428173942_Init.cs b/CloudDrive.EntityFramework/Migrations/MainDatabaseMigrations/20220428173942_Init.cs
@@ -0,0 +1,64 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace CloudDrive.EntityFramework.Migrations.MainDatabaseMigrations
+{
+    public partial class Init : Migration
+    {
+        protected override void Up(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.CreateTable(
+                name: "Files",
+                columns: table => new
+                {
+                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
+                    Name = table.Column<string>(type: "nvarchar(max)", nullable: false),
+                    Size = table.Column<long>(type: "bigint", nullable: false),
+                    FileVersion = table.Column<long>(type: "bigint", nullable: false),
+                    RelativePath = table.Column<string>(type: "nvarchar(max)", nullable: false),
+                    CreatedDate = table.Column<DateTime>(type: "datetime2", nullable: false),
+                    UpdatedDate = table.Column<DateTime>(type: "datetime2", nullable: false)
+                },
+                constraints: table =>
+                {
+                    table.PrimaryKey("PK_Files", x => x.Id);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "FileOperationsLogs",
+                columns: table => new
+                {
+                    Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
+                    OperationType = table.Column<int>(type: "int", nullable: false),
+                    Date = table.Column<DateTime>(type: "datetime2", nullable: false),
+                    UserFileId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
+                },
+                constraints: table =>
+                {
+                    table.PrimaryKey("PK_FileOperationsLogs", x => x.Id);
+                    table.ForeignKey(
+                        name: "FK_FileOperationsLogs_Files_UserFileId",
+                        column: x => x.UserFileId,
+                        principalTable: "Files",
+                        principalColumn: "Id",
+                        onDelete: ReferentialAction.Cascade);
+                });
+
+            migrationBuilder.CreateIndex(
+                name: "IX_FileOperationsLogs_UserFileId",
+                table: "FileOperationsLogs",
+                column: "UserFileId");
+        }
+
+        protected override void Down(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.DropTable(
+                name: "FileOperationsLogs");
+
+            migrationBuilder.DropTable(
+                name: "Files");
+        }
+    }
+}
diff --git a/...ive.EntityFramework/Migrations/MainDatabaseMigrations/MainDatabaseContextModelSnapshot.cs b/...ive.EntityFramework/Migrations/MainDatabaseMigrations/MainDatabaseContextModelSnapshot.cs
@@ -22,6 +22,28 @@ protected override void BuildModel(ModelBuilder modelBuilder)
 
             SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
 
+            modelBuilder.Entity("CloudDrive.Domain.FileOperationsLogs", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("uniqueidentifier");
+
+                    b.Property<DateTime>("Date")
+                        .HasColumnType("datetime2");
+
+                    b.Property<int>("OperationType")
+                        .HasColumnType("int");
+
+                    b.Property<Guid>("UserFileId")
+                        .HasColumnType("uniqueidentifier");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("UserFileId");
+
+                    b.ToTable("FileOperationsLogs");
+                });
+
             modelBuilder.Entity("CloudDrive.Domain.UserFile", b =>
                 {
                     b.Property<Guid>("Id")
@@ -38,13 +60,36 @@ protected override void BuildModel(ModelBuilder modelBuilder)
                         .IsRequired()
                         .HasColumnType("nvarchar(max)");
 
+                    b.Property<string>("RelativePath")
+                        .IsRequired()
+                        .HasColumnType("nvarchar(max)");
+
                     b.Property<long>("Size")
                         .HasColumnType("bigint");
 
+                    b.Property<DateTime>("UpdatedDate")
+                        .HasColumnType("datetime2");
+
                     b.HasKey("Id");
 
                     b.ToTable("Files");
                 });
+
+            modelBuilder.Entity("CloudDrive.Domain.FileOperationsLogs", b =>
+                {
+                    b.HasOne("CloudDrive.Domain.UserFile", "UserFile")
+                        .WithMany("FileOperationsLogs")
+                        .HasForeignKey("UserFileId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired();
+
+                    b.Navigation("UserFile");
+                });
+
+            modelBuilder.Entity("CloudDrive.Domain.UserFile", b =>
+                {
+                    b.Navigation("FileOperationsLogs");
+                });
 #pragma warning restore 612, 618
         }
     }

diff --git a/CloudDrive.sln b/CloudDrive.sln
@@ -31,6 +31,8 @@ Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "CloudDrive.Application.Serv
 EndProject
 Project("{54A90642-561A-4BB1-A94E-469ADEE60C69}") = "CloudDrive.Vue", "CloudDrive.Vue\CloudDrive.Vue.esproj", "{546BB76B-9B2D-4D27-BC58-5103E4FED781}"
 EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "CloudDrive.Dictionaries", "CloudDrive.Dictionaries\CloudDrive.Dictionaries.csproj", "{5DA61A8C-16BC-4608-B00D-6B064D351342}"
+EndProject
 Global
 	GlobalSection(SolutionConfigurationPlatforms) = preSolution
 		Debug|Any CPU = Debug|Any CPU
@@ -75,6 +77,10 @@ Global
 		{546BB76B-9B2D-4D27-BC58-5103E4FED781}.Release|Any CPU.ActiveCfg = Release|Any CPU
 		{546BB76B-9B2D-4D27-BC58-5103E4FED781}.Release|Any CPU.Build.0 = Release|Any CPU
 		{546BB76B-9B2D-4D27-BC58-5103E4FED781}.Release|Any CPU.Deploy.0 = Release|Any CPU
+		{5DA61A8C-16BC-4608-B00D-6B064D351342}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{5DA61A8C-16BC-4608-B00D-6B064D351342}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{5DA61A8C-16BC-4608-B00D-6B064D351342}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{5DA61A8C-16BC-4608-B00D-6B064D351342}.Release|Any CPU.Build.0 = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(SolutionProperties) = preSolution
 		HideSolutionNode = FALSE
@@ -89,6 +95,7 @@ Global
 		{7DDC6C76-2605-41D7-82BD-A4C101388693} = {26BFFE0C-3173-435E-A521-661B5E1E65C9}
 		{7F562B80-9452-42F8-AD22-DD589BD9E868} = {26BFFE0C-3173-435E-A521-661B5E1E65C9}
 		{546BB76B-9B2D-4D27-BC58-5103E4FED781} = {9A76DF35-1027-489E-8894-825D3FBFB7F4}
+		{5DA61A8C-16BC-4608-B00D-6B064D351342} = {B3CC7786-15BD-46A1-AF58-7902088C6862}
 	EndGlobalSection
 	GlobalSection(ExtensibilityGlobals) = postSolution
 		SolutionGuid = {64EA95DE-F32A-47F3-97BF-13ACE0D34C95}