AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AssertionError: assert 3 == 4 + where 3 = len([{'can_be_asynchronously_retried': True, 'event_name': 'user_identity_check_started', 'event_payload': {'type': 'dms'}, 'user_id': 203}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:03', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:03', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'ANDROID', 'can_be_asynchronously_retried': True, 'user_id': 203}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:03', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:03', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'IOS', 'can_be_asynchronously_retried': True, 'user_id': 203}]) + where [{'can_be_asynchronously_retried': True, 'event_name': 'user_identity_check_started', 'event_payload': {'type': 'dms'}, 'user_id': 203}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:03', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:03', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'ANDROID', 'can_be_asynchronously_retried': True, 'user_id': 203}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:03', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:03', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'IOS', 'can_be_asynchronously_retried': True, 'user_id': 203}] = push_testing.requests

AssertionError: assert 3 == 4 + where 3 = len([{'can_be_asynchronously_retried': True, 'event_name': 'user_identity_check_started', 'event_payload': {'type': 'dms'}, 'user_id': 209}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:04', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:04', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'ANDROID', 'can_be_asynchronously_retried': True, 'user_id': 209}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:04', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:04', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'IOS', 'can_be_asynchronously_retried': True, 'user_id': 209}]) + where [{'can_be_asynchronously_retried': True, 'event_name': 'user_identity_check_started', 'event_payload': {'type': 'dms'}, 'user_id': 209}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:04', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:04', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'ANDROID', 'can_be_asynchronously_retried': True, 'user_id': 209}, {'attribute_values': {'date(u.date_created)': '2025-02-06T16:48:04', 'date(u.date_of_birth)': '2007-02-06T00:00:00', 'date(u.deposit_activation_date)': '2025-02-06T16:48:04', 'date(u.deposit_expiration_date)': '2028-02-06T00:00:00', ...}, 'batch_api': 'IOS', 'can_be_asynchronously_retried': True, 'user_id': 209}] = push_testing.requests

❌ Tests reported 3 failures

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

❌ Tests reported 79 failures

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

assert [<LogRecord: celery.app.trace, 20, /usr/src/app/src/pcapi/core/logging.py, 151, "Task %(name)s[%(id)s] succeeded in %(runtime)ss: %(return_value)s">] == [] Left contains one more item: <LogRecord: celery.app.trace, 20, /usr/src/app/src/pcapi/core/logging.py, 151, "Task %(name)s[%(id)s] succeeded in %(runtime)ss: %(return_value)s"> Full diff: - [] + [ + <LogRecord: celery.app.trace, 20, /usr/src/app/src/pcapi/core/logging.py, 151, "Task %(name)s[%(id)s] succeeded in %(runtime)ss: %(return_value)s">, + ]

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AssertionError: {'msg': 'an error occured during ubble v2 workflow update'} assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

❌ Tests reported 50 failures

assert 0 == 1 + where 0 = len([]) + where [] = mails_testing.outbox

assert 0 == 1 + where 0 = len([]) + where [] = mails_testing.outbox

assert 0 == 1 + where 0 = len([]) + where [] = mails_testing.outbox

assert 0 == 1 + where 0 = len([]) + where [] = mails_testing.outbox

assert 0 == 1 + where 0 = len([]) + where [] = mails_testing.outbox

❌ Tests reported 5 failures

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AttributeError: 'dict' object has no attribute 'use_pro_subaccount'

assert 0 == 1 + where 0 = len([]) + where [] = mails_testing.outbox

assert 0 == 1 + where 0 = len([]) + where [] = users_testing.sendinblue_requests

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AssertionError: {'global': ['Il semble que nous ayons des problèmes techniques :( On répare ça au plus vite.']} assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AssertionError: {'global': ['Il semble que nous ayons des problèmes techniques :( On répare ça au plus vite.']} assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AssertionError: {'global': ['Il semble que nous ayons des problèmes techniques :( On répare ça au plus vite.']} assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

KeyError: 'refreshToken'

KeyError: 'refreshToken'

KeyError: 'refreshToken'

KeyError: 'refreshToken'

KeyError: 'refreshToken'

KeyError: 'refreshToken'

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

