Process completed with exit code 1.

AssertionError: assert <FraudCheckStatus.KO: 'ko'> == <FraudCheckStatus.SUSPICIOUS: 'suspiscious'> + where <FraudCheckStatus.KO: 'ko'> = <BeneficiaryFraudCheck #252>.status + and <FraudCheckStatus.SUSPICIOUS: 'suspiscious'> = <enum 'FraudCheckStatus'>.SUSPICIOUS + where <enum 'FraudCheckStatus'> = fraud_models.FraudCheckStatus

❌ Tests reported 1 failures

AssertionError: assert [<FraudReasonCode.AGE_NOT_VALID: 'age_is_not_valid'>] == [] Left contains one more item: <FraudReasonCode.AGE_NOT_VALID: 'age_is_not_valid'> Full diff: - [] + [ + <FraudReasonCode.AGE_NOT_VALID: 'age_is_not_valid'>, + ]

❌ Tests reported 1 failures

Failed: 7 queries executed, 8 expected Captured queries were: 1. SELECT count(offer_id) AS count_1 FROM (SELECT offer.id AS offer_id FROM offer JOIN venue ON venue.id = offer."venueId" WHERE venue."managingOffererId" = 1202 LIMIT 1000) AS anon_1 2. SELECT jsonb_object_agg(status, number) AS jsonb_object_agg_1 FROM (SELECT CASE WHEN (offer."isActive" AND NOT ((EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false)) AND NOT (EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false AND (stock."bookingLimitDatetime" IS NOT NULL AND stock."bookingLimitDatetime" <= now()) IS false)))) THEN active ELSE inactive END AS status, count(offer.id) AS number FROM venue LEFT OUTER JOIN offer ON venue.id = offer."venueId" WHERE venue."managingOffererId" = 1202 AND (offer."isActive" AND offer.validation = APPROVED OR NOT offer."isActive" AND offer.validation IN (APPROVED, PENDING, DRAFT)) GROUP BY status) AS anon_1 3. SELECT count(offer_id) AS count_1 FROM (SELECT collective_offer.id AS offer_id FROM collective_offer JOIN venue ON venue.id = collective_offer."venueId" WHERE venue."managingOffererId" = 1202 LIMIT 1000) AS anon_1 4. SELECT jsonb_object_agg(status, number) AS jsonb_object_agg_1 FROM (SELECT CASE WHEN (collective_offer."isActive" AND NOT (EXISTS (SELECT * FROM collective_stock AS collective_stock_1 WHERE collective_stock_1."collectiveOfferId" = collective_offer.id AND (collective_stock_1."startDatetime" <= now()) IS true))) THEN active ELSE inactive END AS status, count(collective_offer.id) AS number FROM venue LEFT OUTER JOIN collective_offer ON venue.id = collective_offer."venueId" WHERE venue."managingOffererId" = 1202 AND (collective_offer."isActive" AND collective_offer.validation = APPROVED OR NOT collective_offer."isActive" AND collective_offer.validation IN (APPROVED, PENDING, DRAFT)) GROUP BY status) AS anon_1 5. SELECT count(offer_id) AS count_1 FROM (SELECT collective_offer_template.id AS offer_id FROM collective_offer_template JOIN venue ON venue.id = collective_offer_template."venueId" WHERE venue."managingOffererId" = 1202 LIMIT 1000) AS anon_1 6. SELECT jsonb_object_agg(status, number) AS jsonb_object_agg_1 FROM (SELECT CASE WHEN collective_offer_template."isActive" THEN active ELSE inactive END AS status, count(collective_offer_template.id) AS number FROM venue LEFT OUTER JOIN collective_offer_template ON venue.id = collective_offer_template."venueId" WHERE venue."managingOffererId" = 1202 AND (collective_offer_template."isActive" AND collective_offer_template.validation = APPROVED OR NOT collective_offer_template."isActive" AND collective_offer_template.validation IN (APPROVED, PENDING, DRAFT)) GROUP BY status) AS anon_1 7. SELECT (SELECT coalesce(sum(booking.amount * booking.quantity), 0.0) AS coalesce_1 FROM booking WHERE booking."offererId" = 1202 AND booking.status != CANCELLED) + (SELECT coalesce(sum(collective_stock.price), 0.0) AS coalesce_3 FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" WHERE collective_booking."offererId" = 1202 AND collective_booking.status != CANCELLED) AS anon_1

Failed: 7 queries executed, 8 expected Captured queries were: 1. SELECT count(offer_id) AS count_1 FROM (SELECT offer.id AS offer_id FROM offer JOIN venue ON venue.id = offer."venueId" WHERE venue."managingOffererId" = 1209 LIMIT 1000) AS anon_1 2. SELECT jsonb_object_agg(status, number) AS jsonb_object_agg_1 FROM (SELECT CASE WHEN (offer."isActive" AND NOT ((EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false)) AND NOT (EXISTS (SELECT * FROM stock WHERE stock."offerId" = offer.id AND stock."isSoftDeleted" IS false AND (stock."bookingLimitDatetime" IS NOT NULL AND stock."bookingLimitDatetime" <= now()) IS false)))) THEN active ELSE inactive END AS status, count(offer.id) AS number FROM venue LEFT OUTER JOIN offer ON venue.id = offer."venueId" WHERE venue."managingOffererId" = 1209 AND (offer."isActive" AND offer.validation = APPROVED OR NOT offer."isActive" AND offer.validation IN (APPROVED, PENDING, DRAFT)) GROUP BY status) AS anon_1 3. SELECT count(offer_id) AS count_1 FROM (SELECT collective_offer.id AS offer_id FROM collective_offer JOIN venue ON venue.id = collective_offer."venueId" WHERE venue."managingOffererId" = 1209 LIMIT 1000) AS anon_1 4. SELECT jsonb_object_agg(status, number) AS jsonb_object_agg_1 FROM (SELECT CASE WHEN (collective_offer."isActive" AND NOT (EXISTS (SELECT * FROM collective_stock AS collective_stock_1 WHERE collective_stock_1."collectiveOfferId" = collective_offer.id AND (collective_stock_1."startDatetime" <= now()) IS true))) THEN active ELSE inactive END AS status, count(collective_offer.id) AS number FROM venue LEFT OUTER JOIN collective_offer ON venue.id = collective_offer."venueId" WHERE venue."managingOffererId" = 1209 AND (collective_offer."isActive" AND collective_offer.validation = APPROVED OR NOT collective_offer."isActive" AND collective_offer.validation IN (APPROVED, PENDING, DRAFT)) GROUP BY status) AS anon_1 5. SELECT count(offer_id) AS count_1 FROM (SELECT collective_offer_template.id AS offer_id FROM collective_offer_template JOIN venue ON venue.id = collective_offer_template."venueId" WHERE venue."managingOffererId" = 1209 LIMIT 1000) AS anon_1 6. SELECT jsonb_object_agg(status, number) AS jsonb_object_agg_1 FROM (SELECT CASE WHEN collective_offer_template."isActive" THEN active ELSE inactive END AS status, count(collective_offer_template.id) AS number FROM venue LEFT OUTER JOIN collective_offer_template ON venue.id = collective_offer_template."venueId" WHERE venue."managingOffererId" = 1209 AND (collective_offer_template."isActive" AND collective_offer_template.validation = APPROVED OR NOT collective_offer_template."isActive" AND collective_offer_template.validation IN (APPROVED, PENDING, DRAFT)) GROUP BY status) AS anon_1 7. SELECT (SELECT coalesce(sum(booking.amount * booking.quantity), 0.0) AS coalesce_1 FROM booking WHERE booking."offererId" = 1209 AND booking.status != CANCELLED) + (SELECT coalesce(sum(collective_stock.price), 0.0) AS coalesce_3 FROM collective_booking JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" WHERE collective_booking."offererId" = 1209 AND collective_booking.status != CANCELLED) AS anon_1

❌ Tests reported 2 failures

Failed: 6 queries executed, 7 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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" FROM achievement WHERE 168 = achievement."userId" 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" 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" WHERE booking."userId" = 168 AND booking.status != CANCELLED 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 FROM deposit WHERE 168 = deposit."userId" 5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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" FROM beneficiary_fraud_review WHERE 168 = beneficiary_fraud_review."userId"

Failed: 6 queries executed, 7 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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" FROM achievement WHERE 169 = achievement."userId" 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" 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" WHERE booking."userId" = 169 AND booking.status != CANCELLED 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 FROM deposit WHERE 169 = deposit."userId" 5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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" FROM beneficiary_fraud_review WHERE 169 = beneficiary_fraud_review."userId"

Failed: 6 queries executed, 7 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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" FROM achievement WHERE 170 = achievement."userId" 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" 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" WHERE booking."userId" = 170 AND booking.status != CANCELLED 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 FROM deposit WHERE 170 = deposit."userId" 5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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" FROM beneficiary_fraud_review WHERE 170 = beneficiary_fraud_review."userId"

Failed: 6 queries executed, 7 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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" FROM achievement WHERE 176 = achievement."userId" 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" 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" WHERE booking."userId" = 176 AND booking.status != CANCELLED 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 FROM deposit WHERE 176 = deposit."userId" 5. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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" FROM beneficiary_fraud_review WHERE 176 = beneficiary_fraud_review."userId"

Failed: 7 queries executed, 8 expected Captured queries were: 1. UPDATE "user" SET password=None WHERE "user".id = 181 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) = [email protected] 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" FROM achievement WHERE 181 = achievement."userId" 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" 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" WHERE booking."userId" = 181 AND booking.status != CANCELLED 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 FROM deposit WHERE 181 = deposit."userId" 6. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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" FROM beneficiary_fraud_review WHERE 181 = beneficiary_fraud_review."userId"

