Skip to content

Instantly share code, notes, and snippets.

David Inga DaveInga

Block or report user

Report or block DaveInga

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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.