Skip to content

Instantly share code, notes, and snippets.

@aisipos
aisipos / migration_sql.rb
Last active August 26, 2019 01:31
Patch Rails ActiveRecord Migrations to output migration scripts
namespace :db do
[ :migrate, :rollback ].each do |n|
namespace n do |migration_task|
original_task = migration_task.instance_variable_get("@scope").to_a.reverse.join ":"
[:with_sql, :to_sql ].each do |t|
desc "Run migration, and generated SQL" if t == :with_sql
desc "Generate migration SQL" if t == :to_sql
@aisipos
aisipos / gilded_rose.py
Created April 15, 2020 21:30
Python example solution Gilded Rose code Kata to http://codingdojo.org/kata/GildedRose/
import logging
import inspect
from dataclasses import dataclass, field
from typing import List, ClassVar
import pytest
logging.basicConfig(level=logging.DEBUG)
logger = logging.getLogger('rose')
@aisipos
aisipos / jitbit.py
Last active August 7, 2021 00:14
My solutions to jitbit's SQL interview questions:http://www.jitbit.com/news/181-jitbits-sql-interview-questions/Uses SQLAlchemy to populate a sqlite DB with random data to try out the queries with.
"""
A module to populate a DB schema using sqlalchemy for the problems on this webpage:
http://www.jitbit.com/news/181-jitbits-sql-interview-questions/
Questions and my answers:
-- List employees (names) who have a bigger salary than their boss
select e.name from Employees as e
join Employees as b on e.BossId = b.EmployeeID
where e.Salary > b.Salary
@aisipos
aisipos / ihttp.py
Created October 9, 2012 02:43
Small "interactive" HTTP server, starting a Python debugger for each received HTTP request
"""
An interactive HTTP server, starting a python debugger on each http request.
Set the value of "hr" to what you want the HTTP response to be,
and then type "c" to continue
Requires ipdb and bottle
"""
from bottle import *
import ipdb
@route('/favicon.ico')
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aisipos
aisipos / jsonp-in-flask.py
Created July 20, 2011 01:20 — forked from farazdagi/jsonp-in-flask.py
JSONP in Flask
import json
from functools import wraps
from flask import redirect, request, current_app
def support_jsonp(f):
"""Wraps JSONified output for JSONP"""
@wraps(f)
def decorated_function(*args, **kwargs):
callback = request.args.get('callback', False)
if callback: