yuhangch

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");
builder.Services.AddDatabaseDeveloperPageExceptionFilter();
builder.Services.AddDbContext<TestDb>(options =>

yuhangch

cd app-dir
git pull
ps -ef| grep "dotnet run$" | tr -s " " | cut -d " " -f 2 | xargs kill
nohup dotnet run &

yuhangch

-- https://stackoverflow.com/a/41988979/10936088
CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE OR REPLACE FUNCTION generate_uid(size INT) RETURNS TEXT AS $$
DECLARE
  characters TEXT := 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
  bytes BYTEA := gen_random_bytes(size);
  l INT := length(characters);
  i INT := 0;
  output TEXT := '';
BEGIN

yuhangch

using Microsoft.OpenApi.Any;
using Microsoft.OpenApi.Extensions;
using Microsoft.OpenApi.Interfaces;
using Microsoft.OpenApi.Models;
using NetTopologySuite.Features;
using NetTopologySuite.Geometries;
using Swashbuckle.AspNetCore.SwaggerGen;

namespace hello.Common;

yuhangch

DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (SELECT tablename FROM pg_tables WHERE (schemaname = current_schema() and tablename != 'spatial_ref_sys')) LOOP
        EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE';
    END LOOP;
END $$;

yuhangch

// https://blog.codetitans.pl/post/sending-ctrl-c-signal-to-another-application-on-windows/
[DllImport("kernel32.dll", SetLastError = true)]
static extern bool AttachConsole(uint dwProcessId);

[DllImport("kernel32.dll", SetLastError = true, ExactSpelling = true)]
static extern bool FreeConsole();

[DllImport("kernel32.dll")]
static extern bool SetConsoleCtrlHandler(ConsoleCtrlDelegate handler, bool add);

yuhangch

SetStoreCapsLockMode False
CapsLock::
{
    KeyWait "CapsLock"  
    
    time := A_TimeSinceThisHotkey
    if (time > 300) {
         SetTimer SendCaps, -4 
    }
     else {

yuhangch

#! /bin/bash
blog_path=~/path/to/blog
cd $blog_path
hugo new --editor typora posts/$1.md

yuhangch

import os

import tinify

tinify.key = "your key"

root = "./images"
dst_path = "./images-compress"
for origin, _, files in os.walk(root, topdown=False):
    for name in files:

yuhangch

from zipfile import ZipFile
from pathlib import Path


target_directory = "."

    with ZipFile(src, 'r') as f:
        for file_name in f.namelist():
            file_name = f.extract(file_name, path=target_directory)
            try: