Skip to content

Instantly share code, notes, and snippets.

View osumac's full-sized avatar

Christine Osuma osumac

View GitHub Profile
@osumac
osumac / exclusion_status_column_migration.sql
Last active May 7, 2026 17:31
Add status and inactivated_at columns to the exclusion table
###################################################
# PERFTEST MIGRATION
###################################################
userattrclirw@us_perftest/userattributes> UPDATE exclusion e
-> JOIN (
-> SELECT id AS self_id
-> FROM (
-> SELECT
-> id,
-> user_id,
@osumac
osumac / update_timeout_expiry_date_for_user_23362585.sql
Last active April 8, 2026 16:18
Set timeout expiry date in the past for user 23362585
BEGIN;
SELECT * FROM exclusion WHERE user_id = 23362585;
SELECT * FROM exclusion_config;
# UPDATE exclusion SET expiry_date = '2026-04-08 07:40:14' WHERE user_id = 23362585 AND id = 992072;
UPDATE exclusion SET expiry_date = '2026-04-08 08:10:14' WHERE user_id = 23362585 AND id = 992072;
SELECT * FROM exclusion WHERE user_id = 23362585;
(VIRTUALENV) christineosuma@FDG-C02WL0GSG8WL ~/Documents/dev/livedrafting/integration (set-queue-debug)
$ make integration
PYTHONHASHSEED=0 python -m pytest livedrafting/ -n=4 -v --failed-first
======================================================================================== test session starts ========================================================================================
platform darwin -- Python 3.7.5, pytest-5.1.2, py-1.8.1, pluggy-0.13.1 -- /Users/christineosuma/.virtualenvs/VIRTUALENV/bin/python
cachedir: .pytest_cache
rootdir: /Users/christineosuma/Documents/dev/livedrafting/integration
plugins: mock-1.5.0, requests-mock-1.5.0, cov-2.4.0, ordering-0.6, forked-1.1.3, xdist-1.15.0
[gw0] darwin Python 3.7.5 cwd: /Users/christineosuma/Documents/dev/livedrafting/integration
[gw1] darwin Python 3.7.5 cwd: /Users/christineosuma/Documents/dev/livedrafting/integration