15 Commits

Author SHA1 Message Date
Julien Froidefond
88dc00a44b chore: datas are ok and sync also 2025-08-27 12:18:40 +02:00
Julien Froidefond
aee5d74445 feat: importance in db and mentorcard home colors 2025-08-27 11:51:43 +02:00
Julien Froidefond
85a1484c01 chore: test data; always same password 2025-08-27 11:10:21 +02:00
Julien Froidefond
9d11a725d7 fix: clean up admin exports and enhance skill category structure
- Removed unused export for management pages in admin index.
- Added id and name properties to skills being synced from JSON, improving data integrity for skill categories.
2025-08-26 13:06:43 +02:00
Julien Froidefond
e12816a9c2 fix: double skills cleaning and script 2025-08-25 22:46:36 +02:00
Julien Froidefond
2318656a7e feat: enhance skill and user data generation
- Updated loadAllSkills to return both skills and categories, improving data structure.
- Added insertSkillCategories and insertSkills functions for database insertion of skills and categories.
- Modified insertTestUsers to include email and password hash, enhancing user data integrity.
- Improved logging for better visibility during data generation process.
2025-08-25 22:11:17 +02:00
Julien Froidefond
caf396d964 feat: adding login/RegisterForm and new columns in PG 2025-08-25 14:02:07 +02:00
Julien Froidefond
905e2b2081 refactor: improve logging and streamline skill synchronization process
- Enhanced console logging for better clarity during skill category processing.
- Simplified skill update checks and utilized bulkInsertSkillsFromJSON for efficient skill management.
- Improved code readability by standardizing formatting and reducing unnecessary comments.
2025-08-22 16:41:41 +02:00
Julien Froidefond
a4b680b092 refactor: update database setup and remove skills migration API
- Changed migration commands in DATABASE_SETUP.md to use `pnpm run sync-skills` and `pnpm run sync-teams`.
- Removed the skills migration API endpoint in route.ts, streamlining the migration process.
- Updated MIGRATION_UUID.md to reflect changes in migration steps and removed the old skills migration script.
- Added new sync scripts for skills and teams in package.json.
- Cleaned up init.sql by removing old teams data insertion and adjusted comments for clarity.
2025-08-21 15:21:36 +02:00
Julien Froidefond
c7ac6fc920 feat: generation data script 2025-08-21 14:12:30 +02:00
Julien Froidefond
578f0858e8 feat: secu migrate to user uuid 2025-08-21 13:54:13 +02:00
Julien Froidefond
75c3b2c983 feat: update evaluation schema and refactor skill evaluations
- Added unique constraint on users table for first_name, last_name, and team_id.
- Removed category_evaluations and selected_skills tables, simplifying the schema.
- Updated skill_evaluations to directly reference user_evaluations and include is_selected flag.
- Refactored EvaluationService to handle skill evaluations directly, improving data integrity and performance.
- Introduced new queries for loading skills and evaluations, enhancing data retrieval efficiency.
- Added views for user skills summary and category skills count for easier querying.
2025-08-21 11:41:35 +02:00
Julien Froidefond
72b653de19 feat: refactor skills API and database schema
- Replaced file-based skill category loading with API calls in the GET and POST methods of the skills route.
- Added new `SkillsService` for handling skill category operations.
- Updated SQL initialization script to create `skill_categories`, `skills`, and `skill_links` tables with appropriate relationships.
- Enhanced `ApiClient` with methods for loading skill categories and creating new skills, improving API interaction.
- Introduced error handling for skill category creation and loading processes.
2025-08-21 09:55:35 +02:00
Julien Froidefond
345ff5baa0 feat: adding teams in PG 2025-08-21 09:44:29 +02:00
Julien Froidefond
4e82a6d860 feat: add PostgreSQL support and enhance evaluation loading
- Added `pg` and `@types/pg` dependencies for PostgreSQL integration.
- Updated `useEvaluation` hook to load user evaluations from the API, improving data management.
- Refactored `saveUserEvaluation` and `loadUserEvaluation` functions to interact with the API instead of localStorage.
- Introduced error handling for profile loading and evaluation saving to enhance robustness.
- Added new methods for managing user profiles and evaluations, including `clearUserProfile` and `loadEvaluationForProfile`.
2025-08-21 08:46:52 +02:00