Failed: 19 queries executed, 25 expected Captured queries were: 1. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 44 2. SELECT "user"."phoneNumber" AS "user_phoneNumber", "user"."isActive" AS "user_isActive", "user".id AS user_id, "user".activity AS user_activity, "user".address AS user_address, "user".city AS user_city, "user".civility AS user_civility, "user".comment AS user_comment, "user"."culturalSurveyFilledDate" AS "user_culturalSurveyFilledDate", "user"."culturalSurveyId" AS "user_culturalSurveyId", "user"."dateCreated" AS "user_dateCreated", "user"."dateOfBirth" AS "user_dateOfBirth", "user"."departementCode" AS "user_departementCode", "user".email AS user_email, "user"."externalIds" AS "user_externalIds", "user"."extraData" AS "user_extraData", "user"."firstName" AS "user_firstName", "user"."hasSeenProTutorials" AS "user_hasSeenProTutorials", "user"."hasSeenProRgs" AS "user_hasSeenProRgs", "user"."idPieceNumber" AS "user_idPieceNumber", "user"."ineHash" AS "user_ineHash", "user"."irisFranceId" AS "user_irisFranceId", "user"."isEmailValidated" AS "user_isEmailValidated", "user"."lastConnectionDate" AS "user_lastConnectionDate", "user"."lastName" AS "user_lastName", "user".married_name AS user_married_name, "user"."needsToFillCulturalSurvey" AS "user_needsToFillCulturalSurvey", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", "user".password AS user_password, "user"."phoneValidationStatus" AS "user_phoneValidationStatus", "user"."postalCode" AS "user_postalCode", "user"."recreditAmountToShow" AS "user_recreditAmountToShow", "user".roles AS user_roles, "user"."schoolType" AS "user_schoolType", "user"."validatedBirthDate" AS "user_validatedBirthDate" FROM "user" WHERE lower("user".email) = pascal.ture@example.com 3. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 44 AND booking."userId" = 513 LIMIT 1 4. SELECT stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.ean AS offer_1_ean, offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId" FROM stock JOIN offer AS offer_1 ON offer_1.id = stock."offerId" WHERE stock.id = 64 FOR UPDATE 5. SELECT booking.id, booking."dateCreated", booking."dateUsed", booking."stockId", booking."venueId", booking."offererId", booking.quantity, booking.token, booking."userId", booking.amount, booking."priceCategoryLabel", booking."cancellationDate", booking."displayAsEnded", booking."cancellationLimitDate", booking."cancellationReason", booking."cancellationUserId", booking.status, booking."validationAuthorType", booking."reimbursementDate", booking."depositId" FROM booking WHERE booking.id = 44 6. SELECT finance_event.id AS finance_event_id, finance_event."creationDate" AS "finance_event_creationDate", finance_event."valueDate" AS "finance_event_valueDate", finance_event."pricingOrderingDate" AS "finance_event_pricingOrderingDate", finance_event.status AS finance_event_status, finance_event.motive AS finance_event_motive, finance_event."bookingId" AS "finance_event_bookingId", finance_event."collectiveBookingId" AS "finance_event_collectiveBookingId", finance_event."bookingFinanceIncidentId" AS "finance_event_bookingFinanceIncidentId", finance_event."venueId" AS "finance_event_venueId", finance_event."pricingPointId" AS "finance_event_pricingPointId" FROM finance_event WHERE 44 = finance_event."bookingId" AND finance_event.motive IN (booking-used, booking-used-after-cancellation) AND finance_event.status IN (priced, pending, ready) 7. SELECT external_booking.id AS external_booking_id, external_booking."bookingId" AS "external_booking_bookingId", external_booking.barcode AS external_booking_barcode, external_booking.seat AS external_booking_seat, external_booking.additional_information AS external_booking_additional_information FROM external_booking WHERE 44 = external_booking."bookingId" 8. SELECT activation_code.id AS activation_code_id, activation_code."bookingId" AS "activation_code_bookingId", activation_code.code AS activation_code_code, activation_code."expirationDate" AS "activation_code_expirationDate", activation_code."stockId" AS "activation_code_stockId" FROM activation_code WHERE 44 = activation_code."bookingId" 9. UPDATE stock SET "dnBookedQuantity"=0 WHERE stock.id = 64 10. UPDATE booking SET "cancellationDate"=2025-02-06 16:48:55.675609, "cancellationReason"=BENEFICIARY, status=CANCELLED WHERE booking.id = 44 11. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 44 12. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.ean AS offer_1_ean, offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId", stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", user_1."phoneNumber" AS "user_1_phoneNumber", user_1."isActive" AS "user_1_isActive", user_1.id AS user_1_id, user_1.activity AS user_1_activity, user_1.address AS user_1_address, user_1.city AS user_1_city, user_1.civility AS user_1_civility, user_1.comment AS user_1_comment, user_1."culturalSurveyFilledDate" AS "user_1_culturalSurveyFilledDate", user_1."culturalSurveyId" AS "user_1_culturalSurveyId", user_1."dateCreated" AS "user_1_dateCreated", user_1."dateOfBirth" AS "user_1_dateOfBirth", user_1."departementCode" AS "user_1_departementCode", user_1.email AS user_1_email, user_1."externalIds" AS "user_1_externalIds", user_1."extraData" AS "user_1_extraData", user_1."firstName" AS "user_1_firstName", user_1."hasSeenProTutorials" AS "user_1_hasSeenProTutorials", user_1."hasSeenProRgs" AS "user_1_hasSeenProRgs", user_1."idPieceNumber" AS "user_1_idPieceNumber", user_1."ineHash" AS "user_1_ineHash", user_1."irisFranceId" AS "user_1_irisFranceId", user_1."isEmailValidated" AS "user_1_isEmailValidated", user_1."lastConnectionDate" AS "user_1_lastConnectionDate", user_1."lastName" AS "user_1_lastName", user_1.married_name AS user_1_married_name, user_1."needsToFillCulturalSurvey" AS "user_1_needsToFillCulturalSurvey", user_1."notificationSubscriptions" AS "user_1_notificationSubscriptions", user_1.password AS user_1_password, user_1."phoneValidationStatus" AS "user_1_phoneValidationStatus", user_1."postalCode" AS "user_1_postalCode", user_1."recreditAmountToShow" AS "user_1_recreditAmountToShow", user_1.roles AS user_1_roles, user_1."schoolType" AS "user_1_schoolType", user_1."validatedBirthDate" AS "user_1_validatedBirthDate", deposit_1.id AS deposit_1_id, deposit_1.amount AS deposit_1_amount, deposit_1."userId" AS "deposit_1_userId", deposit_1.source AS deposit_1_source, deposit_1."dateCreated" AS "deposit_1_dateCreated", deposit_1."dateUpdated" AS "deposit_1_dateUpdated", deposit_1."expirationDate" AS "deposit_1_expirationDate", deposit_1.version AS deposit_1_version, deposit_1.type AS deposit_1_type, external_booking_1.id AS external_booking_1_id, external_booking_1."bookingId" AS "external_booking_1_bookingId", external_booking_1.barcode AS external_booking_1_barcode, external_booking_1.seat AS external_booking_1_seat, external_booking_1.additional_information AS external_booking_1_additional_information FROM booking JOIN stock AS stock_1 ON stock_1.id = booking."stockId" JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" JOIN "user" AS user_1 ON user_1.id = booking."userId" LEFT OUTER JOIN deposit AS deposit_1 ON user_1.id = deposit_1."userId" LEFT OUTER JOIN external_booking AS external_booking_1 ON booking.id = external_booking_1."bookingId" WHERE booking.id = 44 13. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.ean AS offer_1_ean, offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId", stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", finance_incident_1.id AS finance_incident_1_id, finance_incident_1.kind AS finance_incident_1_kind, finance_incident_1.status AS finance_incident_1_status, finance_incident_1."venueId" AS "finance_incident_1_venueId", finance_incident_1.details AS finance_incident_1_details, finance_incident_1."forceDebitNote" AS "finance_incident_1_forceDebitNote", booking_finance_incident_1.id AS booking_finance_incident_1_id, booking_finance_incident_1."bookingId" AS "booking_finance_incident_1_bookingId", booking_finance_incident_1."collectiveBookingId" AS "booking_finance_incident_1_collectiveBookingId", booking_finance_incident_1."incidentId" AS "booking_finance_incident_1_incidentId", booking_finance_incident_1."beneficiaryId" AS "booking_finance_incident_1_beneficiaryId", booking_finance_incident_1."newTotalAmount" AS "booking_finance_incident_1_newTotalAmount" FROM booking LEFT OUTER JOIN stock AS stock_1 ON stock_1.id = booking."stockId" LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" LEFT OUTER JOIN booking_finance_incident AS booking_finance_incident_1 ON booking.id = booking_finance_incident_1."bookingId" LEFT OUTER JOIN finance_incident AS finance_incident_1 ON finance_incident_1.id = booking_finance_incident_1."incidentId" WHERE booking."depositId" = 107 AND booking.status != CANCELLED 14. SELECT provider."isActive" AS "provider_isActive", provider.id AS provider_id, provider.name AS provider_name, provider."localClass" AS "provider_localClass", provider."enabledForPro" AS "provider_enabledForPro", provider."enableParallelSynchronization" AS "provider_enableParallelSynchronization", provider."logoUrl" AS "provider_logoUrl", provider."bookingExternalUrl" AS "provider_bookingExternalUrl", provider."cancelExternalUrl" AS "provider_cancelExternalUrl", provider."notificationExternalUrl" AS "provider_notificationExternalUrl", provider."hmacKey" AS "provider_hmacKey", provider."pricesInCents" AS "provider_pricesInCents" FROM provider WHERE provider.id IS NULL AND provider."isActive" = true AND provider."enabledForPro" = true 15. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1."jsonData" AS "offer_1_jsonData", offer_1.id AS offer_1_id, offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", venue_1.id AS venue_1_id, venue_1."isVirtual" AS "venue_1_isVirtual", finance_incident_1.id AS finance_incident_1_id, finance_incident_1.kind AS finance_incident_1_kind, finance_incident_1.status AS finance_incident_1_status, finance_incident_1."venueId" AS "finance_incident_1_venueId", finance_incident_1.details AS finance_incident_1_details, finance_incident_1."forceDebitNote" AS "finance_incident_1_forceDebitNote", booking_finance_incident_1.id AS booking_finance_incident_1_id, booking_finance_incident_1."bookingId" AS "booking_finance_incident_1_bookingId", booking_finance_incident_1."collectiveBookingId" AS "booking_finance_incident_1_collectiveBookingId", booking_finance_incident_1."incidentId" AS "booking_finance_incident_1_incidentId", booking_finance_incident_1."beneficiaryId" AS "booking_finance_incident_1_beneficiaryId", booking_finance_incident_1."newTotalAmount" AS "booking_finance_incident_1_newTotalAmount" FROM booking LEFT OUTER JOIN stock AS stock_1 ON stock_1.id = booking."stockId" LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" LEFT OUTER JOIN venue AS venue_1 ON venue_1.id = booking."venueId" LEFT OUTER JOIN booking_finance_incident AS booking_finance_incident_1 ON booking.id = booking_finance_incident_1."bookingId" LEFT OUTER JOIN finance_incident AS finance_incident_1 ON finance_incident_1.id = booking_finance_incident_1."incidentId" WHERE booking."userId" = 513 AND booking.status != CANCELLED ORDER BY booking."dateCreated" DESC 16. SELECT favorite.id AS favorite_id, favorite."userId" AS "favorite_userId", favorite."offerId" AS "favorite_offerId", favorite."dateCreated" AS "favorite_dateCreated", offer_1.id AS offer_1_id, offer_1."subcategoryId" AS "offer_1_subcategoryId" FROM favorite LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = favorite."offerId" WHERE favorite."userId" = 513 ORDER BY favorite.id DESC 17. SELECT get_wallet_balance(513, False) AS get_wallet_balance_1 18. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 19. SELECT action_history."jsonData" AS "action_history_jsonData", action_history.id AS action_history_id, action_history."actionType" AS "action_history_actionType", action_history."actionDate" AS "action_history_actionDate", action_history."authorUserId" AS "action_history_authorUserId", action_history."userId" AS "action_history_userId", action_history."offererId" AS "action_history_offererId", action_history."venueId" AS "action_history_venueId", action_history."financeIncidentId" AS "action_history_financeIncidentId", action_history."bankAccountId" AS "action_history_bankAccountId", action_history."ruleId" AS "action_history_ruleId", action_history."chronicleId" AS "action_history_chronicleId", action_history.comment AS action_history_comment FROM action_history WHERE 513 = action_history."userId" ORDER BY action_history."actionDate" ASC NULLS FIRST