Failed: 7 queries executed, 8 expected Captured queries were: 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" FROM "user" WHERE "user".id = 182 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) = [email protected] 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" FROM achievement WHERE 182 = achievement."userId" 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" 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" WHERE booking."userId" = 182 AND booking.status != CANCELLED 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 FROM deposit WHERE 182 = deposit."userId" 6. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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" FROM beneficiary_fraud_review WHERE 182 = beneficiary_fraud_review."userId"

Failed: 7 queries executed, 8 expected Captured queries were: 1. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature 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) = [email protected] 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 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" 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" = 186 AND booking.status != CANCELLED ORDER BY booking."dateCreated" DESC 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" FROM favorite LEFT OUTER JOIN offer AS offer_1 ON offer_1.id = favorite."offerId" WHERE favorite."userId" = 186 ORDER BY favorite.id DESC 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 FROM deposit WHERE 186 = deposit."userId" 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 FROM action_history WHERE 186 = action_history."userId" ORDER BY action_history."actionDate" ASC NULLS FIRST

assert None is not None

Failed: 3 queries executed, 2 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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 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" WHERE "user".id = 468 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 3 queries executed, 2 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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 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" WHERE "user".id = 469 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 3 queries executed, 2 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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 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" WHERE "user".id = 471 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 3 queries executed, 2 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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 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" WHERE "user".id = 474 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 3 queries executed, 2 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 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 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" WHERE "user".id = 475 3. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

AssertionError: assert None == 'maintenance'

AssertionError: assert None == 'identity-check'

AssertionError: assert None == 'identity-check'

AssertionError: assert None == 'maintenance'

AssertionError: assert None == 'identity-check'

AssertionError: assert None == 'identity-check'

Failed: 2 queries executed, 1 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 2 queries executed, 1 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 2 queries executed, 1 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

Failed: 2 queries executed, 1 expected Captured queries were: 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" FROM "user" WHERE lower("user".email) = [email protected] 2. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature

❌ Tests reported 23 failures

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

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