Skip to content

(PC-30552)[API] feat: Use OA department code as source for compute TZ #4050

(PC-30552)[API] feat: Use OA department code as source for compute TZ

(PC-30552)[API] feat: Use OA department code as source for compute TZ #4050

Triggered via pull request September 4, 2024 15:29
Status Cancelled
Total duration 19m 29s
Artifacts 6
Tests pro  /  ...  /  Style quality check
Tests pro / Type check / Quality check / Style quality check
Tests pro  /  Unit tests
Tests pro / Unit tests
[pcapi-tests] build docker image.  /  Build pcapi-tests:203f4fda8ad6b1a80d903a40c99147210e166b55
3m 43s
[pcapi-tests] build docker image. / Build pcapi-tests:203f4fda8ad6b1a80d903a40c99147210e166b55
[pcapi] build docker image.  /  Build pcapi:203f4fda8ad6b1a80d903a40c99147210e166b55
2m 12s
[pcapi] build docker image. / Build pcapi:203f4fda8ad6b1a80d903a40c99147210e166b55
[pcapi-console] build docker image.  /  Build pcapi-console:203f4fda8ad6b1a80d903a40c99147210e166b55
3m 31s
[pcapi-console] build docker image. / Build pcapi-console:203f4fda8ad6b1a80d903a40c99147210e166b55
MyPy cop  /  MyPy cop test
31s
MyPy cop / MyPy cop test
Tests API documentation  /  Check API documentation can be built
Tests API documentation / Check API documentation can be built
[PRO] Deploy PR version for validation  /  deploy_on_firebase
[PRO] Deploy PR version for validation / deploy_on_firebase
Dependabot  /  dependabot
Dependabot / dependabot
Matrix: Tests api / Pytest
Tests api  /  Quality checks
1m 42s
Tests api / Quality checks
Tests api  /  Pylint
5m 10s
Tests api / Pylint
Tests api  /  Test database schema
2m 53s
Tests api / Test database schema
Tests pro E2E  /  E2E tests and notifications
15m 30s
Tests pro E2E / E2E tests and notifications
Update api client template  /  Update API Client template
1m 54s
Update api client template / Update API Client template
Push pcapi docker image to registry  /  push-docker-image
Push pcapi docker image to registry / push-docker-image
Push pcapi-console docker image to registry  /  push-docker-image
Push pcapi-console docker image to registry / push-docker-image
Fit to window
Zoom out
Zoom in

Annotations

