Skip to content

Instantly share code, notes, and snippets.

Evgeniy.S.Semenchuk evgenii

Block or report user

Report or block evgenii

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:132a9d059578db26fdae1771df06ef56
evgenii:~/.ror/atlant_asrc/tmp/apps sudo java -jar ./web_socket_module_3011.jar
Password:
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v1.5.10.RELEASE)
View gist:e0018468cce7cf0ab4ada1cc8fb16981
mysqldump ezcall_dev -uroot -P3306 --routines --skip-triggers --no-data > ./tmp/dumps/dump_1561034412_000_tables_and_procedures.sql
mysqldump ezcall_dev -uroot -P3306 --skip-triggers --no-create-db --no-create-info --single-transaction=TRUE numeric_sequence schema_migrations > ./tmp/dumps/dump_1561034412_001_all_data.sql
mysqldump ezcall_dev -uroot -P3306 --skip-triggers --no-create-db --no-create-info --single-transaction=TRUE assign_pay_rules audit_logs clients enterprise_connections entity_locations entity_non_clinical_types entity_preferences group_entities group_memberships groups location_groups location_privileges locations non_clinical_types or_manager_clients pay_rules remote_object_mappings remote_systems site_settings specialties staff_entities staff_specialties staffs timekeeper_assignment_configuration_assignments timekeeper_assignment_configurations timekeeper_punches timekeeper_schedule_shifts timekeeper_shift_segments users work_rules -w 'tenant_id in (319)' > ./tmp/dumps/dump_1561034412_003_t
View gist:6959f5247dab742fec1e84b272f4b6d3
---
dumps:
path: "./tmp/dumps"
prefix: dump_1561034266
create_archive: false
variables:
tenant_id: 319
client_id:
condition: select id from clients where tenant_id in (:tenant_id)
entity_id:
View gist:38668cf927dc044f84d34801d20b618b
-- explain
SELECT `staff_types`.*
FROM `staff_types`
INNER JOIN `assign_staff_types`
ON `staff_types`.`id` = `assign_staff_types`.`staff_type_id`
INNER JOIN `schedules`
ON `schedules`.`staff_id` = `assign_staff_types`.`staff_id`
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
You can’t perform that action at this time.