Skip to content

Instantly share code, notes, and snippets.

View skyler's full-sized avatar

Skyler Slade skyler

  • Constant Contact
  • Gainesville, FL
View GitHub Profile
old_code = db.execute(
'''SELECT coupon_code, coupon_offer
FROM surveys
WHERE survey_id = %s''', survey_id).first()
if old_code:
logging.info("Returning old coupon_code %s for survey_id %d and panelist_id %d",
old_code, survey_id, panelist_id)
return dict(coupon_code=old_code['coupon_code'],
coupon_offer=old_code['coupon_offer'],
)
"""
Obfuscate any email addresses by replacing their domain name
with something generated.
:author Skyler Slade
"""
import re
import string
import sys
class EmailAddress(UserDefinedType):
"""Represent the custom email_address DOMAIN."""
def get_col_spec(self):
return 'email_address'
@property
def python_type(self):
return basestring
#!/usr/bin/env bash
# save this file to $repo_dir/.git/hooks/post-checkout
# make it executable and symlink it to $repo_dir/.git/hooks/post-merge
# Delete .pyc files and empty directories from root of project
cd ./$(git rev-parse --show-cdup)
find . -type f -name "*.pyc" \
! -path "./git/*" \
@skyler
skyler / wave.py
Last active August 29, 2015 13:56
from sqlalchemy import Column, Integer, Enum
from sqlalchemy.dialects.postgresql import TEXT
from sqlalchemy import MetaData, create_engine
from sqlalchemy.orm import sessionmaker, scoped_session
from sqlalchemy.ext.declarative import declarative_base
info = 'postgresql+psycopg2://panel_app@localhost:5432/panel_db'
# Emperor uWSGI script
description "uWSGI Emperor"
start on runlevel [2345]
stop on runlevel [06]
exec /usr/local/bin/uwsgi --uid uwsgi --gid nginx --emperor /etc/uwsgi/sites --vassals-include /etc/uwsgi/default.ini --vacuum --logto /var/log/uwsgi.log --die-on-term
#!/bin/bash
# Send an email when a pattern is matched in a log file.
# Example usage:
# /usr/local/bin/logmonitor.sh /var/log/nginx/error.log '[crit|error]' [email protected]
PROGNAME=$0
function usage {
echo "usage: $PROGNAME logfile pattern recipients lines"
#!/bin/bash
# modified from https://gist.github.com/826961
VENV=$1
PROGNAME=$0
if [ -z $VENV ]; then
echo "usage: $PROGNAME [virtualenv_path] CMDS"
exit 1
fi
. ${VENV}/bin/activate
shift 1
@skyler
skyler / zapier_shopify.json
Created May 27, 2014 15:10
Shopify order fields for Zapier
{
"count_today": 0,
"children_ids": [
1242602
],
"code": "eacqr",
"date": "2014-05-27T10:01:17",
"lastchanged": "2014-05-27T10:09:20",
"title": null,
"root_id": null,
- name: create users
user: name={{ item.name }} state=present
uid={{ item.uid }}
system={{ item.get('is_system', 'no') }}
groups={{ ','.join(supplement_groups.get(item.name)) }} append=yes
with_items:
users
when: item.name in enabled_users
tags:
- users