21 errors, 45 warnings, and 3 notices
tests/routes/pro/get_collective_booking_csv_test.py.test_complete_booking_single: tests/routes/pro/get_collective_booking_csv_test.py#L21
Failed: 4 queries executed, 3 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" = 738 AND user_session.uuid = 371762c3-a4ee-4376-84f6-6db3fb003110 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 = 738 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:09.736946 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 738 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_csv_test.py.test_created_booking_single: tests/routes/pro/get_collective_booking_csv_test.py#L60
Failed: 4 queries executed, 3 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" = 739 AND user_session.uuid = d84146b3-75c7-4cff-855d-a01ec7768d79 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 = 739 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:10.209414 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 739 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_csv_test.py.test_one_invisible_rights_booking: tests/routes/pro/get_collective_booking_csv_test.py#L93
Failed: 4 queries executed, 3 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" = 741 AND user_session.uuid = 9bf6feb3-a921-470e-8aa9-859ce1ba67fa 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 = 741 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:10.429799 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 741 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_csv_test.py.test_one_invisible_date_range_booking: tests/routes/pro/get_collective_booking_csv_test.py#L131
Failed: 4 queries executed, 3 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" = 743 AND user_session.uuid = fa9ed104-2d54-44b1-9a53-abbbd0c91102 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 = 743 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:10.641237 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 743 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2015-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_csv_test.py.test_complete_booking_multiple: tests/routes/pro/get_collective_booking_csv_test.py#L170
Failed: 4 queries executed, 3 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" = 744 AND user_session.uuid = 1ce855f8-aecf-4966-9bec-81ac23024cc1 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 = 744 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:10.877372 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 744 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_complete_booking_single: tests/routes/pro/get_collective_booking_excel_test.py#L22
Failed: 4 queries executed, 3 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" = 745 AND user_session.uuid = b298554c-96a7-4cff-8036-37619126ae7c 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 = 745 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:11.029468 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 745 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_created_booking_single: tests/routes/pro/get_collective_booking_excel_test.py#L66
Failed: 4 queries executed, 3 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" = 746 AND user_session.uuid = c3ada230-9d65-4617-b7e8-0c3d25d889db 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 = 746 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:11.184179 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 746 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_one_invisible_rights_booking: tests/routes/pro/get_collective_booking_excel_test.py#L104
Failed: 4 queries executed, 3 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" = 748 AND user_session.uuid = d656c660-67a8-4906-98e8-f2b01048e4a0 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 = 748 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:11.399400 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 748 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_one_invisible_date_range_booking: tests/routes/pro/get_collective_booking_excel_test.py#L150
Failed: 4 queries executed, 3 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" = 750 AND user_session.uuid = 4eeb6080-cbfd-47ee-a3f2-a95e1c8ccc7c 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 = 750 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:11.616853 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 750 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2015-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_complete_booking_multiple: tests/routes/pro/get_collective_booking_excel_test.py#L194
Failed: 4 queries executed, 3 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" = 751 AND user_session.uuid = 7b8d1a33-fe2a-4a7c-a278-9a1429d1d5f5 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 = 751 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:11.857259 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 751 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_booking_status_when_used: tests/routes/pro/get_collective_booking_excel_test.py#L253
Failed: 4 queries executed, 3 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" = 752 AND user_session.uuid = 33157432-0eed-4aa8-9355-9fd47193653e 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 = 752 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:12.013018 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 752 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_booking_status_when_reimbursed: tests/routes/pro/get_collective_booking_excel_test.py#L273
Failed: 4 queries executed, 3 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" = 753 AND user_session.uuid = d41d1cc5-1d5e-4c9b-a344-984a85747672 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 = 753 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:12.167107 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 753 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_booking_status_when_cancelled: tests/routes/pro/get_collective_booking_excel_test.py#L294
Failed: 4 queries executed, 3 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" = 754 AND user_session.uuid = 7272e507-8301-44c7-a744-06131f2e8547 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 = 754 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:12.320957 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 754 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_booking_status_when_pending: tests/routes/pro/get_collective_booking_excel_test.py#L313
Failed: 4 queries executed, 3 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" = 755 AND user_session.uuid = d9607ebd-b539-4097-bbf9-6160defcf307 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 = 755 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:12.468444 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 755 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
tests/routes/pro/get_collective_booking_excel_test.py.test_booking_status_when_confirmed: tests/routes/pro/get_collective_booking_excel_test.py#L332
Failed: 4 queries executed, 3 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" = 756 AND user_session.uuid = ce52d478-a8f8-4d9e-ab0e-7e6ffb9b5538 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 = 756 3. SELECT DISTINCT ON (collective_booking.id) coalesce(nullif(venue."publicName", ), venue.name) AS "venueName", venue."departementCode" AS "venueDepartmentCode", offerer."postalCode" AS "offererPostalCode", collective_offer.name AS "offerName", collective_stock.price AS collective_stock_price, collective_stock."beginningDatetime" AS "stockBeginningDatetime", collective_stock."beginningDatetime" AS "stockBookingLimitDatetime", educational_redactor."firstName" AS "educational_redactor_firstName", educational_redactor."lastName" AS "educational_redactor_lastName", educational_redactor.email AS educational_redactor_email, collective_booking.id AS collective_booking_id, collective_booking."dateCreated" AS "bookedAt", collective_booking."dateUsed" AS "usedAt", collective_booking."reimbursementDate" AS "reimbursedAt", collective_booking.status AS collective_booking_status, collective_booking."cancellationLimitDate" <= 2024-09-04 15:38:12.623752 AS "isConfirmed", educational_institution."institutionId" AS "educational_institution_institutionId", educational_institution.name AS "institutionName", educational_institution."institutionType" AS "educational_institution_institutionType", collective_booking.id AS id, collective_booking."educationalRedactorId" AS "collective_booking_educationalRedactorId" FROM collective_booking JOIN offerer ON offerer.id = collective_booking."offererId" JOIN user_offerer ON offerer.id = user_offerer."offererId" JOIN collective_stock ON collective_stock.id = collective_booking."collectiveStockId" LEFT OUTER JOIN venue ON venue.id = collective_booking."venueId" LEFT OUTER JOIN collective_offer ON collective_offer.id = collective_stock."collectiveOfferId" LEFT OUTER JOIN educational_redactor ON educational_redactor.id = collective_booking."educationalRedactorId" LEFT OUTER JOIN educational_institution ON educational_institution.id = collective_booking."educationalInstitutionId" WHERE 756 = user_offerer."userId" AND user_offerer."validationStatus" = VALIDATED AND CAST(timezone(venue.timezone, timezone(UTC, collective_booking."dateCreated")) AS DATE) BETWEEN SYMMETRIC 2000-01-01 AND 2030-01-01 4. SELECT feature.name AS feature_name, feature."isActive" AS "feature_isActive" FROM feature
Tests api / Pytest (tests/routes -m 'not backoffice')
❌ Tests reported 15 failures
Tests api / Pytest (tests/core --ignore=tests/core/bookings --ignore=tests/core/offers --ignore=tests/core/fi...
Canceling since a higher priority waiting request for '1 [on_pull_request] Initiate workflow-13981' exists
Tests api / Pytest (tests/routes/backoffice -m 'backoffice')
Canceling since a higher priority waiting request for '1 [on_pull_request] Initiate workflow-13981' exists
Tests api / Pytest (tests/routes/backoffice -m 'backoffice')
The operation was canceled.
Update api client template / Update API Client template
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-node@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Update api client template / Update API Client template
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/setup-node@v2, 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/
Tests api / Quality checks
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests api / Quality checks
The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Tests api / Quality checks
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Quality checks
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Quality checks
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Test database schema
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests api / Test database schema
The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Tests api / Test database schema
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Test database schema
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Test database schema
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests --ignore=tests/core --ignore=tests/routes)
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests api / Pytest (tests --ignore=tests/core --ignore=tests/routes)
The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Tests api / Pytest (tests --ignore=tests/core --ignore=tests/routes)
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests --ignore=tests/core --ignore=tests/routes)
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests --ignore=tests/core --ignore=tests/routes)
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/core/bookings tests/core/offers tests/core/finance)
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests api / Pytest (tests/core/bookings tests/core/offers tests/core/finance)
The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Tests api / Pytest (tests/core/bookings tests/core/offers tests/core/finance)
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/core/bookings tests/core/offers tests/core/finance)
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/core/bookings tests/core/offers tests/core/finance)
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pylint
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests api / Pylint
The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Tests api / Pylint
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pylint
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pylint
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes -m 'not backoffice')
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests api / Pytest (tests/routes -m 'not backoffice')
The following actions use a deprecated Node.js version and will be forced to run on node20: docker/login-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
Tests api / Pytest (tests/routes -m 'not backoffice')
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes -m 'not backoffice')
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes -m 'not backoffice')
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/core --ignore=tests/core/bookings --ignore=tests/core/offers --ignore=tests/core/fi...
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/core --ignore=tests/core/bookings --ignore=tests/core/offers --ignore=tests/core/fi...
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/core --ignore=tests/core/bookings --ignore=tests/core/offers --ignore=tests/core/fi...
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes/backoffice -m 'backoffice')
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes/backoffice -m 'backoffice')
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes/backoffice -m 'backoffice')
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests api / Pytest (tests/routes/backoffice -m 'backoffice')
Docker network rm failed with exit code 1
Tests pro E2E / E2E tests and notifications
The following actions uses node12 which is deprecated and will be forced to run on node16: docker/login-action@v1. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Tests pro E2E / E2E tests and notifications
The following actions use a deprecated Node.js version and will be forced to run on node20: technote-space/workflow-conclusion-action@v3, docker/login-action@v1, actions/setup-node@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/
Tests pro E2E / E2E tests and notifications
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.
Tests pro E2E / E2E tests and notifications
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests pro E2E / E2E tests and notifications
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Tests pro E2E / E2E tests and notifications
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
Update api client template / Update API Client template
Running update api client template with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi:203f4fda8ad6b1a80d903a40c99147210e166b55
Tests api / Quality checks
Running tests api with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi-tests:203f4fda8ad6b1a80d903a40c99147210e166b55
Tests pro E2E / E2E tests and notifications
Running e2e-tests with europe-west1-docker.pkg.dev/passculture-infra-prod/pass-culture-artifact-registry/pcapi:203f4fda8ad6b1a80d903a40c99147210e166b55

Artifacts

Produced during runtime
Name Size
pass-culture~pass-culture-main~CRZW5M.dockerbuild
91.6 KB
pass-culture~pass-culture-main~OGG7ZN.dockerbuild
80.5 KB
pass-culture~pass-culture-main~QXHSER.dockerbuild
156 KB
pcapi-203f4fda8ad6b1a80d903a40c99147210e166b55.tar Expired
301 MB
pcapi-console-203f4fda8ad6b1a80d903a40c99147210e166b55.tar Expired
473 MB
pcapi-tests-203f4fda8ad6b1a80d903a40c99147210e166b55.tar Expired
531 MB