Skip to content

Instantly share code, notes, and snippets.

View alexa-infra's full-sized avatar

Alexey Vasilyev alexa-infra

View GitHub Profile
@alexa-infra
alexa-infra / examples.py
Created May 22, 2020 21:27
Dialect-specific SQLAlchemy declarative Column defaults
class Table1(Base):
__tablename__ = 'table1'
id = sa.Column(UUID, primary_key=True, server_default=sa.text("uuid_generate_v4()"))
class Table2(Base):
__tablename__ = 'table2'
id = sa.Column(UUID, primary_key=True, default=uuid.uuid4)
@alexa-infra
alexa-infra / flask_sqlalchemy.py
Last active May 22, 2020 21:33
Minimal flask-sqlalchemy integration, which allows you to keep models independent of flask
from typing import TYPE_CHECKING
from sqlalchemy import create_engine
if TYPE_CHECKING:
from flask import Flask
from sqlalchemy.orm import scoped_session
class FlaskSQLAlchemy:
@alexa-infra
alexa-infra / find-duplicates.sh
Created August 3, 2019 11:19
Find file duplicates
find . -type f | xargs -n 1 md5sum -b > all_md5.txt
cat all_md5.txt | awk '{print $1}' | sort | uniq -d | xargs -n 1 -I '{}' grep '{}' all_md5.txt
@alexa-infra
alexa-infra / pyspy.py
Created January 10, 2016 22:01
Thransparent TCP proxy and logger
import argparse
import os
import select
import socket
import sys
import threading
parser = argparse.ArgumentParser(
description='Transparent TCP proxy and logger')
parser.add_argument('-a', '--host', required=True,