roganjoshp’s gists

roganjoshp / validation_demo.py

Last active October 18, 2025 07:05

Data Validation

	# SETUP IN utils.py

	class NumParse(Enum):
	VAL = 1 # Valid number
	INV = 2 # Invalid number format
	NEG = 3 # Negative value
	ZER = 4 # Zero value
	EXC = 5 # Exceeds maximum value defined in config

	def __eq__(self, other: str):

roganjoshp / logging_time.py

Created September 7, 2025 18:30

	import logging
	import timeit


	logger = logging.getLogger(__name__)
	logging.basicConfig(filename='example.log', encoding='utf-8', level=logging.INFO)


	def as_args():
	some_str = "This is some kind of error message reasonably long"

roganjoshp / gist:59bbabf8790aa217c878327f0dd07518

Created December 6, 2024 19:13

Pandas string operations

	from string import ascii_letters

	import timeit

	import numpy as np
	import pandas as pd

	letters = [
	"".join(np.random.choice(list(ascii_letters), 10, replace=True))
	for x in range(1000000)

roganjoshp / __init__.py

Created November 24, 2023 12:48

# File deliberately empty, but gist won't allow it

roganjoshp / database.py

Last active November 17, 2023 14:59

Alembic migrations

	# src/ex_machina/database.py

	import click
	import os

	from alembic import command
	from alembic.config import Config as AlembicConfig
	from alembic.util import AutogenerateDiffsDetected
	from sqlalchemy import create_engine, MetaData
	from sqlalchemy.orm import scoped_session, sessionmaker

roganjoshp / recursive_cte_bom.py

Created August 8, 2021 08:39

Recursive CTE

roganjoshp / gist:ed69ce537ab4ee3b914cbe52a44a7a06

Created June 4, 2021 22:16

Pandas padding

roganjoshp / config.py

Created June 24, 2020 09:35

relative dump of config files

	# The contents of beatroute/src/beatroute/config.py

	import __main__
	import json
	import os
	import sqlite3
	import uuid

	from pathlib import Path

roganjoshp / .env

Last active June 23, 2020 12:54

Flask with envvars

	SECRET_KEY = '2a057dd2f0844f5a928578032c5b9955'
	DB_URL = 'postgresql+psycopg2://postgres:######@127.0.0.1/so_test'

roganjoshp / test_postgres

Created June 5, 2020 13:17

Confirming that tuple can be used in LIKE query for postgres

	from flask import Flask, render_template_string

	from flask_sqlalchemy import SQLAlchemy


	app = Flask('__name__')
	app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql+psycopg2://postgres:######@127.0.0.1/so_test'
	app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
	app.config['SESSION_TYPE'] = 'sqlalchemy'