lucasnad27

<snippet>
	<content><![CDATA[
CREATE TABLE GCWGS84_VECTOR.${1:FeatureClassName}
(
    ${1:FeatureClassName}IDPK NVARCHAR2(20),
    SDSID NVARCHAR2(20),
    SDSFEATURENAME NVARCHAR2(80),
    SDSFEATUREDESCRIPTION NCLOB,
    SDSMETADATAID NVARCHAR2(80),
	MEDIAIDFK NVARCHAR2(20),

lucasnad27

import urllib2
import urllib

base_url = 'http://lucasnad27.cartodb.com/api/v2/sql'
api_key = 'none of your business'
delete_sql = urllib.quote('delete from CONNECTORS')
insert_sql = urllib.quote('Insert into connectors (the_geom,person_id) select ST_MakeLine(points), c.person_id from (select n.the_geom as points, n.person_id from nodes as n order by start_date) c group by c.person_id')

req = urllib2.Request('%s/?q=%s&api_key=%s' % (base_url, delete_sql, api_key))
response = urllib2.urlopen(req)

lucasnad27

import urllib2
import urllib

base_url = 'http://lucasnad27.cartodb.com/api/v2/sql'
api_key = 'none of your business'
delete_sql = urllib.quote('delete from CONNECTORS')
insert_sql = urllib.quote('Insert into connectors (the_geom,person_id) select ST_MakeLine(points), c.person_id from (select n.the_geom as points, n.person_id from nodes as n order by start_date) c group by c.person_id')

req = urllib2.Request('%s/?q=%s&api_key=%s' % (base_url, delete_sql, api_key))
response = urllib2.urlopen(req)

lucasnad27

RPAT.module('Inlets', function(Inlets, App, Backbone, Marionette, $, _) {

    // Inlet Model
    // -----------

    Inlets.Inlet = Backbone.Model.extend({

        idAttribute: "OBJECTID",

        defaults: {

lucasnad27

Transforming Code into Beautiful, Idiomatic Python

Notes from Raymond Hettinger's talk at pycon US 2013 video, slides and pycon US 2015 video

The code examples and direct quotes are all from Raymond's talk. I've reproduced them here for my own edification and the hopes that others will find them as handy as I have!

Looping over a range of numbers

for i in [0, 1, 2, 3, 4, 5]:

lucasnad27

{
    "build_systems":
    [
        {
            "file_regex": "^[ ]*File \"(...*?)\", line ([0-9]*)",
            "name": "Anaconda Python Builder",
            "selector": "source.python",
            "shell_cmd": "\"/Users/luke/.pyenv/versions/kris-kringle/bin/python\" -u \"$file\""
        }
    ],

lucasnad27

import csv
from pathlib import Path


def get_headers():
    # total hack
    with open('File1.txt') as f:
        headers = []
        for line in f:
            if ':' not in line:

lucasnad27

from enum import Enum

import rq
from redis import Redis

import settings

class Priority(Enum):
    low = 'low'
    default = 'default'

lucasnad27

;; -*- mode: emacs-lisp -*-
;; This file is loaded by Spacemacs at startup.
;; It must be stored in your home directory.
(defun dotspacemacs/layers ()
  "Configuration Layers declaration.
You should not put any user code in this function besides modifying the variable
values."
  (setq-default
   ;; Base distribution to use. This is a layer contained in the directory
   ;; `+distribution'. For now available distributions are `spacemacs-base'

lucasnad27

{
    "vspacecode.bindingOverrides": [
        {
            "keys": "d",
            "name": "Docker...",
            "type": "bindings",
            "bindings": [
                {
                    "key": "c",
                    "name": "Containers",