Created
January 25, 2019 03:44
-
-
Save khyperia/c4f6503069bef9e5af97d222a9bfb9a8 to your computer and use it in GitHub Desktop.
log for localhost:8282/uber/accounts/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2019-01-24 19:40:07.383 PST [18895] LOG: statement: BEGIN | |
2019-01-24 19:40:07.384 PST [18895] LOG: statement: SELECT admin_account.id AS admin_account_id, admin_account.attendee_id AS admin_account_attendee_id, admin_account.hashed AS admin_account_hashed, admin_account.access AS admin_account_access | |
FROM admin_account | |
WHERE admin_account.id = '7b673777-0442-44c9-a43c-870c51d219e4'::uuid | |
2019-01-24 19:40:07.386 PST [18895] LOG: statement: COMMIT | |
2019-01-24 19:40:07.394 PST [18894] LOG: statement: BEGIN | |
2019-01-24 19:40:07.394 PST [18894] LOG: statement: SELECT attendee.id AS attendee_id, CASE WHEN (attendee.first_name IS NULL OR attendee.first_name = '') THEN 'zzz' ELSE lower(attendee.last_name || ', ' || attendee.first_name) END AS last_first, attendee.badge_type AS attendee_badge_type, attendee.badge_num AS attendee_badge_num | |
FROM attendee | |
WHERE attendee.first_name != '' | |
2019-01-24 19:40:07.411 PST [18894] LOG: statement: SELECT admin_account.id AS admin_account_id, admin_account.attendee_id AS admin_account_attendee_id, admin_account.hashed AS admin_account_hashed, admin_account.access AS admin_account_access | |
FROM admin_account JOIN attendee ON attendee.id = admin_account.attendee_id ORDER BY CASE WHEN (attendee.first_name IS NULL OR attendee.first_name = '') THEN 'zzz' ELSE lower(attendee.last_name || ', ' || attendee.first_name) END | |
2019-01-24 19:40:07.424 PST [18894] LOG: statement: SELECT attendee.id AS attendee_id, attendee.watchlist_id AS attendee_watchlist_id, attendee.group_id AS attendee_group_id, attendee.promo_code_id AS attendee_promo_code_id, attendee.placeholder AS attendee_placeholder, attendee.first_name AS attendee_first_name, attendee.last_name AS attendee_last_name, attendee.legal_name AS attendee_legal_name, attendee.email AS attendee_email, attendee.birthdate AS attendee_birthdate, attendee.age_group AS attendee_age_group, attendee.international AS attendee_international, attendee.zip_code AS attendee_zip_code, attendee.address1 AS attendee_address1, attendee.address2 AS attendee_address2, attendee.city AS attendee_city, attendee.region AS attendee_region, attendee.country AS attendee_country, attendee.no_cellphone AS attendee_no_cellphone, attendee.ec_name AS attendee_ec_name, attendee.ec_phone AS attendee_ec_phone, attendee.cellphone AS attendee_cellphone, attendee.requested_hotel_info AS attendee_requested_hotel_info, attendee.requested_accessibility_services AS attendee_requested_accessibility_services, attendee.interests AS attendee_interests, attendee.found_how AS attendee_found_how, attendee.comments AS attendee_comments, attendee.for_review AS attendee_for_review, attendee.admin_notes AS attendee_admin_notes, attendee.public_id AS attendee_public_id, attendee.badge_num AS attendee_badge_num, attendee.badge_type AS attendee_badge_type, attendee.badge_status AS attendee_badge_status, attendee.ribbon AS attendee_ribbon, attendee.affiliate AS attendee_affiliate, attendee.shirt AS attendee_shirt, attendee.second_shirt AS attendee_second_shirt, attendee.can_spam AS attendee_can_spam, attendee.regdesk_info AS attendee_regdesk_info, attendee.extra_merch AS attendee_extra_merch, attendee.got_merch AS attendee_got_merch, attendee.got_staff_merch AS attendee_got_staff_merch, attendee.got_swadge AS attendee_got_swadge, attendee.reg_station AS attendee_reg_station, attendee.registered AS attendee_registered, attendee.confirmed AS attendee_confirmed, attendee.checked_in AS attendee_checked_in, attendee.paid AS attendee_paid, attendee.overridden_price AS attendee_overridden_price, attendee.base_badge_price AS attendee_base_badge_price, attendee.amount_paid AS attendee_amount_paid, attendee.amount_extra AS attendee_amount_extra, attendee.extra_donation AS attendee_extra_donation, attendee.payment_method AS attendee_payment_method, attendee.amount_refunded AS attendee_amount_refunded, attendee.badge_printed_name AS attendee_badge_printed_name, attendee.staffing AS attendee_staffing, attendee.agreed_to_volunteer_agreement AS attendee_agreed_to_volunteer_agreement, attendee.nonshift_hours AS attendee_nonshift_hours, attendee.past_years AS attendee_past_years, attendee.can_work_setup AS attendee_can_work_setup, attendee.can_work_teardown AS attendee_can_work_teardown, attendee.hotel_eligible AS attendee_hotel_eligible, attendee.hotel_pin AS attendee_hotel_pin, attendee.notification_pref AS attendee_notification_pref, attendee.attractions_opt_out AS attendee_attractions_opt_out, anon_1.admin_account_attendee_id AS anon_1_admin_account_attendee_id | |
FROM (SELECT DISTINCT admin_account.attendee_id AS admin_account_attendee_id | |
FROM admin_account JOIN attendee ON attendee.id = admin_account.attendee_id) AS anon_1 JOIN attendee ON attendee.id = anon_1.admin_account_attendee_id ORDER BY anon_1.admin_account_attendee_id | |
2019-01-24 19:40:07.428 PST [18894] LOG: statement: SELECT department.id AS department_id, department.name AS department_name, department.description AS department_description, department.solicits_volunteers AS department_solicits_volunteers, department.is_shiftless AS department_is_shiftless, department.parent_id AS department_parent_id, department.is_setup_approval_exempt AS department_is_setup_approval_exempt, department.is_teardown_approval_exempt AS department_is_teardown_approval_exempt, department.max_consecutive_hours AS department_max_consecutive_hours, attendee_1.id AS attendee_1_id | |
FROM (SELECT DISTINCT admin_account.attendee_id AS admin_account_attendee_id | |
FROM admin_account JOIN attendee ON attendee.id = admin_account.attendee_id) AS anon_1 JOIN attendee AS attendee_1 ON attendee_1.id = anon_1.admin_account_attendee_id JOIN dept_membership AS dept_membership_1 ON attendee_1.id = dept_membership_1.attendee_id JOIN department ON department.id = dept_membership_1.department_id ORDER BY attendee_1.id, department.name | |
2019-01-24 19:40:07.449 PST [18895] LOG: statement: BEGIN | |
2019-01-24 19:40:07.449 PST [18895] LOG: statement: SELECT admin_account.id AS admin_account_id, admin_account.attendee_id AS admin_account_attendee_id, admin_account.hashed AS admin_account_hashed, admin_account.access AS admin_account_access | |
FROM admin_account | |
WHERE admin_account.id = '7b673777-0442-44c9-a43c-870c51d219e4'::uuid | |
2019-01-24 19:40:07.456 PST [18895] LOG: statement: SELECT attendee.id AS attendee_id, attendee.watchlist_id AS attendee_watchlist_id, attendee.group_id AS attendee_group_id, attendee.promo_code_id AS attendee_promo_code_id, attendee.placeholder AS attendee_placeholder, attendee.first_name AS attendee_first_name, attendee.last_name AS attendee_last_name, attendee.legal_name AS attendee_legal_name, attendee.email AS attendee_email, attendee.birthdate AS attendee_birthdate, attendee.age_group AS attendee_age_group, attendee.international AS attendee_international, attendee.zip_code AS attendee_zip_code, attendee.address1 AS attendee_address1, attendee.address2 AS attendee_address2, attendee.city AS attendee_city, attendee.region AS attendee_region, attendee.country AS attendee_country, attendee.no_cellphone AS attendee_no_cellphone, attendee.ec_name AS attendee_ec_name, attendee.ec_phone AS attendee_ec_phone, attendee.cellphone AS attendee_cellphone, attendee.requested_hotel_info AS attendee_requested_hotel_info, attendee.requested_accessibility_services AS attendee_requested_accessibility_services, attendee.interests AS attendee_interests, attendee.found_how AS attendee_found_how, attendee.comments AS attendee_comments, attendee.for_review AS attendee_for_review, attendee.admin_notes AS attendee_admin_notes, attendee.public_id AS attendee_public_id, attendee.badge_num AS attendee_badge_num, attendee.badge_type AS attendee_badge_type, attendee.badge_status AS attendee_badge_status, attendee.ribbon AS attendee_ribbon, attendee.affiliate AS attendee_affiliate, attendee.shirt AS attendee_shirt, attendee.second_shirt AS attendee_second_shirt, attendee.can_spam AS attendee_can_spam, attendee.regdesk_info AS attendee_regdesk_info, attendee.extra_merch AS attendee_extra_merch, attendee.got_merch AS attendee_got_merch, attendee.got_staff_merch AS attendee_got_staff_merch, attendee.got_swadge AS attendee_got_swadge, attendee.reg_station AS attendee_reg_station, attendee.registered AS attendee_registered, attendee.confirmed AS attendee_confirmed, attendee.checked_in AS attendee_checked_in, attendee.paid AS attendee_paid, attendee.overridden_price AS attendee_overridden_price, attendee.base_badge_price AS attendee_base_badge_price, attendee.amount_paid AS attendee_amount_paid, attendee.amount_extra AS attendee_amount_extra, attendee.extra_donation AS attendee_extra_donation, attendee.payment_method AS attendee_payment_method, attendee.amount_refunded AS attendee_amount_refunded, attendee.badge_printed_name AS attendee_badge_printed_name, attendee.staffing AS attendee_staffing, attendee.agreed_to_volunteer_agreement AS attendee_agreed_to_volunteer_agreement, attendee.nonshift_hours AS attendee_nonshift_hours, attendee.past_years AS attendee_past_years, attendee.can_work_setup AS attendee_can_work_setup, attendee.can_work_teardown AS attendee_can_work_teardown, attendee.hotel_eligible AS attendee_hotel_eligible, attendee.hotel_pin AS attendee_hotel_pin, attendee.notification_pref AS attendee_notification_pref, attendee.attractions_opt_out AS attendee_attractions_opt_out, anon_1.admin_account_attendee_id AS anon_1_admin_account_attendee_id | |
FROM (SELECT DISTINCT admin_account.attendee_id AS admin_account_attendee_id | |
FROM admin_account | |
WHERE admin_account.id = '7b673777-0442-44c9-a43c-870c51d219e4'::uuid) AS anon_1 JOIN attendee ON attendee.id = anon_1.admin_account_attendee_id ORDER BY anon_1.admin_account_attendee_id | |
2019-01-24 19:40:07.459 PST [18895] LOG: statement: SELECT department.id AS department_id, department.name AS department_name, department.description AS department_description, department.solicits_volunteers AS department_solicits_volunteers, department.is_shiftless AS department_is_shiftless, department.parent_id AS department_parent_id, department.is_setup_approval_exempt AS department_is_setup_approval_exempt, department.is_teardown_approval_exempt AS department_is_teardown_approval_exempt, department.max_consecutive_hours AS department_max_consecutive_hours, attendee_1.id AS attendee_1_id | |
FROM (SELECT DISTINCT admin_account.attendee_id AS admin_account_attendee_id | |
FROM admin_account | |
WHERE admin_account.id = '7b673777-0442-44c9-a43c-870c51d219e4'::uuid) AS anon_1 JOIN attendee AS attendee_1 ON attendee_1.id = anon_1.admin_account_attendee_id JOIN dept_membership AS dept_membership_1 ON attendee_1.id = dept_membership_1.attendee_id JOIN department ON department.id = dept_membership_1.department_id ORDER BY attendee_1.id, department.name | |
2019-01-24 19:40:07.461 PST [18895] LOG: statement: SELECT admin_account.id AS admin_account_id, admin_account.attendee_id AS admin_account_attendee_id, admin_account.hashed AS admin_account_hashed, admin_account.access AS admin_account_access | |
FROM admin_account | |
WHERE 'd6000fe6-2f8e-4b34-8d0d-86ac0f501fb0'::uuid = admin_account.attendee_id | |
2019-01-24 19:40:07.461 PST [18895] LOG: statement: COMMIT | |
2019-01-24 19:40:07.463 PST [18895] LOG: statement: BEGIN | |
2019-01-24 19:40:07.463 PST [18895] LOG: statement: SELECT admin_account.id AS admin_account_id, admin_account.attendee_id AS admin_account_attendee_id, admin_account.hashed AS admin_account_hashed, admin_account.access AS admin_account_access | |
FROM admin_account | |
WHERE admin_account.id = '7b673777-0442-44c9-a43c-870c51d219e4'::uuid | |
2019-01-24 19:40:07.463 PST [18895] LOG: statement: COMMIT | |
2019-01-24 19:40:07.464 PST [18895] LOG: statement: BEGIN | |
2019-01-24 19:40:07.464 PST [18895] LOG: statement: SELECT admin_account.id AS admin_account_id, admin_account.attendee_id AS admin_account_attendee_id, admin_account.hashed AS admin_account_hashed, admin_account.access AS admin_account_access | |
FROM admin_account | |
WHERE admin_account.id = '7b673777-0442-44c9-a43c-870c51d219e4'::uuid | |
2019-01-24 19:40:07.465 PST [18895] LOG: statement: COMMIT | |
2019-01-24 19:40:07.465 PST [18894] LOG: statement: COMMIT |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment