Skip to content

Instantly share code, notes, and snippets.

@ansemjo

ansemjo/412cfcf1-9326-427e-91a1-ddec60d78dd4

Created March 29, 2017 09:24
Show Gist options
  • Save ansemjo/3ac14e897195779b79bc27647be44e02 to your computer and use it in GitHub Desktop.
Save ansemjo/3ac14e897195779b79bc27647be44e02 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
412cfcf1-9326-427e-91a1-ddec60d78dd4
≡ DATABASE Executed (default): SELECT `orders`.`uuid`, `orders`.`contractor`, `orders`.`order_number`, `orders`.`order_date`, `orders`.`parts_designation`, `orders`.`parts_amount`, `orders`.`parts_drawing`, `orders`.`delivery_wished`, `orders`.`delivery_expected`, `orders`.`comments`, `orders`.`created_at`, `orders`.`ordertype_uuid`, `Processes`.`uuid` AS `Processes.uuid`, `Processes`.`label_de` AS `Processes.label_de`, `Processes`.`label_en` AS `Processes.label_en`, `Processes`.`created_at` AS `Processes.created_at`, `Processes`.`template_uuid` AS `Processes.template_uuid`, `Processes`.`specification_uuid` AS `Processes.specification_uuid`, `Processes.DEBUG`.`id` AS `Processes.DEBUG.id`, `Processes.DEBUG`.`created_at` AS `Processes.DEBUG.created_at`, `Processes.DEBUG`.`order_uuid` AS `Processes.DEBUG.order_uuid`, `Processes.DEBUG`.`process_uuid` AS `Processes.DEBUG.process_uuid`, `Ordertype`.`uuid` AS `Ordertype.uuid`, `Ordertype`.`name` AS `Ordertype.name`, `Ordertype`.`color` AS `Ordertype.color`, `Ordertype`.`created_at` AS `Ordertype.created_at` FROM `orders` AS `orders` LEFT OUTER JOIN `DEBUGs` AS `Processes.DEBUG` ON `orders`.`uuid` = `Processes.DEBUG`.`order_uuid` LEFT OUTER JOIN `processes` AS `Processes` ON `Processes`.`uuid` = `Processes.DEBUG`.`process_uuid` LEFT OUTER JOIN `ordertypes` AS `Ordertype` ON `orders`.`ordertype_uuid` = `Ordertype`.`uuid` WHERE `orders`.`uuid` = '412cfcf1-9326-427e-91a1-ddec60d78dd4'; 8 ms
======================= NEXT ROW =======================
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38' }
====> IF: itemHash EQUAL topHash
====> IF: !resultMap[itemHash]
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null }
====> IF: itemHash NOT EQUAL topHash
====> IF: !resultMap[itemHash]
test: undefined
====> SETTING:
prevKey: Processes.specification_uuid
$lastKeyPrefix: Processes
$parent: { uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38' }
includeMap[prevKey].association: undefined
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2Processes.DEBUG1
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' }
====> IF: itemHash NOT EQUAL topHash
====> IF: !resultMap[itemHash]
test: undefined
====> SETTING:
prevKey: Processes.DEBUG.process_uuid
$lastKeyPrefix: DEBUG
$parent: { uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null }
includeMap[prevKey].association: true
====> setting $parent[DEBUG] = values (see above) ...
======================= Current Resultmap: =======================
{ '412cfcf1-9326-427e-91a1-ddec60d78dd4':
{ uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
Processes: [ [Object] ] },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2':
{ uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null,
DEBUG:
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2Processes.DEBUG1':
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' } }
======================= NEXT ROW =======================
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38' }
====> IF: itemHash EQUAL topHash
====> IF: entry exists! next ..
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dac
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3' }
====> IF: itemHash NOT EQUAL topHash
====> IF: !resultMap[itemHash]
test: undefined
====> SETTING:
prevKey: Processes.specification_uuid
$lastKeyPrefix: Processes
$parent: { uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
Processes:
[ { uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null,
DEBUG: [Object] } ],
Ordertype:
{ uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
name: 'Aerospace',
color: 'blue',
created_at: 2017-03-29T08:53:02.766Z } }
includeMap[prevKey].association: undefined
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dacProcesses.DEBUG2
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { id: 2,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' }
====> IF: itemHash NOT EQUAL topHash
====> IF: !resultMap[itemHash]
test: undefined
====> SETTING:
prevKey: Processes.DEBUG.process_uuid
$lastKeyPrefix: DEBUG
$parent: { uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3' }
includeMap[prevKey].association: true
====> setting $parent[DEBUG] = values (see above) ...
======================= Current Resultmap: =======================
{ '412cfcf1-9326-427e-91a1-ddec60d78dd4':
{ uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
Processes: [ [Object], [Object] ],
Ordertype:
{ uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
name: 'Aerospace',
color: 'blue',
created_at: 2017-03-29T08:53:02.766Z } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2':
{ uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null,
DEBUG:
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2Processes.DEBUG1':
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Ordertype0dd8c409-6d99-4437-a2f9-08d99b385d38':
{ uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
name: 'Aerospace',
color: 'blue',
created_at: 2017-03-29T08:53:02.766Z },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dac':
{ uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3',
DEBUG:
{ id: 2,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dacProcesses.DEBUG2':
{ id: 2,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' } }
======================= NEXT ROW =======================
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38' }
====> IF: itemHash EQUAL topHash
====> IF: entry exists! next ..
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dac
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3' }
====> IF: itemHash NOT EQUAL topHash
====> IF: entry exists! next ..
===| Checking resultMap:
itemHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dacProcesses.DEBUG3
topHash: 412cfcf1-9326-427e-91a1-ddec60d78dd4
values: { id: 3,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' }
====> IF: itemHash NOT EQUAL topHash
====> IF: !resultMap[itemHash]
test: undefined
====> SETTING:
prevKey: Processes.DEBUG.process_uuid
$lastKeyPrefix: DEBUG
$parent: { uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3',
DEBUG:
{ id: 2,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' } }
includeMap[prevKey].association: true
====> setting $parent[DEBUG] = values (see above) ...
======================= Current Resultmap: =======================
{ '412cfcf1-9326-427e-91a1-ddec60d78dd4':
{ uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
Processes: [ [Object], [Object] ],
Ordertype:
{ uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
name: 'Aerospace',
color: 'blue',
created_at: 2017-03-29T08:53:02.766Z } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2':
{ uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null,
DEBUG:
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processese5176b74-fa7c-4685-8c3f-ef12843c45d2Processes.DEBUG1':
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Ordertype0dd8c409-6d99-4437-a2f9-08d99b385d38':
{ uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
name: 'Aerospace',
color: 'blue',
created_at: 2017-03-29T08:53:02.766Z },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dac':
{ uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3',
DEBUG:
{ id: 3,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' } },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dacProcesses.DEBUG2':
{ id: 2,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' },
'412cfcf1-9326-427e-91a1-ddec60d78dd4Processes276496d4-0a8a-4c08-8778-78cbe66a3dacProcesses.DEBUG3':
{ id: 3,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' } }
== SEQUELIZE DEBUG == [ { uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
contractor: 'A',
order_number: 'B',
order_date: '29.3.2017',
parts_designation: 'V',
parts_amount: 'H',
parts_drawing: '99',
delivery_wished: null,
delivery_expected: null,
comments: null,
created_at: 2017-03-29T08:53:02.755Z,
ordertype_uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
Processes: [ [Object], [Object] ],
Ordertype:
{ uuid: '0dd8c409-6d99-4437-a2f9-08d99b385d38',
name: 'Aerospace',
color: 'blue',
created_at: 2017-03-29T08:53:02.766Z } } ]
== SEQUELIZE DEBUG == [ { uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2',
label_de: 'Wareneingangskontrolle',
label_en: 'Incoming Inspection',
created_at: 2017-03-29T08:53:02.783Z,
template_uuid: null,
specification_uuid: null,
DEBUG:
{ id: 1,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: 'e5176b74-fa7c-4685-8c3f-ef12843c45d2' } },
{ uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac',
label_de: 'Hartverchromen',
label_en: 'Hard chrome plating',
created_at: 2017-03-29T08:53:02.785Z,
template_uuid: null,
specification_uuid: '609020b0-6f16-4418-a14d-c0bf03cae9b3',
DEBUG:
{ id: 3,
created_at: 2017-03-29T08:53:02.879Z,
order_uuid: '412cfcf1-9326-427e-91a1-ddec60d78dd4',
process_uuid: '276496d4-0a8a-4c08-8778-78cbe66a3dac' } } ]
GET /orders/412cfcf1-9326-427e-91a1-ddec60d78dd4 200 28.859 ms - 1749
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment