Charlie McElfresh charliemcelfresh

## gist:5306706
## where header is the first line, and data is a data line

Hash[header.zip(data.map{|d| d})].map{|k, v| transform_key_value(k, v)}

def transform_key_value(k, v)
  if v == "true"
		[k, true]
	elsif k == "neighborhood" || k == "cuisine" || k == "category_labels"
		[k, v.split(",").map{|e| e.strip}]
	elsif k == "hours"

## gist:6213005
# 1. Use .erb templates to create custom .conf files based on each server’s config

# Config is held inside capistrano deploy files, like
/config/deploy/staging.rb
set :rails_env, "staging"

namespace :nginx do
  # The /etc/init.d/nginx script points to /home/travel/apps/ShortTrips/shared/config/nginx.conf
  # To deploy changes, run:
  #   cap nginx:configure

## last_updated.csv

          
            Option
            pluses
            minuses

            
              new 'tasks' table
              clean
              big refactor

            
              'tasks' tracking-only table
              partial refactor
              messy

            
              'last_updated' table
              simple
              easily queryable?

## tasks.csv

          
            column
            data type

            
              id
              autoincrement

            
              job_id
              integer

            
              task_id
              integer

            
              state
              integer

            
              last_updated
              datetime

## job_tasks.csv

          
            column
            data type

            
              id
              autoincrement

            
              job_id
              integer

            
              task_id
              integer

            
              last_updated
              datetime

## jobs.csv

          
            column
            data type

            
              id
              autoincrement

            
              tasks
              integer[]

## jobs_data.csv

          
            id
            tasks
            comments

            
              1
              {4,3,1,1,0}
              values [id,state] [0,'finished'], [1,'deleted'], [2,'started'], [3,'started'], [4,'created']
	## where header is the first line, and data is a data line

	Hash[header.zip(data.map{\|d\| d})].map{\|k, v\| transform_key_value(k, v)}

	def transform_key_value(k, v)
	if v == "true"
	[k, true]
	elsif k == "neighborhood" \|\| k == "cuisine" \|\| k == "category_labels"
	[k, v.split(",").map{\|e\| e.strip}]
	elsif k == "hours"
	# 1. Use .erb templates to create custom .conf files based on each server’s config

	# Config is held inside capistrano deploy files, like
	/config/deploy/staging.rb
	set :rails_env, "staging"

	namespace :nginx do
	# The /etc/init.d/nginx script points to /home/travel/apps/ShortTrips/shared/config/nginx.conf
	# To deploy changes, run:
	# cap nginx:configure
Option	pluses	minuses
new 'tasks' table	clean	big refactor
'tasks' tracking-only table	partial refactor	messy
'last_updated' table	simple	easily queryable?
	column	data type
	id	autoincrement
	job_id	integer
	task_id	integer
	state	integer
	last_updated	datetime
	id	tasks	comments
	1	{4,3,1,1,0}	values [id,state] [0,'finished'], [1,'deleted'], [2,'started'], [3,'started'], [4,'created']