Skip to content

Instantly share code, notes, and snippets.

@khyperia
Created January 25, 2019 03:44
Show Gist options
  • Save khyperia/c4f6503069bef9e5af97d222a9bfb9a8 to your computer and use it in GitHub Desktop.
Save khyperia/c4f6503069bef9e5af97d222a9bfb9a8 to your computer and use it in GitHub Desktop.
log for localhost:8282/uber/accounts/
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