tests/routes/native/v1/account_test.py:189: in test_get_user_not_beneficiary
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 6 queries executed, 7 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT achievement.id AS achievement_id, achievement."userId" AS "achievement_userId", achievement."bookingId" AS "achievement_bookingId", achievement.name AS achievement_name, achievement."unlockedDate" AS "achievement_unlockedDate", achievement."seenDate" AS "achievement_seenDate" 
E      FROM achievement 
E      WHERE 168 = achievement."userId"
E   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", offer_1.id AS offer_1_id, 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" 
E      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" 
E      WHERE booking."userId" = 168 AND booking.status != CANCELLED
E   4. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 168 = deposit."userId"
E   5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   6. SELECT beneficiary_fraud_review.id AS beneficiary_fraud_review_id, beneficiary_fraud_review."authorId" AS "beneficiary_fraud_review_authorId", beneficiary_fraud_review."dateReviewed" AS "beneficiary_fraud_review_dateReviewed", beneficiary_fraud_review."eligibilityType" AS "beneficiary_fraud_review_eligibilityType", beneficiary_fraud_review.reason AS beneficiary_fraud_review_reason, beneficiary_fraud_review.review AS beneficiary_fraud_review_review, beneficiary_fraud_review."userId" AS "beneficiary_fraud_review_userId" 
E      FROM beneficiary_fraud_review 
E      WHERE 168 = beneficiary_fraud_review."userId"

tests/routes/native/v1/account_test.py:201: in test_get_user_profile_empty_first_name
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 6 queries executed, 7 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT achievement.id AS achievement_id, achievement."userId" AS "achievement_userId", achievement."bookingId" AS "achievement_bookingId", achievement.name AS achievement_name, achievement."unlockedDate" AS "achievement_unlockedDate", achievement."seenDate" AS "achievement_seenDate" 
E      FROM achievement 
E      WHERE 169 = achievement."userId"
E   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", offer_1.id AS offer_1_id, 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" 
E      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" 
E      WHERE booking."userId" = 169 AND booking.status != CANCELLED
E   4. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 169 = deposit."userId"
E   5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   6. SELECT beneficiary_fraud_review.id AS beneficiary_fraud_review_id, beneficiary_fraud_review."authorId" AS "beneficiary_fraud_review_authorId", beneficiary_fraud_review."dateReviewed" AS "beneficiary_fraud_review_dateReviewed", beneficiary_fraud_review."eligibilityType" AS "beneficiary_fraud_review_eligibilityType", beneficiary_fraud_review.reason AS beneficiary_fraud_review_reason, beneficiary_fraud_review.review AS beneficiary_fraud_review_review, beneficiary_fraud_review."userId" AS "beneficiary_fraud_review_userId" 
E      FROM beneficiary_fraud_review 
E      WHERE 169 = beneficiary_fraud_review."userId"

tests/routes/native/v1/account_test.py:214: in test_get_user_profile_legacy_activity
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 6 queries executed, 7 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT achievement.id AS achievement_id, achievement."userId" AS "achievement_userId", achievement."bookingId" AS "achievement_bookingId", achievement.name AS achievement_name, achievement."unlockedDate" AS "achievement_unlockedDate", achievement."seenDate" AS "achievement_seenDate" 
E      FROM achievement 
E      WHERE 170 = achievement."userId"
E   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", offer_1.id AS offer_1_id, 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" 
E      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" 
E      WHERE booking."userId" = 170 AND booking.status != CANCELLED
E   4. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 170 = deposit."userId"
E   5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   6. SELECT beneficiary_fraud_review.id AS beneficiary_fraud_review_id, beneficiary_fraud_review."authorId" AS "beneficiary_fraud_review_authorId", beneficiary_fraud_review."dateReviewed" AS "beneficiary_fraud_review_dateReviewed", beneficiary_fraud_review."eligibilityType" AS "beneficiary_fraud_review_eligibilityType", beneficiary_fraud_review.reason AS beneficiary_fraud_review_reason, beneficiary_fraud_review.review AS beneficiary_fraud_review_review, beneficiary_fraud_review."userId" AS "beneficiary_fraud_review_userId" 
E      FROM beneficiary_fraud_review 
E      WHERE 170 = beneficiary_fraud_review."userId"

tests/routes/native/v1/account_test.py:332: in test_not_eligible_user_should_not_need_to_fill_cultural_survey
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 6 queries executed, 7 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT achievement.id AS achievement_id, achievement."userId" AS "achievement_userId", achievement."bookingId" AS "achievement_bookingId", achievement.name AS achievement_name, achievement."unlockedDate" AS "achievement_unlockedDate", achievement."seenDate" AS "achievement_seenDate" 
E      FROM achievement 
E      WHERE 176 = achievement."userId"
E   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", offer_1.id AS offer_1_id, 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" 
E      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" 
E      WHERE booking."userId" = 176 AND booking.status != CANCELLED
E   4. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 176 = deposit."userId"
E   5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   6. SELECT beneficiary_fraud_review.id AS beneficiary_fraud_review_id, beneficiary_fraud_review."authorId" AS "beneficiary_fraud_review_authorId", beneficiary_fraud_review."dateReviewed" AS "beneficiary_fraud_review_dateReviewed", beneficiary_fraud_review."eligibilityType" AS "beneficiary_fraud_review_eligibilityType", beneficiary_fraud_review.reason AS beneficiary_fraud_review_reason, beneficiary_fraud_review.review AS beneficiary_fraud_review_review, beneficiary_fraud_review."userId" AS "beneficiary_fraud_review_userId" 
E      FROM beneficiary_fraud_review 
E      WHERE 176 = beneficiary_fraud_review."userId"

tests/routes/native/v1/account_test.py:411: in test_user_without_password
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 7 queries executed, 8 expected
E   Captured queries were:
E   1. UPDATE "user" SET password=None WHERE "user".id = 181
E   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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   3. SELECT achievement.id AS achievement_id, achievement."userId" AS "achievement_userId", achievement."bookingId" AS "achievement_bookingId", achievement.name AS achievement_name, achievement."unlockedDate" AS "achievement_unlockedDate", achievement."seenDate" AS "achievement_seenDate" 
E      FROM achievement 
E      WHERE 181 = achievement."userId"
E   4. 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.id AS offer_1_id, 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" 
E      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" 
E      WHERE booking."userId" = 181 AND booking.status != CANCELLED
E   5. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 181 = deposit."userId"
E   6. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   7. SELECT beneficiary_fraud_review.id AS beneficiary_fraud_review_id, beneficiary_fraud_review."authorId" AS "beneficiary_fraud_review_authorId", beneficiary_fraud_review."dateReviewed" AS "beneficiary_fraud_review_dateReviewed", beneficiary_fraud_review."eligibilityType" AS "beneficiary_fraud_review_eligibilityType", beneficiary_fraud_review.reason AS beneficiary_fraud_review_reason, beneficiary_fraud_review.review AS beneficiary_fraud_review_review, beneficiary_fraud_review."userId" AS "beneficiary_fraud_review_userId" 
E      FROM beneficiary_fraud_review 
E      WHERE 181 = beneficiary_fraud_review."userId"

tests/routes/native/v1/account_test.py:421: in test_currency_pacific_franc
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 7 queries executed, 8 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE "user".id = 182
E   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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   3. SELECT achievement.id AS achievement_id, achievement."userId" AS "achievement_userId", achievement."bookingId" AS "achievement_bookingId", achievement.name AS achievement_name, achievement."unlockedDate" AS "achievement_unlockedDate", achievement."seenDate" AS "achievement_seenDate" 
E      FROM achievement 
E      WHERE 182 = achievement."userId"
E   4. 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.id AS offer_1_id, 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" 
E      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" 
E      WHERE booking."userId" = 182 AND booking.status != CANCELLED
E   5. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 182 = deposit."userId"
E   6. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   7. SELECT beneficiary_fraud_review.id AS beneficiary_fraud_review_id, beneficiary_fraud_review."authorId" AS "beneficiary_fraud_review_authorId", beneficiary_fraud_review."dateReviewed" AS "beneficiary_fraud_review_dateReviewed", beneficiary_fraud_review."eligibilityType" AS "beneficiary_fraud_review_eligibilityType", beneficiary_fraud_review.reason AS beneficiary_fraud_review_reason, beneficiary_fraud_review.review AS beneficiary_fraud_review_review, beneficiary_fraud_review."userId" AS "beneficiary_fraud_review_userId" 
E      FROM beneficiary_fraud_review 
E      WHERE 182 = beneficiary_fraud_review."userId"

tests/routes/native/v1/account_test.py:486: in test_account_creation
    with assert_num_queries(expected_num_queries):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 7 queries executed, 8 expected
E   Captured queries were:
E   1. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature
E   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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   3. INSERT INTO "user" ("isActive", activity, address, city, civility, comment, "culturalSurveyFilledDate", "culturalSurveyId", "dateCreated", "dateOfBirth", "departementCode", email, "externalIds", "extraData", "firstName", "idPieceNumber", "ineHash", "irisFranceId", "isEmailValidated", "lastConnectionDate", "lastName", married_name, "needsToFillCulturalSurvey", "notificationSubscriptions", password, "phoneNumber", "phoneValidationStatus", "postalCode", "recreditAmountToShow", roles, "schoolType", "validatedBirthDate") VALUES (True, None, None, None, None, None, None, None, 2025-01-30 16:21:43.387367, 1960-12-31 00:00:00, None, [email protected], {"apps_flyer": {"user": "apps_flyer_user_id", "platform": "IOS"}, "firebase_pseudo_id": "firebase_pseudo_id"}, {}, None, None, None, None, False, 2025-01-30 16:21:43.385428, None, None, True, {"marketing_push": true, "marketing_email": true, "subscribed_themes": []}, '\x3137623830383639613866393930636462646535623139633665633533386234'::bytea, None, None, None, None, []::VARCHAR(20)[], None, None) RETURNING "user".id
E   4. 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" 
E      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" 
E      WHERE booking."userId" = 186 AND booking.status != CANCELLED ORDER BY booking."dateCreated" DESC
E   5. 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" 
E      FROM favorite LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = favorite."offerId" 
E      WHERE favorite."userId" = 186 ORDER BY favorite.id DESC
E   6. SELECT deposit.id AS deposit_id, deposit.amount AS deposit_amount, deposit."userId" AS "deposit_userId", deposit.source AS deposit_source, deposit."dateCreated" AS "deposit_dateCreated", deposit."dateUpdated" AS "deposit_dateUpdated", deposit."expirationDate" AS "deposit_expirationDate", deposit.version AS deposit_version, deposit.type AS deposit_type 
E      FROM deposit 
E      WHERE 186 = deposit."userId"
E   7. 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 
E      FROM action_history 
E      WHERE 186 = action_history."userId" ORDER BY action_history."actionDate" ASC NULLS FIRST

tests/routes/native/v1/authentication_test.py:1166: in test_validate_email_dms_orphan
    assert fraud_check is not None
E   assert None is not None

tests/routes/native/v1/banner_test.py:53: in should_be_allowed_to_get_banner_when_active
    with assert_num_queries(self.expected_num_queries_without_subscription_check):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 3 queries executed, 2 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   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", 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, beneficiary_fraud_check_1.id AS beneficiary_fraud_check_1_id, beneficiary_fraud_check_1."dateCreated" AS "beneficiary_fraud_check_1_dateCreated", beneficiary_fraud_check_1."eligibilityType" AS "beneficiary_fraud_check_1_eligibilityType", beneficiary_fraud_check_1."reasonCodes" AS "beneficiary_fraud_check_1_reasonCodes", beneficiary_fraud_check_1.status AS beneficiary_fraud_check_1_status, beneficiary_fraud_check_1.type AS beneficiary_fraud_check_1_type, beneficiary_fraud_check_1."updatedAt" AS "beneficiary_fraud_check_1_updatedAt", beneficiary_fraud_check_1."userId" AS "beneficiary_fraud_check_1_userId", beneficiary_fraud_review_1.id AS beneficiary_fraud_review_1_id, beneficiary_fraud_review_1."dateReviewed" AS "beneficiary_fraud_review_1_dateReviewed", beneficiary_fraud_review_1.review AS beneficiary_fraud_review_1_review 
E      FROM "user" LEFT OUTER JOIN deposit AS deposit_1 ON "user".id = deposit_1."userId" LEFT OUTER JOIN beneficiary_fraud_check AS beneficiary_fraud_check_1 ON "user".id = beneficiary_fraud_check_1."userId" LEFT OUTER JOIN beneficiary_fraud_review AS beneficiary_fraud_review_1 ON "user".id = beneficiary_fraud_review_1."userId" 
E      WHERE "user".id = 468
E   3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/banner_test.py:61: in should_return_geolocation_banner_when_not_geolocated
    with assert_num_queries(self.expected_num_queries_without_subscription_check):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 3 queries executed, 2 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   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", 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, beneficiary_fraud_check_1.id AS beneficiary_fraud_check_1_id, beneficiary_fraud_check_1."dateCreated" AS "beneficiary_fraud_check_1_dateCreated", beneficiary_fraud_check_1."eligibilityType" AS "beneficiary_fraud_check_1_eligibilityType", beneficiary_fraud_check_1."reasonCodes" AS "beneficiary_fraud_check_1_reasonCodes", beneficiary_fraud_check_1.status AS beneficiary_fraud_check_1_status, beneficiary_fraud_check_1.type AS beneficiary_fraud_check_1_type, beneficiary_fraud_check_1."updatedAt" AS "beneficiary_fraud_check_1_updatedAt", beneficiary_fraud_check_1."userId" AS "beneficiary_fraud_check_1_userId", beneficiary_fraud_review_1.id AS beneficiary_fraud_review_1_id, beneficiary_fraud_review_1."dateReviewed" AS "beneficiary_fraud_review_1_dateReviewed", beneficiary_fraud_review_1.review AS beneficiary_fraud_review_1_review 
E      FROM "user" LEFT OUTER JOIN deposit AS deposit_1 ON "user".id = deposit_1."userId" LEFT OUTER JOIN beneficiary_fraud_check AS beneficiary_fraud_check_1 ON "user".id = beneficiary_fraud_check_1."userId" LEFT OUTER JOIN beneficiary_fraud_review AS beneficiary_fraud_review_1 ON "user".id = beneficiary_fraud_review_1."userId" 
E      WHERE "user".id = 469
E   3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/banner_test.py:85: in should_return_activation_banner_when_user_has_profile_to_complete
    with assert_num_queries(self.expected_num_queries_without_subscription_check):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 3 queries executed, 2 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   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", 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, beneficiary_fraud_check_1.id AS beneficiary_fraud_check_1_id, beneficiary_fraud_check_1."dateCreated" AS "beneficiary_fraud_check_1_dateCreated", beneficiary_fraud_check_1."eligibilityType" AS "beneficiary_fraud_check_1_eligibilityType", beneficiary_fraud_check_1."reasonCodes" AS "beneficiary_fraud_check_1_reasonCodes", beneficiary_fraud_check_1.status AS beneficiary_fraud_check_1_status, beneficiary_fraud_check_1.type AS beneficiary_fraud_check_1_type, beneficiary_fraud_check_1."updatedAt" AS "beneficiary_fraud_check_1_updatedAt", beneficiary_fraud_check_1."userId" AS "beneficiary_fraud_check_1_userId", beneficiary_fraud_review_1.id AS beneficiary_fraud_review_1_id, beneficiary_fraud_review_1."dateReviewed" AS "beneficiary_fraud_review_1_dateReviewed", beneficiary_fraud_review_1.review AS beneficiary_fraud_review_1_review 
E      FROM "user" LEFT OUTER JOIN deposit AS deposit_1 ON "user".id = deposit_1."userId" LEFT OUTER JOIN beneficiary_fraud_check AS beneficiary_fraud_check_1 ON "user".id = beneficiary_fraud_check_1."userId" LEFT OUTER JOIN beneficiary_fraud_review AS beneficiary_fraud_review_1 ON "user".id = beneficiary_fraud_review_1."userId" 
E      WHERE "user".id = 471
E   3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/banner_test.py:130: in should_not_return_any_banner_when_beneficiary_and_geolocated
    with assert_num_queries(self.expected_num_queries_without_subscription_check):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 3 queries executed, 2 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   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", 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, beneficiary_fraud_check_1.id AS beneficiary_fraud_check_1_id, beneficiary_fraud_check_1."dateCreated" AS "beneficiary_fraud_check_1_dateCreated", beneficiary_fraud_check_1."eligibilityType" AS "beneficiary_fraud_check_1_eligibilityType", beneficiary_fraud_check_1."reasonCodes" AS "beneficiary_fraud_check_1_reasonCodes", beneficiary_fraud_check_1.status AS beneficiary_fraud_check_1_status, beneficiary_fraud_check_1.type AS beneficiary_fraud_check_1_type, beneficiary_fraud_check_1."updatedAt" AS "beneficiary_fraud_check_1_updatedAt", beneficiary_fraud_check_1."userId" AS "beneficiary_fraud_check_1_userId", beneficiary_fraud_review_1.id AS beneficiary_fraud_review_1_id, beneficiary_fraud_review_1."dateReviewed" AS "beneficiary_fraud_review_1_dateReviewed", beneficiary_fraud_review_1.review AS beneficiary_fraud_review_1_review 
