Skip to content

Instantly share code, notes, and snippets.

@danielplawgo
danielplawgo / azure-pipelines.yml
Created April 3, 2022 06:04
Uruchamianie Terraform w Azure DevOps
trigger:
- main
pool:
vmImage: ubuntu-latest
steps:
- task: PublishBuildArtifacts@1
inputs:
PathtoPublish: '$(Build.Repository.LocalPath)/src'
@danielplawgo
danielplawgo / AddProducts.cs
Created February 15, 2022 06:26
EF Core 6 Temporal Tables
public partial class AddProducts : Migration
{
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateTable(
name: "Products",
columns: table => new
{
Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
Name = table.Column<string>(type: "nvarchar(max)", nullable: false),
@danielplawgo
danielplawgo / applicationinsights.tf
Created October 28, 2021 04:23
Terraform i Azure - przykład
resource "azurerm_application_insights" "app_insight" {
name = "onlin-ai-${var.env}"
location = azurerm_resource_group.resource_group.location
resource_group_name = azurerm_resource_group.resource_group.name
application_type = "web"
}
@danielplawgo
danielplawgo / main1.tf
Created October 1, 2021 06:05
Terraform i Azure
terraform {
required_providers {
azurerm = {
source = "hashicorp/azurerm"
version = "=2.46.0"
}
}
required_version = ">= 0.14.9"
}
@danielplawgo
danielplawgo / AuditLog.cs
Created May 26, 2021 12:32
Entity Framework Core - DbFunction
public class AuditLog
{
public Guid Id { get; set; } = Guid.NewGuid();
public DateTimeOffset Created { get; set; } = DateTimeOffset.UtcNow;
public string LogType { get; set; }
public string Data { get; set; }
}
@danielplawgo
danielplawgo / ConnectionStringBuilder.cs
Created May 7, 2021 04:24
Multi Tenant - jedna baza danych per tenant
public class ConnectionStringBuilder : IConnectionStringBuilder
{
private readonly ITenantAccessService _tenantAccessService;
private readonly IConfiguration _configuration;
public ConnectionStringBuilder(ITenantAccessService tenantAccessService,
IConfiguration configuration)
{
_tenantAccessService = tenantAccessService;
_configuration = configuration;
@danielplawgo
danielplawgo / BasePage.cs
Created May 5, 2021 06:29
Blazor - walidacja - Web API
public class BasePage : ComponentBase
{
protected FormValidator FormValidator;
protected void ShowError(Result result, object model = null)
{
FormValidator?.ShowError(result, model);
}
protected void ShowMessage(string message)
@danielplawgo
danielplawgo / ClaimResolutionStrategy.cs
Created April 7, 2021 03:49
Multi tenant - określenie tenanta
public class ClaimResolutionStrategy : ITenantResolutionStrategy
{
private readonly IHttpContextAccessor _httpContextAccessor;
public ClaimResolutionStrategy(IHttpContextAccessor httpContextAccessor)
{
_httpContextAccessor = httpContextAccessor;
}
public Task<Guid> GetTenantIdentifierAsync()
@danielplawgo
danielplawgo / requests.rest
Created April 2, 2021 04:16
Visual Studio Code REST Client
@danielplawgo
danielplawgo / database1.sql
Last active March 24, 2021 19:45
SQL Server i Docker
IF NOT EXISTS(SELECT * FROM sys.databases WHERE name = 'Database1')
BEGIN
CREATE DATABASE [Database1]
END
GO
USE [Database1]
GO
--You need to check if the table exists
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='Users' and xtype='U')