Alphaeus Mote bb5d1f0f5d Fix CSV import to use absolute paths and proper error checking ...

CSV IMPORT FIXES:

- Convert CSV file paths to absolute paths before import

- PostgreSQL \COPY command requires absolute paths for reliability

- Fixed exit code checking (was checking subshell, not psql)

- Capture exit code immediately after psql command

- Show absolute path in error messages for debugging

PROBLEM SOLVED:

- CSV files were being created successfully

- Import was failing silently due to relative path issues

- 0 rows imported because \COPY couldn't find files

- Now converts relative paths to absolute before import

TESTING:

- Tested on Linux server where CSV files exist in data/csv/

- Import should now work correctly with proper row counts

Also includes Windows Python installation improvements from previous commit

2025-10-24 12:57:35 -04:00

..

fix-permissions.sh

Add comprehensive permissions management for Docker bind mounts

2025-10-23 16:45:19 -04:00

generate_csv_data.py

Complete CSV-based data generation and bulk import system

2025-10-24 12:46:31 -04:00

import_csv_data.sh

Fix CSV import to use absolute paths and proper error checking

2025-10-24 12:57:35 -04:00

install-dependencies.sh

Add Python installation detection and Windows-specific instructions

2025-10-24 12:55:28 -04:00

setup-database.sh

Fix customer_segments query column names in verification

2025-10-24 12:28:00 -04:00

verify-setup.sh

Add automatic dependency installer and package checks

2025-10-23 14:34:11 -04:00