Revize 782b6d38

Fixed comments from code review, fixed DB access

Backend/Backend.sln

@@ -7 +7 @@
 EndProject
 Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "Models", "Models\Models.csproj", "{03BFE675-EE7F-4493-8682-6D13EEEABD4F}"
 EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Core", "Core\Core.csproj", "{EE92204E-BFD8-473F-BBBC-51E975BF6937}"
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "Core", "Core\Core.csproj", "{EE92204E-BFD8-473F-BBBC-51E975BF6937}"
+EndProject
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "BackendTesting", "BackendTesting\BackendTesting.csproj", "{516D3F60-5760-445B-9B0C-B2108046D9D4}"
 EndProject
 Global
 	GlobalSection(SolutionConfigurationPlatforms) = preSolution
@@ -27 +29 @@
 		{EE92204E-BFD8-473F-BBBC-51E975BF6937}.Debug|Any CPU.Build.0 = Debug|Any CPU
 		{EE92204E-BFD8-473F-BBBC-51E975BF6937}.Release|Any CPU.ActiveCfg = Release|Any CPU
 		{EE92204E-BFD8-473F-BBBC-51E975BF6937}.Release|Any CPU.Build.0 = Release|Any CPU
+		{516D3F60-5760-445B-9B0C-B2108046D9D4}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+		{516D3F60-5760-445B-9B0C-B2108046D9D4}.Debug|Any CPU.Build.0 = Debug|Any CPU
+		{516D3F60-5760-445B-9B0C-B2108046D9D4}.Release|Any CPU.ActiveCfg = Release|Any CPU
+		{516D3F60-5760-445B-9B0C-B2108046D9D4}.Release|Any CPU.Build.0 = Release|Any CPU
 	EndGlobalSection
 	GlobalSection(SolutionProperties) = preSolution
 		HideSolutionNode = FALSE

Backend/BackendTesting/AnotationTesting.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class AnotationTesting
+    public class AnotationTesting
     {
     }
 }

Backend/BackendTesting/BackendTesting.csproj

@@ -24 +24 @@
     <PackageReference Include="MSTest.TestAdapter" Version="2.2.7" />
     <PackageReference Include="MSTest.TestFramework" Version="2.2.7" />
     <PackageReference Include="coverlet.collector" Version="3.1.0" />
-    <PackageReference Include="Selenium.WebDriver" Version="4.1.0" />
-    <PackageReference Include="Selenium.WebDriver.ChromeDriver" Version="100.0.4896.6000" />
-    <PackageReference Include="Selenium.WebDriver.GeckoDriver" Version="0.30.0.1" />
+  </ItemGroup>
+
+  <ItemGroup>
+    <ProjectReference Include="..\Core\Core.csproj" />
   </ItemGroup>
 
 </Project>

Backend/BackendTesting/Constants.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class Constants
+    public class Constants
     {
     }
 }

Backend/BackendTesting/DocumentManagementTesting.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class DocumentManagementTesting
+    public class DocumentManagementTesting
     {
     }
 }

Backend/BackendTesting/FiltersTesting.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class FiltersTesting
+    public class FiltersTesting
     {
     }
 }

Backend/BackendTesting/ImportExportTesting.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class ImportExportTesting
+    public class ImportExportTesting
     {
     }
 }

Backend/BackendTesting/LoginTesting.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class LoginTesting
+    public class LoginTesting
     {
     }
 }

Backend/BackendTesting/MainTestingClass.cs

@@ +1 @@
+using Microsoft.EntityFrameworkCore;
+using Microsoft.Extensions.Logging;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+
+using System;
+using System.Collections;
+using System.Collections.Generic;
+using System.Threading;
+
+namespace BackendTesting
+{
+
+
+    [TestClass]
+    public class MainTestingClass
+    {
+        //public TestContext context = new TestContext();
+        [TestMethod]
+        public void runAll()
+        {
+            
+
+        } 
+
+
+        /*
+        public IWebDriver fDriver = new FirefoxDriver();
+        public IWebDriver cDriver = new ChromeDriver();
+        [TestMethod]
+        public void DummyTutorial()
+        {
+            var webDriver = cDriver; //potrebuje "using selenium a chrome (firefox)
+            //priprava promennych
+            By googleSearchBar = By.Name("q");
+            By googleSearchButton = By.Name("btnK");
+            By searchName = By.XPath("//h2//span[text()='Elden Ring']");
+            By googleCoockieAggreementButton = By.Id("L2AGLb");
+
+            //prace s driverem
+            webDriver.Manage().Window.Maximize();
+            webDriver.Navigate().GoToUrl("https://www.google.com/");    //zakladni stranka
+            Thread.Sleep(500);
+
+            webDriver.FindElement(googleCoockieAggreementButton).Click();           //odsouhlaseni coockies
+            Thread.Sleep(500);
+
+            webDriver.FindElement(googleSearchBar).SendKeys("Elden Ring");          //napsat Elden Ring do hledani
+            Thread.Sleep(500);
+            webDriver.FindElement(googleSearchButton).Click();                      //kliknout na button pro poslani prikazu
+            Thread.Sleep(500);
+
+            var resultText = webDriver.FindElement(searchName);                     //najit pomoci xpath pozadovany element a ulozit si ho
+
+            Assert.IsTrue(resultText.Text == "Elden Ring"); //samotny test pro otestovani stazene hodnoty
+
+
+            webDriver.Quit();                                                          //ukonceni webdriveru
+        }
+        */
+
+    }
+}