Failed: 19 queries executed, 25 expected Captured queries were: 1. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 45 2. SELECT "user"."phoneNumber" AS "user_phoneNumber", "user"."isActive" AS "user_isActive", "user".id AS user_id, "user".activity AS user_activity, "user".address AS user_address, "user".city AS user_city, "user".civility AS user_civility, "user".comment AS user_comment, "user"."culturalSurveyFilledDate" AS "user_culturalSurveyFilledDate", "user"."culturalSurveyId" AS "user_culturalSurveyId", "user"."dateCreated" AS "user_dateCreated", "user"."dateOfBirth" AS "user_dateOfBirth", "user"."departementCode" AS "user_departementCode", "user".email AS user_email, "user"."externalIds" AS "user_externalIds", "user"."extraData" AS "user_extraData", "user"."firstName" AS "user_firstName", "user"."hasSeenProTutorials" AS "user_hasSeenProTutorials", "user"."hasSeenProRgs" AS "user_hasSeenProRgs", "user"."idPieceNumber" AS "user_idPieceNumber", "user"."ineHash" AS "user_ineHash", "user"."irisFranceId" AS "user_irisFranceId", "user"."isEmailValidated" AS "user_isEmailValidated", "user"."lastConnectionDate" AS "user_lastConnectionDate", "user"."lastName" AS "user_lastName", "user".married_name AS user_married_name, "user"."needsToFillCulturalSurvey" AS "user_needsToFillCulturalSurvey", "user"."notificationSubscriptions" AS "user_notificationSubscriptions", "user".password AS user_password, "user"."phoneValidationStatus" AS "user_phoneValidationStatus", "user"."postalCode" AS "user_postalCode", "user"."recreditAmountToShow" AS "user_recreditAmountToShow", "user".roles AS user_roles, "user"."schoolType" AS "user_schoolType", "user"."validatedBirthDate" AS "user_validatedBirthDate" FROM "user" WHERE lower("user".email) = pascal.ture@example.com 3. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 45 AND booking."userId" = 514 LIMIT 1 4. SELECT stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.ean AS offer_1_ean, offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId" FROM stock JOIN offer AS offer_1 ON offer_1.id = stock."offerId" WHERE stock.id = 65 FOR UPDATE 5. SELECT booking.id, booking."dateCreated", booking."dateUsed", booking."stockId", booking."venueId", booking."offererId", booking.quantity, booking.token, booking."userId", booking.amount, booking."priceCategoryLabel", booking."cancellationDate", booking."displayAsEnded", booking."cancellationLimitDate", booking."cancellationReason", booking."cancellationUserId", booking.status, booking."validationAuthorType", booking."reimbursementDate", booking."depositId" FROM booking WHERE booking.id = 45 6. SELECT finance_event.id AS finance_event_id, finance_event."creationDate" AS "finance_event_creationDate", finance_event."valueDate" AS "finance_event_valueDate", finance_event."pricingOrderingDate" AS "finance_event_pricingOrderingDate", finance_event.status AS finance_event_status, finance_event.motive AS finance_event_motive, finance_event."bookingId" AS "finance_event_bookingId", finance_event."collectiveBookingId" AS "finance_event_collectiveBookingId", finance_event."bookingFinanceIncidentId" AS "finance_event_bookingFinanceIncidentId", finance_event."venueId" AS "finance_event_venueId", finance_event."pricingPointId" AS "finance_event_pricingPointId" FROM finance_event WHERE 45 = finance_event."bookingId" AND finance_event.motive IN (booking-used, booking-used-after-cancellation) AND finance_event.status IN (priced, pending, ready) 7. SELECT external_booking.id AS external_booking_id, external_booking."bookingId" AS "external_booking_bookingId", external_booking.barcode AS external_booking_barcode, external_booking.seat AS external_booking_seat, external_booking.additional_information AS external_booking_additional_information FROM external_booking WHERE 45 = external_booking."bookingId" 8. SELECT activation_code.id AS activation_code_id, activation_code."bookingId" AS "activation_code_bookingId", activation_code.code AS activation_code_code, activation_code."expirationDate" AS "activation_code_expirationDate", activation_code."stockId" AS "activation_code_stockId" FROM activation_code WHERE 45 = activation_code."bookingId" 9. UPDATE stock SET "dnBookedQuantity"=0 WHERE stock.id = 65 10. UPDATE booking SET "cancellationDate"=2025-02-06 16:48:56.514477, "cancellationReason"=BENEFICIARY, status=CANCELLED WHERE booking.id = 45 11. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId" FROM booking WHERE booking.id = 45 12. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.ean AS offer_1_ean, offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId", stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", user_1."phoneNumber" AS "user_1_phoneNumber", user_1."isActive" AS "user_1_isActive", user_1.id AS user_1_id, user_1.activity AS user_1_activity, user_1.address AS user_1_address, user_1.city AS user_1_city, user_1.civility AS user_1_civility, user_1.comment AS user_1_comment, user_1."culturalSurveyFilledDate" AS "user_1_culturalSurveyFilledDate", user_1."culturalSurveyId" AS "user_1_culturalSurveyId", user_1."dateCreated" AS "user_1_dateCreated", user_1."dateOfBirth" AS "user_1_dateOfBirth", user_1."departementCode" AS "user_1_departementCode", user_1.email AS user_1_email, user_1."externalIds" AS "user_1_externalIds", user_1."extraData" AS "user_1_extraData", user_1."firstName" AS "user_1_firstName", user_1."hasSeenProTutorials" AS "user_1_hasSeenProTutorials", user_1."hasSeenProRgs" AS "user_1_hasSeenProRgs", user_1."idPieceNumber" AS "user_1_idPieceNumber", user_1."ineHash" AS "user_1_ineHash", user_1."irisFranceId" AS "user_1_irisFranceId", user_1."isEmailValidated" AS "user_1_isEmailValidated", user_1."lastConnectionDate" AS "user_1_lastConnectionDate", user_1."lastName" AS "user_1_lastName", user_1.married_name AS user_1_married_name, user_1."needsToFillCulturalSurvey" AS "user_1_needsToFillCulturalSurvey", user_1."notificationSubscriptions" AS "user_1_notificationSubscriptions", user_1.password AS user_1_password, user_1."phoneValidationStatus" AS "user_1_phoneValidationStatus", user_1."postalCode" AS "user_1_postalCode", user_1."recreditAmountToShow" AS "user_1_recreditAmountToShow", user_1.roles AS user_1_roles, user_1."schoolType" AS "user_1_schoolType", user_1."validatedBirthDate" AS "user_1_validatedBirthDate", deposit_1.id AS deposit_1_id, deposit_1.amount AS deposit_1_amount, deposit_1."userId" AS "deposit_1_userId", deposit_1.source AS deposit_1_source, deposit_1."dateCreated" AS "deposit_1_dateCreated", deposit_1."dateUpdated" AS "deposit_1_dateUpdated", deposit_1."expirationDate" AS "deposit_1_expirationDate", deposit_1.version AS deposit_1_version, deposit_1.type AS deposit_1_type, external_booking_1.id AS external_booking_1_id, external_booking_1."bookingId" AS "external_booking_1_bookingId", external_booking_1.barcode AS external_booking_1_barcode, external_booking_1.seat AS external_booking_1_seat, external_booking_1.additional_information AS external_booking_1_additional_information FROM booking JOIN stock AS stock_1 ON stock_1.id = booking."stockId" JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" JOIN "user" AS user_1 ON user_1.id = booking."userId" LEFT OUTER JOIN deposit AS deposit_1 ON user_1.id = deposit_1."userId" LEFT OUTER JOIN external_booking AS external_booking_1 ON booking.id = external_booking_1."bookingId" WHERE booking.id = 45 13. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1.description AS offer_1_description, offer_1."durationMinutes" AS "offer_1_durationMinutes", offer_1."jsonData" AS "offer_1_jsonData", offer_1."isActive" AS "offer_1_isActive", offer_1.id AS offer_1_id, offer_1."lastValidationDate" AS "offer_1_lastValidationDate", offer_1."lastValidationType" AS "offer_1_lastValidationType", offer_1.validation AS offer_1_validation, offer_1."audioDisabilityCompliant" AS "offer_1_audioDisabilityCompliant", offer_1."mentalDisabilityCompliant" AS "offer_1_mentalDisabilityCompliant", offer_1."motorDisabilityCompliant" AS "offer_1_motorDisabilityCompliant", offer_1."visualDisabilityCompliant" AS "offer_1_visualDisabilityCompliant", offer_1."authorId" AS "offer_1_authorId", offer_1."bookingContact" AS "offer_1_bookingContact", offer_1."bookingEmail" AS "offer_1_bookingEmail", offer_1."dateCreated" AS "offer_1_dateCreated", offer_1."dateModifiedAtLastProvider" AS "offer_1_dateModifiedAtLastProvider", offer_1."dateUpdated" AS "offer_1_dateUpdated", offer_1.ean AS offer_1_ean, offer_1."externalTicketOfficeUrl" AS "offer_1_externalTicketOfficeUrl", offer_1."fieldsUpdated" AS "offer_1_fieldsUpdated", offer_1."lastProviderId" AS "offer_1_lastProviderId", offer_1."idAtProvider" AS "offer_1_idAtProvider", offer_1."isDuo" AS "offer_1_isDuo", offer_1."isNational" AS "offer_1_isNational", offer_1."lastValidationPrice" AS "offer_1_lastValidationPrice", offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."rankingWeight" AS "offer_1_rankingWeight", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, offer_1."venueId" AS "offer_1_venueId", offer_1."withdrawalDelay" AS "offer_1_withdrawalDelay", offer_1."withdrawalDetails" AS "offer_1_withdrawalDetails", offer_1."withdrawalType" AS "offer_1_withdrawalType", offer_1."offererAddressId" AS "offer_1_offererAddressId", offer_1."lastValidationAuthorUserId" AS "offer_1_lastValidationAuthorUserId", stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", finance_incident_1.id AS finance_incident_1_id, finance_incident_1.kind AS finance_incident_1_kind, finance_incident_1.status AS finance_incident_1_status, finance_incident_1."venueId" AS "finance_incident_1_venueId", finance_incident_1.details AS finance_incident_1_details, finance_incident_1."forceDebitNote" AS "finance_incident_1_forceDebitNote", booking_finance_incident_1.id AS booking_finance_incident_1_id, booking_finance_incident_1."bookingId" AS "booking_finance_incident_1_bookingId", booking_finance_incident_1."collectiveBookingId" AS "booking_finance_incident_1_collectiveBookingId", booking_finance_incident_1."incidentId" AS "booking_finance_incident_1_incidentId", booking_finance_incident_1."beneficiaryId" AS "booking_finance_incident_1_beneficiaryId", booking_finance_incident_1."newTotalAmount" AS "booking_finance_incident_1_newTotalAmount" FROM booking LEFT OUTER JOIN stock AS stock_1 ON stock_1.id = booking."stockId" LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" LEFT OUTER JOIN booking_finance_incident AS booking_finance_incident_1 ON booking.id = booking_finance_incident_1."bookingId" LEFT OUTER JOIN finance_incident AS finance_incident_1 ON finance_incident_1.id = booking_finance_incident_1."incidentId" WHERE booking."depositId" = 108 AND booking.status != CANCELLED 14. SELECT provider."isActive" AS "provider_isActive", provider.id AS provider_id, provider.name AS provider_name, provider."localClass" AS "provider_localClass", provider."enabledForPro" AS "provider_enabledForPro", provider."enableParallelSynchronization" AS "provider_enableParallelSynchronization", provider."logoUrl" AS "provider_logoUrl", provider."bookingExternalUrl" AS "provider_bookingExternalUrl", provider."cancelExternalUrl" AS "provider_cancelExternalUrl", provider."notificationExternalUrl" AS "provider_notificationExternalUrl", provider."hmacKey" AS "provider_hmacKey", provider."pricesInCents" AS "provider_pricesInCents" FROM provider WHERE provider.id IS NULL AND provider."isActive" = true AND provider."enabledForPro" = true 15. SELECT booking.id AS booking_id, booking."dateCreated" AS "booking_dateCreated", booking."dateUsed" AS "booking_dateUsed", booking."stockId" AS "booking_stockId", booking."venueId" AS "booking_venueId", booking."offererId" AS "booking_offererId", booking.quantity AS booking_quantity, booking.token AS booking_token, booking."userId" AS "booking_userId", booking.amount AS booking_amount, booking."priceCategoryLabel" AS "booking_priceCategoryLabel", booking."cancellationDate" AS "booking_cancellationDate", booking."displayAsEnded" AS "booking_displayAsEnded", booking."cancellationLimitDate" AS "booking_cancellationLimitDate", booking."cancellationReason" AS "booking_cancellationReason", booking."cancellationUserId" AS "booking_cancellationUserId", booking.status AS booking_status, booking."validationAuthorType" AS "booking_validationAuthorType", booking."reimbursementDate" AS "booking_reimbursementDate", booking."depositId" AS "booking_depositId", offer_1."jsonData" AS "offer_1_jsonData", offer_1.id AS offer_1_id, offer_1.name AS offer_1_name, offer_1."productId" AS "offer_1_productId", offer_1."subcategoryId" AS "offer_1_subcategoryId", offer_1.url AS offer_1_url, stock_1.id AS stock_1_id, stock_1."isSoftDeleted" AS "stock_1_isSoftDeleted", stock_1."beginningDatetime" AS "stock_1_beginningDatetime", stock_1."bookingLimitDatetime" AS "stock_1_bookingLimitDatetime", stock_1."dateCreated" AS "stock_1_dateCreated", stock_1."dateModified" AS "stock_1_dateModified", stock_1."dnBookedQuantity" AS "stock_1_dnBookedQuantity", stock_1."offerId" AS "stock_1_offerId", stock_1.price AS stock_1_price, stock_1."priceCategoryId" AS "stock_1_priceCategoryId", stock_1.quantity AS stock_1_quantity, stock_1."rawProviderQuantity" AS "stock_1_rawProviderQuantity", stock_1.features AS stock_1_features, stock_1."idAtProviders" AS "stock_1_idAtProviders", stock_1."dateModifiedAtLastProvider" AS "stock_1_dateModifiedAtLastProvider", stock_1."fieldsUpdated" AS "stock_1_fieldsUpdated", stock_1."lastProviderId" AS "stock_1_lastProviderId", venue_1.id AS venue_1_id, venue_1."isVirtual" AS "venue_1_isVirtual", finance_incident_1.id AS finance_incident_1_id, finance_incident_1.kind AS finance_incident_1_kind, finance_incident_1.status AS finance_incident_1_status, finance_incident_1."venueId" AS "finance_incident_1_venueId", finance_incident_1.details AS finance_incident_1_details, finance_incident_1."forceDebitNote" AS "finance_incident_1_forceDebitNote", booking_finance_incident_1.id AS booking_finance_incident_1_id, booking_finance_incident_1."bookingId" AS "booking_finance_incident_1_bookingId", booking_finance_incident_1."collectiveBookingId" AS "booking_finance_incident_1_collectiveBookingId", booking_finance_incident_1."incidentId" AS "booking_finance_incident_1_incidentId", booking_finance_incident_1."beneficiaryId" AS "booking_finance_incident_1_beneficiaryId", booking_finance_incident_1."newTotalAmount" AS "booking_finance_incident_1_newTotalAmount" FROM booking LEFT OUTER JOIN stock AS stock_1 ON stock_1.id = booking."stockId" LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = stock_1."offerId" LEFT OUTER JOIN venue AS venue_1 ON venue_1.id = booking."venueId" LEFT OUTER JOIN booking_finance_incident AS booking_finance_incident_1 ON booking.id = booking_finance_incident_1."bookingId" LEFT OUTER JOIN finance_incident AS finance_incident_1 ON finance_incident_1.id = booking_finance_incident_1."incidentId" WHERE booking."userId" = 514 AND booking.status != CANCELLED ORDER BY booking."dateCreated" DESC 16. SELECT favorite.id AS favorite_id, favorite."userId" AS "favorite_userId", favorite."offerId" AS "favorite_offerId", favorite."dateCreated" AS "favorite_dateCreated", offer_1.id AS offer_1_id, offer_1."subcategoryId" AS "offer_1_subcategoryId" FROM favorite LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = favorite."offerId" WHERE favorite."userId" = 514 ORDER BY favorite.id DESC 17. SELECT get_wallet_balance(514, False) AS get_wallet_balance_1 18. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 19. SELECT action_history."jsonData" AS "action_history_jsonData", action_history.id AS action_history_id, action_history."actionType" AS "action_history_actionType", action_history."actionDate" AS "action_history_actionDate", action_history."authorUserId" AS "action_history_authorUserId", action_history."userId" AS "action_history_userId", action_history."offererId" AS "action_history_offererId", action_history."venueId" AS "action_history_venueId", action_history."financeIncidentId" AS "action_history_financeIncidentId", action_history."bankAccountId" AS "action_history_bankAccountId", action_history."ruleId" AS "action_history_ruleId", action_history."chronicleId" AS "action_history_chronicleId", action_history.comment AS action_history_comment FROM action_history WHERE 514 = action_history."userId" ORDER BY action_history."actionDate" ASC NULLS FIRST

