Skip to content

Instantly share code, notes, and snippets.

from django.db import models
class User(models.Model):
id = models.AutoField(primary_key=True)
parent = models.ForeignKey("self", null=True, blank=True, on_delete=models.CASCADE)
def get_tree_users_recursive(self) -> "models.QuerySet[User]":
return User.objects.extra(
where=[
import inspect
import logging
import os
import argparse
import pathlib
import signal
import subprocess
import sys
import time
import loguru
@sunfkny
sunfkny / whitelist.conf
Created March 15, 2024 01:39
/etc/nginx/whitelist.conf
allow 10.0.0.0/8;
allow 172.16.0.0/12;
allow 192.168.0.0/16;
# https://www.cloudflare.com/ips-v4
allow 173.245.48.0/20;
allow 103.21.244.0/22;
allow 103.22.200.0/22;
allow 103.31.4.0/22;
allow 141.101.64.0/18;
import os
import sys
import pathlib
import django
def django_setup(DJANGO_SETTINGS_MODULE: str):
if os.environ.get("DJANGO_SETTINGS_MODULE"):
return
parts = list(pathlib.Path(__file__).parent.parts)
import os
import shutil
import click
from pathlib import Path
def is_apple_double_file(path: Path) -> bool:
return (
path.is_file()
and path.name.startswith("._")
@sunfkny
sunfkny / oss-browser-ak-his.py
Created February 24, 2024 11:31
get oss-browser AK Histories
import json
import os
import pathlib
import sqlite3
from pprint import pprint
# pip install javascript
from javascript import require
crypto = require("crypto")
@sunfkny
sunfkny / getContentWithAltText.js
Created January 17, 2024 06:39
get html textContent with img alt text
/**
* Traverse DOM Tree
* @param {string[]} content
* @param {Element|ChildNode} node
* @param {string|undefined} altReplacement
* @returns {void}
*/
function traverse(content, node, altReplacement) {
if (node.nodeType === Node.TEXT_NODE) {
content.push(node.textContent ?? '');
from urllib.parse import quote
import polib
def google_lang_convert(lang: str):
if lang == "zh_Hant":
return "zh-TW"
if lang.lower().startswith("zh"):
return "zh-CN"
return lang
{% extends "admin/base_site.html" %}
{% load i18n static %}
{% block extrastyle %}{{ block.super }}<link rel="stylesheet" href="{% static "admin/css/login.css" %}">
<style>
#id_token {
padding: 8px;
width: 100%;
box-sizing: border-box;
}
# https://github.com/douweschulte/opencontrol
import math
from loguru import logger
import logging
import sys
import ctypes
import enum
import typing