Skip to content

Instantly share code, notes, and snippets.

Evgeniy.S.Semenchuk evgenii

View GitHub Profile
View auto_populate.sql
(146.7ms) SET NAMES utf8 COLLATE utf8_unicode_ci, @@SESSION.sql_mode = 'NO_ENGINE_SUBSTITUTION', @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
Client Load (1064.6ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 325 LIMIT 1
CalendarSchedule Load (143.6ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`client_id` = 325 AND `calendar_schedules`.`id` = 1396 ORDER BY `calendar_schedules`.`position` ASC LIMIT 1
CallType Load (985.8ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`id` IN (12732, 12733, 12734)
CalendarSchedule Load (1003.4ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`client_id` = 325 AND `calendar_schedules`.`id` = 1396 ORDER BY `calendar_schedules`.`position` ASC LIMIT 1
Block Load (145.1ms) SELECT `blocks`.* FROM `blocks` INNER JOIN `block_schedules` ON `blocks`.`block_schedule_id` = `block_schedules`.`id` WHERE `block_schedules`.`id` = 456 AND `blocks
@evgenii
evgenii / man-populate-mar-2019.sql
Created Feb 11, 2019
man-populate-mar-2019 session_id: 59135044
View man-populate-mar-2019.sql
[13554a52-f902-4cae-bec0-6e019c72ca70] Started GET "/mat/admin/schedules/new?_=1549887799820&call_type_id=12733&date=2019-03-12&calendar_schedule=1396" for 127.0.0.1 at 2019-02-11 14:23:19 +0200
[13554a52-f902-4cae-bec0-6e019c72ca70] (140.0ms) SET NAMES utf8 COLLATE utf8_unicode_ci, @@SESSION.sql_mode = 'NO_ENGINE_SUBSTITUTION', @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
[13554a52-f902-4cae-bec0-6e019c72ca70] (391.9ms) SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC
[13554a52-f902-4cae-bec0-6e019c72ca70] Full URL: "http://sm.local.ezcall.com:3215/mat/admin/schedules/new?_=1549887799820&call_type_id=12733&date=2019-03-12&calendar_schedule=1396"
[13554a52-f902-4cae-bec0-6e019c72ca70] Remote Addr: 127.0.0.1
[13554a52-f902-4cae-bec0-6e019c72ca70] UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
[13554a52-f902-4cae-bec0-6e019c72ca70] Ten
@evgenii
evgenii / TARGET ANALYSIS on mar-2019.sql
Last active Feb 11, 2019
TARGET ANALYSIS on mar-2019 257067572 /* session_id */
View TARGET ANALYSIS on mar-2019.sql
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] Started POST "/mat/admin/embed_targets/target_analysis" for 127.0.0.1 at 2019-02-11 14:08:52 +0200
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] Full URL: "http://sm.local.ezcall.com:3215/mat/admin/embed_targets/target_analysis"
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] Remote Addr: 127.0.0.1
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] Tenant Load (141.7ms) SELECT `tenants`.* FROM `tenants` WHERE `tenants`.`active` = 1 AND `tenants`.`subdomain` IN ('sm.local.ezcall.com', 'sm') ORDER BY `tenants`.`id` ASC LIMIT 1
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] Client Exists (137.5ms) SELECT 1 AS one FROM `clients` WHERE `clients`.`tenant_id` = 319 LIMIT 1
[6226e955-e9a8-4fc8-88c6-3fa4088005f5] Client Load (296.3ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`tenant_id` = 319 AND `clients`.`subdomain` =
View gist:bfdfbde359ecd15e357b282744b63222
(147.1ms) SET NAMES utf8 COLLATE utf8_unicode_ci, @@SESSION.sql_mode = 'NO_ENGINE_SUBSTITUTION', @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
Client Load (290.9ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 325 LIMIT 1
CalendarSchedule Load (844.4ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`client_id` = 325 AND `calendar_schedules`.`id` = 1396 ORDER BY `calendar_schedules`.`position` ASC LIMIT 1
CallType Load (146.2ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`id` IN (12732, 12733, 12734)
CalendarSchedule Load (160.5ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`client_id` = 325 AND `calendar_schedules`.`id` = 1396 ORDER BY `calendar_schedules`.`position` ASC LIMIT 1
Block Load (189.5ms) SELECT `blocks`.* FROM `blocks` INNER JOIN `block_schedules` ON `blocks`.`block_schedule_id` = `block_schedules`.`id` WHERE `block_schedules`.`id` = 456 AND `blocks`.
@evgenii
evgenii / script_log.sql
Created Jan 10, 2019
script_log.sql session: 2013398260
View script_log.sql
(174.2ms) SET NAMES utf8 COLLATE utf8_unicode_ci, @@SESSION.sql_mode = 'NO_ENGINE_SUBSTITUTION', @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
Client Load (179.5ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 6 LIMIT 1
CalendarSchedule Load (174.0ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`client_id` = 6 AND `calendar_schedules`.`id` = 6 ORDER BY `calendar_schedules`.`position` ASC LIMIT 1
CallType Load (175.1ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`id` IN (46, 47, 48, 49, 51)
CalendarSchedule Load (172.3ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`client_id` = 6 AND `calendar_schedules`.`id` = 6 ORDER BY `calendar_schedules`.`position` ASC LIMIT 1
Block Load (171.7ms) SELECT `blocks`.* FROM `blocks` INNER JOIN `block_schedules` ON `blocks`.`block_schedule_id` = `block_schedules`.`id` WHERE `block_schedules`.`id` = 6 AND `blocks`.`id` = 17087 OR
View populate_log.log
Please, remove /Users/evgenii/.ror/mtt/ezcall/lib/core_ext/hash.rb as it is not needed anymore
The client method is deprecated as of redis-rb 4.0.0, please use the new _clientmethod instead. Support for the old method will be removed in redis-namespace 2.0.
INFO : (01-10 08:55:40) phase: Scheduler::Base
INFO : (01-10 08:55:40) from: 2017-10-01 to: 2017-10-31
INFO : (01-10 08:55:42) rule configurations: AssignmentsPerDay
- Assignments Per Day applied {"opt1"=>{"applied"=>"1", "value"=>"0000002"}} weight:5
- Cumulative Assignment Targets not applied
- Cumulative Combined Assignment Targets not applied
- Cumulative Daily Assignment Targets not applied
- Cumulative Day of Week Targets not applied
View prepopulate.log
Please, remove /Users/evgenii/.ror/mtt/ezcall/lib/core_ext/hash.rb as it is not needed anymore
The client method is deprecated as of redis-rb 4.0.0, please use the new _clientmethod instead. Support for the old method will be removed in redis-namespace 2.0.
INFO : (12-21 18:51:23) phase: Scheduler::Base
INFO : (12-21 18:51:23) from: 2018-01-01 to: 2018-03-31
INFO : (12-21 18:51:25) rule configurations: Weekends
- 'Days Between Same Assignment' applied {} weight:10
- 'Cumulative Assignment Targets' not applied
- 'Cumulative Combined Assignment Targets' not applied
- 'Cumulative Daily Assignment Targets' not applied
- 'Cumulative Day of Week Targets' not applied
View prepopulate_log.sql
(146.9ms) SET NAMES utf8 COLLATE utf8_unicode_ci, @@SESSION.sql_mode = 'NO_ENGINE_SUBSTITUTION', @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
AutopopulateStepStatus Load (153.9ms) SELECT `autopopulate_step_statuses`.* FROM `autopopulate_step_statuses` WHERE `autopopulate_step_statuses`.`id` = 11727 LIMIT 1
Client Load (150.0ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 26 LIMIT 1
CalendarSchedule Load (147.7ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`id` = 26 LIMIT 1
Block Load (146.9ms) SELECT `blocks`.* FROM `blocks` WHERE `blocks`.`id` = 18678 LIMIT 1
AutopopulateStep Load (150.9ms) SELECT `autopopulate_steps`.* FROM `autopopulate_steps` WHERE `autopopulate_steps`.`calendar_schedule_id` = 26 AND `autopopulate_steps`.`step` = 4 ORDER BY autopopulate_steps.step ASC, autopopulate_steps.display_order ASC
PrepopulateRule Exists (147.3ms) SELECT 1 AS one FROM `prepopulate_rules` WHERE `prepopulate_rules`.`
View gist:61e3f04d319b023933c9a471c74ed249
RuleSet Load (140.9ms) SELECT `rule_sets`.* FROM `rule_sets` WHERE `rule_sets`.`id` = 701 LIMIT 1
Client Load (142.9ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 26 LIMIT 1
INFO : (12-21 18:08:49) rule configurations: Weekends
- 'Days Between Same Assignment' applied {} weight:10
- 'Cumulative Assignment Targets' not applied
- 'Cumulative Combined Assignment Targets' not applied
- 'Cumulative Daily Assignment Targets' not applied
- 'Cumulative Day of Week Targets' not applied
- 'Cumulative Hour Targets' not applied
- 'Cumulative Point Targets' not applied
View prepopulate_issue.sql
(139.9ms) SET NAMES utf8 COLLATE utf8_unicode_ci, @@SESSION.sql_mode = 'NO_ENGINE_SUBSTITUTION', @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
AutopopulateStepStatus Load (137.5ms) SELECT `autopopulate_step_statuses`.* FROM `autopopulate_step_statuses` WHERE `autopopulate_step_statuses`.`id` = 11686 LIMIT 1
Client Load (290.5ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 319 LIMIT 1
CalendarSchedule Load (149.0ms) SELECT `calendar_schedules`.* FROM `calendar_schedules` WHERE `calendar_schedules`.`id` = 1381 LIMIT 1
Block Load (145.9ms) SELECT `blocks`.* FROM `blocks` WHERE `blocks`.`id` = 29261 LIMIT 1
AutopopulateStep Load (140.1ms) SELECT `autopopulate_steps`.* FROM `autopopulate_steps` WHERE `autopopulate_steps`.`calendar_schedule_id` = 1381 AND `autopopulate_steps`.`step` = 3 ORDER BY autopopulate_steps.step ASC, autopopulate_steps.display_order ASC
PrepopulateRule Exists (140.6ms) SELECT 1 AS one FROM `prepopulate_rules` WHERE `prepopulate_rul
You can’t perform that action at this time.