assert 500 == 204 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

AssertionError: b'{"global":["Il semble que nous ayons des probl\\u00e8mes techniques :( On r\\u00e9pare \\u00e7a au plus vite."]} ' assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

assert 500 == 200 + where 500 = <WrapperTestResponse streamed [500 INTERNAL SERVER ERROR]>.status_code

❌ Tests reported 199 failures

assert 0 == 2 + where 0 = len([]) + where [] = mails_testing.outbox

AssertionError: assert 2 == 4 + where 2 = len([{'To': 'venue1032@example.net', 'params': {'IS_COLLECTIVE_OFFER': False, 'OFFER_ADDRESS': 'Le Petit Rintintin 1032 - 1 boulevard Poissonnière 75002 Paris', 'OFFER_NAME': 'Offer 598', 'PC_PRO_OFFER_LINK': 'http://localhost:3001/offre/individuelle/599/recapitulatif', ...}, 'reply_to': None, 'template': {'enable_unsubscribe': False, 'id_not_prod': 30, 'id_prod': 30, 'send_to_ehp': True, ...}, ...}, {'To': 'venue1033@example.net', 'params': {'IS_COLLECTIVE_OFFER': False, 'OFFER_NAME': 'Offer 599', 'PC_PRO_OFFER_LINK': 'http://localhost:3001/offre/individuelle/600/recapitulatif', 'VENUE_NAME': 'Le Petit Rintintin 1033'}, 'reply_to': None, 'template': {'enable_unsubscribe': False, 'id_not_prod': 34, 'id_prod': 34, 'send_to_ehp': True, ...}, ...}]) + where [{'To': 'venue1032@example.net', 'params': {'IS_COLLECTIVE_OFFER': False, 'OFFER_ADDRESS': 'Le Petit Rintintin 1032 - 1 boulevard Poissonnière 75002 Paris', 'OFFER_NAME': 'Offer 598', 'PC_PRO_OFFER_LINK': 'http://localhost:3001/offre/individuelle/599/recapitulatif', ...}, 'reply_to': None, 'template': {'enable_unsubscribe': False, 'id_not_prod': 30, 'id_prod': 30, 'send_to_ehp': True, ...}, ...}, {'To': 'venue1033@example.net', 'params': {'IS_COLLECTIVE_OFFER': False, 'OFFER_NAME': 'Offer 599', 'PC_PRO_OFFER_LINK': 'http://localhost:3001/offre/individuelle/600/recapitulatif', 'VENUE_NAME': 'Le Petit Rintintin 1033'}, 'reply_to': None, 'template': {'enable_unsubscribe': False, 'id_not_prod': 34, 'id_prod': 34, 'send_to_ehp': True, ...}, ...}] = mails_testing.outbox

❌ Tests reported 2 failures

Cypress tests: 3 failed

The "process_gcloudignore" option is true, but no .gcloudignore file was found. If you do not intend to process a gcloudignore file, set "process_gcloudignore" to false.

Running update api client template with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi:590d16220992850137f86cf526f362f0bb519f55

Running tests api with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi-tests:590d16220992850137f86cf526f362f0bb519f55