bruth

#!/usr/bin/env python

import os
import sys
import json
from cStringIO import StringIO
from django.core import management


def cmp_value(av, bv):

bruth

boot2docker down
boot2docker destroy
curl http://static.dockerfiles.io/boot2docker-v1.2.0-virtualbox-guest-additions-v4.3.14.iso > ~/.boot2docker/boot2docker.iso
boot2docker init
VBoxManage sharedfolder add boot2docker-vm -name home -hostpath /Users
boot2docker up
boot2docker ssh "sudo modprobe vboxsf && sudo mkdir -v -p /Users && sudo mount -v -t vboxsf -o uid=0,gid=0 home /Users"

bruth

// Route based on the URL
$(document).on('click', 'a', function(event) {
    // Path of the target link
    var path = this.pathname;

    // Handle IE quirk
    if (path.charAt(0) !== '/') path = '/' + path;

    // Trim off the root on the path if present
    var root = Backbone.history.root || '/';

bruth

from random import choice
from string import ascii_lowercase, digits
from django.db import transaction
from django.db.models import User


USERNAME_CHARS = ascii_lowercase + digits


@transaction.commit_on_success

bruth

def merge_sorted(*iterables, **kwargs):
    """Returns a generator that merges N sorted iterables.

    An optional `cmp` keyword argument may be supplied to customize the
    comparison between values produced by the iterables.
    """

    compare = kwargs.get('cmp', cmp)
    direction = -1 if kwargs.get('reverse', False) else 1

bruth

Notes

• UNION removes duplicates from the set while UNION ALL does not which makes it much faster
  • Since this technique is being used for data integration, the UNION ALL is the
• The number of columns must be the same for each select statement
  • A trick to fill in columns is to select a constant value such as null or ''

Example

bruth

import string
from random import SystemRandom
from django.db import connections

key_chars = string.ascii_letters
random = SystemRandom()

class adhoc_db(object):
    """Context manager that temporarily adds a database connection.

bruth

joinPath = (paths...) ->
    finalPath = []

    for path in paths
        for tok, i in path.split('/')
            switch tok
                when '.' then continue
                when '..' then finalPath.pop()
                else finalPath.push tok

bruth

object cli {

  case class ArgumentsRequired(args: List[Any]) extends Exception {
    override def getMessage: String = {
      "required arguments: %s".format(this.args.mkString(", "))
    }
  }

  case class UnknownArguments(args: List[Any]) extends Exception {
    override def getMessage: String = {

bruth

DSL

• [DONE] rename using_bind_vars to bind
  • copy query "SELECT ..." bind (1, 2, 3) from "source" to "target"
• copy FOO from SOURCE to TARGET silently fails when no table exists in TARGET (filed chop-dbhi/dataexpress#42)
  • the right way is to add create TABLE_NAME

Questions

• How to lookup a single row?