Skip to content

Instantly share code, notes, and snippets.

@litch

litch/job_spec.rb

Created January 8, 2013 06:09
Show Gist options
  • Save litch/4481632 to your computer and use it in GitHub Desktop.
Save litch/4481632 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
job_spec.rb
it "can have the dig test requirement overridden" do
job = create :job
job.approve
sign_in(:dispatcher)
visit edit_job_path(job)
find(:css, "#job_no_dig_test_needed").set(true) #selenium test errors on this line - it can't find the selector but in reality it didn't find the job
click_button "Update"
visit job_path(job)
expect(page).to have_content "Activate"
end
Raw
output_no_selenium.log
Connecting to database specified by database.yml
(0.1ms) BEGIN
(0.2ms) SAVEPOINT active_record_1
Customer Exists (0.7ms) SELECT 1 AS one FROM "customers" WHERE "customers"."name" = 'Baumbach-Hoeger' LIMIT 1
Customer Exists (0.2ms) SELECT 1 AS one FROM "customers" WHERE "customers"."prefix" = 'BAUMBACH' LIMIT 1
Employee Exists (0.3ms) SELECT 1 AS one FROM "employees" WHERE "employees"."employee_id" = 'DRH-EMP-1' LIMIT 1
Customer Exists (0.2ms) SELECT 1 AS one FROM "customers" WHERE "customers"."name" = 'Baumbach-Hoeger' LIMIT 1
Customer Exists (0.2ms) SELECT 1 AS one FROM "customers" WHERE "customers"."prefix" = 'BAUMBACH' LIMIT 1
SQL (1.2ms) INSERT INTO "customers" ("created_at", "description", "name", "prefix", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["description", "Enhanced dedicated attitude"], ["name", "Baumbach-Hoeger"], ["prefix", "BAUMBACH"], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00]]
Employee Exists (0.2ms) SELECT 1 AS one FROM "employees" WHERE "employees"."employee_id" = 'DRH-EMP-1' LIMIT 1
SQL (0.9ms) INSERT INTO "employees" ("active", "auto", "check_1099", "child_support", "comdata_card_num", "company_phone_serial", "created_at", "date_1099", "drh_fuel_system_num", "employee_id", "first_name", "fuel_man_card_num", "hire_date", "hourly_rate", "ins", "last_name", "loan_amount", "loan_payback", "title", "updated_at", "user_id", "work_truck_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22) RETURNING "id" [["active", true], ["auto", nil], ["check_1099", nil], ["child_support", nil], ["comdata_card_num", nil], ["company_phone_serial", "MyString"], ["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["date_1099", nil], ["drh_fuel_system_num", nil], ["employee_id", "DRH-EMP-1"], ["first_name", "Yasmin"], ["fuel_man_card_num", nil], ["hire_date", Thu, 13 Dec 2012 11:55:06 CST -06:00], ["hourly_rate", nil], ["ins", nil], ["last_name", "Huel"], ["loan_amount", nil], ["loan_payback", nil], ["title", "Title"], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["user_id", nil], ["work_truck_id", 1]]
SQL (0.9ms) INSERT INTO "job_sites" ("created_at", "hwy_access_lat", "hwy_access_lng", "lat", "lng", "nearest_hwy", "ranch_name", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["hwy_access_lat", #<BigDecimal:7fe1f8034be8,'0.999E1',18(18)>], ["hwy_access_lng", #<BigDecimal:7fe1f8034ad0,'0.999E1',18(18)>], ["lat", #<BigDecimal:7fe1f8034ee0,'0.999E1',18(18)>], ["lng", #<BigDecimal:7fe1f8034d78,'0.999E1',18(18)>], ["nearest_hwy", "nisi"], ["ranch_name", "quia"], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00]]
(0.4ms) SELECT COUNT(*) FROM "dig_tests" WHERE "dig_tests"."job_site_id" = 3354
SQL (0.9ms) INSERT INTO "dig_tests" ("created_at", "job_site_id", "updated_at", "valid_from_date", "valid_to_date") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["job_site_id", 3354], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["valid_from_date", nil], ["valid_to_date", nil]]
(0.5ms) SELECT COUNT(*) FROM "jobs" WHERE "jobs"."customer_id" = 4136
SQL (0.8ms) INSERT INTO "jobs" ("created_at", "customer_contact", "customer_id", "description", "end_date", "job_number", "job_site_id", "location_requested", "name", "no_dig_test_needed", "one_call_valid_until_date", "projected_end_date", "start_date", "state", "supervisor_id", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["customer_contact", nil], ["customer_id", 4136], ["description", "nulla"], ["end_date", nil], ["job_number", "BAUMBACH-1"], ["job_site_id", 3354], ["location_requested", nil], ["name", "quibusdam"], ["no_dig_test_needed", false], ["one_call_valid_until_date", nil], ["projected_end_date", nil], ["start_date", nil], ["state", "requested"], ["supervisor_id", 7042], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00]]
(0.1ms) RELEASE SAVEPOINT active_record_1
(0.0ms) SAVEPOINT active_record_1
Customer Exists (0.4ms) SELECT 1 AS one FROM "customers" WHERE ("customers"."name" = 'Baumbach-Hoeger' AND "customers"."id" != 4136) LIMIT 1
Customer Exists (0.2ms) SELECT 1 AS one FROM "customers" WHERE ("customers"."prefix" = 'BAUMBACH' AND "customers"."id" != 4136) LIMIT 1
Employee Exists (0.3ms) SELECT 1 AS one FROM "employees" WHERE ("employees"."employee_id" = 'DRH-EMP-1' AND "employees"."id" != 7042) LIMIT 1
(0.4ms) UPDATE "jobs" SET "state" = 'awarded', "updated_at" = '2013-01-08 06:08:51.260209' WHERE "jobs"."id" = 3214
(0.1ms) RELEASE SAVEPOINT active_record_1
(0.1ms) SAVEPOINT active_record_1
User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'romaine_schaefer@wuckert.com' LIMIT 1
SQL (0.9ms) INSERT INTO "users" ("confirmation_sent_at", "confirmation_token", "confirmed_at", "created_at", "current_sign_in_at", "current_sign_in_ip", "email", "encrypted_password", "invitation_accepted_at", "invitation_limit", "invitation_sent_at", "invitation_token", "invited_by_id", "invited_by_type", "last_sign_in_at", "last_sign_in_ip", "name", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "unconfirmed_email", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23) RETURNING "id" [["confirmation_sent_at", nil], ["confirmation_token", nil], ["confirmed_at", Tue, 08 Jan 2013 00:08:50 CST -06:00], ["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["current_sign_in_at", nil], ["current_sign_in_ip", nil], ["email", "romaine_schaefer@wuckert.com"], ["encrypted_password", "$2a$04$C0gnwO.i9JMlCv.jSgiqCOr4DrZ28Rf0xiIPrC8b5rctaKA8GodPm"], ["invitation_accepted_at", nil], ["invitation_limit", nil], ["invitation_sent_at", nil], ["invitation_token", nil], ["invited_by_id", nil], ["invited_by_type", nil], ["last_sign_in_at", nil], ["last_sign_in_ip", nil], ["name", "Elias Kuhlman"], ["remember_created_at", nil], ["reset_password_sent_at", nil], ["reset_password_token", nil], ["sign_in_count", 0], ["unconfirmed_email", nil], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00]]
SQL (0.9ms) INSERT INTO "feeds" ("created_at", "feed_ownable_id", "feed_ownable_type", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["feed_ownable_id", 10122], ["feed_ownable_type", "User"], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00]]
Feed Load (0.4ms) SELECT "feeds".* FROM "feeds" WHERE "feeds"."feed_ownable_id" = 10122 AND "feeds"."feed_ownable_type" = 'User' LIMIT 1
(0.1ms) RELEASE SAVEPOINT active_record_1
Role Load (0.5ms) SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'dispatcher' AND "roles"."resource_type" IS NULL AND "roles"."resource_id" IS NULL LIMIT 1
(0.1ms) SAVEPOINT active_record_1
SQL (0.9ms) INSERT INTO "roles" ("created_at", "name", "resource_id", "resource_type", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:08:51 CST -06:00], ["name", "dispatcher"], ["resource_id", nil], ["resource_type", nil], ["updated_at", Tue, 08 Jan 2013 00:08:51 CST -06:00]]
(0.1ms) RELEASE SAVEPOINT active_record_1
Role Exists (0.4ms) SELECT 1 AS one FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122 AND "roles"."id" = 8287 LIMIT 1
(0.3ms) SELECT "roles".id FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122
Role Load (0.2ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" = $1 LIMIT 1 [["id", 8287]]
Role Load (0.3ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122
(0.1ms) SAVEPOINT active_record_1
(0.3ms) INSERT INTO "users_roles" ("user_id", "role_id") VALUES (10122, 8287)
(0.1ms) RELEASE SAVEPOINT active_record_1
Started GET "/login" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
Processing by Devise::SessionsController#new as HTML
Tenant Load (0.3ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Rendered devise/shared/_links.html.haml (1.8ms)
Rendered devise/sessions/new.html.haml within layouts/application (24.9ms)
Rendered layouts/_navigation.html.haml (5.5ms)
Rendered layouts/_messages.html.haml (1.0ms)
Completed 200 OK in 100ms (Views: 94.7ms | ActiveRecord: 2.5ms)
Started POST "/users/sign_in" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
Processing by Devise::SessionsController#create as HTML
Parameters: {"utf8"=>"✓", "user"=>{"email"=>"romaine_schaefer@wuckert.com", "password"=>"[FILTERED]", "remember_me"=>"0"}, "commit"=>"Sign in"}
User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."email" = 'romaine_schaefer@wuckert.com' LIMIT 1
(0.1ms) SAVEPOINT active_record_1
(0.3ms) UPDATE "users" SET "last_sign_in_at" = '2013-01-08 06:08:51.746990', "current_sign_in_at" = '2013-01-08 06:08:51.746990', "last_sign_in_ip" = '127.0.0.1', "current_sign_in_ip" = '127.0.0.1', "sign_in_count" = 1, "updated_at" = '2013-01-08 06:08:51.748263' WHERE "users"."id" = 10122
(0.1ms) RELEASE SAVEPOINT active_record_1
Tenant Load (0.2ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Redirected to http://www.example.com/
Completed 302 Found in 14ms (ActiveRecord: 0.0ms)
Started GET "/" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10122 LIMIT 1
Processing by HomeController#index as HTML
Tenant Load (0.3ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Feed Load (0.3ms) SELECT "feeds".* FROM "feeds" WHERE "feeds"."feed_ownable_id" = 10122 AND "feeds"."feed_ownable_type" = 'User' LIMIT 1
FeedItem Load (0.6ms) SELECT "feed_items".* FROM "feed_items" WHERE "feed_items"."feed_id" = 10083 ORDER BY created_at desc LIMIT 50
Rendered home/_feed.html.haml (1.8ms)
Rendered home/index.html.haml within layouts/application (4.4ms)
(0.4ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
Rendered layouts/_navigation.html.haml (3.9ms)
Rendered layouts/_messages.html.haml (0.2ms)
Completed 200 OK in 22ms (Views: 11.8ms | ActiveRecord: 3.7ms)
Started GET "/jobs/3214/edit" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
Processing by JobsController#edit as HTML
Parameters: {"id"=>"3214"}
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10122 LIMIT 1
Tenant Load (0.2ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Job Load (0.5ms) SELECT "jobs".* FROM "jobs" WHERE "jobs"."id" = $1 LIMIT 1 [["id", "3214"]]
Role Load (0.3ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122
Customer Load (0.3ms) SELECT name, id FROM "customers"
Employee Load (0.5ms) SELECT "employees".* FROM "employees" WHERE "employees"."title" = 'Supervisor'
JobSite Load (0.4ms) SELECT "job_sites".* FROM "job_sites" WHERE "job_sites"."id" = 3354 LIMIT 1
DigTest Load (0.3ms) SELECT "dig_tests".* FROM "dig_tests" WHERE "dig_tests"."job_site_id" = 3354
Rendered dig_tests/_dig_test.html.haml (1.8ms)
Rendered job_sites/_job_site.html.haml (8.6ms)
Rendered jobs/_form.html.haml (37.7ms)
Rendered jobs/edit.html.haml within layouts/application (39.0ms)
(0.4ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
Rendered layouts/_navigation.html.haml (3.3ms)
Rendered layouts/_messages.html.haml (0.1ms)
Completed 200 OK in 57ms (Views: 44.2ms | ActiveRecord: 3.3ms)
Started PUT "/jobs/3214" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
Processing by JobsController#update as HTML
Parameters: {"utf8"=>"✓", "job"=>{"name"=>"quibusdam", "customer_id"=>"4136", "description"=>"nulla", "supervisor_id"=>"", "start_date"=>"", "projected_end_date"=>"", "no_dig_test_needed"=>"1", "job_site_name_token"=>""}, "commit"=>"Update", "id"=>"3214"}
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10122 LIMIT 1
Tenant Load (0.2ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Job Load (0.3ms) SELECT "jobs".* FROM "jobs" WHERE "jobs"."id" = $1 LIMIT 1 [["id", "3214"]]
Role Load (0.4ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122
JobSite Load (0.2ms) SELECT "job_sites".* FROM "job_sites" WHERE "job_sites"."id" = 0 LIMIT 1
(0.1ms) SAVEPOINT active_record_1
Customer Load (0.3ms) SELECT "customers".* FROM "customers" WHERE "customers"."id" = 4136 LIMIT 1
Customer Exists (0.3ms) SELECT 1 AS one FROM "customers" WHERE ("customers"."name" = 'Baumbach-Hoeger' AND "customers"."id" != 4136) LIMIT 1
Customer Exists (0.3ms) SELECT 1 AS one FROM "customers" WHERE ("customers"."prefix" = 'BAUMBACH' AND "customers"."id" != 4136) LIMIT 1
(0.3ms) UPDATE "jobs" SET "job_site_id" = NULL, "supervisor_id" = NULL, "no_dig_test_needed" = 't', "updated_at" = '2013-01-08 06:08:51.872177' WHERE "jobs"."id" = 3214
(0.1ms) RELEASE SAVEPOINT active_record_1
Redirected to http://www.example.com/jobs/3214
Completed 302 Found in 19ms (ActiveRecord: 2.9ms)
Started GET "/jobs/3214" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
Processing by JobsController#show as HTML
Parameters: {"id"=>"3214"}
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10122 LIMIT 1
Tenant Load (0.2ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Job Load (0.3ms) SELECT "jobs".* FROM "jobs" WHERE "jobs"."id" = $1 LIMIT 1 [["id", "3214"]]
Role Load (0.4ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122
Customer Load (0.3ms) SELECT "customers".* FROM "customers" WHERE "customers"."id" = 4136 LIMIT 1
(0.5ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."commentable_id" = 3214 AND "comments"."commentable_type" = 'Job'
Timesheet Load (0.5ms) SELECT "timesheets".* FROM "timesheets" WHERE "timesheets"."job_id" = 3214 ORDER BY start_time desc
Rendered jobs/show.html.haml within layouts/application (76.3ms)
(0.4ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
Rendered layouts/_navigation.html.haml (3.4ms)
Rendered layouts/_messages.html.haml (0.1ms)
Completed 200 OK in 93ms (Views: 76.3ms | ActiveRecord: 7.6ms)
Started GET "/jobs/3214" for 127.0.0.1 at 2013-01-08 00:08:51 -0600
Processing by JobsController#show as HTML
Parameters: {"id"=>"3214"}
User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10122 LIMIT 1
Tenant Load (0.1ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = 'www' LIMIT 1
Job Load (0.3ms) SELECT "jobs".* FROM "jobs" WHERE "jobs"."id" = $1 LIMIT 1 [["id", "3214"]]
Role Load (0.3ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122
Customer Load (0.3ms) SELECT "customers".* FROM "customers" WHERE "customers"."id" = 4136 LIMIT 1
(0.3ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."commentable_id" = 3214 AND "comments"."commentable_type" = 'Job'
Timesheet Load (0.3ms) SELECT "timesheets".* FROM "timesheets" WHERE "timesheets"."job_id" = 3214 ORDER BY start_time desc
Rendered jobs/show.html.haml within layouts/application (9.0ms)
(0.4ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10122 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
Rendered layouts/_navigation.html.haml (3.5ms)
Rendered layouts/_messages.html.haml (0.1ms)
Completed 200 OK in 25ms (Views: 13.6ms | ActiveRecord: 2.4ms)
Tenant Load (0.3ms) SELECT "tenants".* FROM "tenants"
(0.2ms) ROLLBACK
Raw
output_selenium.log
Connecting to database specified by database.yml
(0.2ms) BEGIN
(0.2ms) SAVEPOINT active_record_1
Customer Exists (0.7ms) SELECT 1 AS one FROM "customers" WHERE "customers"."name" = 'Weimann Group' LIMIT 1
Customer Exists (0.3ms) SELECT 1 AS one FROM "customers" WHERE "customers"."prefix" = 'WEIMANN ' LIMIT 1
Employee Exists (0.3ms) SELECT 1 AS one FROM "employees" WHERE "employees"."employee_id" = 'DRH-EMP-1' LIMIT 1
Customer Exists (0.2ms) SELECT 1 AS one FROM "customers" WHERE "customers"."name" = 'Weimann Group' LIMIT 1
Customer Exists (0.2ms) SELECT 1 AS one FROM "customers" WHERE "customers"."prefix" = 'WEIMANN ' LIMIT 1
SQL (1.2ms) INSERT INTO "customers" ("created_at", "description", "name", "prefix", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["description", "Integrated value-added extranet"], ["name", "Weimann Group"], ["prefix", "WEIMANN "], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00]]
Employee Exists (0.3ms) SELECT 1 AS one FROM "employees" WHERE "employees"."employee_id" = 'DRH-EMP-1' LIMIT 1
SQL (0.8ms) INSERT INTO "employees" ("active", "auto", "check_1099", "child_support", "comdata_card_num", "company_phone_serial", "created_at", "date_1099", "drh_fuel_system_num", "employee_id", "first_name", "fuel_man_card_num", "hire_date", "hourly_rate", "ins", "last_name", "loan_amount", "loan_payback", "title", "updated_at", "user_id", "work_truck_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22) RETURNING "id" [["active", true], ["auto", nil], ["check_1099", nil], ["child_support", nil], ["comdata_card_num", nil], ["company_phone_serial", "MyString"], ["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["date_1099", nil], ["drh_fuel_system_num", nil], ["employee_id", "DRH-EMP-1"], ["first_name", "Bridget"], ["fuel_man_card_num", nil], ["hire_date", Thu, 13 Dec 2012 11:55:06 CST -06:00], ["hourly_rate", nil], ["ins", nil], ["last_name", "Crona"], ["loan_amount", nil], ["loan_payback", nil], ["title", "Title"], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["user_id", nil], ["work_truck_id", 1]]
SQL (0.9ms) INSERT INTO "job_sites" ("created_at", "hwy_access_lat", "hwy_access_lng", "lat", "lng", "nearest_hwy", "ranch_name", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["hwy_access_lat", #<BigDecimal:7fce86768228,'0.999E1',18(18)>], ["hwy_access_lng", #<BigDecimal:7fce86768138,'0.999E1',18(18)>], ["lat", #<BigDecimal:7fce867685c0,'0.999E1',18(18)>], ["lng", #<BigDecimal:7fce86768430,'0.999E1',18(18)>], ["nearest_hwy", "accusantium"], ["ranch_name", "sed"], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00]]
(0.4ms) SELECT COUNT(*) FROM "dig_tests" WHERE "dig_tests"."job_site_id" = 3353
SQL (0.9ms) INSERT INTO "dig_tests" ("created_at", "job_site_id", "updated_at", "valid_from_date", "valid_to_date") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["job_site_id", 3353], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["valid_from_date", nil], ["valid_to_date", nil]]
(0.5ms) SELECT COUNT(*) FROM "jobs" WHERE "jobs"."customer_id" = 4135
SQL (0.9ms) INSERT INTO "jobs" ("created_at", "customer_contact", "customer_id", "description", "end_date", "job_number", "job_site_id", "location_requested", "name", "no_dig_test_needed", "one_call_valid_until_date", "projected_end_date", "start_date", "state", "supervisor_id", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["customer_contact", nil], ["customer_id", 4135], ["description", "animi"], ["end_date", nil], ["job_number", "WEIMANN -1"], ["job_site_id", 3353], ["location_requested", nil], ["name", "ipsam"], ["no_dig_test_needed", false], ["one_call_valid_until_date", nil], ["projected_end_date", nil], ["start_date", nil], ["state", "requested"], ["supervisor_id", 7041], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00]]
(0.1ms) RELEASE SAVEPOINT active_record_1
(0.1ms) SAVEPOINT active_record_1
Customer Exists (0.5ms) SELECT 1 AS one FROM "customers" WHERE ("customers"."name" = 'Weimann Group' AND "customers"."id" != 4135) LIMIT 1
Customer Exists (0.3ms) SELECT 1 AS one FROM "customers" WHERE ("customers"."prefix" = 'WEIMANN ' AND "customers"."id" != 4135) LIMIT 1
Employee Exists (0.4ms) SELECT 1 AS one FROM "employees" WHERE ("employees"."employee_id" = 'DRH-EMP-1' AND "employees"."id" != 7041) LIMIT 1
(0.4ms) UPDATE "jobs" SET "state" = 'awarded', "updated_at" = '2013-01-08 06:05:41.233102' WHERE "jobs"."id" = 3213
(0.1ms) RELEASE SAVEPOINT active_record_1
(0.2ms) SAVEPOINT active_record_1
User Exists (0.5ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'sidney_gutmann@bernier.info' LIMIT 1
SQL (1.1ms) INSERT INTO "users" ("confirmation_sent_at", "confirmation_token", "confirmed_at", "created_at", "current_sign_in_at", "current_sign_in_ip", "email", "encrypted_password", "invitation_accepted_at", "invitation_limit", "invitation_sent_at", "invitation_token", "invited_by_id", "invited_by_type", "last_sign_in_at", "last_sign_in_ip", "name", "remember_created_at", "reset_password_sent_at", "reset_password_token", "sign_in_count", "unconfirmed_email", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23) RETURNING "id" [["confirmation_sent_at", nil], ["confirmation_token", nil], ["confirmed_at", Tue, 08 Jan 2013 00:05:40 CST -06:00], ["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["current_sign_in_at", nil], ["current_sign_in_ip", nil], ["email", "sidney_gutmann@bernier.info"], ["encrypted_password", "$2a$04$zPa1O.0Y6br2hUj.h/0Wn.1CXCLDNO6iCY/gvohV86wgEGH8JkS6m"], ["invitation_accepted_at", nil], ["invitation_limit", nil], ["invitation_sent_at", nil], ["invitation_token", nil], ["invited_by_id", nil], ["invited_by_type", nil], ["last_sign_in_at", nil], ["last_sign_in_ip", nil], ["name", "Zelma Hayes DVM"], ["remember_created_at", nil], ["reset_password_sent_at", nil], ["reset_password_token", nil], ["sign_in_count", 0], ["unconfirmed_email", nil], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00]]
SQL (1.0ms) INSERT INTO "feeds" ("created_at", "feed_ownable_id", "feed_ownable_type", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["feed_ownable_id", 10121], ["feed_ownable_type", "User"], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00]]
Feed Load (0.3ms) SELECT "feeds".* FROM "feeds" WHERE "feeds"."feed_ownable_id" = 10121 AND "feeds"."feed_ownable_type" = 'User' LIMIT 1
(0.1ms) RELEASE SAVEPOINT active_record_1
Role Load (0.5ms) SELECT "roles".* FROM "roles" WHERE "roles"."name" = 'dispatcher' AND "roles"."resource_type" IS NULL AND "roles"."resource_id" IS NULL LIMIT 1
(0.2ms) SAVEPOINT active_record_1
SQL (1.1ms) INSERT INTO "roles" ("created_at", "name", "resource_id", "resource_type", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["created_at", Tue, 08 Jan 2013 00:05:41 CST -06:00], ["name", "dispatcher"], ["resource_id", nil], ["resource_type", nil], ["updated_at", Tue, 08 Jan 2013 00:05:41 CST -06:00]]
(0.1ms) RELEASE SAVEPOINT active_record_1
Role Exists (0.3ms) SELECT 1 AS one FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10121 AND "roles"."id" = 8286 LIMIT 1
(0.2ms) SELECT "roles".id FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10121
Role Load (0.4ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" = $1 LIMIT 1 [["id", 8286]]
Role Load (0.3ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 10121
(0.1ms) SAVEPOINT active_record_1
(0.3ms) INSERT INTO "users_roles" ("user_id", "role_id") VALUES (10121, 8286)
(0.1ms) RELEASE SAVEPOINT active_record_1
Started GET "/login" for 127.0.0.1 at 2013-01-08 00:05:45 -0600
Processing by Devise::SessionsController#new as HTML
Tenant Load (0.5ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = '' LIMIT 1
Rendered devise/shared/_links.html.haml (2.5ms)
Rendered devise/sessions/new.html.haml within layouts/application (26.0ms)
Rendered layouts/_navigation.html.haml (52.2ms)
Rendered layouts/_messages.html.haml (1.0ms)
Completed 200 OK in 116ms (Views: 105.7ms | ActiveRecord: 5.8ms)
Started GET "/assets/application.css" for 127.0.0.1 at 2013-01-08 00:05:45 -0600
Warning. Error encountered while saving cache /Users/litch/code/project-oilfield/tmp/cache/sass/e2a30b29f1e28e63b9b6e9f4f2d0dafc677c3308/_modular-scale.sassc: can't dump anonymous class #<Class:0x007fce8b9aa310>
Compiled foundation_and_overrides.css (1915ms) (pid 14010)
Compiled foundation-icons.css (5ms) (pid 14010)
Compiled jquery.ui.core.css (1ms) (pid 14010)
Compiled jquery.ui.theme.css (8ms) (pid 14010)
Compiled jquery.ui.accordion.css (24ms) (pid 14010)
Compiled jquery.ui.autocomplete.css (5ms) (pid 14010)
Compiled jquery.ui.button.css (5ms) (pid 14010)
Compiled jquery.ui.datepicker.css (5ms) (pid 14010)
Compiled jquery.ui.dialog.css (4ms) (pid 14010)
Compiled jquery.ui.progressbar.css (4ms) (pid 14010)
Compiled jquery.ui.resizable.css (4ms) (pid 14010)
Compiled jquery.ui.selectable.css (4ms) (pid 14010)
Compiled jquery.ui.slider.css (4ms) (pid 14010)
Compiled jquery.ui.tabs.css (4ms) (pid 14010)
Compiled jquery.ui.base.css (194ms) (pid 14010)
Compiled jquery.ui.all.css (208ms) (pid 14010)
Compiled comments.css (2ms) (pid 14010)
Compiled employees.css (1ms) (pid 14010)
Compiled equipment_items.css (1ms) (pid 14010)
Compiled equipment_types.css (1ms) (pid 14010)
Compiled fuelings.css (1ms) (pid 14010)
Compiled gmaps4rails.css (0ms) (pid 14010)
Compiled home.css (1ms) (pid 14010)
Compiled jobs.css (1ms) (pid 14010)
Compiled scaffolds.css (1ms) (pid 14010)
Compiled token-input.css (0ms) (pid 14010)
Compiled vendor_categories.css (1ms) (pid 14010)
Compiled vendors.css (1ms) (pid 14010)
Compiled application.css (2391ms) (pid 14010)
Served asset /application.css - 200 OK (2422ms)
Started GET "/assets/application.js" for 127.0.0.1 at 2013-01-08 00:05:48 -0600
Compiled gmaps4rails/gmaps4rails.base.js (172ms) (pid 14010)
Compiled gmaps4rails/gmaps4rails.bing.js (25ms) (pid 14010)
Compiled gmaps4rails/gmaps4rails.googlemaps.js (41ms) (pid 14010)
Compiled gmaps4rails/gmaps4rails.mapquest.js (21ms) (pid 14010)
Compiled gmaps4rails/gmaps4rails.openlayers.js (32ms) (pid 14010)
Compiled application.js (333ms) (pid 14010)
Served asset /application.js - 200 OK (602ms)
Started POST "/users/sign_in" for 127.0.0.1 at 2013-01-08 00:05:49 -0600
Processing by Devise::SessionsController#create as HTML
Parameters: {"utf8"=>"✓", "user"=>{"email"=>"sidney_gutmann@bernier.info", "password"=>"[FILTERED]", "remember_me"=>"0"}, "commit"=>"Sign in"}
User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."email" = 'sidney_gutmann@bernier.info' LIMIT 1
Tenant Load (0.2ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = '' LIMIT 1
Completed 401 Unauthorized in 55ms
Processing by Devise::SessionsController#new as HTML
Parameters: {"utf8"=>"✓", "user"=>{"email"=>"sidney_gutmann@bernier.info", "password"=>"[FILTERED]", "remember_me"=>"0"}, "commit"=>"Sign in"}
CACHE (0.0ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = '' LIMIT 1
Rendered devise/shared/_links.html.haml (0.3ms)
Rendered devise/sessions/new.html.haml within layouts/application (5.8ms)
Rendered layouts/_navigation.html.haml (1.2ms)
Rendered layouts/_messages.html.haml (0.1ms)
Completed 200 OK in 12ms (Views: 9.1ms | ActiveRecord: 0.0ms)
Started GET "/jobs/3213/edit" for 127.0.0.1 at 2013-01-08 00:05:49 -0600
Processing by JobsController#edit as HTML
Parameters: {"id"=>"3213"}
Tenant Load (0.3ms) SELECT "tenants".* FROM "tenants" WHERE "tenants"."subdomain" = '' LIMIT 1
Job Load (0.9ms) SELECT "jobs".* FROM "jobs" WHERE "jobs"."id" = $1 LIMIT 1 [["id", "3213"]]
Completed 404 Not Found in 11ms
Tenant Load (0.2ms) SELECT "tenants".* FROM "tenants"
(0.2ms) ROLLBACK
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment