Init download API (not working)

.gitea/workflows/deploy.yml

@@ -1,27 +0,0 @@
-name: "Build and push image"
-
-on:
-  push:
-    branches:
-      - main
-
-jobs:
-  deploy:
-    name: "Build Docker image"
-    runs-on: ubuntu-latest
-    steps:
-      - name: Login to Docker Hub
-        uses: docker/login-action@v3
-        with:
-          registry: registry.docker.polytech.djalim.fr
-          username: ${{ secrets.registry_login }}
-          password: ${{ secrets.registry_pass }}
-
-      - name: Set up Docker Buildx
-        uses: docker/setup-buildx-action@v3
-
-      - name: Build and push
-        uses: docker/build-push-action@v6
-        with:
-          push: true
-          tags: registry.docker.polytech.djalim.fr/polympr:latest

.github/workflows/main.yml

@@ -24,6 +24,3 @@ jobs:
 
       - name: Check linting
         run: deno lint
-
-      - name: Run tests
-        run: deno test -A --no-check tests/

Dockerfile

@@ -3,11 +3,11 @@ FROM denoland/deno:alpine
 WORKDIR /app
 
 COPY . .
-RUN deno cache main.ts --allow-import
+RUN deno cache main.ts --allow-import flag
 RUN deno task build
 
 USER deno
 EXPOSE 80
 EXPOSE 443
 
-CMD ["run", "-A", "main.ts"]
+CMD ["run", "-A", "main.ts"]

bun.lock

