gistfile1.txt

Loading development environment (Rails 3.2.11)
1.9.3-p327 :001 > user = User.find(6)
  User Load (4.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 6]]
 => #<User id: 6, email: "teacher@example.com", encrypted_password: "$2a$10$tCfwHNgdfElvY/7MV49hIev5e3Zj8D7K/dUttQwtQ7gf...", reset_password_token: nil, reset_password_sent_at: nil, remember_created_at: nil, sign_in_count: 121, current_sign_in_at: "2013-01-22 22:34:15", last_sign_in_at: "2013-01-14 21:37:26", current_sign_in_ip: "127.0.0.1", last_sign_in_ip: "204.16.243.194", created_at: "2012-07-18 18:46:44", updated_at: "2013-01-22 22:34:15", role: "teacher", username: nil, first_name: "Seeded", last_name: "Teacher", max_students: nil, nickname: nil, second_language: nil, state_id: nil, invitation_accepted_at: nil, invitation_token: nil, account_sponsor_email: nil, account_sponsor_name: nil, active: true, zip_code: nil, phone_number: nil, street_address: nil, city: nil, ip_address: nil, school_district_provider_id: nil>
1.9.3-p327 :002 > RequestStore.store[:shard_name] = "enrollments_shard_one"
 => "enrollments_shard_one"
1.9.3-p327 :003 > Lesson.first.id
   (0.3ms)  set application_name = 'apangeas_without_pool';
  [enrollments_shard_one]   (0.1ms)  set application_name = 'apangeas_with_pool_1';
  [enrollments_shard_one]  Lesson Load (0.6ms)  SELECT "lessons".* FROM "lessons" LIMIT 1
 => 20
1.9.3-p327 :004 > Pathway.create!(name: 'a', creator: user, grade_level_id: GradeLevel.first.id, state: State.find_by_code('PA'))
  GradeLevel Load (0.6ms)  SELECT "grade_levels".* FROM "grade_levels" LIMIT 1
  State Load (0.6ms)  SELECT "states".* FROM "states" WHERE "states"."code" = 'PA' LIMIT 1
  [enrollments_shard_one]   (0.2ms)  BEGIN
   (0.4ms)  SELECT customer_id FROM "customer_administrations" WHERE "customer_administrations"."user_id" = 6
   (0.7ms)  SELECT customer_id FROM "districts" INNER JOIN "district_administrations" ON "districts"."id" = "district_administrations"."district_id" WHERE "district_administrations"."user_id" = 6
   (1.0ms)  SELECT customer_id FROM "schools" INNER JOIN "school_administrations" ON "schools"."id" = "school_administrations"."school_id" WHERE "school_administrations"."user_id" = 6
   (1.7ms)  SELECT customer_id FROM "schools" INNER JOIN "classrooms" ON "schools"."id" = "classrooms"."school_id" INNER JOIN "classroom_teachings" ON "classrooms"."id" = "classroom_teachings"."classroom_id" WHERE "classroom_teachings"."user_id" = 6
   (0.6ms)  SELECT customer_id FROM "schools" INNER JOIN "school_assignments" ON "schools"."id" = "school_assignments"."school_id" WHERE "school_assignments"."user_id" = 6
   (0.3ms)  SELECT NEXTVAL('pathways_id_seq')
  [enrollments_shard_one]  SQL (0.9ms)  INSERT INTO "pathways" ("allow_test_out", "created_at", "creator_id", "customer_id", "demo", "grade_level_id", "id", "name", "published", "require_pre_quiz", "skip_problem_solving_process", "state_id", "updated_at", "use_placement_test", "use_remediation") VALUES ('t', '2013-01-27 15:07:58.333499', 6, 1, 'f', 1, 45257, 'a', 'f', 'f', 'f', 40, '2013-01-27 15:07:58.333499', 't', 't') RETURNING "id"
  [enrollments_shard_one]   (0.1ms)  COMMIT
 => #<Pathway id: 45257, created_at: "2013-01-27 15:07:58", updated_at: "2013-01-27 15:07:58", name: "a", grade_level_id: 1, state_id: 40, use_placement_test: true, skip_problem_solving_process: false, allow_test_out: true, require_pre_quiz: false, creator_id: 6, customer_id: 1, use_remediation: true, published: false, demo: false>
1.9.3-p327 :005 > RequestStore.store[:shard_name] = "enrollments_shard_two"
 => "enrollments_shard_two"
1.9.3-p327 :006 > Pathway.create!(name: 'a', creator: user, grade_level_id: GradeLevel.first.id, state: State.find_by_code('PA'))
  GradeLevel Load (0.5ms)  SELECT "grade_levels".* FROM "grade_levels" LIMIT 1
  State Load (0.3ms)  SELECT "states".* FROM "states" WHERE "states"."code" = 'PA' LIMIT 1
  [enrollments_shard_one]   (0.2ms)  BEGIN
   (0.3ms)  SELECT customer_id FROM "customer_administrations" WHERE "customer_administrations"."user_id" = 6
   (0.5ms)  SELECT customer_id FROM "districts" INNER JOIN "district_administrations" ON "districts"."id" = "district_administrations"."district_id" WHERE "district_administrations"."user_id" = 6
   (0.5ms)  SELECT customer_id FROM "schools" INNER JOIN "school_administrations" ON "schools"."id" = "school_administrations"."school_id" WHERE "school_administrations"."user_id" = 6
   (0.9ms)  SELECT customer_id FROM "schools" INNER JOIN "classrooms" ON "schools"."id" = "classrooms"."school_id" INNER JOIN "classroom_teachings" ON "classrooms"."id" = "classroom_teachings"."classroom_id" WHERE "classroom_teachings"."user_id" = 6
   (0.4ms)  SELECT customer_id FROM "schools" INNER JOIN "school_assignments" ON "schools"."id" = "school_assignments"."school_id" WHERE "school_assignments"."user_id" = 6
   (0.2ms)  SELECT NEXTVAL('pathways_id_seq')
  [enrollments_shard_one]  SQL (0.3ms)  INSERT INTO "pathways" ("allow_test_out", "created_at", "creator_id", "customer_id", "demo", "grade_level_id", "id", "name", "published", "require_pre_quiz", "skip_problem_solving_process", "state_id", "updated_at", "use_placement_test", "use_remediation") VALUES ('t', '2013-01-27 15:08:05.743433', 6, 1, 'f', 1, 45258, 'a', 'f', 'f', 'f', 40, '2013-01-27 15:08:05.743433', 't', 't') RETURNING "id"
  [enrollments_shard_one]   (0.2ms)  COMMIT
 => #<Pathway id: 45258, created_at: "2013-01-27 15:08:05", updated_at: "2013-01-27 15:08:05", name: "a", grade_level_id: 1, state_id: 40, use_placement_test: true, skip_problem_solving_process: false, allow_test_out: true, require_pre_quiz: false, creator_id: 6, customer_id: 1, use_remediation: true, published: false, demo: false>
1.9.3-p327 :007 >