PostgreSQL Database Setup

This application is now configured to use PostgreSQL as the default database instead of SQLite.

Database Configuration

The application connects to a PostgreSQL database with the following settings:

Host: icarus.ipa.champion
Port: 5432
Database: motm
Username: motm_user
Password: q7y7f7Lv*sODJZ2wGiv0Wq5a

Running the Application

Linux/macOS

./run_motm.sh

Windows

run_motm.bat

Manual Setup

If you need to run the application manually, set these environment variables:

export DATABASE_TYPE=postgresql
export POSTGRES_HOST=icarus.ipa.champion
export POSTGRES_PORT=5432
export POSTGRES_DATABASE=motm
export POSTGRES_USER=motm_user
export POSTGRES_PASSWORD='q7y7f7Lv*sODJZ2wGiv0Wq5a'

Database Status

The PostgreSQL database contains the following data:

Players: 3 players in the _hkfc_players table
Match Squad: 3 players currently selected for the match squad
Admin Settings: Configured with next match details

Troubleshooting

If you encounter issues:

Connection Failed: Check if the PostgreSQL server is accessible
Empty Data: The database contains sample data - if you see empty tables, check the connection
Permission Errors: Ensure the motm_user has proper database permissions

Testing Database Connection

Run the test script to verify everything is working:

python3 test_match_squad.py

This will test the database connection and display current data.

1.5 KiB Raw Permalink Blame History