PostgreSQL数据库查询服务器

pip install psycopg2-binary

DB_CONFIG = {
    'dbname': 'railway',
    'user': 'postgres',
    'password': 'UqtALrZoRLKifgxpMKUhVcfBYGOIdRDK',
    'host': 'crossover.proxy.rlwy.net',
    'port': '12593'
}

# Rendre le script exécutable
chmod +x setup_railway.sh

# Lancer le script qui crée le schéma et importe les données
./setup_railway.sh

PGPASSWORD=UqtALrZoRLKifgxpMKUhVcfBYGOIdRDK psql \
  -h crossover.proxy.rlwy.net \
  -p 12593 \
  -U postgres \
  -d railway \
  -f schema.sql

python3 import_csv_to_postgres.py

-- Nombre total d'activités
SELECT COUNT(*) FROM activities;

-- Activités par type
SELECT activity_type, COUNT(*) 
FROM activities 
GROUP BY activity_type 
ORDER BY COUNT(*) DESC;

-- AF Setups avec leurs activités
SELECT a.activity_id, a.description, af.name, af.state, af.price
FROM activities a
JOIN af_setups af ON a.activity_id = af.activity_id
LIMIT 10;

-- Traitements par dentiste
SELECT dentist_first_name, dentist_last_name, COUNT(*) as nb_treatments
FROM activities
WHERE treatment_id IS NOT NULL
GROUP BY dentist_first_name, dentist_last_name
ORDER BY nb_treatments DESC;

-- Factures avec montants
SELECT i.title, i.total_ttc, i.status, a.date_activity
FROM invoices i
JOIN activities a ON i.activity_id = a.activity_id
ORDER BY a.date_activity DESC
LIMIT 10;