Failed: 23 queries executed, 14 expected Captured queries were: 1. SELECT user_session.id AS user_session_id, user_session."userId" AS "user_session_userId", user_session.uuid AS user_session_uuid FROM user_session WHERE user_session."userId" = 1352 AND user_session.uuid = e7c0c2ef-1b3e-48cd-84b3-35f44f97faff 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 "user".id = 1352 3. SELECT offerer.address AS offerer_address, offerer.street AS offerer_street, offerer."isActive" AS "offerer_isActive", offerer.id AS offerer_id, offerer."postalCode" AS "offerer_postalCode", offerer.city AS offerer_city, offerer."validationStatus" AS "offerer_validationStatus", offerer."dateCreated" AS "offerer_dateCreated", offerer.name AS offerer_name, offerer.siren AS offerer_siren, offerer."dateValidated" AS "offerer_dateValidated", offerer."allowedOnAdage" AS "offerer_allowedOnAdage" FROM offerer JOIN venue ON offerer.id = venue."managingOffererId" JOIN offer ON venue.id = offer."venueId" WHERE offer.id = 427 4. SELECT EXISTS (SELECT 1 FROM user_offerer WHERE user_offerer."offererId" = 1195 AND user_offerer."userId" = 1352 AND user_offerer."validationStatus" = VALIDATED) AS anon_1 5. SELECT offer.description AS offer_description, offer."jsonData" AS "offer_jsonData", EXISTS (SELECT 1 FROM stock WHERE stock."offerId" = offer.id AND stock.price > 0) AS anon_1, (SELECT coalesce(sum(stock."dnBookedQuantity"), 0) AS coalesce_1 FROM stock WHERE stock."offerId" = offer.id) AS anon_2, offer."isActive" AS "offer_isActive", offer.id AS offer_id, offer."lastValidationDate" AS "offer_lastValidationDate", offer."lastValidationType" AS "offer_lastValidationType", offer.validation AS offer_validation, offer."audioDisabilityCompliant" AS "offer_audioDisabilityCompliant", offer."mentalDisabilityCompliant" AS "offer_mentalDisabilityCompliant", offer."motorDisabilityCompliant" AS "offer_motorDisabilityCompliant", offer."visualDisabilityCompliant" AS "offer_visualDisabilityCompliant", offer."authorId" AS "offer_authorId", offer."bookingContact" AS "offer_bookingContact", offer."bookingEmail" AS "offer_bookingEmail", offer."dateCreated" AS "offer_dateCreated", offer."dateModifiedAtLastProvider" AS "offer_dateModifiedAtLastProvider", offer."dateUpdated" AS "offer_dateUpdated", offer."durationMinutes" AS "offer_durationMinutes", offer."externalTicketOfficeUrl" AS "offer_externalTicketOfficeUrl", offer."fieldsUpdated" AS "offer_fieldsUpdated", offer."lastProviderId" AS "offer_lastProviderId", offer."idAtProvider" AS "offer_idAtProvider", offer."isDuo" AS "offer_isDuo", offer."isNational" AS "offer_isNational", offer."lastValidationPrice" AS "offer_lastValidationPrice", offer.name AS offer_name, offer."productId" AS "offer_productId", offer."rankingWeight" AS "offer_rankingWeight", offer."subcategoryId" AS "offer_subcategoryId", offer.url AS offer_url, offer."venueId" AS "offer_venueId", offer."withdrawalDelay" AS "offer_withdrawalDelay", offer."withdrawalDetails" AS "offer_withdrawalDetails", offer."withdrawalType" AS "offer_withdrawalType", offer."offererAddressId" AS "offer_offererAddressId", offer."lastValidationAuthorUserId" AS "offer_lastValidationAuthorUserId", stock.id AS stock_id, stock."isSoftDeleted" AS "stock_isSoftDeleted", stock."beginningDatetime" AS "stock_beginningDatetime", stock."bookingLimitDatetime" AS "stock_bookingLimitDatetime", stock."dateCreated" AS "stock_dateCreated", stock."dateModified" AS "stock_dateModified", stock."dnBookedQuantity" AS "stock_dnBookedQuantity", stock."offerId" AS "stock_offerId", stock.price AS stock_price, stock."priceCategoryId" AS "stock_priceCategoryId", stock.quantity AS stock_quantity, stock."rawProviderQuantity" AS "stock_rawProviderQuantity", stock.features AS stock_features, stock."offererAddressId" AS "stock_offererAddressId", stock."idAtProviders" AS "stock_idAtProviders", stock."dateModifiedAtLastProvider" AS "stock_dateModifiedAtLastProvider", stock."fieldsUpdated" AS "stock_fieldsUpdated", stock."lastProviderId" AS "stock_lastProviderId", price_category_label_1.id AS price_category_label_1_id, price_category_label_1.label AS price_category_label_1_label, price_category_label_1."venueId" AS "price_category_label_1_venueId", price_category_1.id AS price_category_1_id, price_category_1."offerId" AS "price_category_1_offerId", price_category_1.price AS price_category_1_price, price_category_1."priceCategoryLabelId" AS "price_category_1_priceCategoryLabelId", price_category_1."idAtProvider" AS "price_category_1_idAtProvider", address_1.id AS address_1_id, address_1."banId" AS "address_1_banId", address_1."inseeCode" AS "address_1_inseeCode", address_1.street AS address_1_street, address_1."postalCode" AS "address_1_postalCode", address_1.city AS address_1_city, address_1.latitude AS address_1_latitude, address_1.longitude AS address_1_longitude, address_1."departmentCode" AS "address_1_departmentCode", address_1.timezone AS address_1_timezone, address_1."isManualEdition" AS "address_1_isManualEdition", offerer_address_1.id AS offerer_address_1_id, offerer_address_1.label AS offerer_address_1_label, offerer_address_1."addressId" AS "offerer_address_1_addressId", mediation_1."isActive" AS "mediation_1_isActive", mediation_1.id AS mediation_1_id, mediation_1."thumbCount" AS "mediation_1_thumbCount", mediation_1."idAtProviders" AS "mediation_1_idAtProviders", mediation_1."dateModifiedAtLastProvider" AS "mediation_1_dateModifiedAtLastProvider", mediation_1."fieldsUpdated" AS "mediation_1_fieldsUpdated", mediation_1."authorId" AS "mediation_1_authorId", mediation_1.credit AS mediation_1_credit, mediation_1."dateCreated" AS "mediation_1_dateCreated", mediation_1."offerId" AS "mediation_1_offerId", mediation_1."lastProviderId" AS "mediation_1_lastProviderId" FROM offer LEFT OUTER JOIN stock ON stock."offerId" = 427 AND NOT stock."isSoftDeleted" LEFT OUTER JOIN price_category AS price_category_1 ON offer.id = price_category_1."offerId" LEFT OUTER JOIN price_category_label AS price_category_label_1 ON price_category_label_1.id = price_category_1."priceCategoryLabelId" LEFT OUTER JOIN offerer_address AS offerer_address_1 ON offerer_address_1.id = offer."offererAddressId" LEFT OUTER JOIN address AS address_1 ON address_1.id = offerer_address_1."addressId" LEFT OUTER JOIN mediation AS mediation_1 ON offer.id = mediation_1."offerId" WHERE offer.id = 427 6. SELECT EXISTS (SELECT 1 FROM stock WHERE stock."offerId" = 427 AND NOT (stock."beginningDatetime" IS NOT NULL AND stock."beginningDatetime" <= now() OR stock."bookingLimitDatetime" IS NOT NULL AND stock."bookingLimitDatetime" <= now()) AND NOT (stock."isSoftDeleted" OR stock."beginningDatetime" IS NOT NULL AND stock."beginningDatetime" <= now() OR CASE WHEN (stock.quantity IS NULL) THEN NULL ELSE stock.quantity - stock."dnBookedQuantity" END IS NOT NULL AND CASE WHEN (stock.quantity IS NULL) THEN NULL ELSE stock.quantity - stock."dnBookedQuantity" END <= 0)) AS anon_1 7. SELECT venue.timezone AS venue_timezone FROM venue WHERE venue.id = 1149 8. SELECT future_offer.id AS future_offer_id, future_offer."offerId" AS "future_offer_offerId", future_offer."publicationDate" AS "future_offer_publicationDate" FROM future_offer WHERE 427 = future_offer."offerId" 9. SELECT offer.id AS offer_id FROM offer WHERE offer."venueId" = 1149 AND offer.validation = APPROVED LIMIT 1 10. SELECT offerer_confidence_rule.id AS offerer_confidence_rule_id, offerer_confidence_rule."offererId" AS "offerer_confidence_rule_offererId", offerer_confidence_rule."venueId" AS "offerer_confidence_rule_venueId", offerer_confidence_rule."confidenceLevel" AS "offerer_confidence_rule_confidenceLevel" FROM offerer_confidence_rule WHERE 1149 = offerer_confidence_rule."venueId" 11. SELECT venue."managingOffererId" AS "venue_managingOffererId" FROM venue WHERE venue.id = 1149 12. SELECT offerer_confidence_rule.id AS offerer_confidence_rule_id, offerer_confidence_rule."offererId" AS "offerer_confidence_rule_offererId", offerer_confidence_rule."venueId" AS "offerer_confidence_rule_venueId", offerer_confidence_rule."confidenceLevel" AS "offerer_confidence_rule_confidenceLevel" FROM offerer_confidence_rule WHERE 1195 = offerer_confidence_rule."offererId" 13. SELECT offer_validation_rule."isActive" AS "offer_validation_rule_isActive", offer_validation_rule.id AS offer_validation_rule_id, offer_validation_rule.name AS offer_validation_rule_name, offer_validation_sub_rule_1.id AS offer_validation_sub_rule_1_id, offer_validation_sub_rule_1."validationRuleId" AS "offer_validation_sub_rule_1_validationRuleId", offer_validation_sub_rule_1.model AS offer_validation_sub_rule_1_model, offer_validation_sub_rule_1.attribute AS offer_validation_sub_rule_1_attribute, offer_validation_sub_rule_1.operator AS offer_validation_sub_rule_1_operator, offer_validation_sub_rule_1.comparated AS offer_validation_sub_rule_1_comparated FROM offer_validation_rule LEFT OUTER JOIN offer_validation_sub_rule AS offer_validation_sub_rule_1 ON offer_validation_rule.id = offer_validation_sub_rule_1."validationRuleId" WHERE offer_validation_rule."isActive" IS true 14. SELECT venue."audioDisabilityCompliant" AS "venue_audioDisabilityCompliant" FROM venue WHERE venue.id = 1149 15. SELECT venue."mentalDisabilityCompliant" AS "venue_mentalDisabilityCompliant" FROM venue WHERE venue.id = 1149 16. SELECT venue."motorDisabilityCompliant" AS "venue_motorDisabilityCompliant" FROM venue WHERE venue.id = 1149 17. SELECT venue."visualDisabilityCompliant" AS "venue_visualDisabilityCompliant" FROM venue WHERE venue.id = 1149 18. SELECT venue.address AS venue_address FROM venue WHERE venue.id = 1149 19. SELECT venue."bookingEmail" AS "venue_bookingEmail" FROM venue WHERE venue.id = 1149 20. SELECT venue.city AS venue_city FROM venue WHERE venue.id = 1149 21. SELECT venue."isVirtual" AS "venue_isVirtual" FROM venue WHERE venue.id = 1149 22. UPDATE offer SET "lastValidationDate"=2024-10-09 15:15:58.782759, validation=APPROVED, "authorId"=1352, "dateUpdated"=2024-10-09 15:15:58.809344 WHERE offer.id = 427 23. INSERT INTO future_offer ("offerId", "publicationDate") VALUES (427, 2024-11-08 14:00:00) RETURNING future_offer.id

❌ Tests reported 1 failures

ENOENT warning during artifact zip creation. No such file or directory

ENOENT warning during artifact zip creation. No such file or directory

ENOENT warning during artifact zip creation. No such file or directory

The following actions use a deprecated Node.js version and will be forced to run on node20: actions/cache@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

The following actions use a deprecated Node.js version and will be forced to run on node20: technote-space/workflow-conclusion-action@v3, actions/cache@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

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

The following actions use a deprecated Node.js version and will be forced to run on node20: technote-space/workflow-conclusion-action@v3, actions/cache@v3. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

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

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

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

Running e2e-tests with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi:013f28659634606b2c077f8f3ac219c882fdd77e