DEPLOY.Cachorro.Api
1.0.0
git config --local --list
git config --local user.name "Felipe Augusto"
git config --local user.email [email protected]
git fetch origin --prune
Projet éducatif, créé et maintenu via la chaîne DEPLOY sur YouTube.
Pour créer l'image, depuis le répertoire racine de l'application (dossier contenant le fichier sln)
Pour exécuter le projet local :
dotnet run --project ./src/DEPLOY.Cachorro.Api/DEPLOY.Cachorro.Api.csproj ASPNETCORE_ENVIRONMENT=aaa ConnectionStrings:ApplicationInsights="bbb" ConnectionStrings:DefaultConnection="ccc" ConnectionStrings:AppConfiguration="ddd"
ApplicationInsights:ApiKey="eee" KeyVault:VaultUri="fff"
Pour exécuter le projet local, à l'aide de Docker
docker container run --rm -p 8088:80
-e ASPNETCORE_ENVIRONMENT=aaa
-e ConnectionStrings__ApplicationInsights="bbb"
-e ConnectionStrings__DefaultConnection="ccc"
-e ConnectionStrings__AppConfiguration="ddd"
-e ApplicationInsights__ApiKey="eee"
-e KeyVault__VaultUri="fff"
-e AzureAd__Instance="https://login.microsoftonline.com"
-e AzureAd__ClientId="ggg"
-e AzureAd__TenantId="hhh"
felipementel/cachorro.api:latest
aaa = Development|Production
bbb = ConnectionString do Application Insights
ccc = Connection String (Azure SQL Database ou https://hub.docker.com/_/microsoft-azure-sql-edge)
ddd = Connection string do App Configuration
eee = ApiKey gerada dentro do Application Insights
fff = URI do Azure KeyVault
ggg = Identificador do cliente criado no Entra ID
hhh = Identificador do Tenant
Commande pour télécharger la base de données locale :
docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=Abcd1234%' -e 'MSSQL_PID=Developer' -p 1433:1433 --name azuresqledge -d mcr.microsoft.com/azure-sql-edge:2.0.0
Si vous souhaitez tester avec une autre balise, utilisez les commandes ci-dessous pour obtenir la liste des balises
https://mcr.microsoft.com/v2/azure-sql-edge/tags/list
Technologie : XUnit
dotnet tool install --global dotnet-reportgenerator-globaltool
dotnet tool install --global dotnet-coverage
dotnet test
Génération de rapport de test
1.1 Depuis le dossier src, exécutez la commande :
dotnet test --collect:"XPlat Code Coverage" --logger "console;verbosity=detailed" --results-directory ..TestResultsXPlatCodeCoverage
puis exécutez :
reportgenerator -reports:..TestResultsXPlatCodeCoverage**coverage.cobertura.xml -targetdir:..TestResultsXPlatCodeCoverageCoverageReport -reporttypes:"Html;SonarQube;JsonSummary;Badges" -classfilters:"-*.Migrations.*" -verbosity:Verbose -title:Cachorro.API -tag:canal-deploy
ou
$var = (Get-Date).ToString("yyyyMMdd-HHmmss"); dotnet-coverage collect "dotnet test" -f xml -o "..TestResultsDotnetCoverageCollect$varcoverage.cobertura.xml"
puis exécutez :
reportgenerator -reports:..TestResultsDotnetCoverageCollect**coverage.cobertura.xml -targetdir:..TestResultsDotnetCoverageCollectCoverageReport -reporttypes:"Html;SonarQube;JsonSummary;Badges" -verbosity:Verbose -title:Cachorro.API -tag:canal-deploy
1.2 Depuis le dossier src, exécutez la commande :
dotnet sonarscanner begin /k:"CachorroAPI" /d:sonar.host.url="http://localhost:9044" /d:sonar.token="xxxxx" /d:sonar.cs.vscoveragexml.reportsPaths=coverage.xml /d:sonar.exclusions="**/Migrations/**"
dotnet restore .srcDEPLOY.Cachorro.ApiDEPLOY.Cachorro.Api.csproj
dotnet build .srcDEPLOY.Cachorro.ApiDEPLOY.Cachorro.Api.csproj --no-incremental
dotnet-coverage collect 'dotnet test ./src/' -f xml -o 'coverage.xml'
dotnet-sonarscanner end /d:sonar.token="xxxxx"
dotnet tool install --global dotnet-ef
dotnet ef migrations add InitDatabaseAPI -s DEPLOY.Cachorro.Api -p DEPLOY.Cachorro.Infra.Repository -c DEPLOY.Cachorro.Infra.Repository.CachorroDbContext --output-dir Migrations/API -v
dotnet ef database update InitDatabaseAPI --startup-project DEPLOY.Cachorro.Api --project DEPLOY.Cachorro.Infra.Repository --context DEPLOY.Cachorro.Infra.Repository.CachorroDbContext --verbose
Chaîne de connexion
Data Source=127.0.0.1,1433;Initial Catalog=Cachorro;User Id=sa;Password=Abcd1234%;Integrated Security=False;MultipleActiveResultSets=True;TrustServerCertificate=true;
https://learn.microsoft.com/en-us/entra/identity-platform/v2-overview
https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app
https://learn.microsoft.com/en-us/entra/identity-platform/scopes-oidc
https://learn.microsoft.com/en-us/entra/identity-platform/scenario-protected-web-api-app-configuration?tabs=aspnetcore#bearer-token
https://learn.microsoft.com/en-us/entra/identity-platform/scenario-web-app-sign-user-app-configuration?tabs=aspnet
https://learn.microsoft.com/en-us/dotnet/core/tools/dotnet
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/logging/?view=aspnetcore-7.0
https://learn.microsoft.com/en-us/dotnet/core/compatibility/containers/8.0/app-user
https://learn.microsoft.com/en-us/aspnet/core/security/app-secrets?view=aspnetcore-7.0&tabs=windows
https://docs.github.com/en/actions
https://github.com/danielpalme/ReportGenerator
https://github.com/marketplace/actions/reportgenerator
https://github.com/marketplace/actions/reportgenerator
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/logging/?view=aspnetcore-7.0
https://learn.microsoft.com/en-us/dotnet/core/tools/dotnet-test
https://learn.microsoft.com/en-us/azure/azure-monitor/app/ilogger?tabs=dotnet6
https://learn.microsoft.com/pt-br/azure/azure-monitor/app/asp-net-core?tabs=netcorenew%2Cnetcore6
Diffusion en direct/métriques en direct
https://learn.microsoft.com/en-us/azure/azure-monitor/app/live-stream?tabs=dotnet6
https://learn.microsoft.com/pt-br/azure/key-vault/general/basic-concepts
https://learn.microsoft.com/en-us/dotnet/azure/sdk/dependency-injection?tabs=web-app-builder
https://learn.microsoft.com/pt-br/aspnet/core/security/key-vault-configuration?view=aspnetcore-3.1
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/configuration/?view=aspnetcore-7.0
https://docs.sonarsource.com/sonarcloud/advanced-setup/analysis-parameters/
https://learn.microsoft.com/en-us/azure/azure-app-configuration/quickstart-aspnet-core-app?tabs=core6x
https://learn.microsoft.com/en-us/azure/azure-app-configuration/howto-feature-filters-aspnet-core
https://learn.microsoft.com/en-us/azure/azure-app-configuration/enable-dynamic-configuration-aspnet-core?tabs=core6x
docker container rm -f $(docker container ls -a -q)
docker volume rm $(docker volume ls -q)
docker image rm -f $(docker image ls -a -q)
docker system prune
docker image ls
docker build -f ./src/DEPLOY.Cachorro.Api/Dockerfile -t felipementel/cachorro.api:local ./src
docker tag 430f5d9f4229 crcanaldeploydev.azurecr.io/cachorro.api:latest
docker push crcanaldeploydev.azurecr.io/cachorro.api:latest
docker push ghcr.io/felipementel/cachorro.api:latest
docker container run -p 8088:80 crcanaldeploydev.azurecr.io/cachorro.api:latest
docker container run --rm --name sonar-canal-deploy -p 9044:9000 sonarqube:10.3.0-community
az keyvault secret show --name CachorroConnectionString --vault-name kv-canaldeploy-dev
@Microsoft.KeyVault(SecretUri=https://kv-canaldeploy-dev.vault.azure.net/secrets/ConnectionStrings--ApplicationInsights/)
@Microsoft.KeyVault(VaultName=kv-canaldeploy-dev;SecretName=ConnectionStrings--ApplicationInsights)
az container logs --resource-group rg-canaldeploy-dev --name api-cachorro
az container exec -g g-canaldeploy-dev --name cachorro.api --exec-command "/bin/bash"
#git #github #github-actions #sonar-qube #wsl-2 #docker #docker-compose #docker-hub #donet #ef-core #entity-framework-core #x-unit #postman #azure #azure-application -ingishts #azure-sql-database #azure-app-configuration #azure-container-registry #azure-container-instance #azure-container-apps #azure-key-vault