@@ -1,233 +0,0 @@
-{
-  "lockfileVersion": 1,
-  "configVersion": 1,
-  "workspaces": {
-    "": {
-      "dependencies": {
-        "dotenv": "^17.4.0",
-        "drizzle-orm": "^0.45.2",
-        "pg": "^8.20.0",
-      },
-      "devDependencies": {
-        "@types/pg": "^8.20.0",
-        "drizzle-kit": "^0.31.10",
-        "tsx": "^4.21.0",
-      },
-    },
-  },
-  "packages": {
-    "@drizzle-team/brocli": ["@drizzle-team/brocli@0.10.2", "", {}, "sha512-z33Il7l5dKjUgGULTqBsQBQwckHh5AbIuxhdsIxDDiZAzBOrZO6q9ogcWC65kU382AfynTfgNumVcNIjuIua6w=="],
-
-    "@esbuild-kit/core-utils": ["@esbuild-kit/core-utils@3.3.2", "", { "dependencies": { "esbuild": "~0.18.20", "source-map-support": "^0.5.21" } }, "sha512-sPRAnw9CdSsRmEtnsl2WXWdyquogVpB3yZ3dgwJfe8zrOzTsV7cJvmwrKVa+0ma5BoiGJ+BoqkMvawbayKUsqQ=="],
-
-    "@esbuild-kit/esm-loader": ["@esbuild-kit/esm-loader@2.6.5", "", { "dependencies": { "@esbuild-kit/core-utils": "^3.3.2", "get-tsconfig": "^4.7.0" } }, "sha512-FxEMIkJKnodyA1OaCUoEvbYRkoZlLZ4d/eXFu9Fh8CbBBgP5EmZxrfTRyN0qpXZ4vOvqnE5YdRdcrmUUXuU+dA=="],
-
-    "@esbuild/aix-ppc64": ["@esbuild/aix-ppc64@0.25.12", "", { "os": "aix", "cpu": "ppc64" }, "sha512-Hhmwd6CInZ3dwpuGTF8fJG6yoWmsToE+vYgD4nytZVxcu1ulHpUQRAB1UJ8+N1Am3Mz4+xOByoQoSZf4D+CpkA=="],
-
-    "@esbuild/android-arm": ["@esbuild/android-arm@0.25.12", "", { "os": "android", "cpu": "arm" }, "sha512-VJ+sKvNA/GE7Ccacc9Cha7bpS8nyzVv0jdVgwNDaR4gDMC/2TTRc33Ip8qrNYUcpkOHUT5OZ0bUcNNVZQ9RLlg=="],
-
-    "@esbuild/android-arm64": ["@esbuild/android-arm64@0.25.12", "", { "os": "android", "cpu": "arm64" }, "sha512-6AAmLG7zwD1Z159jCKPvAxZd4y/VTO0VkprYy+3N2FtJ8+BQWFXU+OxARIwA46c5tdD9SsKGZ/1ocqBS/gAKHg=="],
-
-    "@esbuild/android-x64": ["@esbuild/android-x64@0.25.12", "", { "os": "android", "cpu": "x64" }, "sha512-5jbb+2hhDHx5phYR2By8GTWEzn6I9UqR11Kwf22iKbNpYrsmRB18aX/9ivc5cabcUiAT/wM+YIZ6SG9QO6a8kg=="],
-
-    "@esbuild/darwin-arm64": ["@esbuild/darwin-arm64@0.25.12", "", { "os": "darwin", "cpu": "arm64" }, "sha512-N3zl+lxHCifgIlcMUP5016ESkeQjLj/959RxxNYIthIg+CQHInujFuXeWbWMgnTo4cp5XVHqFPmpyu9J65C1Yg=="],
-
-    "@esbuild/darwin-x64": ["@esbuild/darwin-x64@0.25.12", "", { "os": "darwin", "cpu": "x64" }, "sha512-HQ9ka4Kx21qHXwtlTUVbKJOAnmG1ipXhdWTmNXiPzPfWKpXqASVcWdnf2bnL73wgjNrFXAa3yYvBSd9pzfEIpA=="],
-
-    "@esbuild/freebsd-arm64": ["@esbuild/freebsd-arm64@0.25.12", "", { "os": "freebsd", "cpu": "arm64" }, "sha512-gA0Bx759+7Jve03K1S0vkOu5Lg/85dou3EseOGUes8flVOGxbhDDh/iZaoek11Y8mtyKPGF3vP8XhnkDEAmzeg=="],
-
-    "@esbuild/freebsd-x64": ["@esbuild/freebsd-x64@0.25.12", "", { "os": "freebsd", "cpu": "x64" }, "sha512-TGbO26Yw2xsHzxtbVFGEXBFH0FRAP7gtcPE7P5yP7wGy7cXK2oO7RyOhL5NLiqTlBh47XhmIUXuGciXEqYFfBQ=="],
-
-    "@esbuild/linux-arm": ["@esbuild/linux-arm@0.25.12", "", { "os": "linux", "cpu": "arm" }, "sha512-lPDGyC1JPDou8kGcywY0YILzWlhhnRjdof3UlcoqYmS9El818LLfJJc3PXXgZHrHCAKs/Z2SeZtDJr5MrkxtOw=="],
-
-    "@esbuild/linux-arm64": ["@esbuild/linux-arm64@0.25.12", "", { "os": "linux", "cpu": "arm64" }, "sha512-8bwX7a8FghIgrupcxb4aUmYDLp8pX06rGh5HqDT7bB+8Rdells6mHvrFHHW2JAOPZUbnjUpKTLg6ECyzvas2AQ=="],
-
-    "@esbuild/linux-ia32": ["@esbuild/linux-ia32@0.25.12", "", { "os": "linux", "cpu": "ia32" }, "sha512-0y9KrdVnbMM2/vG8KfU0byhUN+EFCny9+8g202gYqSSVMonbsCfLjUO+rCci7pM0WBEtz+oK/PIwHkzxkyharA=="],
-
-    "@esbuild/linux-loong64": ["@esbuild/linux-loong64@0.25.12", "", { "os": "linux", "cpu": "none" }, "sha512-h///Lr5a9rib/v1GGqXVGzjL4TMvVTv+s1DPoxQdz7l/AYv6LDSxdIwzxkrPW438oUXiDtwM10o9PmwS/6Z0Ng=="],
-
-    "@esbuild/linux-mips64el": ["@esbuild/linux-mips64el@0.25.12", "", { "os": "linux", "cpu": "none" }, "sha512-iyRrM1Pzy9GFMDLsXn1iHUm18nhKnNMWscjmp4+hpafcZjrr2WbT//d20xaGljXDBYHqRcl8HnxbX6uaA/eGVw=="],
-
-    "@esbuild/linux-ppc64": ["@esbuild/linux-ppc64@0.25.12", "", { "os": "linux", "cpu": "ppc64" }, "sha512-9meM/lRXxMi5PSUqEXRCtVjEZBGwB7P/D4yT8UG/mwIdze2aV4Vo6U5gD3+RsoHXKkHCfSxZKzmDssVlRj1QQA=="],
-
-    "@esbuild/linux-riscv64": ["@esbuild/linux-riscv64@0.25.12", "", { "os": "linux", "cpu": "none" }, "sha512-Zr7KR4hgKUpWAwb1f3o5ygT04MzqVrGEGXGLnj15YQDJErYu/BGg+wmFlIDOdJp0PmB0lLvxFIOXZgFRrdjR0w=="],
-
-    "@esbuild/linux-s390x": ["@esbuild/linux-s390x@0.25.12", "", { "os": "linux", "cpu": "s390x" }, "sha512-MsKncOcgTNvdtiISc/jZs/Zf8d0cl/t3gYWX8J9ubBnVOwlk65UIEEvgBORTiljloIWnBzLs4qhzPkJcitIzIg=="],
-
-    "@esbuild/linux-x64": ["@esbuild/linux-x64@0.25.12", "", { "os": "linux", "cpu": "x64" }, "sha512-uqZMTLr/zR/ed4jIGnwSLkaHmPjOjJvnm6TVVitAa08SLS9Z0VM8wIRx7gWbJB5/J54YuIMInDquWyYvQLZkgw=="],
-
-    "@esbuild/netbsd-arm64": ["@esbuild/netbsd-arm64@0.25.12", "", { "os": "none", "cpu": "arm64" }, "sha512-xXwcTq4GhRM7J9A8Gv5boanHhRa/Q9KLVmcyXHCTaM4wKfIpWkdXiMog/KsnxzJ0A1+nD+zoecuzqPmCRyBGjg=="],
-
-    "@esbuild/netbsd-x64": ["@esbuild/netbsd-x64@0.25.12", "", { "os": "none", "cpu": "x64" }, "sha512-Ld5pTlzPy3YwGec4OuHh1aCVCRvOXdH8DgRjfDy/oumVovmuSzWfnSJg+VtakB9Cm0gxNO9BzWkj6mtO1FMXkQ=="],
-
-    "@esbuild/openbsd-arm64": ["@esbuild/openbsd-arm64@0.25.12", "", { "os": "openbsd", "cpu": "arm64" }, "sha512-fF96T6KsBo/pkQI950FARU9apGNTSlZGsv1jZBAlcLL1MLjLNIWPBkj5NlSz8aAzYKg+eNqknrUJ24QBybeR5A=="],
-
-    "@esbuild/openbsd-x64": ["@esbuild/openbsd-x64@0.25.12", "", { "os": "openbsd", "cpu": "x64" }, "sha512-MZyXUkZHjQxUvzK7rN8DJ3SRmrVrke8ZyRusHlP+kuwqTcfWLyqMOE3sScPPyeIXN/mDJIfGXvcMqCgYKekoQw=="],
-
-    "@esbuild/openharmony-arm64": ["@esbuild/openharmony-arm64@0.25.12", "", { "os": "none", "cpu": "arm64" }, "sha512-rm0YWsqUSRrjncSXGA7Zv78Nbnw4XL6/dzr20cyrQf7ZmRcsovpcRBdhD43Nuk3y7XIoW2OxMVvwuRvk9XdASg=="],
-
-    "@esbuild/sunos-x64": ["@esbuild/sunos-x64@0.25.12", "", { "os": "sunos", "cpu": "x64" }, "sha512-3wGSCDyuTHQUzt0nV7bocDy72r2lI33QL3gkDNGkod22EsYl04sMf0qLb8luNKTOmgF/eDEDP5BFNwoBKH441w=="],
-
-    "@esbuild/win32-arm64": ["@esbuild/win32-arm64@0.25.12", "", { "os": "win32", "cpu": "arm64" }, "sha512-rMmLrur64A7+DKlnSuwqUdRKyd3UE7oPJZmnljqEptesKM8wx9J8gx5u0+9Pq0fQQW8vqeKebwNXdfOyP+8Bsg=="],
-
-    "@esbuild/win32-ia32": ["@esbuild/win32-ia32@0.25.12", "", { "os": "win32", "cpu": "ia32" }, "sha512-HkqnmmBoCbCwxUKKNPBixiWDGCpQGVsrQfJoVGYLPT41XWF8lHuE5N6WhVia2n4o5QK5M4tYr21827fNhi4byQ=="],
-
-    "@esbuild/win32-x64": ["@esbuild/win32-x64@0.25.12", "", { "os": "win32", "cpu": "x64" }, "sha512-alJC0uCZpTFrSL0CCDjcgleBXPnCrEAhTBILpeAp7M/OFgoqtAetfBzX0xM00MUsVVPpVjlPuMbREqnZCXaTnA=="],
-
-    "@types/node": ["@types/node@25.5.0", "", { "dependencies": { "undici-types": "~7.18.0" } }, "sha512-jp2P3tQMSxWugkCUKLRPVUpGaL5MVFwF8RDuSRztfwgN1wmqJeMSbKlnEtQqU8UrhTmzEmZdu2I6v2dpp7XIxw=="],
-
-    "@types/pg": ["@types/pg@8.20.0", "", { "dependencies": { "@types/node": "*", "pg-protocol": "*", "pg-types": "^2.2.0" } }, "sha512-bEPFOaMAHTEP1EzpvHTbmwR8UsFyHSKsRisLIHVMXnpNefSbGA1bD6CVy+qKjGSqmZqNqBDV2azOBo8TgkcVow=="],
-
-    "buffer-from": ["buffer-from@1.1.2", "", {}, "sha512-E+XQCRwSbaaiChtv6k6Dwgc+bx+Bs6vuKJHHl5kox/BaKbhiXzqQOwK4cO22yElGp2OCmjwVhT3HmxgyPGnJfQ=="],
-
-    "dotenv": ["dotenv@17.4.0", "", {}, "sha512-kCKF62fwtzwYm0IGBNjRUjtJgMfGapII+FslMHIjMR5KTnwEmBmWLDRSnc3XSNP8bNy34tekgQyDT0hr7pERRQ=="],
-
-    "drizzle-kit": ["drizzle-kit@0.31.10", "", { "dependencies": { "@drizzle-team/brocli": "^0.10.2", "@esbuild-kit/esm-loader": "^2.5.5", "esbuild": "^0.25.4", "tsx": "^4.21.0" }, "bin": { "drizzle-kit": "bin.cjs" } }, "sha512-7OZcmQUrdGI+DUNNsKBn1aW8qSoKuTH7d0mYgSP8bAzdFzKoovxEFnoGQp2dVs82EOJeYycqRtciopszwUf8bw=="],
-
-    "drizzle-orm": ["drizzle-orm@0.45.2", "", { "peerDependencies": { "@aws-sdk/client-rds-data": ">=3", "@cloudflare/workers-types": ">=4", "@electric-sql/pglite": ">=0.2.0", "@libsql/client": ">=0.10.0", "@libsql/client-wasm": ">=0.10.0", "@neondatabase/serverless": ">=0.10.0", "@op-engineering/op-sqlite": ">=2", "@opentelemetry/api": "^1.4.1", "@planetscale/database": ">=1.13", "@prisma/client": "*", "@tidbcloud/serverless": "*", "@types/better-sqlite3": "*", "@types/pg": "*", "@types/sql.js": "*", "@upstash/redis": ">=1.34.7", "@vercel/postgres": ">=0.8.0", "@xata.io/client": "*", "better-sqlite3": ">=7", "bun-types": "*", "expo-sqlite": ">=14.0.0", "gel": ">=2", "knex": "*", "kysely": "*", "mysql2": ">=2", "pg": ">=8", "postgres": ">=3", "sql.js": ">=1", "sqlite3": ">=5" }, "optionalPeers": ["@aws-sdk/client-rds-data", "@cloudflare/workers-types", "@electric-sql/pglite", "@libsql/client", "@libsql/client-wasm", "@neondatabase/serverless", "@op-engineering/op-sqlite", "@opentelemetry/api", "@planetscale/database", "@prisma/client", "@tidbcloud/serverless", "@types/better-sqlite3", "@types/pg", "@types/sql.js", "@upstash/redis", "@vercel/postgres", "@xata.io/client", "better-sqlite3", "bun-types", "expo-sqlite", "gel", "knex", "kysely", "mysql2", "pg", "postgres", "sql.js", "sqlite3"] }, "sha512-kY0BSaTNYWnoDMVoyY8uxmyHjpJW1geOmBMdSSicKo9CIIWkSxMIj2rkeSR51b8KAPB7m+qysjuHme5nKP+E5Q=="],
-
-    "esbuild": ["esbuild@0.25.12", "", { "optionalDependencies": { "@esbuild/aix-ppc64": "0.25.12", "@esbuild/android-arm": "0.25.12", "@esbuild/android-arm64": "0.25.12", "@esbuild/android-x64": "0.25.12", "@esbuild/darwin-arm64": "0.25.12", "@esbuild/darwin-x64": "0.25.12", "@esbuild/freebsd-arm64": "0.25.12", "@esbuild/freebsd-x64": "0.25.12", "@esbuild/linux-arm": "0.25.12", "@esbuild/linux-arm64": "0.25.12", "@esbuild/linux-ia32": "0.25.12", "@esbuild/linux-loong64": "0.25.12", "@esbuild/linux-mips64el": "0.25.12", "@esbuild/linux-ppc64": "0.25.12", "@esbuild/linux-riscv64": "0.25.12", "@esbuild/linux-s390x": "0.25.12", "@esbuild/linux-x64": "0.25.12", "@esbuild/netbsd-arm64": "0.25.12", "@esbuild/netbsd-x64": "0.25.12", "@esbuild/openbsd-arm64": "0.25.12", "@esbuild/openbsd-x64": "0.25.12", "@esbuild/openharmony-arm64": "0.25.12", "@esbuild/sunos-x64": "0.25.12", "@esbuild/win32-arm64": "0.25.12", "@esbuild/win32-ia32": "0.25.12", "@esbuild/win32-x64": "0.25.12" }, "bin": { "esbuild": "bin/esbuild" } }, "sha512-bbPBYYrtZbkt6Os6FiTLCTFxvq4tt3JKall1vRwshA3fdVztsLAatFaZobhkBC8/BrPetoa0oksYoKXoG4ryJg=="],
-
-    "fsevents": ["fsevents@2.3.3", "", { "os": "darwin" }, "sha512-5xoDfX+fL7faATnagmWPpbFtwh/R77WmMMqqHGS65C3vvB0YHrgF+B1YmZ3441tMj5n63k0212XNoJwzlhffQw=="],
-
-    "get-tsconfig": ["get-tsconfig@4.13.7", "", { "dependencies": { "resolve-pkg-maps": "^1.0.0" } }, "sha512-7tN6rFgBlMgpBML5j8typ92BKFi2sFQvIdpAqLA2beia5avZDrMs0FLZiM5etShWq5irVyGcGMEA1jcDaK7A/Q=="],
-
-    "pg": ["pg@8.20.0", "", { "dependencies": { "pg-connection-string": "^2.12.0", "pg-pool": "^3.13.0", "pg-protocol": "^1.13.0", "pg-types": "2.2.0", "pgpass": "1.0.5" }, "optionalDependencies": { "pg-cloudflare": "^1.3.0" }, "peerDependencies": { "pg-native": ">=3.0.1" }, "optionalPeers": ["pg-native"] }, "sha512-ldhMxz2r8fl/6QkXnBD3CR9/xg694oT6DZQ2s6c/RI28OjtSOpxnPrUCGOBJ46RCUxcWdx3p6kw/xnDHjKvaRA=="],
-
-    "pg-cloudflare": ["pg-cloudflare@1.3.0", "", {}, "sha512-6lswVVSztmHiRtD6I8hw4qP/nDm1EJbKMRhf3HCYaqud7frGysPv7FYJ5noZQdhQtN2xJnimfMtvQq21pdbzyQ=="],
-
-    "pg-connection-string": ["pg-connection-string@2.12.0", "", {}, "sha512-U7qg+bpswf3Cs5xLzRqbXbQl85ng0mfSV/J0nnA31MCLgvEaAo7CIhmeyrmJpOr7o+zm0rXK+hNnT5l9RHkCkQ=="],
-
-    "pg-int8": ["pg-int8@1.0.1", "", {}, "sha512-WCtabS6t3c8SkpDBUlb1kjOs7l66xsGdKpIPZsg4wR+B3+u9UAum2odSsF9tnvxg80h4ZxLWMy4pRjOsFIqQpw=="],
-
-    "pg-pool": ["pg-pool@3.13.0", "", { "peerDependencies": { "pg": ">=8.0" } }, "sha512-gB+R+Xud1gLFuRD/QgOIgGOBE2KCQPaPwkzBBGC9oG69pHTkhQeIuejVIk3/cnDyX39av2AxomQiyPT13WKHQA=="],
-
-    "pg-protocol": ["pg-protocol@1.13.0", "", {}, "sha512-zzdvXfS6v89r6v7OcFCHfHlyG/wvry1ALxZo4LqgUoy7W9xhBDMaqOuMiF3qEV45VqsN6rdlcehHrfDtlCPc8w=="],
-
-    "pg-types": ["pg-types@2.2.0", "", { "dependencies": { "pg-int8": "1.0.1", "postgres-array": "~2.0.0", "postgres-bytea": "~1.0.0", "postgres-date": "~1.0.4", "postgres-interval": "^1.1.0" } }, "sha512-qTAAlrEsl8s4OiEQY69wDvcMIdQN6wdz5ojQiOy6YRMuynxenON0O5oCpJI6lshc6scgAY8qvJ2On/p+CXY0GA=="],
-
-    "pgpass": ["pgpass@1.0.5", "", { "dependencies": { "split2": "^4.1.0" } }, "sha512-FdW9r/jQZhSeohs1Z3sI1yxFQNFvMcnmfuj4WBMUTxOrAyLMaTcE1aAMBiTlbMNaXvBCQuVi0R7hd8udDSP7ug=="],
-
-    "postgres-array": ["postgres-array@2.0.0", "", {}, "sha512-VpZrUqU5A69eQyW2c5CA1jtLecCsN2U/bD6VilrFDWq5+5UIEVO7nazS3TEcHf1zuPYO/sqGvUvW62g86RXZuA=="],
-
-    "postgres-bytea": ["postgres-bytea@1.0.1", "", {}, "sha512-5+5HqXnsZPE65IJZSMkZtURARZelel2oXUEO8rH83VS/hxH5vv1uHquPg5wZs8yMAfdv971IU+kcPUczi7NVBQ=="],
-
-    "postgres-date": ["postgres-date@1.0.7", "", {}, "sha512-suDmjLVQg78nMK2UZ454hAG+OAW+HQPZ6n++TNDUX+L0+uUlLywnoxJKDou51Zm+zTCjrCl0Nq6J9C5hP9vK/Q=="],
-
-    "postgres-interval": ["postgres-interval@1.2.0", "", { "dependencies": { "xtend": "^4.0.0" } }, "sha512-9ZhXKM/rw350N1ovuWHbGxnGh/SNJ4cnxHiM0rxE4VN41wsg8P8zWn9hv/buK00RP4WvlOyr/RBDiptyxVbkZQ=="],
-
-    "resolve-pkg-maps": ["resolve-pkg-maps@1.0.0", "", {}, "sha512-seS2Tj26TBVOC2NIc2rOe2y2ZO7efxITtLZcGSOnHHNOQ7CkiUBfw0Iw2ck6xkIhPwLhKNLS8BO+hEpngQlqzw=="],
-
-    "source-map": ["source-map@0.6.1", "", {}, "sha512-UjgapumWlbMhkBgzT7Ykc5YXUT46F0iKu8SGXq0bcwP5dz/h0Plj6enJqjz1Zbq2l5WaqYnrVbwWOWMyF3F47g=="],
-
-    "source-map-support": ["source-map-support@0.5.21", "", { "dependencies": { "buffer-from": "^1.0.0", "source-map": "^0.6.0" } }, "sha512-uBHU3L3czsIyYXKX88fdrGovxdSCoTGDRZ6SYXtSRxLZUzHg5P/66Ht6uoUlHu9EZod+inXhKo3qQgwXUT/y1w=="],
-
-    "split2": ["split2@4.2.0", "", {}, "sha512-UcjcJOWknrNkF6PLX83qcHM6KHgVKNkV62Y8a5uYDVv9ydGQVwAHMKqHdJje1VTWpljG0WYpCDhrCdAOYH4TWg=="],
-
-    "tsx": ["tsx@4.21.0", "", { "dependencies": { "esbuild": "~0.27.0", "get-tsconfig": "^4.7.5" }, "optionalDependencies": { "fsevents": "~2.3.3" }, "bin": { "tsx": "dist/cli.mjs" } }, "sha512-5C1sg4USs1lfG0GFb2RLXsdpXqBSEhAaA/0kPL01wxzpMqLILNxIxIOKiILz+cdg/pLnOUxFYOR5yhHU666wbw=="],
-
-    "undici-types": ["undici-types@7.18.2", "", {}, "sha512-AsuCzffGHJybSaRrmr5eHr81mwJU3kjw6M+uprWvCXiNeN9SOGwQ3Jn8jb8m3Z6izVgknn1R0FTCEAP2QrLY/w=="],
-
-    "xtend": ["xtend@4.0.2", "", {}, "sha512-LKYU1iAXJXUgAXn9URjiu+MWhyUXHsvfp7mcuYm9dSUKK0/CjtrUwFAxD82/mCWbtLsGjFIad0wIsod4zrTAEQ=="],
-
-    "@esbuild-kit/core-utils/esbuild": ["esbuild@0.18.20", "", { "optionalDependencies": { "@esbuild/android-arm": "0.18.20", "@esbuild/android-arm64": "0.18.20", "@esbuild/android-x64": "0.18.20", "@esbuild/darwin-arm64": "0.18.20", "@esbuild/darwin-x64": "0.18.20", "@esbuild/freebsd-arm64": "0.18.20", "@esbuild/freebsd-x64": "0.18.20", "@esbuild/linux-arm": "0.18.20", "@esbuild/linux-arm64": "0.18.20", "@esbuild/linux-ia32": "0.18.20", "@esbuild/linux-loong64": "0.18.20", "@esbuild/linux-mips64el": "0.18.20", "@esbuild/linux-ppc64": "0.18.20", "@esbuild/linux-riscv64": "0.18.20", "@esbuild/linux-s390x": "0.18.20", "@esbuild/linux-x64": "0.18.20", "@esbuild/netbsd-x64": "0.18.20", "@esbuild/openbsd-x64": "0.18.20", "@esbuild/sunos-x64": "0.18.20", "@esbuild/win32-arm64": "0.18.20", "@esbuild/win32-ia32": "0.18.20", "@esbuild/win32-x64": "0.18.20" }, "bin": { "esbuild": "bin/esbuild" } }, "sha512-ceqxoedUrcayh7Y7ZX6NdbbDzGROiyVBgC4PriJThBKSVPWnnFHZAkfI1lJT8QFkOwH4qOS2SJkS4wvpGl8BpA=="],
-
-    "tsx/esbuild": ["esbuild@0.27.7", "", { "optionalDependencies": { "@esbuild/aix-ppc64": "0.27.7", "@esbuild/android-arm": "0.27.7", "@esbuild/android-arm64": "0.27.7", "@esbuild/android-x64": "0.27.7", "@esbuild/darwin-arm64": "0.27.7", "@esbuild/darwin-x64": "0.27.7", "@esbuild/freebsd-arm64": "0.27.7", "@esbuild/freebsd-x64": "0.27.7", "@esbuild/linux-arm": "0.27.7", "@esbuild/linux-arm64": "0.27.7", "@esbuild/linux-ia32": "0.27.7", "@esbuild/linux-loong64": "0.27.7", "@esbuild/linux-mips64el": "0.27.7", "@esbuild/linux-ppc64": "0.27.7", "@esbuild/linux-riscv64": "0.27.7", "@esbuild/linux-s390x": "0.27.7", "@esbuild/linux-x64": "0.27.7", "@esbuild/netbsd-arm64": "0.27.7", "@esbuild/netbsd-x64": "0.27.7", "@esbuild/openbsd-arm64": "0.27.7", "@esbuild/openbsd-x64": "0.27.7", "@esbuild/openharmony-arm64": "0.27.7", "@esbuild/sunos-x64": "0.27.7", "@esbuild/win32-arm64": "0.27.7", "@esbuild/win32-ia32": "0.27.7", "@esbuild/win32-x64": "0.27.7" }, "bin": { "esbuild": "bin/esbuild" } }, "sha512-IxpibTjyVnmrIQo5aqNpCgoACA/dTKLTlhMHihVHhdkxKyPO1uBBthumT0rdHmcsk9uMonIWS0m4FljWzILh3w=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/android-arm": ["@esbuild/android-arm@0.18.20", "", { "os": "android", "cpu": "arm" }, "sha512-fyi7TDI/ijKKNZTUJAQqiG5T7YjJXgnzkURqmGj13C6dCqckZBLdl4h7bkhHt/t0WP+zO9/zwroDvANaOqO5Sw=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/android-arm64": ["@esbuild/android-arm64@0.18.20", "", { "os": "android", "cpu": "arm64" }, "sha512-Nz4rJcchGDtENV0eMKUNa6L12zz2zBDXuhj/Vjh18zGqB44Bi7MBMSXjgunJgjRhCmKOjnPuZp4Mb6OKqtMHLQ=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/android-x64": ["@esbuild/android-x64@0.18.20", "", { "os": "android", "cpu": "x64" }, "sha512-8GDdlePJA8D6zlZYJV/jnrRAi6rOiNaCC/JclcXpB+KIuvfBN4owLtgzY2bsxnx666XjJx2kDPUmnTtR8qKQUg=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/darwin-arm64": ["@esbuild/darwin-arm64@0.18.20", "", { "os": "darwin", "cpu": "arm64" }, "sha512-bxRHW5kHU38zS2lPTPOyuyTm+S+eobPUnTNkdJEfAddYgEcll4xkT8DB9d2008DtTbl7uJag2HuE5NZAZgnNEA=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/darwin-x64": ["@esbuild/darwin-x64@0.18.20", "", { "os": "darwin", "cpu": "x64" }, "sha512-pc5gxlMDxzm513qPGbCbDukOdsGtKhfxD1zJKXjCCcU7ju50O7MeAZ8c4krSJcOIJGFR+qx21yMMVYwiQvyTyQ=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/freebsd-arm64": ["@esbuild/freebsd-arm64@0.18.20", "", { "os": "freebsd", "cpu": "arm64" }, "sha512-yqDQHy4QHevpMAaxhhIwYPMv1NECwOvIpGCZkECn8w2WFHXjEwrBn3CeNIYsibZ/iZEUemj++M26W3cNR5h+Tw=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/freebsd-x64": ["@esbuild/freebsd-x64@0.18.20", "", { "os": "freebsd", "cpu": "x64" }, "sha512-tgWRPPuQsd3RmBZwarGVHZQvtzfEBOreNuxEMKFcd5DaDn2PbBxfwLcj4+aenoh7ctXcbXmOQIn8HI6mCSw5MQ=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-arm": ["@esbuild/linux-arm@0.18.20", "", { "os": "linux", "cpu": "arm" }, "sha512-/5bHkMWnq1EgKr1V+Ybz3s1hWXok7mDFUMQ4cG10AfW3wL02PSZi5kFpYKrptDsgb2WAJIvRcDm+qIvXf/apvg=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-arm64": ["@esbuild/linux-arm64@0.18.20", "", { "os": "linux", "cpu": "arm64" }, "sha512-2YbscF+UL7SQAVIpnWvYwM+3LskyDmPhe31pE7/aoTMFKKzIc9lLbyGUpmmb8a8AixOL61sQ/mFh3jEjHYFvdA=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-ia32": ["@esbuild/linux-ia32@0.18.20", "", { "os": "linux", "cpu": "ia32" }, "sha512-P4etWwq6IsReT0E1KHU40bOnzMHoH73aXp96Fs8TIT6z9Hu8G6+0SHSw9i2isWrD2nbx2qo5yUqACgdfVGx7TA=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-loong64": ["@esbuild/linux-loong64@0.18.20", "", { "os": "linux", "cpu": "none" }, "sha512-nXW8nqBTrOpDLPgPY9uV+/1DjxoQ7DoB2N8eocyq8I9XuqJ7BiAMDMf9n1xZM9TgW0J8zrquIb/A7s3BJv7rjg=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-mips64el": ["@esbuild/linux-mips64el@0.18.20", "", { "os": "linux", "cpu": "none" }, "sha512-d5NeaXZcHp8PzYy5VnXV3VSd2D328Zb+9dEq5HE6bw6+N86JVPExrA6O68OPwobntbNJ0pzCpUFZTo3w0GyetQ=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-ppc64": ["@esbuild/linux-ppc64@0.18.20", "", { "os": "linux", "cpu": "ppc64" }, "sha512-WHPyeScRNcmANnLQkq6AfyXRFr5D6N2sKgkFo2FqguP44Nw2eyDlbTdZwd9GYk98DZG9QItIiTlFLHJHjxP3FA=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-riscv64": ["@esbuild/linux-riscv64@0.18.20", "", { "os": "linux", "cpu": "none" }, "sha512-WSxo6h5ecI5XH34KC7w5veNnKkju3zBRLEQNY7mv5mtBmrP/MjNBCAlsM2u5hDBlS3NGcTQpoBvRzqBcRtpq1A=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-s390x": ["@esbuild/linux-s390x@0.18.20", "", { "os": "linux", "cpu": "s390x" }, "sha512-+8231GMs3mAEth6Ja1iK0a1sQ3ohfcpzpRLH8uuc5/KVDFneH6jtAJLFGafpzpMRO6DzJ6AvXKze9LfFMrIHVQ=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/linux-x64": ["@esbuild/linux-x64@0.18.20", "", { "os": "linux", "cpu": "x64" }, "sha512-UYqiqemphJcNsFEskc73jQ7B9jgwjWrSayxawS6UVFZGWrAAtkzjxSqnoclCXxWtfwLdzU+vTpcNYhpn43uP1w=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/netbsd-x64": ["@esbuild/netbsd-x64@0.18.20", "", { "os": "none", "cpu": "x64" }, "sha512-iO1c++VP6xUBUmltHZoMtCUdPlnPGdBom6IrO4gyKPFFVBKioIImVooR5I83nTew5UOYrk3gIJhbZh8X44y06A=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/openbsd-x64": ["@esbuild/openbsd-x64@0.18.20", "", { "os": "openbsd", "cpu": "x64" }, "sha512-e5e4YSsuQfX4cxcygw/UCPIEP6wbIL+se3sxPdCiMbFLBWu0eiZOJ7WoD+ptCLrmjZBK1Wk7I6D/I3NglUGOxg=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/sunos-x64": ["@esbuild/sunos-x64@0.18.20", "", { "os": "sunos", "cpu": "x64" }, "sha512-kDbFRFp0YpTQVVrqUd5FTYmWo45zGaXe0X8E1G/LKFC0v8x0vWrhOWSLITcCn63lmZIxfOMXtCfti/RxN/0wnQ=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/win32-arm64": ["@esbuild/win32-arm64@0.18.20", "", { "os": "win32", "cpu": "arm64" }, "sha512-ddYFR6ItYgoaq4v4JmQQaAI5s7npztfV4Ag6NrhiaW0RrnOXqBkgwZLofVTlq1daVTQNhtI5oieTvkRPfZrePg=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/win32-ia32": ["@esbuild/win32-ia32@0.18.20", "", { "os": "win32", "cpu": "ia32" }, "sha512-Wv7QBi3ID/rROT08SABTS7eV4hX26sVduqDOTe1MvGMjNd3EjOz4b7zeexIR62GTIEKrfJXKL9LFxTYgkyeu7g=="],
-
-    "@esbuild-kit/core-utils/esbuild/@esbuild/win32-x64": ["@esbuild/win32-x64@0.18.20", "", { "os": "win32", "cpu": "x64" }, "sha512-kTdfRcSiDfQca/y9QIkng02avJ+NCaQvrMejlsB3RRv5sE9rRoeBPISaZpKxHELzRxZyLvNts1P27W3wV+8geQ=="],
-
-    "tsx/esbuild/@esbuild/aix-ppc64": ["@esbuild/aix-ppc64@0.27.7", "", { "os": "aix", "cpu": "ppc64" }, "sha512-EKX3Qwmhz1eMdEJokhALr0YiD0lhQNwDqkPYyPhiSwKrh7/4KRjQc04sZ8db+5DVVnZ1LmbNDI1uAMPEUBnQPg=="],
-
-    "tsx/esbuild/@esbuild/android-arm": ["@esbuild/android-arm@0.27.7", "", { "os": "android", "cpu": "arm" }, "sha512-jbPXvB4Yj2yBV7HUfE2KHe4GJX51QplCN1pGbYjvsyCZbQmies29EoJbkEc+vYuU5o45AfQn37vZlyXy4YJ8RQ=="],
-
-    "tsx/esbuild/@esbuild/android-arm64": ["@esbuild/android-arm64@0.27.7", "", { "os": "android", "cpu": "arm64" }, "sha512-62dPZHpIXzvChfvfLJow3q5dDtiNMkwiRzPylSCfriLvZeq0a1bWChrGx/BbUbPwOrsWKMn8idSllklzBy+dgQ=="],
-
-    "tsx/esbuild/@esbuild/android-x64": ["@esbuild/android-x64@0.27.7", "", { "os": "android", "cpu": "x64" }, "sha512-x5VpMODneVDb70PYV2VQOmIUUiBtY3D3mPBG8NxVk5CogneYhkR7MmM3yR/uMdITLrC1ml/NV1rj4bMJuy9MCg=="],
-
-    "tsx/esbuild/@esbuild/darwin-arm64": ["@esbuild/darwin-arm64@0.27.7", "", { "os": "darwin", "cpu": "arm64" }, "sha512-5lckdqeuBPlKUwvoCXIgI2D9/ABmPq3Rdp7IfL70393YgaASt7tbju3Ac+ePVi3KDH6N2RqePfHnXkaDtY9fkw=="],
-
-    "tsx/esbuild/@esbuild/darwin-x64": ["@esbuild/darwin-x64@0.27.7", "", { "os": "darwin", "cpu": "x64" }, "sha512-rYnXrKcXuT7Z+WL5K980jVFdvVKhCHhUwid+dDYQpH+qu+TefcomiMAJpIiC2EM3Rjtq0sO3StMV/+3w3MyyqQ=="],
-
-    "tsx/esbuild/@esbuild/freebsd-arm64": ["@esbuild/freebsd-arm64@0.27.7", "", { "os": "freebsd", "cpu": "arm64" }, "sha512-B48PqeCsEgOtzME2GbNM2roU29AMTuOIN91dsMO30t+Ydis3z/3Ngoj5hhnsOSSwNzS+6JppqWsuhTp6E82l2w=="],
-
-    "tsx/esbuild/@esbuild/freebsd-x64": ["@esbuild/freebsd-x64@0.27.7", "", { "os": "freebsd", "cpu": "x64" }, "sha512-jOBDK5XEjA4m5IJK3bpAQF9/Lelu/Z9ZcdhTRLf4cajlB+8VEhFFRjWgfy3M1O4rO2GQ/b2dLwCUGpiF/eATNQ=="],
-
-    "tsx/esbuild/@esbuild/linux-arm": ["@esbuild/linux-arm@0.27.7", "", { "os": "linux", "cpu": "arm" }, "sha512-RkT/YXYBTSULo3+af8Ib0ykH8u2MBh57o7q/DAs3lTJlyVQkgQvlrPTnjIzzRPQyavxtPtfg0EopvDyIt0j1rA=="],
-
-    "tsx/esbuild/@esbuild/linux-arm64": ["@esbuild/linux-arm64@0.27.7", "", { "os": "linux", "cpu": "arm64" }, "sha512-RZPHBoxXuNnPQO9rvjh5jdkRmVizktkT7TCDkDmQ0W2SwHInKCAV95GRuvdSvA7w4VMwfCjUiPwDi0ZO6Nfe9A=="],
-
-    "tsx/esbuild/@esbuild/linux-ia32": ["@esbuild/linux-ia32@0.27.7", "", { "os": "linux", "cpu": "ia32" }, "sha512-GA48aKNkyQDbd3KtkplYWT102C5sn/EZTY4XROkxONgruHPU72l+gW+FfF8tf2cFjeHaRbWpOYa/uRBz/Xq1Pg=="],
-
-    "tsx/esbuild/@esbuild/linux-loong64": ["@esbuild/linux-loong64@0.27.7", "", { "os": "linux", "cpu": "none" }, "sha512-a4POruNM2oWsD4WKvBSEKGIiWQF8fZOAsycHOt6JBpZ+JN2n2JH9WAv56SOyu9X5IqAjqSIPTaJkqN8F7XOQ5Q=="],
-
-    "tsx/esbuild/@esbuild/linux-mips64el": ["@esbuild/linux-mips64el@0.27.7", "", { "os": "linux", "cpu": "none" }, "sha512-KabT5I6StirGfIz0FMgl1I+R1H73Gp0ofL9A3nG3i/cYFJzKHhouBV5VWK1CSgKvVaG4q1RNpCTR2LuTVB3fIw=="],
-
-    "tsx/esbuild/@esbuild/linux-ppc64": ["@esbuild/linux-ppc64@0.27.7", "", { "os": "linux", "cpu": "ppc64" }, "sha512-gRsL4x6wsGHGRqhtI+ifpN/vpOFTQtnbsupUF5R5YTAg+y/lKelYR1hXbnBdzDjGbMYjVJLJTd2OFmMewAgwlQ=="],
-
-    "tsx/esbuild/@esbuild/linux-riscv64": ["@esbuild/linux-riscv64@0.27.7", "", { "os": "linux", "cpu": "none" }, "sha512-hL25LbxO1QOngGzu2U5xeXtxXcW+/GvMN3ejANqXkxZ/opySAZMrc+9LY/WyjAan41unrR3YrmtTsUpwT66InQ=="],
-
-    "tsx/esbuild/@esbuild/linux-s390x": ["@esbuild/linux-s390x@0.27.7", "", { "os": "linux", "cpu": "s390x" }, "sha512-2k8go8Ycu1Kb46vEelhu1vqEP+UeRVj2zY1pSuPdgvbd5ykAw82Lrro28vXUrRmzEsUV0NzCf54yARIK8r0fdw=="],
-
-    "tsx/esbuild/@esbuild/linux-x64": ["@esbuild/linux-x64@0.27.7", "", { "os": "linux", "cpu": "x64" }, "sha512-hzznmADPt+OmsYzw1EE33ccA+HPdIqiCRq7cQeL1Jlq2gb1+OyWBkMCrYGBJ+sxVzve2ZJEVeePbLM2iEIZSxA=="],
-
-    "tsx/esbuild/@esbuild/netbsd-arm64": ["@esbuild/netbsd-arm64@0.27.7", "", { "os": "none", "cpu": "arm64" }, "sha512-b6pqtrQdigZBwZxAn1UpazEisvwaIDvdbMbmrly7cDTMFnw/+3lVxxCTGOrkPVnsYIosJJXAsILG9XcQS+Yu6w=="],
-
-    "tsx/esbuild/@esbuild/netbsd-x64": ["@esbuild/netbsd-x64@0.27.7", "", { "os": "none", "cpu": "x64" }, "sha512-OfatkLojr6U+WN5EDYuoQhtM+1xco+/6FSzJJnuWiUw5eVcicbyK3dq5EeV/QHT1uy6GoDhGbFpprUiHUYggrw=="],
-
-    "tsx/esbuild/@esbuild/openbsd-arm64": ["@esbuild/openbsd-arm64@0.27.7", "", { "os": "openbsd", "cpu": "arm64" }, "sha512-AFuojMQTxAz75Fo8idVcqoQWEHIXFRbOc1TrVcFSgCZtQfSdc1RXgB3tjOn/krRHENUB4j00bfGjyl2mJrU37A=="],
-
-    "tsx/esbuild/@esbuild/openbsd-x64": ["@esbuild/openbsd-x64@0.27.7", "", { "os": "openbsd", "cpu": "x64" }, "sha512-+A1NJmfM8WNDv5CLVQYJ5PshuRm/4cI6WMZRg1by1GwPIQPCTs1GLEUHwiiQGT5zDdyLiRM/l1G0Pv54gvtKIg=="],
-
-    "tsx/esbuild/@esbuild/openharmony-arm64": ["@esbuild/openharmony-arm64@0.27.7", "", { "os": "none", "cpu": "arm64" }, "sha512-+KrvYb/C8zA9CU/g0sR6w2RBw7IGc5J2BPnc3dYc5VJxHCSF1yNMxTV5LQ7GuKteQXZtspjFbiuW5/dOj7H4Yw=="],
-
-    "tsx/esbuild/@esbuild/sunos-x64": ["@esbuild/sunos-x64@0.27.7", "", { "os": "sunos", "cpu": "x64" }, "sha512-ikktIhFBzQNt/QDyOL580ti9+5mL/YZeUPKU2ivGtGjdTYoqz6jObj6nOMfhASpS4GU4Q/Clh1QtxWAvcYKamA=="],
-
-    "tsx/esbuild/@esbuild/win32-arm64": ["@esbuild/win32-arm64@0.27.7", "", { "os": "win32", "cpu": "arm64" }, "sha512-7yRhbHvPqSpRUV7Q20VuDwbjW5kIMwTHpptuUzV+AA46kiPze5Z7qgt6CLCK3pWFrHeNfDd1VKgyP4O+ng17CA=="],
-
-    "tsx/esbuild/@esbuild/win32-ia32": ["@esbuild/win32-ia32@0.27.7", "", { "os": "win32", "cpu": "ia32" }, "sha512-SmwKXe6VHIyZYbBLJrhOoCJRB/Z1tckzmgTLfFYOfpMAx63BJEaL9ExI8x7v0oAO3Zh6D/Oi1gVxEYr5oUCFhw=="],
-
-    "tsx/esbuild/@esbuild/win32-x64": ["@esbuild/win32-x64@0.27.7", "", { "os": "win32", "cpu": "x64" }, "sha512-56hiAJPhwQ1R4i+21FVF7V8kSD5zZTdHcVuRFMW0hn753vVfQN8xlx4uOPT4xoGH0Z/oVATuR82AiqSTDIpaHg=="],
-  }
-}

compose.yml

@@ -1,26 +1,10 @@
 services:
   app:
-    image: registry.docker.polytech.djalim.fr/polympr:latest
+    container_name: deno_fresh_app
+    build: .
     ports:
-      - "8008:80"
+      - "80:80"
-      - "4430:443"
+      - "443:443"
     volumes:
-      - /home/kevin/PolyMPR/:/app
+      - .:/app
     command: deno run -A main.ts
-    deploy:
-      replicas: 1
-      placement:
-        constraints: [node.role == manager]
-
-  db:
-    image: postgres
-    restart: always
-    shm_size: 128mb
-    environment: 
-      POSTGRES_PASSWORD: ${POSTGRES_PASS}
-    deploy:
-      replicas: 1
-      placement:
-        constraints: [node.role == manager]
-
-

contributing.md

@@ -1,20 +0,0 @@
-# Contributing
-
-Thank you for your interest in contributing to our project! We appreciate your
-help in making this project better. To get started with contributing, please
-refer to our
-[Contributing Guide](https://github.com/fedyna-k/PolyMPR/wiki/Contributing) on
-the project's wiki.
-
-The Contributing Guide provides detailed information on how to:
-
-- Set up your development environment
-- Submit issues and feature requests
-- Fork the repository and create pull requests
-- Follow our coding standards and guidelines
-- Report bugs and suggest improvements
-
-If you have any questions or need further assistance, feel free to reach out to
-us by opening an issue or contacting the maintainers directly.
-
-Happy coding! 💻✨

databases/db.ts

@@ -1,14 +0,0 @@
-import { drizzle } from "npm:drizzle-orm@0.45.2/node-postgres";
-import pg from "npm:pg@8.20.0";
-
-const { Pool } = pg;
-
-const pool = new Pool({
-  host: Deno.env.get("POSTGRES_HOST"),
-  port: Number(Deno.env.get("POSTGRES_PORT") ?? 5432),
-  user: Deno.env.get("POSTGRES_USER"),
-  password: Deno.env.get("POSTGRES_PASS"),
-  database: Deno.env.get("POSTGRES_DB"),
-});
-
-export const db = drizzle(pool);

databases/init/mobility.sql

@@ -7,5 +7,5 @@ CREATE TABLE mobility (
     destinationCountry  text,
     destinationName     text,
     mobilityStatus      text default 'N/A',
-    foreign key (studentId) references students(userId)
+    attestationFile     blob
 );

databases/init/students.sql

@@ -1,14 +1,15 @@
 create table promotions (
-  id        integer primary key autoincrement,
+  id      integer primary key autoincrement,
-  endyear   integer,
+  name    text,
-  current   integer
+  endyear integer,
+  current integer
 );
 
 create table students (
-  userId      text  primary key,
+  userId    text  primary key,
-  firstName   text,
+  firstName text,
-  lastName    text,
+  lastName  text,
-  mail        text,
+  mail      text,
-  promotionId integer,
+  promotionId     integer,
   foreign key(promotionId) references promotions(id)
 );

databases/schema.ts

@@ -1,99 +0,0 @@
-import {
-  date,
-  doublePrecision,
-  integer,
-  pgTable,
-  primaryKey,
-  serial,
-  text,
-} from "npm:drizzle-orm@0.45.2/pg-core";
-
-export const roles = pgTable("roles", {
-  id: serial("id").primaryKey(),
-  nom: text("nom").notNull(),
-});
-
-export const permissions = pgTable("permissions", {
-  id: text("id").primaryKey(),
-  nom: text("nom").notNull(),
-});
-
-export const rolePermissions = pgTable("role_permissions", {
-  idRole: integer("idRole").notNull().references(() => roles.id),
-  idPermission: text("idPermission").notNull().references(() => permissions.id),
-}, (t) => ({
-  pk: primaryKey({ columns: [t.idRole, t.idPermission] }),
-}));
-
-export const users = pgTable("users", {
-  id: text("id").primaryKey(),
-  nom: text("nom").notNull(),
-  prenom: text("prenom").notNull(),
-  idRole: integer("idRole").references(() => roles.id),
-});
-
-export const promotions = pgTable("promotions", {
-  id: text("idPromo").primaryKey(),
-  annee: text("annee"),
-});
-
-export const students = pgTable("students", {
-  numEtud: serial("numEtud").primaryKey(),
-  nom: text("nom").notNull(),
-  prenom: text("prenom").notNull(),
-  idPromo: text("idPromo").references(() => promotions.id),
-});
-
-export const modules = pgTable("modules", {
-  id: text("id").primaryKey(),
-  nom: text("nom").notNull(),
-});
-
-export const enseignements = pgTable("enseignements", {
-  idProf: text("idProf").notNull().references(() => users.id),
-  idModule: text("idModule").notNull().references(() => modules.id),
-  idPromo: text("idPromo").notNull().references(() => promotions.id),
-}, (t) => ({
-  pk: primaryKey({ columns: [t.idProf, t.idModule, t.idPromo] }),
-}));
-
-export const ues = pgTable("ues", {
-  id: serial("id").primaryKey(),
-  nom: text("nom").notNull(),
-});
-
-export const ueModules = pgTable("ue_modules", {
-  idModule: text("idModule").notNull().references(() => modules.id),
-  idUE: integer("idUE").notNull().references(() => ues.id),
-  idPromo: text("idPromo").notNull().references(() => promotions.id),
-  coeff: doublePrecision("coeff").notNull(),
-}, (t) => ({
-  pk: primaryKey({ columns: [t.idModule, t.idUE, t.idPromo] }),
-}));
-
-export const notes = pgTable("notes", {
-  numEtud: integer("numEtud").notNull().references(() => students.numEtud),
-  idModule: text("idModule").notNull().references(() => modules.id),
-  note: doublePrecision("note").notNull(),
-}, (t) => ({
-  pk: primaryKey({ columns: [t.numEtud, t.idModule] }),
-}));
-
-export const ajustements = pgTable("ajustements", {
-  numEtud: integer("numEtud").notNull().references(() => students.numEtud),
-  idUE: integer("idUE").notNull().references(() => ues.id),
-  valeur: doublePrecision("valeur").notNull(),
-}, (t) => ({
-  pk: primaryKey({ columns: [t.numEtud, t.idUE] }),
-}));
-
-export const mobility = pgTable("mobility", {
-  id: serial("id").primaryKey(),
-  studentId: integer("studentId").references(() => students.numEtud),
-  startDate: date("startDate"),
-  endDate: date("endDate"),
-  weeksCount: integer("weeksCount"),
-  destinationCountry: text("destinationCountry"),
-  destinationName: text("destinationName"),
-  mobilityStatus: text("mobilityStatus").default("N/A"),
-});

defaults/interfaces.ts

@@ -1,10 +1,9 @@
 import { type RegularTagNode, type TextNode } from "@melvdouc/xml-parser";
 import { AsyncRoute } from "$fresh/src/server/types.ts";
 
-export interface AuthenticatedState {
+interface AuthenticatedState {
   isAuthenticated: true;
   session: CasContent;
-  availablePages: Record<string, string>;
 }
 
 interface UnauthenticatedState {

deno.json

@@ -9,8 +9,7 @@
     "start": "deno run -A --unstable-ffi --watch=static/,routes/ dev.ts",
     "build": "deno run -A --unstable-ffi dev.ts build",
     "preview": "deno run -A --unstable-ffi main.ts",
-    "update": "deno run -A -r https://fresh.deno.dev/update .",
+    "update": "deno run -A -r https://fresh.deno.dev/update ."
-    "test": "deno test -A --no-check tests/"
   },
   "lint": {
     "rules": {
@@ -30,17 +29,12 @@
     "@popov/jwt": "jsr:@popov/jwt@^1.0.1",
     "@psych/sheet": "jsr:@psych/sheet@^1.0.6",
     "@std/cli": "jsr:@std/cli@^1.0.10",
-    "@std/dotenv": "jsr:@std/dotenv@^0.225.3",
     "preact": "https://esm.sh/preact@10.22.0",
     "preact/": "https://esm.sh/preact@10.22.0/",
     "@preact/signals": "https://esm.sh/*@preact/signals@1.2.2",
     "@preact/signals-core": "https://esm.sh/*@preact/signals-core@1.5.1",
     "$std/": "https://deno.land/std@0.216.0/",
-    "@std/assert": "jsr:@std/assert@^1.0.0",
+    "$root/": "./"
-    "@std/testing": "jsr:@std/testing@^1.0.0",
-    "happy-dom": "npm:happy-dom@^16.0.0",
-    "$root/": "./",
-    "$apps/": "./routes/(apps)/"
   },
   "compilerOptions": {
     "jsx": "react-jsx",

drizzle.config.ts

@@ -1,15 +0,0 @@
-import { defineConfig } from "drizzle-kit";
-import process from "node:process";
-
-export default defineConfig({
-  dialect: "postgresql",
-  schema: "./databases/schema.ts",
-  out: "./databases/migrations",
-  dbCredentials: {
-    host: process.env.POSTGRES_HOST!,
-    port: Number(process.env.POSTGRES_PORT ?? 5432),
-    user: process.env.POSTGRES_USER!,
-    password: process.env.POSTGRES_PASS!,
-    database: process.env.POSTGRES_DB!,
-  },
-});

env.template

@@ -1,8 +0,0 @@
-#Local mode, set to true to access admin pages with any users
-LOCAL=false
-
-POSTGRES_HOST = db
-POSTGRES_PORT = 5432
-POSTGRES_PASS = astrongpass
-POSTGRES_USER = postgres
-POSTGRES_DB = polympr

fresh.config.ts

@@ -1,8 +1,6 @@
 import { defineConfig } from "$fresh/server.ts";
 import ensureDatabases from "$root/databases/ensure.ts";
-import { load } from "@std/dotenv";
 
-await load({ envPath: "./.env", export: true });
 await ensureDatabases();
 export default defineConfig({
   server: {

fresh.gen.ts

@@ -3,22 +3,23 @@
 // This file is automatically updated during development when running `dev.ts`.
 
 import * as $_apps_layout from "./routes/(apps)/_layout.tsx";
-import * as $_apps_middleware from "./routes/(apps)/_middleware.ts";
+import * as $_apps_mobility_api_download from "./routes/(apps)/mobility/api/download.ts";
-import * as $_apps_mobility_api_insert_mobility from "./routes/(apps)/mobility/api/insert_mobility.ts";
+import * as $_apps_mobility_api_insert_mobility from "./routes/(apps)/mobility/api/insert-mobility.ts";
 import * as $_apps_mobility_index from "./routes/(apps)/mobility/index.tsx";
 import * as $_apps_mobility_partials_admin_edit_mobility from "./routes/(apps)/mobility/partials/(admin)/edit_mobility.tsx";
 import * as $_apps_mobility_partials_index from "./routes/(apps)/mobility/partials/index.tsx";
 import * as $_apps_mobility_partials_overview from "./routes/(apps)/mobility/partials/overview.tsx";
+import * as $_apps_mobility_types_d from "./routes/(apps)/mobility/types.d.ts";
 import * as $_apps_notes_index from "./routes/(apps)/notes/index.tsx";
 import * as $_apps_notes_partials_admin_courses from "./routes/(apps)/notes/partials/(admin)/courses.tsx";
 import * as $_apps_notes_partials_index from "./routes/(apps)/notes/partials/index.tsx";
 import * as $_apps_notes_partials_notes from "./routes/(apps)/notes/partials/notes.tsx";
-import * as $_apps_students_api_students from "./routes/(apps)/students/api/students.ts";
+import * as $_apps_students_api_insert_students from "./routes/(apps)/students/api/insert_students.ts";
 import * as $_apps_students_index from "./routes/(apps)/students/index.tsx";
 import * as $_apps_students_partials_admin_consult from "./routes/(apps)/students/partials/(admin)/consult.tsx";
 import * as $_apps_students_partials_admin_upload from "./routes/(apps)/students/partials/(admin)/upload.tsx";
 import * as $_apps_students_partials_index from "./routes/(apps)/students/partials/index.tsx";
-import * as $_apps_students_types_d from "./routes/(apps)/students/types.d.ts";
+import * as $_apps_students_partials_overview from "./routes/(apps)/students/partials/overview.tsx";
 import * as $_404 from "./routes/_404.tsx";
 import * as $_app from "./routes/_app.tsx";
 import * as $_middleware from "./routes/_middleware.ts";
@@ -31,7 +32,6 @@ import * as $_islands_AppNavigator from "./routes/(_islands)/AppNavigator.tsx";
 import * as $_islands_Navbar from "./routes/(_islands)/Navbar.tsx";
 import * as $_apps_mobility_islands_ConsultMobility from "./routes/(apps)/mobility/(_islands)/ConsultMobility.tsx";
 import * as $_apps_mobility_islands_EditMobility from "./routes/(apps)/mobility/(_islands)/EditMobility.tsx";
-import * as $_apps_mobility_islands_ImportFile from "./routes/(apps)/mobility/(_islands)/ImportFile.tsx";
 import * as $_apps_students_islands_ConsultStudents from "./routes/(apps)/students/(_islands)/ConsultStudents.tsx";
 import * as $_apps_students_islands_EditStudents from "./routes/(apps)/students/(_islands)/EditStudents.tsx";
 import * as $_apps_students_islands_UploadStudents from "./routes/(apps)/students/(_islands)/UploadStudents.tsx";
@@ -40,8 +40,8 @@ import type { Manifest } from "$fresh/server.ts";
 const manifest = {
   routes: {
     "./routes/(apps)/_layout.tsx": $_apps_layout,
-    "./routes/(apps)/_middleware.ts": $_apps_middleware,
+    "./routes/(apps)/mobility/api/download.ts": $_apps_mobility_api_download,
-    "./routes/(apps)/mobility/api/insert_mobility.ts":
+    "./routes/(apps)/mobility/api/insert-mobility.ts":
       $_apps_mobility_api_insert_mobility,
     "./routes/(apps)/mobility/index.tsx": $_apps_mobility_index,
     "./routes/(apps)/mobility/partials/(admin)/edit_mobility.tsx":
@@ -50,12 +50,14 @@ const manifest = {
       $_apps_mobility_partials_index,
     "./routes/(apps)/mobility/partials/overview.tsx":
       $_apps_mobility_partials_overview,
+    "./routes/(apps)/mobility/types.d.ts": $_apps_mobility_types_d,
     "./routes/(apps)/notes/index.tsx": $_apps_notes_index,
     "./routes/(apps)/notes/partials/(admin)/courses.tsx":
       $_apps_notes_partials_admin_courses,
     "./routes/(apps)/notes/partials/index.tsx": $_apps_notes_partials_index,
     "./routes/(apps)/notes/partials/notes.tsx": $_apps_notes_partials_notes,
-    "./routes/(apps)/students/api/students.ts": $_apps_students_api_students,
+    "./routes/(apps)/students/api/insert_students.ts":
+      $_apps_students_api_insert_students,
     "./routes/(apps)/students/index.tsx": $_apps_students_index,
     "./routes/(apps)/students/partials/(admin)/consult.tsx":
       $_apps_students_partials_admin_consult,
@@ -63,7 +65,8 @@ const manifest = {
       $_apps_students_partials_admin_upload,
     "./routes/(apps)/students/partials/index.tsx":
       $_apps_students_partials_index,
-    "./routes/(apps)/students/types.d.ts": $_apps_students_types_d,
+    "./routes/(apps)/students/partials/overview.tsx":
+      $_apps_students_partials_overview,
     "./routes/_404.tsx": $_404,
     "./routes/_app.tsx": $_app,
     "./routes/_middleware.ts": $_middleware,
@@ -80,8 +83,6 @@ const manifest = {
       $_apps_mobility_islands_ConsultMobility,
     "./routes/(apps)/mobility/(_islands)/EditMobility.tsx":
       $_apps_mobility_islands_EditMobility,
-    "./routes/(apps)/mobility/(_islands)/ImportFile.tsx":
-      $_apps_mobility_islands_ImportFile,
     "./routes/(apps)/students/(_islands)/ConsultStudents.tsx":
       $_apps_students_islands_ConsultStudents,
     "./routes/(apps)/students/(_islands)/EditStudents.tsx":

license

@@ -1,18 +0,0 @@
-Copyright 2025 - PolyMPR team @ Polytech Marseille
-
-Permission is hereby granted, free of charge, to any person obtaining a copy of
-this software and associated documentation files (the “Software”), to deal in
-the Software without restriction, including without limitation the rights to
-use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
-the Software, and to permit persons to whom the Software is furnished to do so,
-subject to the following conditions:
-
-The above copyright notice and this permission notice shall be included in all
-copies or substantial portions of the Software.
-
-THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
-IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS
-FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
-COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER
-IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
-CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

package.json

@@ -1,12 +0,0 @@
-{
-  "dependencies": {
-    "dotenv": "^17.4.0",
-    "drizzle-orm": "^0.45.2",
-    "pg": "^8.20.0"
-  },
-  "devDependencies": {
-    "@types/pg": "^8.20.0",
-    "drizzle-kit": "^0.31.10",
-    "tsx": "^4.21.0"
-  }
-}

readme.md

@@ -1,89 +1,4 @@
 # ✨ PolyMPR ✨
 
-**PolyMPR** (Poly Management Platform for Resources) is a modern, modular
+The ✨ Poly Module de Pilotage des Ressources ✨ is the ultimate tool to handle
-framework built on **Deno** and **Fresh**, designed to help organizations
+various HR task in the INFO department.
-transition their HR systems to the cloud. With its **modulith architecture**,
-PolyMPR simplifies the development, deployment, and maintenance of HR
-applications, making it the perfect choice for teams looking to modernize their
-workflows. 🌐
-
-## Features ✨
-
-- **Modular Design**: Easily add, remove, or update features without disrupting
-  the entire system. 🧩
-- **Cloud-Native**: Built for the cloud, enabling seamless integration with
-  cloud services (amU DataCenter). ☁️
-- **Deno-Powered**: Utilizes Deno's secure runtime for TypeScript. 🦕
-- **Fresh Framework**: Delivers fast, edge-ready web applications with minimal
-  overhead. ⚡
-- **HR-Focused**: Tailored to meet the unique needs of INFO's HR. 👩‍💼👨‍💼
-
-## Getting Started 🛠️
-
-### Prerequisites
-
-- **Deno**: Install Deno by following the
-  [official guide](https://deno.land/#installation).
-- **Docker** (optional): Install Docker for containerized deployments. Follow
-  the [Docker installation guide](https://docs.docker.com/get-docker/).
-
-### Installation
-
-1. Clone the PolyMPR repository:
-   ```bash
-   git clone https://github.com/fedyna-k/PolyMPR.git
-   cd PolyMPR
-   ```
-2. Start the application:
-   ```bash
-   deno task start
-   ```
-3. Access the application at `https://localhost`.
-
-For detailed installation instructions, check out the
-[Installation Guide](./wiki/installation).
-
-## Modules Overview 🧩
-
-PolyMPR comes with a variety of modules to streamline HR processes.
-
-To learn how to create a module, visit the [Module Overview](./wiki/modules).
-
-## CLI Documentation 📄
-
-The **PolyMPR CLI** simplifies development tasks. Here are some common commands:
-
-- Create a new module:
-  ```bash
-  pmpr module create <module-name-kebab-case>
-  ```
-
-For detailed CLI usage, check out the [CLI Documentation](./wiki/cli).
-
-## Contributing 🤝
-
-We welcome contributions from the community! Whether you're fixing bugs, adding
-features, or improving documentation, your help is appreciated. Here’s how to
-get started:
-
-1. Create a new issue.
-2. Create a new branch for your changes:
-   ```bash
-   git checkout -b PMPR-:ISSUE_ID:
-   ```
-3. Commit your changes and push them to your branch.
-4. Submit a pull request.
-
-For more details, read the [Contributing Guide](./contributing).
-
-## Community and Support 🌟
-
-Join the PolyMPR community to connect with other users and developers:
-
-- **GitHub Discussions**: Ask questions and share ideas. 💬
-- **Issue Tracker**: Report bugs or request features. 🐛
-
-## License 📜
-
-PolyMPR is open-source and released under the **MIT License**. Feel free to use,
-modify, and distribute it as per the license terms.

routes/(apps)/_layout.tsx

@@ -1,19 +1,22 @@
 import { FreshContext } from "$fresh/server.ts";
 import { Partial } from "$fresh/runtime.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
+import { State } from "$root/defaults/interfaces.ts";
+import { AppProperties } from "$root/defaults/interfaces.ts";
 import Navbar from "$root/routes/(_islands)/Navbar.tsx";
 
-// deno-lint-ignore require-await
 export default async function AppLayout(
   request: Request,
-  context: FreshContext<AuthenticatedState>,
+  context: FreshContext<State>,
 ) {
   const pathname = new URL(request.url).pathname;
   const currentApp = pathname.split("/")[1];
+  const properties: AppProperties = (await import(
+    `./${currentApp}/(_props)/props.ts`
+  )).default;
 
   return (
     <section id="app">
-      <Navbar currentApp={currentApp} pages={context.state.availablePages} />
+      <Navbar currentApp={currentApp} pages={properties.pages} />
       <section id="app-body">
         <Partial name="body">
           <context.Component />

routes/(apps)/_middleware.ts

@@ -1,36 +0,0 @@
-import { FreshContext, MiddlewareHandler } from "$fresh/server.ts";
-import {
-  AppProperties,
-  AuthenticatedState,
-} from "$root/defaults/interfaces.ts";
-
-export const handler: MiddlewareHandler<AuthenticatedState>[] = [
-  /**
-   * Get all available pages for current user.
-   * @param request The HTTP incomming request.
-   * @param context The Fresh context object with custom `AuthenticatedState`.
-   * @returns The response from the next middleware.
-   */
-  async function getAllAvailablePages(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const pathname = new URL(request.url).pathname;
-    const currentApp = pathname.split("/")[1];
-    const properties: AppProperties = (await import(
-      `./${currentApp}/(_props)/props.ts`
-    )).default;
-
-    context.state.availablePages = properties.pages;
-    if (
-      context.state.session.eduPersonPrimaryAffiliation == "student" &&
-      Deno.env.get("LOCAL") != "true"
-    ) {
-      properties.adminOnly.forEach((page) =>
-        delete context.state.availablePages[page]
-      );
-    }
-
-    return await context.next();
-  },
-];

routes/(apps)/admin/(_props)/props.ts

@@ -1,13 +0,0 @@
-import { AppProperties } from "$root/defaults/interfaces.ts";
-
-const properties: AppProperties = {
-  name: "Admin",
-  icon: "school",
-  pages: {
-    index: "Homepage",
-  },
-  adminOnly: [],
-  hint: "PolyMPR module",
-};
-
-export default properties;

routes/(apps)/admin/api/example.ts

@@ -1,22 +0,0 @@
-import { Handlers } from "$fresh/server.ts";
-
-export const handler: Handlers = {
-  async POST(request, context) {
-    if (request.headers.get("content-type") != "application/json") {
-      return new Response(null, {
-        status: 400,
-      });
-    }
-
-    const responseBody = {
-      requestBody: await request.json(),
-      context,
-    };
-
-    return new Response(JSON.stringify(responseBody), {
-      headers: {
-        "content-type": "application/json",
-      },
-    });
-  },
-};

routes/(apps)/admin/api/modules.ts

@@ -1,63 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { modules } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm";
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #23 GET /modules
-  async GET(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(JSON.stringify([]), {
-        headers: { "content-type": "application/json" },
-      });
-    }
-
-    const rows = await db.select().from(modules);
-    return new Response(JSON.stringify(rows), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #24 POST /modules
-  async POST(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(null, { status: 403 });
-    }
-
-    const body: { id: string; nom: string } = await request.json();
-
-    if (!body.id || !body.nom) {
-      return new Response(null, { status: 400 });
-    }
-
-    const existing = await db
-      .select()
-      .from(modules)
-      .where(eq(modules.id, body.id))
-      .then((rows) => rows[0] ?? null);
-
-    if (existing) {
-      return new Response(
-        JSON.stringify({ error: "Un module avec cet identifiant existe déjà" }),
-        { status: 409, headers: { "content-type": "application/json" } },
-      );
-    }
-
-    const [created] = await db
-      .insert(modules)
-      .values({ id: body.id, nom: body.nom })
-      .returning();
-
-    return new Response(JSON.stringify(created), {
-      status: 201,
-      headers: { "content-type": "application/json" },
-    });
-  },
-};

routes/(apps)/admin/api/permissions.ts

@@ -1,22 +0,0 @@
-import { Handlers } from "$fresh/server.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-
-const PERMISSIONS = [
-  { id: "student_read", nom: "Consulter les élèves" },
-  { id: "student_write", nom: "Gérer les élèves" },
-  { id: "note_read", nom: "Consulter les notes" },
-  { id: "note_write", nom: "Gérer les notes" },
-  { id: "module_read", nom: "Consulter les modules" },
-  { id: "module_write", nom: "Gérer les modules" },
-  { id: "user_read", nom: "Consulter les utilisateurs" },
-  { id: "user_write", nom: "Gérer les utilisateurs" },
-  { id: "role_write", nom: "Gérer les rôles" },
-] as const;
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  GET(_request, _context): Response {
-    return new Response(JSON.stringify(PERMISSIONS), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-};

routes/(apps)/admin/api/roles.ts

@@ -1,68 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { rolePermissions, roles } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-async function getRoleWithPermissions(
-  id: number,
-): Promise<{ id: number; nom: string; permissions: string[] } | null> {
-  const role = await db
-    .select()
-    .from(roles)
-    .where(eq(roles.id, id))
-    .then((rows) => rows[0] ?? null);
-
-  if (!role) return null;
-
-  const perms = await db
-    .select({ idPermission: rolePermissions.idPermission })
-    .from(rolePermissions)
-    .where(eq(rolePermissions.idRole, id));
-
-  return {
-    id: role.id,
-    nom: role.nom,
-    permissions: perms.map((p) => p.idPermission),
-  };
-}
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #65 GET /roles
-  async GET(
-    _request: Request,
-    _context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const allRoles = await db.select().from(roles);
-
-    const result = await Promise.all(
-      allRoles.map((r) => getRoleWithPermissions(r.id)),
-    );
-
-    return new Response(JSON.stringify(result), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #66 POST /roles
-  async POST(
-    request: Request,
-    _context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const body: { nom: string } = await request.json();
-
-    if (!body.nom) {
-      return new Response(null, { status: 400 });
-    }
-
-    const [created] = await db
-      .insert(roles)
-      .values({ nom: body.nom })
-      .returning();
-
-    return new Response(
-      JSON.stringify({ id: created.id, nom: created.nom, permissions: [] }),
-      { status: 201, headers: { "content-type": "application/json" } },
-    );
-  },
-};

routes/(apps)/admin/api/roles/[idRole].ts

@@ -1,101 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { rolePermissions, roles } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-const NOT_FOUND = new Response(
-  JSON.stringify({ error: "Ressource introuvable" }),
-  { status: 404, headers: { "content-type": "application/json" } },
-);
-
-async function getRoleWithPermissions(
-  id: number,
-): Promise<{ id: number; nom: string; permissions: string[] } | null> {
-  const role = await db
-    .select()
-    .from(roles)
-    .where(eq(roles.id, id))
-    .then((rows) => rows[0] ?? null);
-
-  if (!role) return null;
-
-  const perms = await db
-    .select({ idPermission: rolePermissions.idPermission })
-    .from(rolePermissions)
-    .where(eq(rolePermissions.idRole, id));
-
-  return {
-    id: role.id,
-    nom: role.nom,
-    permissions: perms.map((p) => p.idPermission),
-  };
-}
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #67 GET /roles/{idRole}
-  async GET(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const id = Number(context.params.idRole);
-    const role = await getRoleWithPermissions(id);
-
-    if (!role) return NOT_FOUND;
-
-    return new Response(JSON.stringify(role), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #68 PUT /roles/{idRole}
-  async PUT(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const id = Number(context.params.idRole);
-    const body: { nom: string; permissions: string[] } = await request.json();
-
-    const [updated] = await db
-      .update(roles)
-      .set({ nom: body.nom })
-      .where(eq(roles.id, id))
-      .returning();
-
-    if (!updated) return NOT_FOUND;
-
-    // Reset permissions
-    await db.delete(rolePermissions).where(eq(rolePermissions.idRole, id));
-
-    if (body.permissions?.length) {
-      await db.insert(rolePermissions).values(
-        body.permissions.map((p) => ({ idRole: id, idPermission: p })),
-      );
-    }
-
-    const role = await getRoleWithPermissions(id);
-    return new Response(JSON.stringify(role), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #69 DELETE /roles/{idRole}
-  async DELETE(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const id = Number(context.params.idRole);
-
-    // Cascade delete role_permissions first
-    await db.delete(rolePermissions).where(eq(rolePermissions.idRole, id));
-
-    const [deleted] = await db
-      .delete(roles)
-      .where(eq(roles.id, id))
-      .returning();
-
-    if (!deleted) return NOT_FOUND;
-
-    return new Response(null, { status: 204 });
-  },
-};

routes/(apps)/admin/api/users.ts

@@ -1,67 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { users } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #60 GET /users
-  async GET(
-    request: Request,
-    _context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const url = new URL(request.url);
-    const idRole = url.searchParams.get("idRole");
-
-    const rows = idRole
-      ? await db.select().from(users).where(eq(users.idRole, Number(idRole)))
-      : await db.select().from(users);
-
-    return new Response(JSON.stringify(rows), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #61 POST /users
-  async POST(
-    request: Request,
-    _context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const body: { id: string; nom: string; prenom: string; idRole: number } =
-      await request.json();
-
-    if (!body.id || !body.nom || !body.prenom) {
-      return new Response(null, { status: 400 });
-    }
-
-    const existing = await db
-      .select()
-      .from(users)
-      .where(eq(users.id, body.id))
-      .then((rows) => rows[0] ?? null);
-
-    if (existing) {
-      return new Response(
-        JSON.stringify({
-          error: "Un utilisateur avec cet identifiant existe déjà",
-        }),
-        { status: 409, headers: { "content-type": "application/json" } },
-      );
-    }
-
-    const [created] = await db
-      .insert(users)
-      .values({
-        id: body.id,
-        nom: body.nom,
-        prenom: body.prenom,
-        idRole: body.idRole,
-      })
-      .returning();
-
-    return new Response(JSON.stringify(created), {
-      status: 201,
-      headers: { "content-type": "application/json" },
-    });
-  },
-};

routes/(apps)/admin/api/users/[id].ts

@@ -1,66 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { users } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-const NOT_FOUND = new Response(
-  JSON.stringify({ error: "Ressource introuvable" }),
-  { status: 404, headers: { "content-type": "application/json" } },
-);
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #62 GET /users/{id}
-  async GET(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const user = await db
-      .select()
-      .from(users)
-      .where(eq(users.id, context.params.id))
-      .then((rows) => rows[0] ?? null);
-
-    if (!user) return NOT_FOUND;
-
-    return new Response(JSON.stringify(user), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #63 PUT /users/{id}
-  async PUT(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const body: { nom: string; prenom: string; idRole: number } = await request
-      .json();
-
-    const [updated] = await db
-      .update(users)
-      .set({ nom: body.nom, prenom: body.prenom, idRole: body.idRole })
-      .where(eq(users.id, context.params.id))
-      .returning();
-
-    if (!updated) return NOT_FOUND;
-
-    return new Response(JSON.stringify(updated), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #64 DELETE /users/{id}
-  async DELETE(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    const [deleted] = await db
-      .delete(users)
-      .where(eq(users.id, context.params.id))
-      .returning();
-
-    if (!deleted) return NOT_FOUND;
-
-    return new Response(null, { status: 204 });
-  },
-};

routes/(apps)/admin/index.tsx

@@ -1,2 +0,0 @@
-import makeIndex from "$root/defaults/makeIndex.ts";
-export default makeIndex(import.meta.dirname!);

routes/(apps)/admin/partials/index.tsx

@@ -1,13 +0,0 @@
-import {
-  getPartialsConfig,
-  makePartials,
-} from "$root/defaults/makePartials.tsx";
-import { FreshContext } from "$fresh/server.ts";
-import { State } from "$root/routes/_middleware.ts";
-
-export function Index(_request: Request, _context: FreshContext<State>) {
-  return <h2>Welcome to Admin.</h2>;
-}
-
-export const config = getPartialsConfig();
-export default makePartials(Index);

routes/(apps)/mobility/(_islands)/ConsultMobility.tsx

@@ -1,113 +1,147 @@
 import { useEffect, useState } from "preact/hooks";
 
-interface Promotion {
-  id: number;
-  name: string;
-}
-
-interface Student {
-  id: string;
-  firstName: string;
-  lastName: string;
-  promotionId: number;
-}
-
-interface Mobility {
-  id: number;
-  studentId: string;
-  startDate: string | null;
-  endDate: string | null;
-  weeksCount: number | null;
-  destinationCountry: string | null;
-  destinationName: string | null;
-  mobilityStatus: string;
-}
-
 export default function ConsultMobility() {
-  const [data, setData] = useState<
+  const [mobilityData, setMobilityData] = useState<MobilityData[]>([]);
-    | {
+  const [promotions, setPromotions] = useState<Promotion[]>([]);
-      promotions?: Promotion[];
+  const [selectedPromotion, setSelectedPromotion] = useState<number | "all">("all");
-      students?: Student[];
-      mobilities?: Mobility[];
-    }
-    | null
-  >(null);
   const [error, setError] = useState<string | null>(null);
 
   useEffect(() => {
     const fetchData = async () => {
-      console.log("ConsultMobility: Fetching data from API...");
       try {
-        const response = await fetch("/mobility/api/insert_mobility");
+        console.log("ConsultMobility: Fetching data from API...");
-        console.log("ConsultMobility: API response status:", response.status);
+        const response = await fetch("/mobility/api/insert-mobility");
-
         if (!response.ok) {
           throw new Error(`Error fetching data: ${response.statusText}`);
         }
 
         const result = await response.json();
         console.log("ConsultMobility: Data fetched successfully:", result);
-        setData(result);
+
+        setPromotions(result.promotions);
+
+        const mergedData = result.students.map((student: any) => {
+          const existingMobility = result.mobilities.find(
+            (mobility: any) => mobility.studentId === student.id
+          );
+          return {
+            id: existingMobility ? existingMobility.id : null, 
+            studentId: student.id,
+            firstName: student.firstName,
+            lastName: student.lastName,
+            startDate: existingMobility?.startDate || null,
+            endDate: existingMobility?.endDate || null,
+            weeksCount: existingMobility?.weeksCount || null,
+            destinationCountry: existingMobility?.destinationCountry || null,
+            destinationName: existingMobility?.destinationName || null,
+            mobilityStatus: existingMobility?.mobilityStatus || "N/A",
+            promotionId: student.promotionId,
+            promotionName: student.promotionName,
+            attestationFile: existingMobility?.attestationFile || null,
+          };
+        });
+
+        setMobilityData(mergedData);
       } catch (err) {
         console.error("ConsultMobility: Error fetching data:", err);
-        setError("Failed to load mobility data. Please try again later.");
+        setError("Failed to load data. Please try again later.");
       }
     };
 
     fetchData();
   }, []);
 
-  if (error) {
+  const filteredData =
-    return <p className="error">{error}</p>;
+    selectedPromotion === "all"
-  }
+      ? mobilityData
+      : mobilityData.filter((entry) => entry.promotionId === selectedPromotion);
 
-  if (!data?.promotions) {
+  const downloadFile = (id: number | null) => {
-    return <p>No promotions found.</p>;
+    if (!id) {
-  }
+      alert("No file available for download.");
+      return;
+    }
+
+    const downloadUrl = `/mobility/api/download/${id}`;
+    window.open(downloadUrl, "_blank");
+  };
 
   return (
     <section>
       <h2>Consult Mobility</h2>
-      {data.promotions.map((promo) => (
+      {error && <p className="error">{error}</p>}
+
+      <div>
+        <label htmlFor="promotionSelect">Select Promotion: </label>
+        <select
+          id="promotionSelect"
+          value={selectedPromotion}
+          onChange={(e) =>
+            setSelectedPromotion(
+              e.target.value === "all" ? "all" : Number(e.target.value)
+            )
+          }
+        >
+          <option value="all">All Promotions</option>
+          {promotions.map((promo) => (
+            <option key={promo.id} value={promo.id}>
+              {promo.name}
+            </option>
+          ))}
+        </select>
+      </div>
+
+      {promotions.map((promo) => (
         <div key={promo.id}>
-          <h3>Promotion: {promo.name}</h3>
+          {selectedPromotion === "all" || selectedPromotion === promo.id ? (
-          <table>
+            <>
-            <thead>
+              <h3>Promotion: {promo.name}</h3>
-              <tr>
+              <table>
-                <th>ID</th>
+                <thead>
-                <th>First Name</th>
+                  <tr>
-                <th>Last Name</th>
+                    <th>ID</th>
-                <th>Start Date</th>
+                    <th>First Name</th>
-                <th>End Date</th>
+                    <th>Last Name</th>
-                <th>Weeks Count</th>
+                    <th>Start Date</th>
-                <th>Destination Country</th>
+                    <th>End Date</th>
-                <th>Destination Name</th>
+                    <th>Weeks Count</th>
-                <th>Status</th>
+                    <th>Destination Country</th>
-              </tr>
+                    <th>Destination Name</th>
-            </thead>
+                    <th>Status</th>
-            <tbody>
+                    <th>Attestation File</th>
-              {data.students
+                  </tr>
-                ?.filter((student) => student.promotionId === promo.id)
+                </thead>
-                .map((student) => {
+                <tbody>
-                  const mobility = data.mobilities?.find((mob) =>
+                  {filteredData
-                    mob.studentId === student.id
+                    .filter((entry) => entry.promotionId === promo.id)
-                  );
+                    .map((entry) => (
-                  return (
+                      <tr key={entry.studentId}>
-                    <tr key={student.id}>
+                        <td>{entry.studentId}</td>
-                      <td>{student.id}</td>
+                        <td>{entry.firstName}</td>
-                      <td>{student.firstName}</td>
+                        <td>{entry.lastName}</td>
-                      <td>{student.lastName}</td>
+                        <td>{entry.startDate || "N/A"}</td>
-                      <td>{mobility?.startDate || "N/A"}</td>
+                        <td>{entry.endDate || "N/A"}</td>
-                      <td>{mobility?.endDate || "N/A"}</td>
+                        <td>{entry.weeksCount || "0"}</td>
-                      <td>{mobility?.weeksCount ?? "N/A"}</td>
+                        <td>{entry.destinationCountry || "N/A"}</td>
-                      <td>{mobility?.destinationCountry || "N/A"}</td>
+                        <td>{entry.destinationName || "N/A"}</td>
-                      <td>{mobility?.destinationName || "N/A"}</td>
+                        <td>{entry.mobilityStatus}</td>
-                      <td>{mobility?.mobilityStatus || "N/A"}</td>
+                        <td>
-                    </tr>
+                          {entry.attestationFile ? (
-                  );
+                            <button
-                })}
+                              onClick={() => downloadFile(entry.id)}
-            </tbody>
+                            >
-          </table>
+                              Download
+                            </button>
+                          ) : (
+                            "No file"
+                          )}
+                        </td>
+                      </tr>
+                    ))}
+                </tbody>
+              </table>
+            </>
+          ) : null}
         </div>
       ))}
     </section>

routes/(apps)/mobility/(_islands)/ConsultStudents_test.tsx

@@ -1,75 +0,0 @@
-import { useEffect, useState } from "preact/hooks";
-
-interface Promotion {
-  id: number;
-  name: string;
-}
-
-interface Student {
-  id: number;
-  firstName: string;
-  lastName: string;
-  mail: string;
-  promotionId: number;
-  promotionName: string;
-}
-
-export default function ConsultStudents_test() {
-  const [data, setData] = useState<
-    { promotions: Promotion[]; students: Student[] } | null
-  >(null);
-  const [error, setError] = useState<string | null>(null);
-
-  useEffect(() => {
-    const fetchData = async () => {
-      try {
-        const response = await fetch("/students/api/insert_students");
-        if (!response.ok) {
-          throw new Error(`Error fetching data: ${response.statusText}`);
-        }
-
-        const result = await response.json();
-        setData(result);
-      } catch (err) {
-        console.error("Error fetching data:", err);
-        setError("Failed to load data. Please try again later.");
-      }
-    };
-
-    fetchData();
-  }, []);
-
-  return (
-    <section>
-      <h2>Consult Students</h2>
-      {error && <p className="error">{error}</p>}
-      {data?.promotions.map((promo) => (
-        <div key={promo.id}>
-          <h3>Promotion: {promo.id}</h3>
-          <table>
-            <thead>
-              <tr>
-                <th>ID</th>
-                <th>First Name</th>
-                <th>Last Name</th>
-                <th>Email</th>
-              </tr>
-            </thead>
-            <tbody>
-              {data.students
-                .filter((student) => student.promotionId === promo.id)
-                .map((student) => (
-                  <tr key={student.id}>
-                    <td>{student.id}</td>
-                    <td>{student.firstName}</td>
-                    <td>{student.lastName}</td>
-                    <td>{student.mail}</td>
-                  </tr>
-                ))}
-            </tbody>
-          </table>
-        </div>
-      ))}
-    </section>
-  );
-}

routes/(apps)/mobility/(_islands)/EditMobility.tsx

@@ -1,117 +1,97 @@
 import { useEffect, useState } from "preact/hooks";
 
-interface Student {
-  id: string;
-  firstName: string;
-  lastName: string;
-  promotionId: number;
-}
-
-interface Promotion {
-  id: number;
-  name: string;
-}
-
-interface Mobility {
-  id: number | null;
-  studentId: string;
-  startDate: string | null;
-  endDate: string | null;
-  weeksCount: number | null;
-  destinationCountry: string | null;
-  destinationName: string | null;
-  mobilityStatus: string;
-}
-
 export default function EditMobility() {
-  const [data, setData] = useState<
+  const [mobilityData, setMobilityData] = useState<MobilityData[]>([]);
-    | {
+  const [promotions, setPromotions] = useState<Promotion[]>([]);
-      promotions?: Promotion[];
+  const [selectedPromotion, setSelectedPromotion] = useState<number | "all">("all");
-      students?: Student[];
-      mobilities?: Mobility[];
-    }
-    | null
-  >(null);
-  const [error, setError] = useState<string | null>(null);
   const [isSaving, setIsSaving] = useState(false);
 
   useEffect(() => {
-    const fetchData = async () => {
+    async function fetchMobilityData() {
       console.log("EditMobility: Fetching data from API...");
-      try {
+      const response = await fetch("/mobility/api/insert-mobility");
-        const response = await fetch("/mobility/api/insert_mobility");
+      const data = await response.json();
-        console.log("EditMobility: API response status:", response.status);
+      console.log("EditMobility: Data fetched successfully:", data);
 
-        if (!response.ok) {
+      setPromotions(data.promotions);
-          throw new Error(`Error fetching data: ${response.statusText}`);
-        }
 
-        const result = await response.json();
+      const initializedData = data.students.map((student: any) => {
-        console.log("EditMobility: Data fetched successfully:", result);
+        const existingMobility = data.mobilities.find(
-        setData(result);
+          (mobility: any) => mobility.studentId === student.id
-      } catch (err) {
+        );
-        console.error("EditMobility: Error fetching data:", err);
+        return {
-        setError("Failed to load mobility data. Please try again later.");
+          id: existingMobility ? existingMobility.id : null,
-      }
+          studentId: student.id,
-    };
+          firstName: student.firstName,
+          lastName: student.lastName,
+          startDate: existingMobility?.startDate || null,
+          endDate: existingMobility?.endDate || null,
+          weeksCount: existingMobility?.weeksCount || null,
+          destinationCountry: existingMobility?.destinationCountry || null,
+          destinationName: existingMobility?.destinationName || null,
+          mobilityStatus: existingMobility?.mobilityStatus || "N/A",
+          attestationFile: existingMobility?.attestationFile || null,
+          promotionId: student.promotionId,
+          promotionName: student.promotionName,
+        };
+      });
+      setMobilityData(initializedData);
+    }
 
-    fetchData();
+    fetchMobilityData();
   }, []);
 
-  const handleChange = (
+  const handleFileChange = (studentId: string, file: File | null) => {
-    studentId: string,
+    if (file && file.type !== "application/pdf") {
-    field: keyof Mobility,
+      alert("Only PDF files are allowed.");
-    value: string | number | null,
+      return;
-  ) => {
+    }
-    if (!data) return;
 
-    setData((prevData) => {
+    setMobilityData((prev) =>
-      if (!prevData) return null;
+      prev.map((entry) =>
-
+        entry.studentId === studentId ? { ...entry, attestationFile: file } : entry
-      const updatedMobilities = prevData.mobilities?.map((mobility) => {
+      )
-        if (mobility.studentId === studentId) {
+    );
-          const updatedMobility = { ...mobility, [field]: value };
-
-          if (field === "startDate" || field === "endDate") {
-            const startDate = new Date(updatedMobility.startDate || "");
-            const endDate = new Date(updatedMobility.endDate || "");
-            if (startDate && endDate && startDate <= endDate) {
-              const weeks = Math.ceil(
-                (endDate.getTime() - startDate.getTime()) /
-                  (7 * 24 * 60 * 60 * 1000),
-              );
-              updatedMobility.weeksCount = weeks;
-            } else {
-              updatedMobility.weeksCount = null;
-            }
-          }
-
-          return updatedMobility;
-        }
-        return mobility;
-      }) || [];
-
-      return { ...prevData, mobilities: updatedMobilities };
-    });
   };
 
   const handleSave = async () => {
     setIsSaving(true);
 
     try {
-      const response = await fetch("/mobility/api/insert_mobility", {
+      console.log("EditMobility: Sending data to API...");
-        method: "POST",
+
-        headers: { "Content-Type": "application/json" },
+      const formData = new FormData();
-        body: JSON.stringify({ data: data?.mobilities }),
+
+      mobilityData.forEach((entry) => {
+        formData.append(
+          "data",
+          JSON.stringify({
+            id: entry.id,
+            studentId: entry.studentId,
+            startDate: entry.startDate,
+            endDate: entry.endDate,
+            destinationCountry: entry.destinationCountry,
+            destinationName: entry.destinationName,
+            mobilityStatus: entry.mobilityStatus,
+          })
+        );
+
+        if (entry.attestationFile instanceof File) {
+          formData.append(`file_${entry.studentId}`, entry.attestationFile);
+        }
       });
 
-      console.log("EditMobility: Save response status:", response.status);
+      const response = await fetch("/mobility/api/insert-mobility", {
+        method: "POST",
+        body: formData,
+      });
 
       if (response.ok) {
         alert("Data saved successfully!");
-        globalThis.location.reload();
+        console.log("EditMobility: Save response status:", response.status);
       } else {
-        throw new Error(`Failed to save data: ${response.statusText}`);
+        alert("Failed to save data.");
+        console.error("EditMobility: Save response status:", response.status);
       }
     } catch (error) {
       console.error("EditMobility: Error saving data:", error);
@@ -121,110 +101,143 @@ export default function EditMobility() {
     }
   };
 
-  if (error) {
+  const filteredData =
-    return <p className="error">{error}</p>;
+    selectedPromotion === "all"
-  }
+      ? mobilityData
+      : mobilityData.filter((entry) => entry.promotionId === selectedPromotion);
 
-  if (!data?.promotions) {
+  const groupedData = promotions.map((promo) => ({
-    return <p>Loading data...</p>;
+    promotion: promo.name,
-  }
+    students: filteredData.filter((entry) => entry.promotionId === promo.id),
+  }));
+
+  const handleDownload = (id: number) => {
+    window.open(`/mobility/api/download/${id}`, "_blank");
+  };
 
   return (
-    <section>
+    <div>
       <h2>Edit Mobility</h2>
-      {data.promotions.map((promo) => (
-        <div key={promo.id}>
-          <h3>Promotion: {promo.name}</h3>
-          <table>
-            <thead>
-              <tr>
-                <th>ID</th>
-                <th>First Name</th>
-                <th>Last Name</th>
-                <th>Start Date</th>
-                <th>End Date</th>
-                <th>Weeks Count</th>
-                <th>Destination Country</th>
-                <th>Destination Name</th>
-                <th>Status</th>
-              </tr>
-            </thead>
-            <tbody>
-              {data.students
-                ?.filter((student) => student.promotionId === promo.id)
-                .map((student) => {
-                  const mobility = data.mobilities?.find((mob) =>
-                    mob.studentId === student.id
-                  ) || {
-                    id: null,
-                    studentId: student.id,
-                    startDate: null,
-                    endDate: null,
-                    weeksCount: null,
-                    destinationCountry: null,
-                    destinationName: null,
-                    mobilityStatus: "N/A",
-                  };
 
-                  return (
+      <div>
-                    <tr key={student.id}>
+        <label htmlFor="promotionSelect">Select Promotion: </label>
-                      <td>{student.id}</td>
+        <select
-                      <td>{student.firstName}</td>
+          id="promotionSelect"
-                      <td>{student.lastName}</td>
+          value={selectedPromotion}
+          onChange={(e) =>
+            setSelectedPromotion(
+              e.target.value === "all" ? "all" : Number(e.target.value)
+            )
+          }
+        >
+          <option value="all">All Promotions</option>
+          {promotions.map((promo) => (
+            <option key={promo.id} value={promo.id}>
+              {promo.name}
+            </option>
+          ))}
+        </select>
+      </div>
+
+      {groupedData.map((group) => (
+        <div key={group.promotion}>
+          {group.students.length > 0 && (
+            <>
+              <h3>Promotion: {group.promotion}</h3>
+              <table>
+                <thead>
+                  <tr>
+                    <th>ID</th>
+                    <th>First Name</th>
+                    <th>Last Name</th>
+                    <th>Start Date</th>
+                    <th>End Date</th>
+                    <th>Weeks Count</th>
+                    <th>Destination Country</th>
+                    <th>Destination Name</th>
+                    <th>Status</th>
+                    <th>Attestation File</th>
+                  </tr>
+                </thead>
+                <tbody>
+                  {group.students.map((entry) => (
+                    <tr key={entry.studentId}>
+                      <td>{entry.studentId}</td>
+                      <td>{entry.firstName}</td>
+                      <td>{entry.lastName}</td>
                       <td>
                         <input
                           type="date"
-                          value={mobility.startDate || ""}
+                          value={entry.startDate || ""}
                           onChange={(e) =>
-                            handleChange(
+                            setMobilityData((prev) =>
-                              student.id,
+                              prev.map((data) =>
-                              "startDate",
+                                data.studentId === entry.studentId
-                              e.target.value,
+                                  ? { ...data, startDate: e.target.value }
-                            )}
+                                  : data
+                              )
+                            )
+                          }
                         />
                       </td>
                       <td>
                         <input
                           type="date"
-                          value={mobility.endDate || ""}
+                          value={entry.endDate || ""}
                           onChange={(e) =>
-                            handleChange(student.id, "endDate", e.target.value)}
+                            setMobilityData((prev) =>
+                              prev.map((data) =>
+                                data.studentId === entry.studentId
+                                  ? { ...data, endDate: e.target.value }
+                                  : data
+                              )
+                            )
+                          }
                         />
                       </td>
-                      <td>{mobility.weeksCount ?? "N/A"}</td>
+                      <td>{entry.weeksCount || "0"}</td>
                       <td>
                         <input
                           type="text"
-                          value={mobility.destinationCountry || ""}
+                          value={entry.destinationCountry || ""}
                           onChange={(e) =>
-                            handleChange(
+                            setMobilityData((prev) =>
-                              student.id,
+                              prev.map((data) =>
-                              "destinationCountry",
+                                data.studentId === entry.studentId
-                              e.target.value,
+                                  ? { ...data, destinationCountry: e.target.value }
-                            )}
+                                  : data
+                              )
+                            )
+                          }
                         />
                       </td>
                       <td>
                         <input
                           type="text"
-                          value={mobility.destinationName || ""}
+                          value={entry.destinationName || ""}
                           onChange={(e) =>
-                            handleChange(
+                            setMobilityData((prev) =>
-                              student.id,
+                              prev.map((data) =>
-                              "destinationName",
+                                data.studentId === entry.studentId
-                              e.target.value,
+                                  ? { ...data, destinationName: e.target.value }
-                            )}
+                                  : data
+                              )
+                            )
+                          }
                         />
                       </td>
                       <td>
                         <select
-                          value={mobility.mobilityStatus}
+                          value={entry.mobilityStatus}
                           onChange={(e) =>
-                            handleChange(
+                            setMobilityData((prev) =>
-                              student.id,
+                              prev.map((data) =>
-                              "mobilityStatus",
+                                data.studentId === entry.studentId
-                              e.target.value,
+                                  ? { ...data, mobilityStatus: e.target.value }
-                            )}
+                                  : data
+                              )
+                            )
+                          }
                         >
                           <option value="N/A">N/A</option>
                           <option value="Planned">Planned</option>
@@ -233,16 +246,51 @@ export default function EditMobility() {
                           <option value="Validated">Validated</option>
                         </select>
                       </td>
+                      <td>
+                        {entry.attestationFile ? (
+                          <>
+                            <button onClick={() => handleDownload(entry.id!)}>
+                              Download
+                            </button>
+                            <button
+                              onClick={() =>
+                                setMobilityData((prev) =>
+                                  prev.map((data) =>
+                                    data.studentId === entry.studentId
+                                      ? { ...data, attestationFile: null }
+                                      : data
+                                  )
+                                )
+                              }
+                            >
+                              Delete
+                            </button>
+                          </>
+                        ) : (
+                          <input
+                            type="file"
+                            accept=".pdf"
+                            onChange={(e) =>
+                              handleFileChange(
+                                entry.studentId,
+                                e.target.files?.[0] || null
+                              )
+                            }
+                          />
+                        )}
+                      </td>
                     </tr>
-                  );
+                  ))}
-                })}
+                </tbody>
-            </tbody>
+              </table>
-          </table>
+            </>
+          )}
         </div>
       ))}
-      <button type="button" onClick={handleSave} disabled={isSaving}>
+
+      <button onClick={handleSave} disabled={isSaving}>
         {isSaving ? "Saving..." : "Confirm"}
       </button>
-    </section>
+    </div>
   );
 }

routes/(apps)/mobility/(_props)/props.ts

@@ -8,9 +8,8 @@ const properties: AppProperties = {
     index: "Homepage",
     overview: "Mobility overview",
     edit_mobility: "Mobility management",
-    consult_students_test: "Test consult students",
   },
-  adminOnly: ["edit_mobility", "consult_students_test"],
+  adminOnly: ["edit_mobility"],
 };
 
 export default properties;

routes/(apps)/mobility/api/download.ts

@@ -0,0 +1,43 @@
+import { Handlers } from "$fresh/server.ts";
+import connect from "$root/databases/connect.ts";
+
+export const handler: Handlers = {
+  async GET(request) {
+    try {
+      console.log("API /mobility/api/download/:id GET called");
+
+      const url = new URL(request.url);
+      const id = url.pathname.split("/").pop();
+
+      if (!id) {
+        return new Response("Invalid request: Missing ID", { status: 400 });
+      }
+
+      console.log("Connecting to mobility database...");
+      using connection = connect("mobility");
+      console.log("Connected to databases.");
+
+      const query = connection.database.prepare(
+        `SELECT attestationFile FROM mobility WHERE id = ?`
+      );
+      const result = query.get(id);
+
+      if (!result || !result.attestationFile) {
+        return new Response("No file found for the given ID", { status: 404 });
+      }
+
+      const fileBuffer = result.attestationFile;
+
+      return new Response(fileBuffer, {
+        status: 200,
+        headers: {
+          "Content-Type": "application/pdf",
+          "Content-Disposition": `attachment; filename="attestation_${id}.pdf"`,
+        },
+      });
+    } catch (error) {
+      console.error("Error fetching file:", error);
+      return new Response("Failed to fetch file", { status: 500 });
+    }
+  },
+};

routes/(apps)/mobility/api/insert-mobility.ts

@@ -0,0 +1,131 @@
+import { Handlers } from "$fresh/server.ts";
+import connect from "$root/databases/connect.ts";
+
+export const handler: Handlers = {
+  // deno-lint-ignore require-await
+  async GET() {
+    try {
+      using connection = connect("mobility");
+
+      const mobilities = connection.database.prepare(
+        `SELECT 
+          mobility.id, 
+          mobility.studentId, 
+          mobility.startDate, 
+          mobility.endDate, 
+          mobility.weeksCount, 
+          mobility.destinationCountry, 
+          mobility.destinationName, 
+          mobility.mobilityStatus, 
+          mobility.attestationFile -- Inclure le fichier
+        FROM mobility`
+      ).all();
+
+      const students = connection.database.prepare(
+        `SELECT 
+          students.userId AS id, 
+          students.firstName, 
+          students.lastName, 
+          students.promotionId AS promotionId, 
+          promotions.name AS promotionName
+        FROM students.students
+        LEFT JOIN students.promotions ON students.promotionId = promotions.id`
+      ).all();
+
+      const promotions = connection.database.prepare(
+        `SELECT id, name FROM students.promotions`
+      ).all();
+
+      return new Response(
+        JSON.stringify({ mobilities, students, promotions }),
+        {
+          status: 200,
+          headers: { "Content-Type": "application/json" },
+        },
+      );
+    } catch (error) {
+      console.error("Error fetching mobility data:", error);
+      return new Response("Failed to fetch data", { status: 500 });
+    }
+  },
+
+  async POST(request) {
+    console.log("API /mobility/api/insert-mobility POST called");
+
+    try {
+      const formData = await request.formData();
+      const dataEntries = formData.getAll("data").map((item) => JSON.parse(item as string));
+      console.log("Parsed data entries:", dataEntries);
+
+      const fileMap: Record<string, Uint8Array> = {};
+      for (const [key, value] of formData.entries()) {
+        if (key.startsWith("file_") && value instanceof File) {
+          const studentId = key.split("_")[1]; 
+          const file = value as File;
+          fileMap[studentId] = new Uint8Array(await file.arrayBuffer());
+          console.log(`File processed for studentId ${studentId}`);
+        }
+      }
+
+      using connection = connect("mobility");
+      const insertQuery = connection.database.prepare(
+        `INSERT INTO mobility (
+          id, studentId, startDate, endDate, weeksCount, destinationCountry, destinationName, mobilityStatus, attestationFile
+        )
+        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
+        ON CONFLICT(id) DO UPDATE SET
+          startDate = excluded.startDate,
+          endDate = excluded.endDate,
+          weeksCount = excluded.weeksCount,
+          destinationCountry = excluded.destinationCountry,
+          destinationName = excluded.destinationName,
+          mobilityStatus = excluded.mobilityStatus,
+          attestationFile = excluded.attestationFile`
+      );
+
+      for (const mobility of dataEntries) {
+        const {
+          id = null,
+          studentId,
+          startDate,
+          endDate,
+          destinationCountry,
+          destinationName,
+          mobilityStatus = "N/A",
+        } = mobility;
+
+        let calculatedWeeksCount = null;
+        if (startDate && endDate) {
+          const start = new Date(startDate);
+          const end = new Date(endDate);
+          if (start <= end) {
+            const differenceInDays = Math.ceil(
+              (end.getTime() - start.getTime()) / (24 * 60 * 60 * 1000)
+            );
+            calculatedWeeksCount = Math.floor(differenceInDays / 7);
+          }
+        }
+        const attestationFile = fileMap[studentId] || null;
+
+        console.log(`Inserting/Updating mobility for studentId: ${studentId}`);
+        insertQuery.run(
+          id,
+          studentId,
+          startDate,
+          endDate,
+          calculatedWeeksCount,
+          destinationCountry,
+          destinationName,
+          mobilityStatus,
+          attestationFile
+        );
+      }
+
+      console.log("Mobility data inserted/updated successfully.");
+      return new Response("Data inserted/updated successfully", { status: 200 });
+    } catch (error) {
+      console.error("Error inserting mobility data:", error);
+      return new Response("Failed to insert/update data", { status: 500 });
+    }
+  },
+};

routes/(apps)/mobility/api/insert_mobility.ts

@@ -1,122 +0,0 @@
-import { Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { mobility, promotions, students } from "$root/databases/schema.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-export const handler: Handlers = {
-  async GET() {
-    try {
-      const studentRows = await db
-        .select({
-          id: students.userId,
-          firstName: students.firstName,
-          lastName: students.lastName,
-          promotionId: students.promotionId,
-          endyear: promotions.endyear,
-          current: promotions.current,
-        })
-        .from(students)
-        .leftJoin(promotions, eq(students.promotionId, promotions.id));
-
-      const mobilityRows = await db.select().from(mobility);
-
-      const promotionRows = await db
-        .select({
-          id: promotions.id,
-          endyear: promotions.endyear,
-          current: promotions.current,
-        })
-        .from(promotions);
-
-      return new Response(
-        JSON.stringify({
-          mobilities: mobilityRows,
-          students: studentRows,
-          promotions: promotionRows,
-        }),
-        { status: 200, headers: { "Content-Type": "application/json" } },
-      );
-    } catch (error) {
-      console.error("Error fetching mobility data:", error);
-      return new Response("Failed to fetch data", { status: 500 });
-    }
-  },
-
-  async POST(request) {
-    try {
-      const body = await request.json();
-      const { data } = body;
-
-      if (!Array.isArray(data)) {
-        throw new Error("Invalid request body");
-      }
-
-      for (const entry of data) {
-        const {
-          id,
-          studentId,
-          startDate,
-          endDate,
-          weeksCount,
-          destinationCountry,
-          destinationName,
-          mobilityStatus = "N/A",
-        } = entry;
-
-        const studentExists = await db
-          .select({ userId: students.userId })
-          .from(students)
-          .where(eq(students.userId, studentId))
-          .limit(1)
-          .then((rows) => rows.length > 0);
-
-        if (!studentExists) {
-          console.warn(`Skipping mobility for unknown studentId: ${studentId}`);
-          continue;
-        }
-
-        let calculatedWeeksCount = weeksCount;
-        if (startDate && endDate) {
-          const start = new Date(startDate);
-          const end = new Date(endDate);
-          calculatedWeeksCount = start <= end
-            ? Math.ceil(
-              (end.getTime() - start.getTime()) / (7 * 24 * 60 * 60 * 1000),
-            )
-            : null;
-        }
-
-        await db
-          .insert(mobility)
-          .values({
-            id,
-            studentId,
-            startDate,
-            endDate,
-            weeksCount: calculatedWeeksCount,
-            destinationCountry,
-            destinationName,
-            mobilityStatus,
-          })
-          .onConflictDoUpdate({
-            target: mobility.id,
-            set: {
-              startDate,
-              endDate,
-              weeksCount: calculatedWeeksCount,
-              destinationCountry,
-              destinationName,
-              mobilityStatus,
-            },
-          });
-      }
-
-      return new Response("Data inserted/updated successfully", {
-        status: 200,
-      });
-    } catch (error) {
-      console.error("Error inserting mobility data:", error);
-      return new Response("Failed to insert/update data", { status: 500 });
-    }
-  },
-};

routes/(apps)/mobility/partials/(admin)/consult_students_test.tsx

@@ -1,21 +0,0 @@
-import ConsultStudents_test from "$root/routes/(apps)/mobility/(_islands)/ConsultStudents_test.tsx";
-import {
-  getPartialsConfig,
-  makePartials,
-} from "$root/defaults/makePartials.tsx";
-import { FreshContext } from "$fresh/server.ts";
-import { State } from "$root/routes/_middleware.ts";
-//import EditStudents from "../(_islands)/EditStudents.tsx";
-
-// deno-lint-ignore require-await
-async function Mobility(_request: Request, _context: FreshContext<State>) {
-  return (
-    <>
-      <h1>Test consult students</h1>
-      <ConsultStudents_test />
-    </>
-  );
-}
-
-export const config = getPartialsConfig();
-export default makePartials(Mobility);

routes/(apps)/mobility/partials/overview.tsx

@@ -10,7 +10,7 @@ import { State } from "$root/routes/_middleware.ts";
 async function Mobility(_request: Request, _context: FreshContext<State>) {
   return (
     <>
-      <h1>Edit mobility</h1>
+      <h1>Mobility overview</h1>
       <ConsultMobility />
     </>
   );

routes/(apps)/mobility/types.d.ts

@@ -0,0 +1,21 @@
+interface Promotion {
+    id: number;
+    name: string;
+}
+
+interface MobilityData {
+    id: number | null;
+    studentId: string;
+    firstName: string;
+    lastName: string;
+    startDate: string | null;
+    endDate: string | null;
+    weeksCount: number | null;
+    destinationCountry: string | null;
+    destinationName: string | null;
+    mobilityStatus: string;
+    promotionId: number;
+    promotionName: string;
+    //attestationFile: File | null;
+  }
+  

routes/(apps)/notes/api/notes.ts

@@ -1,39 +0,0 @@
-import { Handlers } from "$fresh/server.ts";
-import { db } from "../../../../databases/db.ts";
-import { notes } from "../../../../databases/schema.ts";
-import { eq } from "npm:drizzle-orm";
-
-export const handler: Handlers = {
-  // #42 GET /notes
-  async GET(request) {
-    try {
-      const url = new URL(request.url);
-      const numEtudParam = url.searchParams.get("numEtud");
-      const idModule = url.searchParams.get("idModule");
-
-      let query = db.select().from(notes).$dynamic();
-
-      if (numEtudParam) {
-        const numEtud = parseInt(numEtudParam);
-        if (isNaN(numEtud)) {
-          return new Response("Paramètre numEtud invalide", { status: 400 });
-        }
-        query = query.where(eq(notes.numEtud, numEtud));
-      }
-
-      if (idModule) {
-        query = query.where(eq(notes.idModule, idModule));
-      }
-
-      const result = await query;
-
-      return new Response(JSON.stringify(result), {
-        status: 200,
-        headers: { "Content-Type": "application/json" },
-      });
-    } catch (error) {
-      console.error("Error fetching notes:", error);
-      return new Response("Failed to fetch data", { status: 500 });
-    }
-  },
-};

routes/(apps)/notes/api/ues.ts

@@ -1,42 +0,0 @@
-import { Handlers } from "$fresh/server.ts";
-import { db } from "../../../../databases/db.ts";
-import { ues } from "../../../../databases/schema.ts";
-
-export const handler: Handlers = {
-  // #32 GET /ues
-  async GET() {
-    try {
-      const result = await db.select().from(ues);
-
-      return new Response(JSON.stringify(result), {
-        status: 200,
-        headers: { "Content-Type": "application/json" },
-      });
-    } catch (error) {
-      console.error("Error fetching UEs:", error);
-      return new Response("Failed to fetch data", { status: 500 });
-    }
-  },
-
-  // #33 POST /ues
-  async POST(request) {
-    try {
-      const body = await request.json();
-      const { nom } = body;
-
-      if (!nom) {
-        return new Response("Champ 'nom' manquant", { status: 400 });
-      }
-
-      const result = await db.insert(ues).values({ nom }).returning();
-
-      return new Response(JSON.stringify(result[0]), {
-        status: 201,
-        headers: { "Content-Type": "application/json" },
-      });
-    } catch (error) {
-      console.error("Error creating UE:", error);
-      return new Response("Failed to create UE", { status: 500 });
-    }
-  },
-};

routes/(apps)/students/(_components)/Promotion.tsx

@@ -1,30 +0,0 @@
-import Student from "$root/routes/(apps)/students/(_components)/Student.tsx";
-
-type PromotionProps = { students: Student[]; promo: Promotion };
-
-export default function Promotion(props: PromotionProps) {
-  if (!props.promo) {
-    return <p>Unable to find user in database.</p>;
-  }
-
-  return (
-    <div key={props.promo.id}>
-      <h3>Promotion {props.promo.endyear}</h3>
-      <table>
-        <thead>
-          <tr>
-            <th>ID</th>
-            <th>First Name</th>
-            <th>Last Name</th>
-            <th>Email</th>
-          </tr>
-        </thead>
-        <tbody>
-          {props.students
-            .filter((student) => student.promotionId === props.promo.id)
-            .map((student) => <Student key={student.id} student={student} />)}
-        </tbody>
-      </table>
-    </div>
-  );
-}

routes/(apps)/students/(_components)/SelfPortrait.tsx

@@ -1,31 +0,0 @@
-import { CasContent } from "$root/defaults/interfaces.ts";
-
-type SelfPortraitProps = { self: CasContent };
-
-const regex =
-  /^(?<year>\d{4})(?<month>\d{2})(?<date>\d{2})(?<hours>\d{2})(?<minutes>\d{2})(?<seconds>\d{2})Z$/;
-
-export default function SelfPortrait(props: SelfPortraitProps) {
-  const { year, month, date, hours, minutes, seconds } = props.self
-    .amuDateValidation.match(regex)!.groups!;
-
-  const validationIsoDate =
-    `${year}-${month}-${date}T${hours}:${minutes}:${seconds}Z`;
-
-  const validationDate = new Date(validationIsoDate);
-
-  return (
-    <div id="self-portrait">
-      <div>Identity</div>
-      <div>{props.self.supannCivilite} {props.self.displayName}</div>
-      <div>Student number</div>
-      <div>{props.self.uid}</div>
-      <div>amU mail</div>
-      <div>{props.self.mail}</div>
-      <div>First amU registration</div>
-      <div>{validationDate.toLocaleString()}</div>
-      <div>amU class code</div>
-      <div>{props.self.supannEtuEtape}</div>
-    </div>
-  );
-}

routes/(apps)/students/(_components)/Student.tsx

@@ -1,13 +0,0 @@
-type StudentProps = { student: Student; promo?: number };
-
-export default function Student(props: StudentProps) {
-  return (
-    <tr key={props.student.userId}>
-      <td>{props.student.userId}</td>
-      <td>{props.student.firstName}</td>
-      <td>{props.student.lastName}</td>
-      <td>{props.student.mail}</td>
-      {props.promo && <td>{props.promo}</td>}
-    </tr>
-  );
-}

routes/(apps)/students/(_islands)/ConsultStudents.tsx

@@ -1,45 +1,75 @@
 import { useEffect, useState } from "preact/hooks";
-import Promotion from "$root/routes/(apps)/students/(_components)/Promotion.tsx";
 
-type SingleUserResponse = { promo: Promotion; student: Student };
+interface Promotion {
-type ManyUsersResponse = { promos: Promotion[]; students: Student[] };
+  id: number;
+  name: string;
+}
 
-type APIResponse = SingleUserResponse | ManyUsersResponse;
+interface Student {
+  userId: string;
+  firstName: string;
+  lastName: string;
+  mail: string;
+  promotionId: number;
+}
 
 export default function ConsultStudents() {
-  const [data, setData] = useState<APIResponse | null>(null);
+  const [data, setData] = useState<
+    { promotions: Promotion[]; students: Student[] } | null
+  >(null);
   const [error, setError] = useState<string | null>(null);
 
   useEffect(() => {
     const fetchData = async () => {
-      const response = await fetch("/students/api/students");
+      try {
-      if (!response.ok) {
+        const response = await fetch("/students/api/insert_students");
+        if (!response.ok) {
+          throw new Error(`Error fetching data: ${response.statusText}`);
+        }
+
+        const result = await response.json();
+        console.log("Fetched data:", result);
+        setData(result);
+      } catch (err) {
+        console.error("Error fetching data:", err);
         setError("Failed to load data. Please try again later.");
       }
-
-      const result: APIResponse = await response.json();
-      setData(result);
     };
 
     fetchData();
   }, []);
 
   return (
-    <>
+    <section>
+      <h2>Consult Students</h2>
       {error && <p className="error">{error}</p>}
-      {data && ((Object.hasOwn(data, "student"))
+      {data?.promotions.map((promo) => (
-        ? (
+        <div key={promo.id}>
-          <Promotion
+          <h3>Promotion: {promo.name}</h3>
-            students={[(data as SingleUserResponse).student]}
+          <table>
-            promo={(data as SingleUserResponse).promo}
+            <thead>
-          />
+              <tr>
-        )
+                <th>ID</th>
-        : (data as ManyUsersResponse).promos.map((promo) => (
+                <th>First Name</th>
-          <Promotion
+                <th>Last Name</th>
-            students={(data as ManyUsersResponse).students}
+                <th>Email</th>
-            promo={promo}
+              </tr>
-          />
+            </thead>
-        )))}
+            <tbody>
-    </>
+              {data.students
+                .filter((student) => student.promotionId === promo.id)
+                .map((student) => (
+                  <tr key={student.userId}>
+                    <td>{student.userId}</td>
+                    <td>{student.firstName}</td>
+                    <td>{student.lastName}</td>
+                    <td>{student.mail}</td>
+                  </tr>
+                ))}
+            </tbody>
+          </table>
+        </div>
+      ))}
+    </section>
   );
 }

routes/(apps)/students/(_islands)/UploadStudents.tsx

@@ -1,111 +1,75 @@
 // @deno-types="https://cdn.sheetjs.com/xlsx-0.20.3/package/types/index.d.ts"
 import * as XLSX from "https://cdn.sheetjs.com/xlsx-0.20.3/package/xlsx.mjs";
-import { Signal, useSignal } from "@preact/signals";
+import { useSignal } from "@preact/signals";
-
-/**
- * Create a new handler for file change that displays
- * messages in statusMessage and gets file data in fileData.
- * @param statusMessage The status message signal.
- * @param fileData The file data signal.
- * @returns The file change handler.
- */
-function getFileChangeHandler(
-  statusMessage: Signal<string>,
-  fileData: Signal<File | null>,
-): (event: Event) => void {
-  /**
-   * Handle file change.
-   * @param event The file change event.
-   */
-  return (event: Event) => {
-    const input = event.target as HTMLInputElement;
-    if (input.files && input.files.length > 0) {
-      fileData.value = input.files[0];
-      statusMessage.value = `File selected: ${input.files[0].name}`;
-    } else {
-      fileData.value = null;
-      statusMessage.value = "No file selected";
-    }
-  };
-}
-
-/**
- * Create a new handler that sends data file to server.
- * @param statusMessage The status message signal.
- * @param fileData The file data signal.
- * @returns The file confirmation handler.
- */
-function getUploadConfirmationFunction(
-  statusMessage: Signal<string>,
-  fileData: Signal<File | null>,
-): () => void {
-  /**
-   * Add students to database.
-   * @returns Confirm upload of students.
-   */
-  return () => {
-    if (!fileData.value) {
-      statusMessage.value = "Please select a file before confirming upload.";
-      return;
-    }
-
-    const reader = new FileReader();
-
-    /**
-     * Send all data to the server.
-     * @param event The finished progress event.
-     */
-    reader.onload = async (event: ProgressEvent<FileReader>) => {
-      const arrayBuffer = event.target!.result as ArrayBuffer;
-      const workbook = XLSX.read(arrayBuffer, { type: "array" });
-      let allOK = true;
-
-      for (const sheetName of workbook.SheetNames) {
-        const sheet = workbook.Sheets[sheetName];
-        const data = XLSX.utils.sheet_to_json(sheet, {
-          header: ["userId", "lastName", "firstName", "mail"],
-          range: 1,
-        });
-
-        const response = await fetch("/students/api/students", {
-          method: "POST",
-          headers: { "Content-Type": "application/json" },
-          body: JSON.stringify({ promoName: sheetName, data }),
-        });
-
-        if (!response.ok) {
-          allOK = false;
-        }
-      }
-
-      statusMessage.value = allOK
-        ? "Failed to insert all data."
-        : "Data uploaded and inserted successfully!";
-    };
-
-    /**
-     * Display error message if any.
-     */
-    reader.onerror = () => {
-      statusMessage.value = "Error reading the file.";
-    };
-
-    reader.readAsArrayBuffer(fileData.value);
-  };
-}
 
 export default function UploadStudents() {
   const statusMessage = useSignal<string>("");
   const fileData = useSignal<File | null>(null);
 
-  const handleFileChange = getFileChangeHandler(statusMessage, fileData);
+  const handleFileChange = (event: Event) => {
-  const confirmUpload = getUploadConfirmationFunction(statusMessage, fileData);
+    const input = event.target as HTMLInputElement;
+    if (input.files && input.files.length > 0) {
+      fileData.value = input.files[0];
+      statusMessage.value = "File selected: " + input.files[0].name;
+    } else {
+      fileData.value = null;
+      statusMessage.value = "No file selected";
+    }
+  };
+
+  const confirmUpload = () => {
+    if (!fileData.value) {
+      statusMessage.value = "Please select a file before confirming upload.";
+      return;
+    }
+
+    try {
+      const reader = new FileReader();
+
+      reader.onload = async (e) => {
+        const arrayBuffer = e.target?.result as ArrayBuffer;
+        const workbook = XLSX.read(arrayBuffer, { type: "array" });
+
+        for (const sheetName of workbook.SheetNames) {
+          const sheet = workbook.Sheets[sheetName];
+          const data = XLSX.utils.sheet_to_json(sheet, {
+            header: ["Identifiant", "Nom", "Prénom", "Mail"],
+            range: 1, // Ignorer les en-têtes
+          });
+
+          console.log(`Data from sheet ${sheetName}:`, data);
+
+          const response = await fetch("/students/api/insert_students", {
+            method: "POST",
+            headers: { "Content-Type": "application/json" },
+            body: JSON.stringify({ promoName: sheetName, data }),
+          });
+
+          if (!response.ok) {
+            throw new Error(`Failed to insert data for promotion ${sheetName}`);
+          }
+        }
+
+        statusMessage.value = "Data uploaded and inserted successfully!";
+      };
+
+      reader.onerror = () => {
+        statusMessage.value = "Error reading the file.";
+      };
+
+      reader.readAsArrayBuffer(fileData.value);
+    } catch (error) {
+      console.error("Error uploading file:", error);
+      statusMessage.value = "An unexpected error occurred during upload.";
+    }
+  };
 
   return (
-    <>
+    <div>
+      <h2>Upload Students</h2>
       <input type="file" accept=".xlsx, .xls" onChange={handleFileChange} />
-      <button type="button" onClick={confirmUpload}>Confirm Upload</button>
+      <button onClick={confirmUpload}>Confirm Upload</button>
       <p>{statusMessage.value}</p>
-    </>
+    </div>
   );
 }

routes/(apps)/students/(_props)/props.ts

@@ -5,6 +5,7 @@ const properties: AppProperties = {
   icon: "badge",
   pages: {
     index: "Homepage",
+    overview: "Students overview",
     upload: "Upload students",
     consult: "Consult students",
   },

routes/(apps)/students/api/insert_students.ts

@@ -0,0 +1,83 @@
+import { Handlers } from "$fresh/server.ts";
+import connect from "$root/databases/connect.ts";
+
+export const handler: Handlers = {
+  // deno-lint-ignore require-await
+  async GET() {
+    try {
+      using connection = connect("students");
+
+      const promotions = connection.database.prepare(
+        "select id, name from promotions",
+      ).all();
+
+      const students = connection.database
+        .prepare(
+          `select userId, firstName, lastName, mail, promotionId from students`,
+        )
+        .all();
+
+      return new Response(
+        JSON.stringify({ promotions, students }),
+        {
+          status: 200,
+          headers: { "Content-Type": "application/json" },
+        },
+      );
+    } catch (error) {
+      console.error("Error fetching data:", error);
+      return new Response("Failed to fetch data", { status: 500 });
+    }
+  },
+
+  async POST(request) {
+    console.log("API /students/api/insert_students called");
+
+    try {
+      const body = await request.json();
+      const { data, promoName } = body;
+
+      console.log("Received data:", { promoName, data });
+
+      if (!promoName || !Array.isArray(data)) {
+        throw new Error("Invalid request body");
+      }
+
+      using connection = connect("students");
+
+      connection.database.prepare(
+        "INSERT OR IGNORE INTO promotions (name) VALUES (?)",
+      ).run(promoName);
+
+      const promoIdRow: { id: number } = connection.database
+        .prepare("SELECT id FROM promotions WHERE name = ?")
+        .get(promoName)!;
+      const promoId = promoIdRow.id;
+
+      console.log(`Promotion ID for "${promoName}":`, promoId);
+
+      const insertQuery = connection.database.prepare(
+        `INSERT INTO students 
+        (userId, firstName, lastName, mail, promotionId) 
+        VALUES (?, ?, ?, ?, ?)`,
+      );
+
+      for (const student of data) {
+        console.log("Inserting student:", student);
+        insertQuery.run(
+          student.Identifiant,
+          student.Nom,
+          student["Prénom"],
+          student.Mail,
+          promoId,
+        );
+      }
+
+      console.log("All data inserted successfully");
+      return new Response("Data inserted successfully", { status: 201 });
+    } catch (error) {
+      console.error("Error inserting data:", error);
+      return new Response("Failed to insert data", { status: 500 });
+    }
+  },
+};

routes/(apps)/students/api/promotions.ts

@@ -1,49 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { promotions } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #13 GET /promotions
-  async GET(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(JSON.stringify([]), {
-        headers: { "content-type": "application/json" },
-      });
-    }
-
-    const rows = await db.select().from(promotions);
-    return new Response(JSON.stringify(rows), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #14 POST /promotions
-  async POST(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(null, { status: 403 });
-    }
-
-    const body: { idPromo: string; annee: string } = await request.json();
-
-    if (!body.idPromo || !body.annee) {
-      return new Response(null, { status: 400 });
-    }
-
-    const [created] = await db
-      .insert(promotions)
-      .values({ id: body.idPromo, annee: body.annee })
-      .returning();
-
-    return new Response(JSON.stringify(created), {
-      status: 201,
-      headers: { "content-type": "application/json" },
-    });
-  },
-};

routes/(apps)/students/api/promotions/[idPromo].ts

@@ -1,79 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { promotions } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-const NOT_FOUND = new Response(
-  JSON.stringify({ error: "Ressource introuvable" }),
-  { status: 404, headers: { "content-type": "application/json" } },
-);
-
-const FORBIDDEN = new Response(null, { status: 403 });
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #15 GET /promotions/{idPromo}
-  async GET(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return FORBIDDEN;
-    }
-
-    const promo = await db
-      .select()
-      .from(promotions)
-      .where(eq(promotions.id, context.params.idPromo))
-      .then((rows) => rows[0] ?? null);
-
-    if (!promo) return NOT_FOUND;
-
-    return new Response(JSON.stringify(promo), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #16 PUT /promotions/{idPromo}
-  async PUT(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return FORBIDDEN;
-    }
-
-    const body: { annee: string } = await request.json();
-
-    const [updated] = await db
-      .update(promotions)
-      .set({ annee: body.annee })
-      .where(eq(promotions.id, context.params.idPromo))
-      .returning();
-
-    if (!updated) return NOT_FOUND;
-
-    return new Response(JSON.stringify(updated), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #17 DELETE /promotions/{idPromo}
-  async DELETE(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return FORBIDDEN;
-    }
-
-    const [deleted] = await db
-      .delete(promotions)
-      .where(eq(promotions.id, context.params.idPromo))
-      .returning();
-
-    if (!deleted) return NOT_FOUND;
-
-    return new Response(null, { status: 204 });
-  },
-};

routes/(apps)/students/api/students.ts

@@ -1,61 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { students } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #7 GET /students
-  async GET(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(JSON.stringify([]), {
-        headers: { "content-type": "application/json" },
-      });
-    }
-
-    const url = new URL(request.url);
-    const idPromo = url.searchParams.get("idPromo");
-
-    const rows = idPromo
-      ? await db.select().from(students).where(eq(students.idPromo, idPromo))
-      : await db.select().from(students);
-
-    return new Response(JSON.stringify(rows), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #8 POST /students
-  async POST(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(null, { status: 403 });
-    }
-
-    const body: {
-      numEtud: number;
-      nom: string;
-      prenom: string;
-      idPromo: string;
-    } = await request.json();
-
-    if (!body.nom || !body.prenom || !body.idPromo) {
-      return new Response(null, { status: 400 });
-    }
-
-    const [created] = await db
-      .insert(students)
-      .values({ nom: body.nom, prenom: body.prenom, idPromo: body.idPromo })
-      .returning();
-
-    return new Response(JSON.stringify(created), {
-      status: 201,
-      headers: { "content-type": "application/json" },
-    });
-  },
-};

routes/(apps)/students/api/students/[numEtud].ts

@@ -1,83 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { students } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-import { eq } from "npm:drizzle-orm@0.45.2";
-
-const NOT_FOUND = new Response(
-  JSON.stringify({ error: "Ressource introuvable" }),
-  { status: 404, headers: { "content-type": "application/json" } },
-);
-
-const FORBIDDEN = new Response(null, { status: 403 });
-
-export const handler: Handlers<null, AuthenticatedState> = {
-  // #10 GET /students/{numEtud}
-  async GET(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return FORBIDDEN;
-    }
-
-    const numEtud = Number(context.params.numEtud);
-    const student = await db
-      .select()
-      .from(students)
-      .where(eq(students.numEtud, numEtud))
-      .then((rows) => rows[0] ?? null);
-
-    if (!student) return NOT_FOUND;
-
-    return new Response(JSON.stringify(student), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #11 PUT /students/{numEtud}
-  async PUT(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return FORBIDDEN;
-    }
-
-    const numEtud = Number(context.params.numEtud);
-    const body: { nom: string; prenom: string; idPromo: string } = await request
-      .json();
-
-    const [updated] = await db
-      .update(students)
-      .set({ nom: body.nom, prenom: body.prenom, idPromo: body.idPromo })
-      .where(eq(students.numEtud, numEtud))
-      .returning();
-
-    if (!updated) return NOT_FOUND;
-
-    return new Response(JSON.stringify(updated), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-
-  // #12 DELETE /students/{numEtud}
-  async DELETE(
-    _request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return FORBIDDEN;
-    }
-
-    const numEtud = Number(context.params.numEtud);
-    const [deleted] = await db
-      .delete(students)
-      .where(eq(students.numEtud, numEtud))
-      .returning();
-
-    if (!deleted) return NOT_FOUND;
-
-    return new Response(null, { status: 204 });
-  },
-};

routes/(apps)/students/api/students/import-csv.ts

@@ -1,64 +0,0 @@
-import { FreshContext, Handlers } from "$fresh/server.ts";
-import { db } from "$root/databases/db.ts";
-import { students } from "$root/databases/schema.ts";
-import { AuthenticatedState } from "$root/defaults/interfaces.ts";
-
-// #9 POST /students/import-csv
-export const handler: Handlers<null, AuthenticatedState> = {
-  async POST(
-    request: Request,
-    context: FreshContext<AuthenticatedState>,
-  ): Promise<Response> {
-    if (context.state.session.eduPersonPrimaryAffiliation !== "employee") {
-      return new Response(null, { status: 403 });
-    }
-
-    const formData = await request.formData();
-    const file = formData.get("file") as File | null;
-    const idPromo = formData.get("idPromo") as string | null;
-
-    if (!file || !idPromo) {
-      return new Response(null, { status: 400 });
-    }
-
-    const text = await file.text();
-    const lines = text.trim().split("\n");
-
-    let imported = 0;
-    const errors: { line: number; message: string }[] = [];
-
-    for (let i = 0; i < lines.length; i++) {
-      const lineNum = i + 1;
-      const cols = lines[i].split(",").map((c) => c.trim());
-
-      const [numEtudStr, nom, prenom] = cols;
-
-      if (!numEtudStr) {
-        errors.push({ line: lineNum, message: "Numéro étudiant manquant" });
-        continue;
-      }
-
-      const numEtud = Number(numEtudStr);
-      if (isNaN(numEtud)) {
-        errors.push({ line: lineNum, message: "Numéro étudiant invalide" });
-        continue;
-      }
-
-      if (!nom || !prenom) {
-        errors.push({ line: lineNum, message: "Nom ou prénom manquant" });
-        continue;
-      }
-
-      await db
-        .insert(students)
-        .values({ nom, prenom, idPromo })
-        .onConflictDoNothing();
-
-      imported++;
-    }
-
-    return new Response(JSON.stringify({ imported, errors }), {
-      headers: { "content-type": "application/json" },
-    });
-  },
-};

routes/(apps)/students/partials/(admin)/consult.tsx

@@ -1,16 +1,17 @@
-import ConsultStudents from "../../(_islands)/ConsultStudents.tsx";
+import ConsultStudents from "$root/routes/(apps)/students/(_islands)/ConsultStudents.tsx";
 import {
   getPartialsConfig,
   makePartials,
 } from "$root/defaults/makePartials.tsx";
 import { FreshContext } from "$fresh/server.ts";
-import { State } from "$root/defaults/interfaces.ts";
+import { State } from "$root/routes/_middleware.ts";
+//import EditStudents from "../(_islands)/EditStudents.tsx";
 
 // deno-lint-ignore require-await
 async function Students(_request: Request, _context: FreshContext<State>) {
   return (
     <>
-      <h2>Consult students</h2>
+      <h1>Manage Promotions</h1>
       <ConsultStudents />
     </>
   );

routes/(apps)/students/partials/(admin)/upload.tsx

@@ -1,16 +1,17 @@
-import UploadStudents from "../../(_islands)/UploadStudents.tsx";
+import UploadStudents from "$root/routes/(apps)/students/(_islands)/UploadStudents.tsx";
 import {
   getPartialsConfig,
   makePartials,
 } from "$root/defaults/makePartials.tsx";
 import { FreshContext } from "$fresh/server.ts";
-import { State } from "$root/defaults/interfaces.ts";
+import { State } from "$root/routes/_middleware.ts";
+//import EditStudents from "../(_islands)/EditStudents.tsx";
 
 // deno-lint-ignore require-await
 async function Students(_request: Request, _context: FreshContext<State>) {
   return (
     <>
-      <h2>Upload Students</h2>
+      <h1>Manage Promotions</h1>
       <UploadStudents />
     </>
   );

routes/(apps)/students/partials/index.tsx

@@ -3,18 +3,11 @@ import {
   makePartials,
 } from "$root/defaults/makePartials.tsx";
 import { FreshContext } from "$fresh/server.ts";
-import { State } from "$root/defaults/interfaces.ts";
+import { State } from "$root/routes/_middleware.ts";
-import SelfPortrait from "$root/routes/(apps)/students/(_components)/SelfPortrait.tsx";
 
 // deno-lint-ignore require-await
 export async function Index(_request: Request, context: FreshContext<State>) {
-  return (
+  return <h2>Welcome to {context.state.session?.displayName}.</h2>;
-    <>
-      <h2>Welcome {context.state.session?.givenName}!</h2>
-      <h3>Your amU identity</h3>
-      <SelfPortrait self={context.state.session!} />
-    </>
-  );
 }
 
 export const config = getPartialsConfig();

routes/(apps)/students/partials/overview.tsx

@@ -0,0 +1,17 @@
+import { Partial } from "$fresh/runtime.ts";
+import { RouteConfig } from "$fresh/server.ts";
+
+type ModulesProps = Record<string | number | symbol, never>;
+
+export const config: RouteConfig = {
+  skipAppWrapper: true,
+  skipInheritedLayouts: true,
+};
+
+export default function Modules(_props: ModulesProps) {
+  return (
+    <Partial name="body">
+      <a href="students" f-partial={"notes/partials"}>students</a>
+    </Partial>
+  );
+}

routes/(apps)/students/types.d.ts

@@ -1,13 +0,0 @@
-interface Student {
-  userId: string;
-  firstName: string;
-  lastName: string;
-  mail: string;
-  promotionId: number;
-}
-
-interface Promotion {
-  id: number;
-  endyear: number;
-  current: number;
-}

routes/_app.tsx

@@ -27,7 +27,6 @@ export default async function App(
         <link rel="stylesheet" href="/styles/main.css" />
         <link rel="stylesheet" href="/styles/app.css" />
         <link rel="stylesheet" href="styles/app-cards.css" />
-        <link rel="stylesheet" href="styles/students.css" />
       </head>
       <body f-client-nav>
         <Header link={link} />

static/styles/app.css

@@ -3,7 +3,7 @@
   padding: 1em 0;
   display: grid;
   grid-template-columns: auto 1fr;
-  gap: 4em;
+  gap: 1em;
 }
 
 #app > #app-body {
@@ -16,7 +16,7 @@
 }
 
 #app > nav > a {
-  padding: 0.5em 4em 0.5em 1em;
+  padding: 0.25em 0.5em;
   color: light-dark(var(--light-foreground), var(--dark-foreground));
 }
 
@@ -57,10 +57,5 @@
   #app {
     grid-template-rows: auto 1fr;
     grid-template-columns: none;
-    gap: 1em;
-  }
-
-  #app > nav > a {
-    padding: 0.5em 1em;
   }
 }

static/styles/students.css

@@ -1,15 +0,0 @@
-#self-portrait {
-  display: grid;
-  gap: 1em;
-  grid-template-columns: auto 1fr;
-}
-
-#self-portrait > div:nth-child(2n+1) {
-  font-weight: var(--font-weight-bold);
-}
-
-@media screen and (max-width: 1024px) {
-  #self-portrait {
-    grid-template-columns: 1fr;
-  }
-}

tests/helpers/api_mock.ts

@@ -1,123 +0,0 @@
-// Mock de fetch() pour les tests — supporte méthodes HTTP et status codes
-
-type HttpMethod = "GET" | "POST" | "PUT" | "DELETE";
-
-export interface MockRoute {
-  method?: HttpMethod;
-  status?: number;
-  body?: unknown;
-  headers?: Record<string, string>;
-}
-
-// deno-lint-ignore no-explicit-any
-let _originalFetch: ((input: any, init?: any) => Promise<Response>) | null =
-  null;
-let _calls: { url: string; method: string; body?: unknown }[] = [];
-
-/**
- * Remplace globalThis.fetch par un mock configurable.
- *
- * Usage simple (GET 200 par défaut) :
- *   mockFetch({ "/students": studentsData })
- *
- * Usage avancé (méthode + status) :
- *   mockFetch({ "/students": { method: "POST", status: 201, body: newStudent } })
- */
-export function mockFetch(
-  routes: Record<string, unknown | MockRoute>,
-): void {
-  _originalFetch = globalThis.fetch;
-  _calls = [];
-
-  globalThis.fetch = (
-    input: string | URL | Request,
-    init?: RequestInit,
-  ): Promise<Response> => {
-    const url = typeof input === "string"
-      ? input
-      : input instanceof URL
-      ? input.toString()
-      : input.url;
-    const method = (init?.method ?? "GET").toUpperCase();
-
-    // Parse le body si présent
-    let reqBody: unknown = undefined;
-    if (init?.body) {
-      try {
-        reqBody = JSON.parse(init.body as string);
-      } catch {
-        reqBody = init.body;
-      }
-    }
-
-    _calls.push({ url, method, body: reqBody });
-
-    for (const [pattern, config] of Object.entries(routes)) {
-      if (!url.includes(pattern)) continue;
-
-      // Config simple : la valeur est directement le body de réponse (GET 200)
-      if (!isRouteConfig(config)) {
-        return new Response(JSON.stringify(config), {
-          status: 200,
-          headers: { "Content-Type": "application/json" },
-        });
-      }
-
-      // Config avancée : vérifier la méthode si spécifiée
-      if (config.method && config.method !== method) continue;
-
-      const status = config.status ?? 200;
-
-      // 204 : pas de body
-      if (status === 204) {
-        return new Response(null, { status: 204 });
-      }
-
-      return new Response(
-        config.body !== undefined ? JSON.stringify(config.body) : null,
-        {
-          status,
-          headers: {
-            "Content-Type": "application/json",
-            ...config.headers,
-          },
-        },
-      );
-    }
-
-    return new Response(JSON.stringify({ error: "Not Found" }), {
-      status: 404,
-      headers: { "Content-Type": "application/json" },
-    });
-  };
-}
-
-/**
- * Restaure le fetch original.
- */
-export function restoreFetch(): void {
-  if (_originalFetch) {
-    globalThis.fetch = _originalFetch;
-    _originalFetch = null;
-  }
-  _calls = [];
-}
-
-/**
- * Retourne la liste des appels fetch interceptés.
- */
-export function getFetchCalls(): {
-  url: string;
-  method: string;
-  body?: unknown;
-}[] {
-  return [..._calls];
-}
-
-function isRouteConfig(value: unknown): value is MockRoute {
-  if (typeof value !== "object" || value === null || Array.isArray(value)) {
-    return false;
-  }
-  const v = value as Record<string, unknown>;
-  return "status" in v || "method" in v || "body" in v;
-}

tests/helpers/db_mock.ts

@@ -1,122 +0,0 @@
-// Mock de la couche Drizzle pour les tests unitaires/intégration
-// Permet de tester les handlers sans connexion PostgreSQL
-
-export interface MockQueryResult<T> {
-  rows: T[];
-}
-
-export interface MockDbConfig {
-  // Table name → array of rows
-  // deno-lint-ignore no-explicit-any
-  tables: Record<string, Record<string, any>[]>;
-}
-
-/**
- * Crée un mock de la DB Drizzle.
- * Simule select/insert/update/delete avec un store en mémoire.
- *
- * Usage :
- * ```ts
- * const db = createMockDb({
- *   tables: {
- *     students: [{ numEtud: 21212006, nom: "Dupont", ... }],
- *     notes: [],
- *   }
- * });
- *
- * // Lire toutes les lignes d'une table
- * const rows = db.getTable("students");
- *
- * // Insérer
- * db.insert("students", { numEtud: 21212009, nom: "Test", ... });
- *
- * // Trouver par clé
- * const student = db.findOne("students", (r) => r.numEtud === 21212006);
- *
- * // Supprimer
- * db.deleteWhere("students", (r) => r.numEtud === 21212006);
- * ```
- */
-export function createMockDb(config: MockDbConfig) {
-  // Deep clone pour éviter les mutations entre tests
-  // deno-lint-ignore no-explicit-any
-  const tables: Record<string, Record<string, any>[]> = {};
-  for (const [name, rows] of Object.entries(config.tables)) {
-    tables[name] = rows.map((r) => ({ ...r }));
-  }
-
-  return {
-    /** Retourne toutes les lignes d'une table */
-    getTable<T = Record<string, unknown>>(name: string): T[] {
-      return (tables[name] ?? []) as T[];
-    },
-
-    /** Retourne les lignes qui matchent le filtre */
-    findMany<T = Record<string, unknown>>(
-      name: string,
-      predicate: (row: T) => boolean,
-    ): T[] {
-      return (this.getTable<T>(name)).filter(predicate);
-    },
-
-    /** Retourne la première ligne qui matche, ou undefined */
-    findOne<T = Record<string, unknown>>(
-      name: string,
-      predicate: (row: T) => boolean,
-    ): T | undefined {
-      return (this.getTable<T>(name)).find(predicate);
-    },
-
-    /** Insère une ligne dans la table */
-    insert<T = Record<string, unknown>>(name: string, row: T): T {
-      if (!tables[name]) tables[name] = [];
-      const copy = { ...row } as T;
-      // deno-lint-ignore no-explicit-any
-      tables[name].push(copy as any);
-      return copy;
-    },
-
-    /** Met à jour les lignes qui matchent le prédicat */
-    updateWhere<T = Record<string, unknown>>(
-      name: string,
-      predicate: (row: T) => boolean,
-      updates: Partial<T>,
-    ): number {
-      const rows = this.getTable<T>(name);
-      let count = 0;
-      for (const row of rows) {
-        if (predicate(row)) {
-          Object.assign(row as Record<string, unknown>, updates);
-          count++;
-        }
-      }
-      return count;
-    },
-
-    /** Supprime les lignes qui matchent le prédicat */
-    deleteWhere<T = Record<string, unknown>>(
-      name: string,
-      predicate: (row: T) => boolean,
-    ): number {
-      const before = (tables[name] ?? []).length;
-      tables[name] = (tables[name] ?? []).filter(
-        (r) => !predicate(r as unknown as T),
-      );
-      return before - tables[name].length;
-    },
-
-    /** Vide une table */
-    clear(name: string): void {
-      tables[name] = [];
-    },
-
-    /** Vide toutes les tables */
-    reset(): void {
-      for (const name of Object.keys(tables)) {
-        tables[name] = [];
-      }
-    },
-  };
-}
-
-export type MockDb = ReturnType<typeof createMockDb>;

tests/helpers/fixtures.ts

@@ -1,137 +0,0 @@
-// Types et données de test alignés sur l'API REST PolyMPR
-
-// --- Types ---
-
-export interface Student {
-  numEtud: number;
-  nom: string;
-  prenom: string;
-  idPromo: string;
-}
-
-export interface Promotion {
-  idPromo: string;
-  annee: string;
-}
-
-export interface Prof {
-  id: number;
-  nom: string;
-  prenom: string;
-}
-
-export interface Module {
-  id: string;
-  nom: string;
-}
-
-export interface Note {
-  note: number;
-  numEtud: number;
-  idModule: string;
-}
-
-export interface UE {
-  id: number;
-  nom: string;
-}
-
-export interface UeModule {
-  idModule: string;
-  idUE: number;
-  idPromo: string;
-  coeff: number;
-}
-
-export interface Enseignement {
-  idProf: number;
-  idModule: string;
-  idPromo: string;
-}
-
-export interface Ajustement {
-  numEtud: number;
-  idUE: number;
-  valeur: number;
-}
-
-export interface ImportResult {
-  imported: number;
-  errors: { line: number; message: string }[];
-}
-
-export interface ApiError {
-  error: string;
-}
-
-// --- Fixtures ---
-
-export const students: Student[] = [
-  { numEtud: 21212006, nom: "Dupont", prenom: "Jean", idPromo: "4AFISE25/26" },
-  {
-    numEtud: 21212007,
-    nom: "Martin",
-    prenom: "Alice",
-    idPromo: "4AFISE25/26",
-  },
-  {
-    numEtud: 21212008,
-    nom: "Durand",
-    prenom: "Claire",
-    idPromo: "3AFISE25/26",
-  },
-];
-
-export const promotions: Promotion[] = [
-  { idPromo: "4AFISE25/26", annee: "2025" },
-  { idPromo: "3AFISE25/26", annee: "2025" },
-  { idPromo: "JIA4A2526", annee: "2025" },
-];
-
-export const profs: Prof[] = [
-  { id: 1, nom: "Leclerc", prenom: "Jean" },
-  { id: 2, nom: "Moreau", prenom: "Sophie" },
-];
-
-export const modules: Module[] = [
-  { id: "JIN702C", nom: "Optimisation" },
-  { id: "JIN703C", nom: "Informatique" },
-  { id: "JIN704C", nom: "Physique" },
-];
-
-export const notes: Note[] = [
-  { note: 15.5, numEtud: 21212006, idModule: "JIN702C" },
-  { note: 12.0, numEtud: 21212006, idModule: "JIN703C" },
-  { note: 18.0, numEtud: 21212007, idModule: "JIN702C" },
-  { note: 9.0, numEtud: 21212008, idModule: "JIN704C" },
-];
-
-export const ues: UE[] = [
-  { id: 1, nom: "UE Informatique" },
-  { id: 2, nom: "UE Mathématiques" },
-];
-
-export const ueModules: UeModule[] = [
-  { idModule: "JIN702C", idUE: 1, idPromo: "4AFISE25/26", coeff: 3.0 },
-  { idModule: "JIN703C", idUE: 2, idPromo: "4AFISE25/26", coeff: 4.0 },
-  { idModule: "JIN704C", idUE: 1, idPromo: "3AFISE25/26", coeff: 2.0 },
-];
-
-export const enseignements: Enseignement[] = [
-  { idProf: 1, idModule: "JIN702C", idPromo: "4AFISE25/26" },
-  { idProf: 2, idModule: "JIN703C", idPromo: "4AFISE25/26" },
-  { idProf: 1, idModule: "JIN704C", idPromo: "3AFISE25/26" },
-];
-
-export const ajustements: Ajustement[] = [
-  { numEtud: 21212006, idUE: 1, valeur: 13.25 },
-  { numEtud: 21212008, idUE: 1, valeur: 11.0 },
-];
-
-// --- Réponses d'erreur standard ---
-
-export const ERROR_NOT_FOUND: ApiError = { error: "Ressource introuvable" };
-export const ERROR_CONFLICT: ApiError = { error: "Ressource déjà existante" };
-export const ERROR_BAD_REQUEST: ApiError = { error: "Requête invalide" };
-export const ERROR_UNAUTHORIZED: ApiError = { error: "Non authentifié" };
-export const ERROR_FORBIDDEN: ApiError = { error: "Accès interdit" };

tests/helpers/render.ts

@@ -1,55 +0,0 @@
-// Setup happy-dom + wrapper render pour les tests de composants Preact
-
-import { Window } from "happy-dom";
-
-let _window: Window | null = null;
-
-/**
- * Initialise un environnement DOM virtuel via happy-dom.
- * À appeler avant de rendre des composants Preact dans les tests.
- */
-export function setupDOM(): void {
-  _window = new Window({ url: "http://localhost" });
-
-  // Expose les globals DOM nécessaires à Preact
-  const globals = _window as unknown as Record<string, unknown>;
-  const target = globalThis as unknown as Record<string, unknown>;
-
-  for (
-    const key of [
-      "document",
-      "navigator",
-      "location",
-      "HTMLElement",
-      "HTMLInputElement",
-      "HTMLTextAreaElement",
-      "HTMLSelectElement",
-      "Event",
-      "CustomEvent",
-      "KeyboardEvent",
-      "MouseEvent",
-      "InputEvent",
-      "MutationObserver",
-      "requestAnimationFrame",
-      "cancelAnimationFrame",
-    ]
-  ) {
-    target[key] = globals[key];
-  }
-
-  target["window"] = _window;
-}
-
-/**
- * Nettoie l'environnement DOM.
- * À appeler dans un afterEach ou à la fin d'un test.
- */
-export function cleanupDOM(): void {
-  if (_window) {
-    const doc = _window.document;
-    doc.body.innerHTML = "";
-    doc.head.innerHTML = "";
-    _window.close();
-    _window = null;
-  }
-}

tests/unit/example_test.ts

@@ -1,266 +0,0 @@
-import { assertEquals, assertExists } from "@std/assert";
-import { getFetchCalls, mockFetch, restoreFetch } from "../helpers/api_mock.ts";
-import { createMockDb } from "../helpers/db_mock.ts";
-import {
-  ERROR_CONFLICT,
-  ERROR_NOT_FOUND,
-  modules,
-  notes,
-  type Student,
-  students,
-} from "../helpers/fixtures.ts";
-import { cleanupDOM, setupDOM } from "../helpers/render.ts";
-
-// --- Fixtures ---
-
-Deno.test("fixtures - students match API shape", () => {
-  assertEquals(students.length, 3);
-  assertEquals(students[0].numEtud, 21212006);
-  assertEquals(students[0].idPromo, "4AFISE25/26");
-  assertEquals(typeof students[0].idPromo, "string");
-});
-
-Deno.test("fixtures - modules have string ids", () => {
-  assertEquals(modules[0].id, "JIN702C");
-  assertEquals(typeof modules[0].id, "string");
-});
-
-Deno.test("fixtures - notes use decimal values", () => {
-  assertEquals(notes[0].note, 15.5);
-  assertEquals(notes[0].idModule, "JIN702C");
-});
-
-// --- Mock fetch simple (GET 200) ---
-
-Deno.test("mockFetch - GET returns mocked data", async () => {
-  mockFetch({ "/students": students });
-  try {
-    const res = await fetch("http://localhost/api/students");
-    assertEquals(res.status, 200);
-    const data = await res.json();
-    assertEquals(data.length, 3);
-    assertEquals(data[0].nom, "Dupont");
-  } finally {
-    restoreFetch();
-  }
-});
-
-Deno.test("mockFetch - returns 404 for unknown routes", async () => {
-  mockFetch({});
-  try {
-    const res = await fetch("http://localhost/api/unknown");
-    assertEquals(res.status, 404);
-  } finally {
-    restoreFetch();
-  }
-});
-
-// --- Mock fetch avancé (méthodes + status codes) ---
-
-Deno.test("mockFetch - POST 201 created", async () => {
-  const newStudent = students[0];
-  mockFetch({
-    "/students": { method: "POST", status: 201, body: newStudent },
-  });
-  try {
-    const res = await fetch("http://localhost/api/students", {
-      method: "POST",
-      headers: { "Content-Type": "application/json" },
-      body: JSON.stringify(newStudent),
-    });
-    assertEquals(res.status, 201);
-    const data = await res.json();
-    assertEquals(data.numEtud, 21212006);
-  } finally {
-    restoreFetch();
-  }
-});
-
-Deno.test("mockFetch - DELETE 204 no content", async () => {
-  mockFetch({
-    "/students/21212006": { method: "DELETE", status: 204 },
-  });
-  try {
-    const res = await fetch("http://localhost/api/students/21212006", {
-      method: "DELETE",
-    });
-    assertEquals(res.status, 204);
-    assertEquals(res.body, null);
-  } finally {
-    restoreFetch();
-  }
-});
-
-Deno.test("mockFetch - 404 error response", async () => {
-  mockFetch({
-    "/students/99999": { status: 404, body: ERROR_NOT_FOUND },
-  });
-  try {
-    const res = await fetch("http://localhost/api/students/99999");
-    assertEquals(res.status, 404);
-    const data = await res.json();
-    assertEquals(data.error, "Ressource introuvable");
-  } finally {
-    restoreFetch();
-  }
-});
-
-Deno.test("mockFetch - 409 conflict", async () => {
-  mockFetch({
-    "/enseignements": { method: "POST", status: 409, body: ERROR_CONFLICT },
-  });
-  try {
-    const res = await fetch("http://localhost/api/enseignements", {
-      method: "POST",
-      body: JSON.stringify({
-        idProf: 1,
-        idModule: "JIN702C",
-        idPromo: "4AFISE25/26",
-      }),
-    });
-    assertEquals(res.status, 409);
-  } finally {
-    restoreFetch();
-  }
-});
-
-// --- getFetchCalls ---
-
-Deno.test("getFetchCalls - tracks all intercepted calls", async () => {
-  mockFetch({ "/notes": notes });
-  try {
-    await fetch("http://localhost/api/notes");
-    await fetch("http://localhost/api/notes?numEtud=21212006");
-    const calls = getFetchCalls();
-    assertEquals(calls.length, 2);
-    assertEquals(calls[0].method, "GET");
-    assertEquals(calls[1].url, "http://localhost/api/notes?numEtud=21212006");
-  } finally {
-    restoreFetch();
-  }
-});
-
-Deno.test("getFetchCalls - captures POST body", async () => {
-  mockFetch({ "/notes": { method: "POST", status: 201, body: notes[0] } });
-  try {
-    await fetch("http://localhost/api/notes", {
-      method: "POST",
-      body: JSON.stringify(notes[0]),
-    });
-    const calls = getFetchCalls();
-    assertEquals(calls.length, 1);
-    assertEquals(calls[0].method, "POST");
-    assertEquals((calls[0].body as { note: number }).note, 15.5);
-  } finally {
-    restoreFetch();
-  }
-});
-
-// --- Mock DB ---
-
-Deno.test("mockDb - getTable returns seeded rows", () => {
-  const db = createMockDb({ tables: { students: [...students] } });
-  assertEquals(db.getTable("students").length, 3);
-});
-
-Deno.test("mockDb - findOne by key", () => {
-  const db = createMockDb({ tables: { students: [...students] } });
-  const found = db.findOne<Student>("students", (r) => r.numEtud === 21212006);
-  assertExists(found);
-  assertEquals(found.nom, "Dupont");
-});
-
-Deno.test("mockDb - findOne returns undefined for missing", () => {
-  const db = createMockDb({ tables: { students: [...students] } });
-  const found = db.findOne<Student>("students", (r) => r.numEtud === 99999);
-  assertEquals(found, undefined);
-});
-
-Deno.test("mockDb - insert adds a row", () => {
-  const db = createMockDb({ tables: { students: [] } });
-  const newStudent: Student = {
-    numEtud: 21212099,
-    nom: "Test",
-    prenom: "User",
-    idPromo: "4AFISE25/26",
-  };
-  db.insert("students", newStudent);
-  assertEquals(db.getTable("students").length, 1);
-  assertEquals(
-    db.findOne<Student>("students", (r) => r.numEtud === 21212099)?.nom,
-    "Test",
-  );
-});
-
-Deno.test("mockDb - updateWhere modifies matching rows", () => {
-  const db = createMockDb({ tables: { students: [...students] } });
-  const updated = db.updateWhere<Student>(
-    "students",
-    (r) => r.numEtud === 21212006,
-    { prenom: "Marie" },
-  );
-  assertEquals(updated, 1);
-  assertEquals(
-    db.findOne<Student>("students", (r) => r.numEtud === 21212006)?.prenom,
-    "Marie",
-  );
-});
-
-Deno.test("mockDb - deleteWhere removes matching rows", () => {
-  const db = createMockDb({ tables: { students: [...students] } });
-  const deleted = db.deleteWhere<Student>(
-    "students",
-    (r) => r.numEtud === 21212006,
-  );
-  assertEquals(deleted, 1);
-  assertEquals(db.getTable("students").length, 2);
-});
-
-Deno.test("mockDb - findMany with filter", () => {
-  const db = createMockDb({ tables: { students: [...students] } });
-  const promo4 = db.findMany<Student>(
-    "students",
-    (r) => r.idPromo === "4AFISE25/26",
-  );
-  assertEquals(promo4.length, 2);
-});
-
-Deno.test("mockDb - reset clears all tables", () => {
-  const db = createMockDb({
-    tables: { students: [...students], notes: [...notes] },
-  });
-  db.reset();
-  assertEquals(db.getTable("students").length, 0);
-  assertEquals(db.getTable("notes").length, 0);
-});
-
-Deno.test("mockDb - isolated between instances", () => {
-  const db1 = createMockDb({ tables: { students: [...students] } });
-  const db2 = createMockDb({ tables: { students: [...students] } });
-  db1.deleteWhere<Student>("students", () => true);
-  assertEquals(db1.getTable("students").length, 0);
-  assertEquals(db2.getTable("students").length, 3);
-});
-
-// --- happy-dom ---
-
-Deno.test({
-  name: "happy-dom - document is available after setup",
-  sanitizeResources: false,
-  sanitizeOps: false,
-  fn() {
-    setupDOM();
-    try {
-      const doc = globalThis.document;
-      assertExists(doc);
-
-      const div = doc.createElement("div");
-      div.textContent = "hello";
-      doc.body.appendChild(div);
-
-      assertEquals(doc.body.textContent, "hello");
-    } finally {
-      cleanupDOM();
-    }
-  },
-});