Skip to content

Instantly share code, notes, and snippets.

View krysros's full-sized avatar

Krystian Rosiński krysros

View GitHub Profile
CREATE TABLE alembic_version (
version_num VARCHAR(32) NOT NULL,
CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
);
CREATE TABLE users (
id INTEGER NOT NULL,
name VARCHAR NOT NULL,
fullname VARCHAR NOT NULL,
email VARCHAR NOT NULL,
role VARCHAR NOT NULL,
@krysros
krysros / extract_postcode_and_city.py
Created December 18, 2022 08:59
Extract postcode and city from address
import re
def dash_filter(v):
"""Replace em dash, en dash, minus sign, hyphen-minus with a hypen"""
return (
v.replace("\u2014", "-")
.replace("\u2013", "-")
.replace("\u2212", "-")
.replace("\u002D", "-")
@krysros
krysros / vs-lua.cmd
Last active December 3, 2024 00:20
Build Lua on Windows
@echo off
rem Install Build Tools for Visual Studio 2022
rem https://visualstudio.microsoft.com/pl/downloads/#build-tools-for-visual-studio-2022
rem Run "Developer Command Prompt for VS 2022"
setlocal
set lua_version=5.4.7
cd %USERPROFILE%\Downloads
curl https://lua.org/ftp/lua-%lua_version%.tar.gz -o lua-%lua_version%.tar.gz
tar -xvf lua-%lua_version%.tar.gz
cd lua-%lua_version%\src