Skip to content

Instantly share code, notes, and snippets.

View log4code's full-sized avatar

log4code

0 followers · 1 following
View GitHub Profile
@log4code
log4code / WeatherForecastController.cs
Created November 15, 2023 20:14
Slim Controller + MediatR
using MediatR;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.Infrastructure;
using System.ComponentModel.DataAnnotations;
namespace SlimController.Controllers
{
[ApiController]
[Route("[controller]")]
public class WeatherForecastController : ControllerBase
@log4code
log4code / csv2md.sh
Last active January 1, 2023 23:09
Convert a CSV file to a Markdown table using SQLite3
#!/bin/bash
#remove old output fiile
outputFile="$1.md"
rm -f outputFile
#SQLite3 commands
cmd=$({ grep -v '^#' <<EOF
.headers on
.mode csv
@log4code
log4code / rownumber_mysql3.csv
Created April 13, 2019 20:22
company_name sale_date total_amount day_rank company_id
Company A 2017–07–02 900 1 1
Company A 2018–03–01 500 2 1
Company A 2018–03–03 100 3 1
Company B 2018–03–03 1000 1 2
Company B 2017–09–15 700 2 2
Company B 2017–12–01 650 3 2
Company B 2017–06–10 560 4 2
@log4code
log4code / rownumber_mysql3.sql
Created April 13, 2019 20:20
SELECT
company_name,
sale_date,
total_amount,
@rank := IF( @comp_id = company_id, @rank + 1, 1) AS day_rank,
@comp_id := company_id AS company_id
FROM
company_sales
ORDER BY
company_id, total_amount DESC
@log4code
log4code / rownumber_mysql2.sql
Last active April 13, 2019 20:15
SET @rank = 0;
SELECT
company_name,
sale_date,
total_amount,
day_rank
FROM (
SELECT
company_name,
@log4code
log4code / rownumber_mysql2.csv
Last active April 13, 2019 20:10
company_name sale_date total_amount day_rank
Company A 2017–07–02 900.00 1
Company A 2018–03–01 500.00 2
Company A 2018–03–03 100.00 3
Company B 2018–03–03 1000.00 1
Company B 2017–09–15 700.00 2
Company B 2017–12–01 650.00 3
Company B 2017–06–10 560.00 4
@log4code
log4code / rownumber_mysql1.csv
Last active April 13, 2019 20:05
company_id company_name sale_date total_amount
1 Company A 2018–03–01 500.00
2 Company B 2017–09–15 700.00
1 Company A 2017–07–02 900.00
2 Company B 2017–06–10 560.00
2 Company B 2018–03–03 1000.00
1 Company A 2018–03–03 100.00
2 Company B 2017–12–01 650.00
@log4code
log4code / rownumber_mysql1.sql
Created April 12, 2019 18:02
SELECT
company_name,
sale_date,
total_amount,
ROW_NUMBER() OVER(PARTITION BY company_id ORDER BY total_amount DESC) AS day_rank
FROM
company_sales