Skip to content

Instantly share code, notes, and snippets.

@rmehta

rmehta/debug.sql

Last active August 12, 2020 16:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rmehta/3ab456f9ce3b32dedbdd44dfbba4f092 to your computer and use it in GitHub Desktop.
Save rmehta/3ab456f9ce3b32dedbdd44dfbba4f092 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
debug.sql
test_inner_mapping (frappe.event_streaming.doctype.event_producer.test_event_producer.TestEventProducer) ... select `name` from `tabEvent Producer` where `name` = 'http://test_site_producer:8000' order by modified desc
select * from `tabEvent Producer` where `name` = 'http://test_site_producer:8000' order by modified desc
16:11:53 worker_default.1 | select * from `tabDocPerm` where `parent` = 'Document Follow' and `parenttype` = 'DocType' and `parentfield` = 'permissions' order by idx asc
select * from `tabEvent Producer Document Type` where `parent` = 'http://test_site_producer:8000' and `parenttype` = 'Event Producer' and `parentfield` = 'producer_doctypes' order by idx asc
select `password` from `__Auth`
where doctype='Event Producer' and name='http://test_site_producer:8000' and fieldname='api_secret' and encrypted=1
16:11:53 worker_default.1 | select * from `tabDocType Action` where `parent` = 'Document Follow' and `parenttype` = 'DocType' and `parentfield` = 'actions' order by idx asc
select * from `tabEvent Producer` where `name` = 'http://test_site_producer:8000' order by modified desc
16:11:53 worker_default.1 | select * from `tabDocType Link` where `parent` = 'Document Follow' and `parenttype` = 'DocType' and `parentfield` = 'links' order by idx asc
select * from `tabEvent Producer Document Type` where `parent` = 'http://test_site_producer:8000' and `parenttype` = 'Event Producer' and `parentfield` = 'producer_doctypes' order by idx asc
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | SELECT * FROM `tabCustom Field`
16:11:53 worker_default.1 | WHERE dt = 'Document Follow' AND docstatus < 2
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | select * from `tabProperty Setter` where
16:11:53 worker_default.1 | doc_type='Document Follow'
select `name` from `tabDocument Type Mapping` where `name` = 'Role to Note Dependency Creation' order by modified desc
16:11:53 worker_default.1 | select *
select `module`, `custom` from `tabDocType` where `name` = 'Document Type Mapping' order by modified desc
16:11:53 worker_default.1 | from `tabCustom DocPerm`
16:11:53 worker_default.1 | where `tabCustom DocPerm`.parent = 'Document Follow'
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | order by `tabCustom DocPerm`.`modified` ASC
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | select `tabDocument Follow`.`name`
16:11:53 worker_default.1 | from `tabDocument Follow`
16:11:53 worker_default.1 | where `tabDocument Follow`.ref_doctype = 'Version' and `tabDocument Follow`.ref_docname = '860c250af3' and `tabDocument Follow`.user = 'Administrator'
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | order by `tabDocument Follow`.`modified` DESC
select `issingle` from `tabDocType` where `name` = 'Document Type Mapping' order by modified desc
16:11:53 worker_default.1 | limit 1 offset 0
16:11:53 worker_default.1 | select `document_follow_notify` from `tabUser` where `name` = 'Administrator' order by modified desc
select `module`, `custom` from `tabDocType` where `name` = 'Document Type Field Mapping' order by modified desc
16:11:53 worker_default.1 | select `tabEnergy Point Rule`.`name`
16:11:53 worker_default.1 | from `tabEnergy Point Rule`
16:11:53 worker_default.1 | where `tabEnergy Point Rule`.reference_doctype = 'Event Sync Log' and `tabEnergy Point Rule`.enabled = 1.0
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | order by `tabEnergy Point Rule`.`modified` DESC
16:11:53 worker_default.1 |
select `issingle` from `tabDocType` where `name` = 'Document Type Field Mapping' order by modified desc
16:11:53 worker_default.1 | select `name` from `tabDocType` where `name` = 'Event Consumer' order by modified desc
16:11:53 worker_default.1 | select `tabEvent Consumer Document Type`.`name`
16:11:53 worker_default.1 | from `tabEvent Consumer Document Type`
16:11:53 worker_default.1 | where `tabEvent Consumer Document Type`.ref_doctype = 'Event Sync Log' and `tabEvent Consumer Document Type`.status = 'Approved'
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | order by `tabEvent Consumer Document Type`.`modified` DESC
16:11:53 worker_default.1 | limit 1 offset 0
16:11:53 worker_default.1 | select `tabDocument Follow`.`name`
16:11:53 worker_default.1 | from `tabDocument Follow`
16:11:53 worker_default.1 | where `tabDocument Follow`.ref_doctype = 'Event Sync Log' and `tabDocument Follow`.ref_docname = '70b2c55621' and `tabDocument Follow`.user = 'Administrator'
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | order by `tabDocument Follow`.`modified` DESC
16:11:53 worker_default.1 | limit 1 offset 0
16:11:53 worker_default.1 | select `document_follow_notify` from `tabUser` where `name` = 'Administrator' order by modified desc
select name, event, method
from `tabNotification`
where `tabNotification`.enabled = 1.0 and `tabNotification`.document_type = 'Document Type Mapping'
order by `tabNotification`.`modified` DESC
16:11:53 worker_default.1 | select * from `tabEvent Producer` where `name` = 'http://test_site_producer:8000' order by modified desc
select `name` from `tabDocType` where `name` = 'Role' order by modified desc
16:11:53 worker_default.1 | select * from `tabEvent Producer Document Type` where `parent` = 'http://test_site_producer:8000' and `parenttype` = 'Event Producer' and `parentfield` = 'producer_doctypes' order by idx asc
16:11:53 worker_default.1 | select `name` from `tabEvent Producer` where `name` = 'http://test_site_producer:8000' order by modified desc for update
select name, event, method
from `tabNotification`
where `tabNotification`.enabled = 1.0 and `tabNotification`.document_type = 'Document Type Field Mapping'
order by `tabNotification`.`modified` DESC
16:11:53 worker_default.1 | update `tabEvent Producer`
16:11:53 worker_default.1 | set `modified`='2020-08-12 12:11:53.563316', `modified_by`='Administrator', `last_update`='2020-08-12 21:41:52.024991' where name='http://test_site_producer:8000'
16:11:53 worker_default.1 | select `tabEnergy Point Rule`.`name`
16:11:53 worker_default.1 | from `tabEnergy Point Rule`
16:11:53 worker_default.1 | where `tabEnergy Point Rule`.reference_doctype = 'Event Producer' and `tabEnergy Point Rule`.enabled = 1.0
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | order by `tabEnergy Point Rule`.`modified` DESC
16:11:53 worker_default.1 |
16:11:53 worker_default.1 | commit
select `name` from `tabWorkflow` where `document_type` = 'Document Type Mapping' and `is_active` = 1 order by modified desc
16:11:53 worker_default.1 | commit
INSERT INTO `tabDocument Type Mapping` (`name`, `owner`, `creation`, `modified`, `modified_by`, `parent`, `parentfield`, `parenttype`, `idx`, `docstatus`, `mapping_name`, `local_doctype`, `remote_doctype`)
VALUES ('Role to Note Dependency Creation', 'Administrator', '2020-08-12 12:11:53.553322', '2020-08-12 12:11:53.553322', 'Administrator', NULL, NULL, NULL, 0, 0, 'Role to Note Dependency Creation', 'Role', 'Note')
INSERT INTO `tabDocument Type Field Mapping` (`name`, `owner`, `creation`, `modified`, `modified_by`, `parent`, `parentfield`, `parenttype`, `idx`, `docstatus`, `local_fieldname`, `mapping_type`, `mapping`, `remote_value_filters`, `remote_fieldname`, `default_value`)
VALUES ('5b9d9f5453', 'Administrator', '2020-08-12 12:11:53.553322', '2020-08-12 12:11:53.553322', 'Administrator', 'Role to Note Dependency Creation', 'field_mapping', 'Document Type Mapping', 1, 0, 'role_name', '', NULL, NULL, 'title', NULL)
select `tabAssignment Rule`.`name`
from `tabAssignment Rule`
where `tabAssignment Rule`.document_type = 'Document Type Mapping' and `tabAssignment Rule`.disabled = 0.0
order by priority desc
select `tabMilestone Tracker`.`name`
from `tabMilestone Tracker`
where `tabMilestone Tracker`.document_type = 'Document Type Mapping' and `tabMilestone Tracker`.disabled = 0.0
order by `tabMilestone Tracker`.`modified` ASC
select `tabEnergy Point Rule`.`name`
from `tabEnergy Point Rule`
where `tabEnergy Point Rule`.reference_doctype = 'Document Type Mapping' and `tabEnergy Point Rule`.enabled = 1.0
order by `tabEnergy Point Rule`.`modified` DESC
select `name` from `tabDocType` where `name` = 'Event Consumer' order by modified desc
select `tabEvent Consumer Document Type`.`name`
from `tabEvent Consumer Document Type`
where `tabEvent Consumer Document Type`.ref_doctype = 'Document Type Mapping' and `tabEvent Consumer Document Type`.status = 'Approved'
order by `tabEvent Consumer Document Type`.`modified` DESC
limit 1 offset 0
select `tabDocument Follow`.`name`
from `tabDocument Follow`
where `tabDocument Follow`.ref_doctype = 'Document Type Mapping' and `tabDocument Follow`.ref_docname = 'Role to Note Dependency Creation' and `tabDocument Follow`.user = 'Administrator'
order by `tabDocument Follow`.`modified` DESC
limit 1 offset 0
select `document_follow_notify` from `tabUser` where `name` = 'Administrator' order by modified desc
select `name` from `tabDocument Type Mapping` where `name` = 'ToDo to Note Mapping' order by modified desc
select `name` from `tabDocument Type Mapping` where `name` = 'Role to Note Dependency Creation' order by modified desc
INSERT INTO `tabDocument Type Mapping` (`name`, `owner`, `creation`, `modified`, `modified_by`, `parent`, `parentfield`, `parenttype`, `idx`, `docstatus`, `mapping_name`, `local_doctype`, `remote_doctype`)
VALUES ('ToDo to Note Mapping', 'Administrator', '2020-08-12 12:11:53.603756', '2020-08-12 12:11:53.603756', 'Administrator', NULL, NULL, NULL, 0, 0, 'ToDo to Note Mapping', 'ToDo', 'Note')
INSERT INTO `tabDocument Type Field Mapping` (`name`, `owner`, `creation`, `modified`, `modified_by`, `parent`, `parentfield`, `parenttype`, `idx`, `docstatus`, `local_fieldname`, `mapping_type`, `mapping`, `remote_value_filters`, `remote_fieldname`, `default_value`)
VALUES ('61fe0d9565', 'Administrator', '2020-08-12 12:11:53.603756', '2020-08-12 12:11:53.603756', 'Administrator', 'ToDo to Note Mapping', 'field_mapping', 'Document Type Mapping', 1, 0, 'description', '', NULL, NULL, 'content', NULL)
INSERT INTO `tabDocument Type Field Mapping` (`name`, `owner`, `creation`, `modified`, `modified_by`, `parent`, `parentfield`, `parenttype`, `idx`, `docstatus`, `local_fieldname`, `mapping_type`, `mapping`, `remote_value_filters`, `remote_fieldname`, `default_value`)
VALUES ('32ceec6dcc', 'Administrator', '2020-08-12 12:11:53.603756', '2020-08-12 12:11:53.603756', 'Administrator', 'ToDo to Note Mapping', 'field_mapping', 'Document Type Mapping', 2, 0, 'role', 'Document', 'Role to Note Dependency Creation', '{\"title\": \"title\"}', 'title', NULL)
select `tabAssignment Rule`.`name`
from `tabAssignment Rule`
where `tabAssignment Rule`.document_type = 'Document Type Mapping' and `tabAssignment Rule`.disabled = 0.0
order by priority desc
select `tabMilestone Tracker`.`name`
from `tabMilestone Tracker`
where `tabMilestone Tracker`.document_type = 'Document Type Mapping' and `tabMilestone Tracker`.disabled = 0.0
order by `tabMilestone Tracker`.`modified` ASC
select `tabEnergy Point Rule`.`name`
from `tabEnergy Point Rule`
where `tabEnergy Point Rule`.reference_doctype = 'Document Type Mapping' and `tabEnergy Point Rule`.enabled = 1.0
order by `tabEnergy Point Rule`.`modified` DESC
select `name` from `tabDocType` where `name` = 'Event Consumer' order by modified desc
select `tabEvent Consumer Document Type`.`name`
from `tabEvent Consumer Document Type`
where `tabEvent Consumer Document Type`.ref_doctype = 'Document Type Mapping' and `tabEvent Consumer Document Type`.status = 'Approved'
order by `tabEvent Consumer Document Type`.`modified` DESC
limit 1 offset 0
select `tabDocument Follow`.`name`
from `tabDocument Follow`
where `tabDocument Follow`.ref_doctype = 'Document Type Mapping' and `tabDocument Follow`.ref_docname = 'ToDo to Note Mapping' and `tabDocument Follow`.user = 'Administrator'
order by `tabDocument Follow`.`modified` DESC
limit 1 offset 0
select `document_follow_notify` from `tabUser` where `name` = 'Administrator' order by modified desc
select modified, docstatus from `tabEvent Producer`
where name = 'http://test_site_producer:8000' for update
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment