seejee

seejee@seejee-mbp:~/code/apangea (review)$ git diff
diff --git a/db/enrollments_schema.rb b/db/enrollments_schema.rb
index 8e7447c..8bd8a6a 100644
--- a/db/enrollments_schema.rb
+++ b/db/enrollments_schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended to check this file into your version control system.

-ActiveRecord::Schema.define(:version => 20130211201447) do

seejee

  SELECT
		s.id as session_id,
		s.created_at,
		min(coalesce(s1.created_at, '9999-01-01')) as end_date
	FROM
		student_sessions s
		left outer join student_sessions s1 on s.student_id = s1.student_id
			AND s.created_at < s1.created_at
	GROUP BY
		s.id,

seejee

1. Migrate the db.

2. Copy 'temp_session.dump' from the 'ttm-utilities' S3 bucket.

3. Restore the dump to the master shard: (Ignore any warnings about the zmance user ... nailed it.)

   pg_restore -U -h -p -d -t tmp_session_last_attempt_date temp_session.dump

4. Add an index to the temp table:

seejee

FactoryGirl.define do
  factory :status do
  end
  
  factory :thing do
    association :status, factory: status
  end
end

seejee

class LessonMapBuilder
  def initialize(activities, current)
    @activities = activities
    @current = current
  end
  
  def build
    map = {}
    
    @activities.each do |ea|

seejee

Before putting the Heroku-hosted app in maintenance mode:

• Stop the data warehouse from auto-pooooooooling for new data in the Heroku databases:

    heroku ps:scale etl_job=0 -a ttm-reporting
  

After the AWS-hosted app is up and running:

• Update the five database URL environment variables:

seejee

#!/bin/bash

# These paramters will be required when using the script.
# Scalr will ask for them.
__UPDATE_ALL_PACKAGES__=%updateAllPackages%
SCALR_FARM_NAME=%farm_name%
SCALR_ROLE_NAME=%role_name%
SCALR_INSTANCE_INDEX=%instance_index%
RECONFIGURE=%reconfigure%
RECONFIGURE_OPTS=%reconfigure_opts%

seejee

  onProcess: (job, done, chatExporter = new ChatExporter()) =>
    logger.debug('processing transcript', job.data.id)

    hget = Q.nbind(@redis.hget, @redis)
    hget('chats', job.data.id)
      .then((t) -> @chatExporter.exportTranscript(JSON.parse(t)))
      .then( ->
        logger.debug "Successfully processed transcript:", id
        done()
       )

seejee

Rbx 2.0:

• Full:

  real    18m26.393s
  user	25m39.945s
  sys	1m32.109s
  
  Processing control /Users/seejee/code/reporting/etl/attempt_fact.ctl
  Source: /Users/seejee/code/reporting/etl/attempt_fact.txt
  

seejee

 class FiguresOutTheNextThing
    constructor: (@lesson) ->
      
    doNextThing:
      is @lesson.isntStarted() ->
        navigate("#{@lesson.id}/start")
        return
        
      if @lesson.isFinished() ->
        navigate('/student_dashboard')