BenDoyle

{
  "color_scheme": "Packages/Color Scheme - Default/Mac Classic.tmTheme",
	"font_size": 16.0,
	"ignored_packages":
	[
		"Vintage"
	],
	"save_on_focus_lost": true,
	"tab_size": 2,
	"translate_tabs_to_space": true

BenDoyle

require 'json'

raw = JSON.parse(File.read(ARGV[0]))

header = raw[0].keys

def values(header, row)
	header.map{|h|row[h]}
end

BenDoyle

with
p as (
  SELECT 1 as id, 1 as t, 'p' as k, 'x' as v
  UNION ALL
  SELECT 1 as id, 2 as t, 'p' as k, 'y' as v
  UNION ALL
  SELECT 1 as id, 5 as t, 'p' as k, 'z' as v
),
q as (
  SELECT 1 as id, 3 as t, 'q' as k, 'a' as v

BenDoyle

 Dungeon Crawl Stone Soup version 0.17.1-1 (tiles) character file.

482312 Uhijidghi the Black Sun (level 23, -29/169 HPs)
             Began as a Vampire Enchanter on Mar 8, 2016.
             Was a High Priest of Kikubaaqudgha.
             Killed from afar by a frost giant (51 damage)
             ... with a bolt of cold
             ... on level 5 of the Vaults on Mar 28, 2016.
             The game lasted 10:38:41 (109459 turns).

BenDoyle

##### Crawl Init file ###############################################
# For descriptions of all options, as well as some more in-depth information
# on setting them, consult the file
#    options_guide.txt
# in your /docs directory. If you can't find it, the file is also available
# online at:
# https://gitorious.org/crawl/crawl/source/HEAD:crawl-ref/docs/options_guide.txt
#
# Crawl uses the first file of the following list as its option file:
#  * init.txt in the -rcdir directory (if specified)

BenDoyle

SELECT m FROM UNNEST(sequence(0,23)) as t(m)

BenDoyle

-- building residuals join based

with
raw as (
  SELECT 1 as t, 1 as v
  UNION ALL
  SELECT 2 as t, 1 as v
  UNION ALL
  SELECT 3 as t, 1 as v
  UNION ALL

BenDoyle

from functools import reduce
import operator

def flatten(values):
    if not values:
        return values
    return reduce(operator.concat, ([item] if not hasattr(item, '__iter__') else flatten(item) for item in values))

BenDoyle

git log  --pretty=format:%ae --diff-filter=A -- <filename>

BenDoyle

CREATE TABLE conformed_transactions
(
    source TEXT,
    transaction_type TEXT,
    transaction_text TEXT,
    amount TEXT,
    provider_category TEXT,
    transaction_date TEXT
)