E      FROM "user" LEFT OUTER JOIN deposit AS deposit_1 ON "user".id = deposit_1."userId" LEFT OUTER JOIN beneficiary_fraud_check AS beneficiary_fraud_check_1 ON "user".id = beneficiary_fraud_check_1."userId" LEFT OUTER JOIN beneficiary_fraud_review AS beneficiary_fraud_review_1 ON "user".id = beneficiary_fraud_review_1."userId" 
E      WHERE "user".id = 474
E   3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/banner_test.py:143: in should_return_activation_banner_with_20_euros_when_15_year_old
    with assert_num_queries(2):
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 3 queries executed, 2 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   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", 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, beneficiary_fraud_check_1.id AS beneficiary_fraud_check_1_id, beneficiary_fraud_check_1."dateCreated" AS "beneficiary_fraud_check_1_dateCreated", beneficiary_fraud_check_1."eligibilityType" AS "beneficiary_fraud_check_1_eligibilityType", beneficiary_fraud_check_1."reasonCodes" AS "beneficiary_fraud_check_1_reasonCodes", beneficiary_fraud_check_1.status AS beneficiary_fraud_check_1_status, beneficiary_fraud_check_1.type AS beneficiary_fraud_check_1_type, beneficiary_fraud_check_1."updatedAt" AS "beneficiary_fraud_check_1_updatedAt", beneficiary_fraud_check_1."userId" AS "beneficiary_fraud_check_1_userId", beneficiary_fraud_review_1.id AS beneficiary_fraud_review_1_id, beneficiary_fraud_review_1."dateReviewed" AS "beneficiary_fraud_review_1_dateReviewed", beneficiary_fraud_review_1.review AS beneficiary_fraud_review_1_review 
E      FROM "user" LEFT OUTER JOIN deposit AS deposit_1 ON "user".id = deposit_1."userId" LEFT OUTER JOIN beneficiary_fraud_check AS beneficiary_fraud_check_1 ON "user".id = beneficiary_fraud_check_1."userId" LEFT OUTER JOIN beneficiary_fraud_review AS beneficiary_fraud_review_1 ON "user".id = beneficiary_fraud_review_1."userId" 
E      WHERE "user".id = 475
E   3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/subscription_test.py:91: in test_next_subscription_maintenance_page
    assert response.json["nextSubscriptionStep"] == "maintenance"
E   AssertionError: assert None == 'maintenance'

tests/routes/native/v1/subscription_test.py:460: in test_ubble_subscription_limited
    assert response.json["nextSubscriptionStep"] == "identity-check"
E   AssertionError: assert None == 'identity-check'

tests/routes/native/v1/subscription_test.py:460: in test_ubble_subscription_limited
    assert response.json["nextSubscriptionStep"] == "identity-check"
E   AssertionError: assert None == 'identity-check'

tests/routes/native/v1/subscription_test.py:870: in test_next_subscription_maintenance_page
    assert response.json["nextSubscriptionStep"] == "maintenance"
E   AssertionError: assert None == 'maintenance'

tests/routes/native/v1/subscription_test.py:1243: in test_ubble_subscription_limited
    assert response.json["nextSubscriptionStep"] == "identity-check"
E   AssertionError: assert None == 'identity-check'

tests/routes/native/v1/subscription_test.py:1243: in test_ubble_subscription_limited
    assert response.json["nextSubscriptionStep"] == "identity-check"
E   AssertionError: assert None == 'identity-check'

tests/routes/native/v1/subscription_test.py:1654: in test_get_activity_types
    with assert_num_queries(1):  # user
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 2 queries executed, 1 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/subscription_test.py:1654: in test_get_activity_types
    with assert_num_queries(1):  # user
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 2 queries executed, 1 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/subscription_test.py:1654: in test_get_activity_types
    with assert_num_queries(1):  # user
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 2 queries executed, 1 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature

tests/routes/native/v1/subscription_test.py:1654: in test_get_activity_types
    with assert_num_queries(1):  # user
/usr/local/lib/python3.11/contextlib.py:144: in __exit__
    next(self.gen)
src/pcapi/core/testing.py:82: in assert_num_queries
    pytest.fail(
E   Failed: 2 queries executed, 1 expected
E   Captured queries were:
E   1. 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" 
E      FROM "user" 
E      WHERE lower("user".email) = [email protected]
E   2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" 
E      FROM feature