Backend/BackendTesting/Main_Testing_Class.cs

@@ -1 @@
-using Microsoft.VisualStudio.TestTools.UnitTesting;
-using OpenQA.Selenium;
-using OpenQA.Selenium.Chrome;
-using OpenQA.Selenium.Firefox;
-
-using System;
-using System.Collections;
-using System.Collections.Generic;
-using System.Threading;
-
-namespace BackendTesting
-{
-    [TestClass]
-    public class Main_Testing_Class
-    {
-        public IWebDriver fDriver = new FirefoxDriver();
-        public IWebDriver cDriver = new ChromeDriver();
-
-
-        [TestMethod]
-        public void DummyTutorial()
-        {
-            var webDriver = cDriver; //potrebuje "using selenium a chrome (firefox)
-            //priprava promennych
-            By googleSearchBar = By.Name("q");
-            By googleSearchButton = By.Name("btnK");
-            By searchName = By.XPath("//h2//span[text()='Elden Ring']");
-            By googleCoockieAggreementButton = By.Id("L2AGLb");
-
-            //prace s driverem
-            webDriver.Manage().Window.Maximize();
-            webDriver.Navigate().GoToUrl("https://www.google.com/");    //zakladni stranka
-            Thread.Sleep(500);
-
-            webDriver.FindElement(googleCoockieAggreementButton).Click();           //odsouhlaseni coockies
-            Thread.Sleep(500);
-
-            webDriver.FindElement(googleSearchBar).SendKeys("Elden Ring");          //napsat Elden Ring do hledani
-            Thread.Sleep(500);
-            webDriver.FindElement(googleSearchButton).Click();                      //kliknout na button pro poslani prikazu
-            Thread.Sleep(500);
-
-            var resultText = webDriver.FindElement(searchName);                     //najit pomoci xpath pozadovany element a ulozit si ho
-
-            Assert.IsTrue(resultText.Text == "Elden Ring"); //samotny test pro otestovani stazene hodnoty
-
-
-            webDriver.Quit();                                                          //ukonceni webdriveru
-        }
-
-
-    }
-}

Backend/BackendTesting/TagsManagementTesting.cs

@@ -6 +6 @@
 
 namespace BackendTesting
 {
-    internal class TagsManagementTesting
+    public class TagsManagementTesting
     {
     }
 }

Backend/BackendTesting/UserManagementTesting.cs

@@ -1 @@
-using System;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+using Models.Enums;
+using Core.Entities;
+using Serilog;
+
+using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
+using Microsoft.EntityFrameworkCore;
+using AutoMapper;
+using Core.MapperProfiles;
+using Core.Contexts;
+using Microsoft.Extensions.Configuration;
 
-namespace BackendTesting
+namespace Core.Services
 {
-    internal class UserManagementTesting
+    public class UserContext : DatabaseContext
     {
+        public UserContext(IConfiguration configuration) : base(configuration) { }
+
+        //public static ILoggerFactory logger = LoggerFactory.Create(builder => { builder.AddConsole(); });
+        public ILogger logger = new LoggerConfiguration().WriteTo.Console().CreateLogger(); /* logger */
+
+        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
+        {
+            base.OnConfiguring(optionsBuilder);
+            optionsBuilder.UseSqlite("Data source=db.sqlite", b => b.MigrationsAssembly("RestAPI"));
+            //optionsBuilder.(logger);
+        }
+
+    }
+    [TestClass]
+    public class UserManagementTesting      //testing of Core/Services/UserService
+    {
+
     }
 }

Backend/BackendTesting/Utils.cs

@@ -1 @@
-using System;
+using Microsoft.VisualStudio.TestTools.UnitTesting;
+using Models.Enums;
+using Core.Entities;
+using Serilog;
+
+using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
+using Microsoft.EntityFrameworkCore;
+using AutoMapper;
+using Core.MapperProfiles;
 
-namespace BackendTesting
+namespace Core.Services
 {
-    internal class Utils
+    public class Utils
+    {
+    }
+
+    public static class TestingMapper
+    {
+        public static IMapper GetMapper()
+        {
+            var mapperConfig = new MapperConfiguration(cfg =>
+            {
+                cfg.AddProfile<DocumentProfileEF>();
+                cfg.AddProfile<UserProfileEF>();
+                cfg.AddProfile<TagProfileEF>();
+            });
+
+            IMapper mapper = mapperConfig.CreateMapper();
+            return mapper;
+        }
+    }
+    public static class TestingLogger
     {
+        public static ILogger GetLogger() 
+        {
+            return new LoggerConfiguration().WriteTo.Console().CreateLogger(); /* logger */
+        }
     }
 }

Backend/Core/Contexts/DatabaseContext.cs

@@ -31 +31 @@
 
         protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
         {
-            optionsBuilder.UseNpgsql(_configuration["ConnectionString"], b => b.MigrationsAssembly("RestAPI"));
+            //optionsBuilder.UseNpgsql(_configuration["ConnectionString"], b => b.MigrationsAssembly("RestAPI"));
+            optionsBuilder.UseNpgsql("Host=localhost:5432;Database=dbo;Username=myuser;Password=password");
         }
     }
 }

README.md

@@ -9 +9 @@
 CREATE DATABASE dbo;
 CREATE USER myuser WITH PASSWORD 'password';
 GRANT ALL PRIVILEGES ON DATABASE dbo TO myuser;
+ALTER ROLE myuser WITH SUPERUSER;