wonderbeyond

Writing an apt proxy conf file /etc/apt/apt.conf.d/proxy.conf as below.

Acquire::http::Proxy "socks5h://127.0.0.1:1080";
Acquire::https::Proxy "socks5h://127.0.0.1:1080";
Acquire::socks::Proxy "socks5h://127.0.0.1:1080";

And the proxy settings will be applied the next time we run apt.

wonderbeyond

References:

• https://github.com/darkk/redsocks
• https://www.cnblogs.com/develon/p/11830726.html
• https://fuckcloudnative.io/posts/linux-circumvent/
• https://www.cnblogs.com/whych/p/9147900.html
• https://www.singchia.com/2018/03/23/A-Brief-Talk-About-Proxy-CN/
• https://blog.chih.me/global-proxy-within-redsocks-and-shadowsocks.html
• http://gsoc-blog.ecklm.com/iptables-redirect-vs.-dnat-vs.-tproxy/

---

wonderbeyond

genpac

$ pip install genpac
$ genpac \
    --pac-proxy="SOCKS5 172.16.1.117:1080" \
    --gfwlist-proxy="SOCKS5 172.16.1.117:1080" \
    --gfwlist-url="https://raw.githubusercontent.com/gfwlist/gfwlist/master/gfwlist.txt" \
    -o ~/autoproxy.pac
# we got: file:///home/wonder/autoproxy.pac

wonderbeyond

#!/usr/bin/env python
import argparse
import urllib.parse
import textwrap

import psycopg2
import psycopg2.extras


def main():

wonderbeyond

from typing import Any

import sqlalchemy as sa
from sqlalchemy.dialects.postgresql import array as pg_array, JSONB


def jsonb_set(target, path: list[str], val: Any):
    """
    An easy wrapper over sa.func.jsonb_set().

wonderbeyond

import os
from contextlib import contextmanager
from tempfile import mkstemp


@contextmanager
def MakeTemporaryFile(suffix=None, prefix=None, dir=None):
    """An alternative to tempfile.NamedTemporaryFile working with Windows NT."""
    try:
        fd, name = mkstemp(suffix=suffix, prefix=prefix, dir=dir)

wonderbeyond

"""
Python's builtin min function is evil

>>> min(2, 1)
1
>>> min([2, 1])
1
>>> min([2])
2
>>> min([])

wonderbeyond

"""
A Task-Step model that can describe steps' upstream and downstream relationships.
Also refer to https://docs.sqlalchemy.org/en/20/orm/join_conditions.html#self-referential-many-to-many-relationship
"""
from typing import Annotated, List

import sqlalchemy as sa
from sqlalchemy import ForeignKey
from sqlalchemy.orm import Mapped, mapped_column, relationship, backref
from sqlalchemy.orm import MappedAsDataclass, DeclarativeBase

wonderbeyond

class AsyncSQLAlchemy:
    def __init__(
        self,
        url: str,
        engine_options: Optional[Dict[str, Any]] = None,
        session_options: Optional[Dict[str, Any]] = None,
    ):
        from sqlalchemy.orm import sessionmaker
        from sqlalchemy.ext.asyncio import AsyncSession

wonderbeyond

#!/bin/bash
# Author: wonderbeyond@gmail.com
# Usage: viaproxy "socks5 127.0.0.1 1080" telnet some-host

command -v proxychains4 > /dev/null && PROXYCHAINS="proxychains4 -q" || PROXYCHAINS=proxychains

proxy="$1"
shift

temp_conf_file=$(mktemp /tmp/viaproxy-proxchains-conf-XXXX)