Skip to content

Instantly share code, notes, and snippets.

Avatar

David Inga DaveInga

View GitHub Profile
@DaveInga
DaveInga / gist:a7c68e1403c8ecddcad2
Last active Sep 13, 2015 — forked from rtt/gist:5a2e0cfa638c938cca59
example python tinderbot
View gist:a7c68e1403c8ecddcad2
# encoding: utf8 1,1 Top# encoding: utf8
import argparse
from datetime import datetime
import json
from random import randint
import requests
import sys
from time import sleep
@DaveInga
DaveInga / desired-output.txt
Created Jul 24, 2013
I'm an sql noob, this is my first function... How do I go about creating a function 'fiscal_year' which could create output.txt (below)?
View desired-output.txt
xbrl=# select fiscal_year,cik,company_name from csv_table limit 10;
fiscal_year | cik | company_name
-------------+---------+--------------------------------------
2010 | 1075607 | TC PIPELINES LP
2011 | 1075607 | TC PIPELINES LP
2012 | 1075607 | TC PIPELINES LP
2012 | 1075607 | TC PIPELINES LP
2010 | 1314054 | BMX Development Corp.
2011 | 1423974 | Farrallon, Inc
2011 | 1396536 | INFORMATION SYSTEMS ASSOCIATES, INC.
You can’t perform that action at this time.