feat: Add script for populating resource from cv and type

[lsetiawan]

This pull request includes significant changes to the database schema, resource management, and test data files for the support_sphere_py project. The main updates involve modifying resource-related models, updating sample data scripts, and restructuring CSV data files.

Database Schema Updates:

• src/support_sphere_py/src/support_sphere/models/public/resource.py: Changed primary key from id to resource_cv_id and made notes field nullable.
• src/support_sphere_py/src/support_sphere/models/public/resource_tag.py: Updated resource_id to reference resource_cv_id instead of id.
• src/support_sphere_py/src/support_sphere/models/public/user_resource.py: Updated resource_id to reference resource_cv_id instead of id.

Sample Data Script Updates:

• src/support_sphere_py/tests/resources/scripts/update_db_sample_data.py:
  • Added Resource model to imports.
  • Modified populate_resource_types to return resource type UUIDs.
  • Updated populate_resources to handle both resource CV and resources based on CSV input.
  • Adjusted main execution to use the updated populate_resources function.

Test Data File Updates:

• src/support_sphere_py/tests/resources/data/resources.csv: Added comprehensive resource and skill data for testing.
• src/support_sphere_py/tests/resources/data/resources_cv.csv: Removed old resource CV data file.

Miscellaneous:

• pixi.toml: Removed dependency on setup-supabase for the port-forward-supabase-db task.

Related Issues

Resolves #170

[github-actions[bot]]

🚀 Deployed on https://deploy-preview-175--pdc-ssphere.netlify.app