Skip to content

Instantly share code, notes, and snippets.

View sluipmoord's full-sized avatar
🏠
Working from home

Gerhard Janse Van Rensburg sluipmoord

🏠
Working from home
View GitHub Profile
@sluipmoord
sluipmoord / flask_sqlalchemy_pgp_encryption.py
Last active March 25, 2025 17:36
Custom PGP Encryption TypeDecorator for sqlalchemy and flask_sqlalchemy
import os
import sys
from typing import Any, ClassVar
from flask import current_app
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import ColumnElement, Dialect, FunctionElement, Integer, String, TypeDecorator, func, text, type_coerce
from sqlalchemy.dialects.postgresql import BYTEA, JSON, JSONB
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
from sqlalchemy.sql.operators import OperatorType