test/dummy/log/test.log in advert_selector-3.0.0 vs test/dummy/log/test.log in advert_selector-3.0.1

- old
+ new

@@ -180774,5 +180774,993 @@ AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]]  (0.0ms) SELECT COUNT(*) FROM "advert_selector_helper_items" AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC LIMIT ? [["banner_id", 814558298], ["LIMIT", 1]] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["LIMIT", 1]]  (0.1ms) rollback transaction + ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) begin transaction + Fixture Delete (0.1ms) DELETE FROM "advert_selector_helper_items" + Fixture Insert (0.1ms) INSERT INTO "advert_selector_helper_items" ("name", "content_for", "content", "position", "created_at", "updated_at", "id", "banner_id") VALUES ('banner_leaderboard', 't', '<img src=''coke_banner''/>', 1, '2018-03-22 14:47:41.359621', '2018-03-22 14:47:41.359621', 929640376, 814558298) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_helper_items" ("name", "content_for", "content", "created_at", "updated_at", "id", "banner_id") VALUES ('request_params_include?', 'f', 'pepsi=true', '2018-03-22 14:47:41.359621', '2018-03-22 14:47:41.359621', 435138789, 394627963) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_helper_items" ("position", "name", "content_for", "content", "created_at", "updated_at", "id", "banner_id") VALUES (2, 'banner_leaderboard', 't', '<img src=''pepsi_banner''/>', '2018-03-22 14:47:41.359621', '2018-03-22 14:47:41.359621', 960656439, 394627963) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_helper_items" ("position", "name", "content_for", "content", "created_at", "updated_at", "id", "banner_id") VALUES (1, 'banner_parade', 't', '<img src=''banner_parade''/>', '2018-03-22 14:47:41.359621', '2018-03-22 14:47:41.359621', 281932184, 207249520) + Fixture Delete (0.1ms) DELETE FROM "advert_selector_banners" + Fixture Insert (0.1ms) INSERT INTO "advert_selector_banners" ("name", "start_time", "end_time", "target_view_count", "running_view_count", "frequency", "fast_mode", "comment", "confirmed", "priority", "created_at", "updated_at", "id", "placement_id") VALUES ('Coke', '2018-03-17 00:00:00', '2018-03-27 00:00:00', 1000, 100, 0, 'f', 'Coke banner', 't', 50, '2018-03-22 14:47:41.361772', '2018-03-22 14:47:41.361772', 814558298, 405688915) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_banners" ("name", "start_time", "end_time", "target_view_count", "frequency", "comment", "fast_mode", "confirmed", "priority", "created_at", "updated_at", "id", "placement_id") VALUES ('Pepsi', '2018-03-22 00:00:00', '2018-04-01 00:00:00', 1000, 0, 'Pepsi banner', 't', 't', 100, '2018-03-22 14:47:41.361772', '2018-03-22 14:47:41.361772', 394627963, 405688915) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_banners" ("name", "start_time", "end_time", "target_view_count", "frequency", "fast_mode", "confirmed", "priority", "created_at", "updated_at", "id", "placement_id") VALUES ('parade_banner', '2018-03-22 00:00:00', '2018-04-01 00:00:00', 1000, 1, 't', 'f', 1000, '2018-03-22 14:47:41.361772', '2018-03-22 14:47:41.361772', 207249520, 718799085) + Fixture Delete (0.0ms) DELETE FROM "advert_selector_placements" + Fixture Insert (0.0ms) INSERT INTO "advert_selector_placements" ("name", "conflicting_placements_array", "created_at", "updated_at", "id") VALUES ('Parade', 'leaderboard,video', '2018-03-22 14:47:41.364270', '2018-03-22 14:47:41.364270', 718799085) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_placements" ("name", "conflicting_placements_array", "created_at", "updated_at", "id") VALUES ('Leaderboard', 'parade', '2018-03-22 14:47:41.364270', '2018-03-22 14:47:41.364270', 405688915) + Fixture Insert (0.0ms) INSERT INTO "advert_selector_placements" ("name", "only_once_per_session", "conflicting_placements_array", "created_at", "updated_at", "id") VALUES ('Video', 't', 'parade', '2018-03-22 14:47:41.364270', '2018-03-22 14:47:41.364270', 1019730477) +  (16.3ms) commit transaction +  (0.0ms) begin transaction +-------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_get_edit +-------------------------------------------------------------- + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +Processing by AdvertSelector::PlacementsController#edit as HTML + Parameters: {"id"=>"405688915"} + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/edit.html.erb within layouts/advert_selector/application + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'leaderboard') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'parade') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/_form.html.erb (21.5ms) + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/edit.html.erb within layouts/advert_selector/application (22.7ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.128616') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 132ms (Views: 127.9ms | ActiveRecord: 0.7ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +--------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_get_index +--------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +Processing by AdvertSelector::PlacementsController#index as HTML + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/index.html.erb within layouts/advert_selector/application + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/index.html.erb within layouts/advert_selector/application (1.7ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.004449') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 7ms (Views: 6.2ms | ActiveRecord: 0.5ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_create_placement +---------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_placements" +Processing by AdvertSelector::PlacementsController#create as HTML + Parameters: {"placement"=>{"name"=>"new placement"}} +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.1ms) INSERT INTO "advert_selector_placements" ("name", "created_at", "updated_at") VALUES (?, ?, ?) [["name", "new placement"], ["created_at", "2018-03-22 10:00:00.003939"], ["updated_at", "2018-03-22 10:00:00.003939"]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Redirected to http://test.host/advert_selector/placements/1019730478 +Completed 302 Found in 2ms (ActiveRecord: 0.2ms) +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_placements" +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_show_placement +-------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +Processing by AdvertSelector::PlacementsController#show as HTML + Parameters: {"id"=>"405688915"} +Redirected to http://test.host/advert_selector/placements/405688915/edit +Completed 302 Found in 0ms (ActiveRecord: 0.0ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_get_new +------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +Processing by AdvertSelector::PlacementsController#new as HTML + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/new.html.erb within layouts/advert_selector/application + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = '') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/_form.html.erb (2.8ms) + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/new.html.erb within layouts/advert_selector/application (3.3ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.005964') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 9ms (Views: 7.8ms | ActiveRecord: 0.6ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_destroy_placement +----------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_placements" +Processing by AdvertSelector::PlacementsController#destroy as HTML + Parameters: {"id"=>"405688915"} + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) DELETE FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? [["id", 405688915]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Redirected to http://test.host/advert_selector/placements +Completed 302 Found in 1ms (ActiveRecord: 0.3ms) +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_placements" +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------------- +AdvertSelector::PlacementsControllerTest: test_should_update_placement +---------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +Processing by AdvertSelector::PlacementsController#update as HTML + Parameters: {"placement"=>{"name"=>"Leaderboard"}, "id"=>"405688915"} + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.1ms) SAVEPOINT active_record_1 +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Redirected to http://test.host/advert_selector/placements/405688915 +Completed 302 Found in 1ms (ActiveRecord: 0.1ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------------- +AdvertSelector::BannerTest: test_running_viewcount_&_add_one_viewcount +---------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 0], ["updated_at", "2018-03-22 10:00:00.000642"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 551], ["updated_at", "2018-03-22 10:00:00.010071"], ["id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------------------------- +AdvertSelector::BannerTest: test_view_count_basics_compare_value_and_per_fast_mode +---------------------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "end_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", "2018-03-21 22:00:00"], ["end_time", "2018-03-26 14:00:00"], ["updated_at", "2018-03-22 10:00:00.000562"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 0], ["updated_at", "2018-03-22 10:00:00.002629"], ["id", 814558298]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------------------------------- +AdvertSelector::BannerTest: test_show_now_basic?_for_default_banners +-------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.000328"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "t"], ["updated_at", "2018-03-22 10:00:00.002170"], ["id", 814558298]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------- +AdvertSelector::BannerTest: test_name_sym +----------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------------------------------------------------- +AdvertSelector::BannerTest: test_running_viewcount_&_add_one_viewcount_reaching_target +-------------------------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "target_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 0], ["target_view_count", 10], ["updated_at", "2018-03-22 10:00:00.000555"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 10], ["updated_at", "2018-03-22 10:00:00.003249"], ["id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------------ +AdvertSelector::BannerTest: test_show_now_basic?_time_usages +------------------------------------------------------------ + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", "2018-03-22 11:00:00.000344"], ["updated_at", "2018-03-22 10:00:00.000759"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "end_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", "2018-03-22 08:00:00.002412"], ["end_time", "2018-03-22 09:00:00.002483"], ["updated_at", "2018-03-22 10:00:00.002895"], ["id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "end_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", nil], ["end_time", "2018-03-22 11:00:00.003834"], ["updated_at", "2018-03-22 10:00:00.004238"], ["id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------------------- +AdvertSelector::BannerTest: test_find_future_&&_find_current_scopes +------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.000094' OR end_time IS NULL) +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.000620' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.000701' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_banners" WHERE (end_time > '2017-03-22 10:00:00.001199' OR end_time IS NULL) +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_banners" WHERE (end_time > '2017-03-22 10:00:00.001566' OR end_time IS NULL) AND (start_time < '2017-03-22 11:00:00.001641' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------- +AdvertSelector::BannerTest: test_HelperItems +-------------------------------------------- + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_helper_items" +  (0.1ms) SAVEPOINT active_record_1 + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND ("advert_selector_helper_items"."position" IS NOT NULL) ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["LIMIT", 1]] + SQL (0.1ms) INSERT INTO "advert_selector_helper_items" ("banner_id", "position", "created_at", "updated_at") VALUES (?, ?, ?, ?) [["banner_id", 814558298], ["position", 2], ["created_at", "2018-03-22 10:00:00.001935"], ["updated_at", "2018-03-22 10:00:00.001935"]] + SQL (0.1ms) UPDATE "advert_selector_helper_items" SET "position" = ("advert_selector_helper_items"."position" + 1), "updated_at" = '2018-03-22 10:00:00.003711' WHERE "advert_selector_helper_items"."banner_id" = ? AND ("advert_selector_helper_items"."position" >= 10) [["banner_id", 814558298]] + SQL (0.1ms) INSERT INTO "advert_selector_helper_items" ("banner_id", "position", "name", "content_for", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["banner_id", 814558298], ["position", 10], ["name", "content_for_invalid"], ["content_for", "t"], ["created_at", "2018-03-22 10:00:00.003395"], ["updated_at", "2018-03-22 10:00:00.003395"]] + SQL (0.1ms) UPDATE "advert_selector_helper_items" SET "position" = ("advert_selector_helper_items"."position" + 1), "updated_at" = '2018-03-22 10:00:00.004830' WHERE "advert_selector_helper_items"."banner_id" = ? AND ("advert_selector_helper_items"."position" >= 1) [["banner_id", 814558298]] + SQL (0.1ms) INSERT INTO "advert_selector_helper_items" ("banner_id", "position", "name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["banner_id", 814558298], ["position", 1], ["name", "some_limit_helper_here"], ["created_at", "2018-03-22 10:00:00.004608"], ["updated_at", "2018-03-22 10:00:00.004608"]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."id" = ? LIMIT ? [["id", 960656440], ["LIMIT", 1]] + SQL (0.0ms) DELETE FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."id" = ? [["id", 960656440]] + SQL (0.1ms) UPDATE "advert_selector_helper_items" SET "position" = ("advert_selector_helper_items"."position" - 1), "updated_at" = '2018-03-22 10:00:00.007946' WHERE "advert_selector_helper_items"."banner_id" = ? AND ("advert_selector_helper_items"."position" > 3) [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_helper_items" + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC LIMIT ? [["banner_id", 814558298], ["LIMIT", 1]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------- +AdvertSelector::BannerTest: test_view_count_per_hour +---------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "end_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", "2018-03-21 22:00:00"], ["end_time", "2018-03-26 14:00:00"], ["updated_at", "2018-03-22 10:00:00.000577"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 0], ["updated_at", "2018-03-22 10:00:00.002521"], ["id", 814558298]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------- +AdvertSelector::BannerTest: test_view_count_daily_tests +------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "end_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", "2018-03-21 22:00:00"], ["end_time", "2018-04-01 00:00:00"], ["updated_at", "2018-03-22 10:00:00.000697"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 0], ["updated_at", "2018-03-22 10:00:00.002572"], ["id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "start_time" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["start_time", "2018-03-22 16:00:00"], ["updated_at", "2018-03-22 17:00:00.001111"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) rollback transaction +  (0.1ms) begin transaction +----------------------------------------------------------------------- +BannerShowsTest: test_banner_frequency,_limit_frequency_within_one_week +----------------------------------------------------------------------- + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000926"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003878"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "frequency" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["frequency", 2], ["updated_at", "2018-03-22 10:00:00.005786"], ["id", 814558298]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.010647' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.010789' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (5.8ms) +Completed 200 OK in 8ms (Views: 7.2ms | ActiveRecord: 0.4ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/" for 127.0.0.1 at 2018-03-25 13:00:00 +0300 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-25 10:00:00.021795' OR end_time IS NULL) AND (start_time < '2018-03-25 11:00:00.021904' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (4.0ms) +Completed 200 OK in 6ms (Views: 5.2ms | ActiveRecord: 0.4ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/" for 127.0.0.1 at 2018-03-25 13:00:00 +0300 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (0.8ms) +Completed 200 OK in 3ms (Views: 2.3ms | ActiveRecord: 0.0ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------------------------------- +BannerShowsTest: test_banner_preview_url_forces_banner_and_displays_information +------------------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000849"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003824"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.007719' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.007819' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (3.6ms) +Completed 200 OK in 6ms (Views: 4.8ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 207249520], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/?advert_selector_force=207249520&advert_selector_force_stamp=1521676800" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Parameters: {"advert_selector_force"=>"207249520", "advert_selector_force_stamp"=>"1521676800"} + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +[AdvertSelector] AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 207249520]] +[AdvertSelector] ForceShowing banner parade_banner in placement Parade +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.018243' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.018349' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (5.3ms) +Completed 200 OK in 7ms (Views: 6.5ms | ActiveRecord: 0.5ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 207249520], ["content_for", "t"], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------------------------------------------- +BannerShowsTest: test_HelperItem_with_raising_error_and_common_error_displays +----------------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000883"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003501"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_helper_items" SET "position" = ("advert_selector_helper_items"."position" + 1), "updated_at" = '2018-03-22 10:00:00.005850' WHERE "advert_selector_helper_items"."banner_id" = ? AND ("advert_selector_helper_items"."position" >= 1) [["banner_id", 814558298]] + SQL (0.1ms) INSERT INTO "advert_selector_helper_items" ("banner_id", "position", "name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["banner_id", 814558298], ["position", 1], ["name", "raise_error"], ["created_at", "2018-03-22 10:00:00.005594"], ["updated_at", "2018-03-22 10:00:00.005594"]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.009217' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.009320' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Error with banner Coke in placement Leaderboard. +2018-03-22T12:00:00+02:00 - http://www.example.com/ - <ActionController::Parameters {"controller"=>"examples", "action"=>"index"} permitted: false> +#<ZeroDivisionError: divided by 0> + +/home/ohu/koodi/own_gems_programs/advert_selector/test/dummy/app/helpers/advert_selector_helper.rb:9:in `/' +/home/ohu/koodi/own_gems_programs/advert_selector/test/dummy/app/helpers/advert_selector_helper.rb:9:in `advert_selector_raise_error' +/home/ohu/koodi/own_gems_programs/advert_selector/app/helpers/advert_selector/application_helper.rb:53:in `block in advert_selector_banner_try' +/home/ohu/.rvm/gems/ruby-2.4.3/gems/activerecord-5.0.6/lib/active_record/relation/delegation.rb:38:in `each' +/home/ohu/.rvm/gems/ruby-2.4.3/gems/activerecord-5.0.6/lib/active_record/relation/delegation.rb:38:in `each' +/home/ohu/koodi/own_gems_programs/advert_selector/app/helpers/advert_selector/application_helper.rb:49:in `advert_selector_banner_try' +/home/ohu/koodi/own_gems_programs/advert_selector/app/helpers/advert_selector/application_helper.rb:20:in `block (2 levels) in advert_selector_initialize' +/home/ohu/.rvm/gems/ruby-2.4.3/gems/activerecord-5.0.6/lib/active_record/relation/delegation.rb:38:in `each' +/home/ohu/.rvm/gems/ruby-2.4.3/gems/activerecord-5.0.6/lib/active_record/relation/delegation.rb:38:in `each' +/home/ohu/koodi/own_gems_programs/advert_selector/app/helpers/advert_selector/application_helper.rb:18:in `block in advert_selector_initialize' +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (3.5ms) +Completed 200 OK in 6ms (Views: 4.8ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/advert_selector/placements" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by AdvertSelector::PlacementsController#index as HTML + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/index.html.erb within layouts/advert_selector/application + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/placements/index.html.erb within layouts/advert_selector/application (1.6ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.020792') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + CACHE (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + CACHE (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 9ms (Views: 7.7ms | ActiveRecord: 0.5ms) +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +--------------------------------------- +BannerShowsTest: test_HelperItem_runned +--------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000946"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003649"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.007459' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.007557' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (3.6ms) +Completed 200 OK in 5ms (Views: 4.8ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_helper_items" SET "position" = ("advert_selector_helper_items"."position" + 1), "updated_at" = '2018-03-22 10:00:00.013171' WHERE "advert_selector_helper_items"."banner_id" = ? AND ("advert_selector_helper_items"."position" >= 1) [["banner_id", 814558298]] + SQL (0.1ms) INSERT INTO "advert_selector_helper_items" ("banner_id", "position", "name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?) [["banner_id", 814558298], ["position", 1], ["name", "always_false"], ["created_at", "2018-03-22 10:00:00.012936"], ["updated_at", "2018-03-22 10:00:00.012936"]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.016458' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.016571' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (3.1ms) +Completed 200 OK in 5ms (Views: 4.3ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +--------------------------------------------------------------- +BannerShowsTest: test_complex_setup_multiple_banners_placements +--------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.001024"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.007797"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "t"], ["updated_at", "2018-03-22 10:00:00.009774"], ["id", 207249520]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 207249520]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_placements" SET "conflicting_placements_array" = ?, "updated_at" = ? WHERE "advert_selector_placements"."id" = ? [["conflicting_placements_array", ""], ["updated_at", "2018-03-22 10:00:00.012048"], ["id", 718799085]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'leaderboard') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + SQL (0.1ms) UPDATE "advert_selector_placements" SET "conflicting_placements_array" = ?, "updated_at" = ? WHERE "advert_selector_placements"."id" = ? [["conflicting_placements_array", ""], ["updated_at", "2018-03-22 10:00:00.013463"], ["id", 405688915]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'parade') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'video') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + SQL (0.1ms) UPDATE "advert_selector_placements" SET "conflicting_placements_array" = ?, "updated_at" = ? WHERE "advert_selector_placements"."id" = ? [["conflicting_placements_array", ""], ["updated_at", "2018-03-22 10:00:00.015064"], ["id", 1019730477]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'parade') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.018646' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.018764' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (207249520) parade_banner in placement Parade +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (4.3ms) +Completed 200 OK in 6ms (Views: 5.5ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 207249520], ["content_for", "t"], ["LIMIT", 1]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------------------ +BannerShowsTest: test_complex_setup_conflicting_banners_placements +------------------------------------------------------------------ + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000879"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003626"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "t"], ["updated_at", "2018-03-22 10:00:00.005596"], ["id", 207249520]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 207249520]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.009430' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.009526' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (207249520) parade_banner in placement Parade +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (3.9ms) +Completed 200 OK in 6ms (Views: 5.1ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 207249520], ["content_for", "t"], ["LIMIT", 1]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (1.6ms) +Completed 200 OK in 3ms (Views: 3.1ms | ActiveRecord: 0.0ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 207249520], ["content_for", "t"], ["LIMIT", 1]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +--------------------------------------------------- +BannerShowsTest: test_only_once_per_session_banners +--------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000877"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003671"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_placements" SET "only_once_per_session" = ?, "updated_at" = ? WHERE "advert_selector_placements"."id" = ? [["only_once_per_session", "t"], ["updated_at", "2018-03-22 10:00:00.005995"], ["id", 405688915]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.008945' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.009053' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (7.2ms) +Completed 200 OK in 9ms (Views: 8.4ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (0.9ms) +Completed 200 OK in 3ms (Views: 2.5ms | ActiveRecord: 0.0ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------- +BannerShowsTest: test_normal_request_and_banner_loading +------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "fast_mode" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["fast_mode", "t"], ["updated_at", "2018-03-22 10:00:00.000900"], ["id", 814558298]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558298]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "confirmed" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["confirmed", "f"], ["updated_at", "2018-03-22 10:00:00.003588"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.005443' OR end_time IS NULL) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (3.3ms) +Completed 200 OK in 5ms (Views: 4.5ms | ActiveRecord: 0.3ms) + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? AND "advert_selector_helper_items"."content_for" = ? ORDER BY "advert_selector_helper_items"."position" DESC LIMIT ? [["banner_id", 814558298], ["content_for", "t"], ["LIMIT", 1]] +Started GET "/" for 127.0.0.1 at 2018-03-22 12:00:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (1.4ms) +Completed 200 OK in 3ms (Views: 2.8ms | ActiveRecord: 0.0ms) +Started GET "/" for 127.0.0.1 at 2018-03-22 12:15:00 +0200 +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (1.4ms) +Completed 200 OK in 3ms (Views: 2.9ms | ActiveRecord: 0.0ms) +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------------- +AdvertSelector::MainControllerTest: test_forbidden_with_default_access +---------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::MainController#index as HTML + Rendering text template + Rendered text template (0.0ms) +Filter chain halted as :admin_access_only rendered or redirected +Completed 403 Forbidden in 1ms (Views: 0.7ms | ActiveRecord: 0.0ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------- +AdvertSelector::MainControllerTest: test_should_clear_errors_log +---------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::MainController#clear_errors_log as HTML +Redirected to http://test.host/advert_selector/ +Completed 302 Found in 1ms (ActiveRecord: 0.0ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +--------------------------------------------------------- +AdvertSelector::MainControllerTest: test_should_get_index +--------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::MainController#index as HTML + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/main/index.html.erb within layouts/advert_selector/application + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/main/index.html.erb within layouts/advert_selector/application (0.4ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.003780') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 7ms (Views: 6.3ms | ActiveRecord: 0.5ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +------------------------------ +AdvertSelectorTest: test_truth +------------------------------ + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------- +AdvertSelector::PlacementTest: test_conflicting_with +---------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------- +AdvertSelector::PlacementTest: test_conflicting_placements +---------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------------------------------- +AdvertSelector::PlacementTest: test_conflicting_placements_array= +----------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_placements" SET "conflicting_placements_array" = ?, "updated_at" = ? WHERE "advert_selector_placements"."id" = ? [["conflicting_placements_array", "not_found,video"], ["updated_at", "2018-03-22 10:00:00.001160"], ["id", 718799085]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'leaderboard') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + SQL (0.1ms) UPDATE "advert_selector_placements" SET "conflicting_placements_array" = ?, "updated_at" = ? WHERE "advert_selector_placements"."id" = ? [["conflicting_placements_array", ""], ["updated_at", "2018-03-22 10:00:00.002624"], ["id", 405688915]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE (LOWER(name) = 'parade') ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."name" = ? ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["name", "not_found"], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."name" = ? ORDER BY "advert_selector_placements"."id" ASC LIMIT ? [["name", "video"], ["LIMIT", 1]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------- +AdvertSelector::PlacementTest: test_name_sym +-------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------------------------------------- +AdvertSelector::PlacementTest: test_conflicting_placements_string_handling +-------------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_update_banner +---------------------------------------------------------------- + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::BannersController#update as HTML + Parameters: {"banner"=>{"comment"=>"Pepsi banner"}, "id"=>"394627963"} + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + AdvertSelector::HelperItem Load (0.1ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Redirected to http://test.host/advert_selector/banners/394627963 +Completed 302 Found in 3ms (ActiveRecord: 0.2ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +------------------------------------------------------------ +AdvertSelector::BannersControllerTest: test_should_get_index +------------------------------------------------------------ + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::BannersController#index as HTML + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/index.html.erb within layouts/advert_selector/application + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/index.html.erb within layouts/advert_selector/application (2.5ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.005467') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 9ms (Views: 7.8ms | ActiveRecord: 0.5ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_get_edit +----------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::BannersController#edit as HTML + Parameters: {"id"=>"394627963"} + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/edit.html.erb within layouts/advert_selector/application + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? [["banner_id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/_form.html.erb (20.8ms) + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/edit.html.erb within layouts/advert_selector/application (22.6ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.025123') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 29ms (Views: 27.4ms | ActiveRecord: 0.7ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +-------------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_show_banner +-------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::BannersController#show as HTML + Parameters: {"id"=>"394627963"} +Redirected to http://test.host/advert_selector/banners/394627963/edit +Completed 302 Found in 0ms (ActiveRecord: 0.0ms) +  (0.0ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_destroy_banner +----------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_banners" +Processing by AdvertSelector::BannersController#destroy as HTML + Parameters: {"id"=>"394627963"} + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] + SQL (0.1ms) DELETE FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."id" = ? [["id", 435138789]] + SQL (0.0ms) DELETE FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."id" = ? [["id", 960656439]] + SQL (0.1ms) DELETE FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? [["id", 394627963]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Redirected to http://test.host/advert_selector/banners +Completed 302 Found in 3ms (ActiveRecord: 0.4ms) +  (0.1ms) SELECT COUNT(*) FROM "advert_selector_banners" +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_create_banner +---------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_banners" +Processing by AdvertSelector::BannersController#create as HTML + Parameters: {"banner"=>{"comment"=>"Pepsi banner", "end_time"=>"2018-04-01 00:00:00 UTC", "frequency"=>"0", "name"=>"Pepsi", "placement_id"=>"405688915", "start_time"=>"2018-03-22 00:00:00 UTC", "target_view_count"=>"1000"}} +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) INSERT INTO "advert_selector_banners" ("name", "start_time", "end_time", "target_view_count", "frequency", "comment", "placement_id", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [["name", "Pepsi"], ["start_time", "2018-03-22 00:00:00"], ["end_time", "2018-04-01 00:00:00"], ["target_view_count", 1000], ["frequency", 0], ["comment", "Pepsi banner"], ["placement_id", 405688915], ["created_at", "2018-03-22 10:00:00.001855"], ["updated_at", "2018-03-22 10:00:00.001855"]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 814558299]] +  (0.0ms) RELEASE SAVEPOINT active_record_1 +Redirected to http://test.host/advert_selector/banners/814558299 +Completed 302 Found in 3ms (ActiveRecord: 0.2ms) +  (0.0ms) SELECT COUNT(*) FROM "advert_selector_banners" +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_get_new +---------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by AdvertSelector::BannersController#new as HTML + Rendering /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/new.html.erb within layouts/advert_selector/application + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/_form.html.erb (12.4ms) + Rendered /home/ohu/koodi/own_gems_programs/advert_selector/app/views/advert_selector/banners/new.html.erb within layouts/advert_selector/application (13.1ms) + AdvertSelector::Banner Load (0.2ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time is null or end_time > '2018-03-20 10:00:00.015740') ORDER BY priority desc LIMIT ? [["LIMIT", 10]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 718799085], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" = ? LIMIT ? [["id", 405688915], ["LIMIT", 1]] + AdvertSelector::Placement Load (0.0ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" +Completed 200 OK in 19ms (Views: 18.0ms | ActiveRecord: 0.5ms) +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +----------------------------------------------------------------------------------- +AdvertSelector::BannersControllerTest: test_should_update_banner_running_view_count +----------------------------------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +  (0.0ms) SAVEPOINT active_record_1 + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = ?, "updated_at" = ? WHERE "advert_selector_banners"."id" = ? [["running_view_count", 1], ["updated_at", "2018-03-22 10:00:00.000982"], ["id", 394627963]] + AdvertSelector::HelperItem Load (0.0ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" = ? ORDER BY "advert_selector_helper_items"."position" ASC [["banner_id", 394627963]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +Processing by AdvertSelector::BannersController#update_running_view_count as HTML + Parameters: {"banner"=>{"running_view_count"=>"99"}, "id"=>"394627963"} + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = 99 WHERE "advert_selector_banners"."id" = ? [["id", 394627963]] + SQL (0.1ms) UPDATE "advert_selector_banners" SET "running_view_count" = 99 WHERE "advert_selector_banners"."id" = ? [["id", 394627963]] +Redirected to http://test.host/advert_selector/banners/394627963 +Completed 302 Found in 1023ms (ActiveRecord: 0.2ms) + AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] +  (0.1ms) rollback transaction +  (0.0ms) begin transaction +---------------------------------------------------------- +ExamplesControllerTest: test_render_video_once_per_session +---------------------------------------------------------- + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 814558298], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 394627963], ["LIMIT", 1]] + AdvertSelector::Banner Load (0.0ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE "advert_selector_banners"."id" = ? LIMIT ? [["id", 207249520], ["LIMIT", 1]] +Processing by ExamplesController#index as HTML + Rendering examples/index.html.erb within layouts/application +[AdvertSelector] AdvertSelection initialized +[AdvertSelector] AdvertSelection fetching banners and placements +[AdvertSelector] AdvertSelector::Banner Load (0.1ms) SELECT "advert_selector_banners".* FROM "advert_selector_banners" WHERE (end_time > '2018-03-22 10:00:00.001157' OR end_time IS NULL) AND (start_time < '2018-03-22 11:00:00.001300' OR start_time IS NULL) AND (target_view_count IS NULL OR target_view_count > running_view_count) ORDER BY priority desc +[AdvertSelector] AdvertSelector::Placement Load (0.1ms) SELECT "advert_selector_placements".* FROM "advert_selector_placements" WHERE "advert_selector_placements"."id" IN (718799085, 405688915) +[AdvertSelector] AdvertSelector::HelperItem Load (0.2ms) SELECT "advert_selector_helper_items".* FROM "advert_selector_helper_items" WHERE "advert_selector_helper_items"."banner_id" IN (207249520, 394627963, 814558298) ORDER BY "advert_selector_helper_items"."position" ASC +[AdvertSelector] Showing banner (814558298) Coke in placement Leaderboard +[AdvertSelector] AdvertSelection finished + Rendered examples/index.html.erb within layouts/application (4.0ms) +Completed 200 OK in 5ms (Views: 4.5ms | ActiveRecord: 0.4ms) +  (0.0ms) rollback transaction