Ben Menesini sayhiben

## pg_import_csv_to_heroku.sh
# You have your csv data and it looks like so... It's in a file named "my_data.csv" and we want to import it into a table named "my_things".

"1", "Something", "0.50", "2013-05-05 10:00:00"
"2", "Another thing", "1.50", "2013-06-05 10:30:00"

# Now you want to import it, go to the command line and type:

$ PGPASSWORD=PWHERE psql -h HOSTHERE -U USERHERE DBNAMEHERE -c "\copy my_things FROM 'my_data.csv' WITH CSV;"

# Voila! It's impoted. Now if you want to wipe it out and import a fresh one, you would do this:

## good_dog_scraper.py
import csv
import logging
import requests
import time

logging.basicConfig(level=logging.NOTSET)
logger = logging.getLogger(__name__)

# Seconds between requests
RATE_LIMIT = 2
	# You have your csv data and it looks like so... It's in a file named "my_data.csv" and we want to import it into a table named "my_things".

	"1", "Something", "0.50", "2013-05-05 10:00:00"
	"2", "Another thing", "1.50", "2013-06-05 10:30:00"

	# Now you want to import it, go to the command line and type:

	$ PGPASSWORD=PWHERE psql -h HOSTHERE -U USERHERE DBNAMEHERE -c "\copy my_things FROM 'my_data.csv' WITH CSV;"

	# Voila! It's impoted. Now if you want to wipe it out and import a fresh one, you would do this:
	import csv
	import logging
	import requests
	import time

	logging.basicConfig(level=logging.NOTSET)
	logger = logging.getLogger(__name__)

	# Seconds between requests
	RATE_LIMIT = 2