TestsCreateEntityFrameworkDbContext.cs

using NUnit.Framework;
using Acme.DemoServer.Processing.DataAccess.PostgreSql.EfModels;
using Acme.DemoServer.Processing.Generated.Tests;
using Acme.DemoServer.Testing;
using Acme.Wattle.Testing;
using System;
using System.IO;
using System.Text;
using Acme.DemoServer.Processing.Model.Implements;
using Acme.Wattle.Mappers.Interfaces;

namespace Acme.DemoServer.Processing.Tests.DataAccess.PostgreSql;

[TestFixture]
public class TestsCreateEntityFrameworkDbContext : BaseAutoTestsMapper
{
    protected override void DoPreCreateDb()
    {
        base.DoPreCreateDb();

        m_addTags = false;
        m_dbName = "test_ef_seed";
    }

    /// <summary>
    /// Создание пустой БД и скрипта генерации контекста Entity Framework Core.
    /// </summary>
    [Test]
    [Explicit]
    [Timeout(TestTimeout.Short)]
    [Category(TestCategory.Short)]
    [Description("Создание БД")]
    public void Test()
    {
        m_dropDb = false;

        using (var session = m_mappers.OpenSession())
        {
            foreach (var mapper in m_mappers)
            {
                if (mapper is IPartitionsMapper partitionsMapper)
                {
                    partitionsMapper.Partitions.CreatedDefaultPartition(session);
                }
            }

            session.Commit();
        }

        var pathSrc = "src";
        var pathDataAccess = ProviderProjectBasePath.GetFullPath(pathSrc + @"\DemoServer.Processing.DataAccess.Postgresql");
        var pathModel = ProviderProjectBasePath.GetFullPath(pathSrc + @"\DemoServer.Processing.Model");
        var text = new StringBuilder();
        var fileNameScrirpt = Path.Combine(Path.GetTempPath(), $"Make_{nameof(ProcessingDbContext)}.ps1");

        text.AppendLine("$ErrorActionPreference = \"Stop\"");
        text.AppendLine($"Rename-Item -Path \"{Path.Combine(pathDataAccess, "EfModels")}\" -NewName EfModels_old");
        text.AppendLine($"Rename-Item -Path \"{Path.Combine(pathDataAccess, "EfModelsOptimized")}\" -NewName EfModelsOptimized_old");
        text.AppendLine($@"Scaffold-DbContext -Connection ""{m_dbConnectionString}"" -Provider ""Npgsql.EntityFrameworkCore.PostgreSQL"" -OutputDir ""EfModels"" -ContextDir ""EfModels"" -Namespace ""Acme.DemoServer.Processing.DataAccess.PostgreSql.EfModels"" -ContextNamespace ""Acme.DemoServer.Processing.DataAccess.PostgreSql.EfModels"" -Context ""{nameof(ProcessingDbContext)}"" -NoOnConfiguring -Force -StartupProject DemoServer.Processing.DataAccess.Postgresql -Project DemoServer.Processing.DataAccess.Postgresql -NoPluralize");
        text.AppendLine($"Remove-Item -LiteralPath \"{Path.Combine(pathDataAccess, "EfModels_old")}\" -Force -Recurse");
        text.AppendLine($"Remove-Item -LiteralPath \"{Path.Combine(pathDataAccess, "EfModelsOptimized_old")}\" -Force -Recurse");

        var fileNameEntryPointExtensions = Path.Combine(Path.Combine(pathModel, "Implements"), $"{nameof(EntryPointStartUpExtensions)}.cs");
        text.AppendLine($"(Get-Content \"{fileNameEntryPointExtensions}\").Replace('using DbContextModel', '// using DbContextModel') | Set-Content \"{fileNameEntryPointExtensions}\"");
        text.AppendLine($"(Get-Content \"{fileNameEntryPointExtensions}\").Replace('o.UseModel(DbContextModel.Instance);', '// o.UseModel(DbContextModel.Instance);') | Set-Content \"{fileNameEntryPointExtensions}\"");

        var fileNameProcessingDbContext = Path.Combine(Path.Combine(pathDataAccess, "EfModels"), $"{nameof(ProcessingDbContext)}.cs");
        text.AppendLine($"(Get-Content \"{fileNameProcessingDbContext}\").Replace('$PD_', '') | Set-Content \"{fileNameProcessingDbContext}\"");
        text.AppendLine($"(Get-Content \"{fileNameProcessingDbContext}\").Replace('entity.ToTable(\"', 'entity.ToTableLowerCase(\"') | Set-Content \"{fileNameProcessingDbContext}\"");
        text.AppendLine($"(Get-Content \"{fileNameProcessingDbContext}\").Replace('entity.HasKey(', '// entity.HasKey(') | Set-Content \"{fileNameProcessingDbContext}\"");
        text.AppendLine($"(Get-Content \"{fileNameProcessingDbContext}\").Replace('entity.HasIndex(', '// entity.HasIndex(') | Set-Content \"{fileNameProcessingDbContext}\"");
        text.AppendLine($"Optimize-DbContext -OutputDir EfModelsOptimized -Verbose -Context {nameof(ProcessingDbContext)} -StartupProject DemoServer.Processing.DataAccess.Postgresql -Project DemoServer.Processing.DataAccess.Postgresql");
        text.AppendLine($"(Get-Content \"{fileNameEntryPointExtensions}\").Replace('// using DbContextModel', 'using DbContextModel') | Set-Content \"{fileNameEntryPointExtensions}\"");
        text.AppendLine($"(Get-Content \"{fileNameEntryPointExtensions}\").Replace('// o.UseModel(DbContextModel.Instance);', 'o.UseModel(DbContextModel.Instance);') | Set-Content \"{fileNameEntryPointExtensions}\"");
        text.AppendLine($"Remove-Item -Path \"{fileNameScrirpt}\"");
        var scrirptText = text.ToString();
        File.WriteAllText(fileNameScrirpt, scrirptText);

        Console.WriteLine();
        Console.WriteLine($"Создана БД : {m_dbName}");
        Console.WriteLine($"Создана PowerShell скрипт : {fileNameScrirpt}");
        Console.WriteLine();
        Console.WriteLine("В Package Manager Console выполнить скрипт :");
        Console.WriteLine();
        Console.WriteLine(fileNameScrirpt);
        Console.WriteLine();
        Console.WriteLine("Или в Package Manager Console выполнить команды :");
        Console.WriteLine();
        Console.WriteLine(scrirptText);
        Console.WriteLine();
    }
}