# Requêtes d'authentification

# Données chargées après login réussi
login_data:
  projects: >
    SELECT id, parent_id, name, description, position, created_at, updated_at
    FROM projects WHERE user_id = ? ORDER BY position
  tasks: >
    SELECT id, project_id, status_id, title, description, priority,
    date_start, date_end, time_estimated, time_spent, billing, position,
    created_at, updated_at
    FROM tasks WHERE user_id = ? ORDER BY position
  tags: >
    SELECT id, name, color, created_at
    FROM tags WHERE user_id = ?
  statuses: >
    SELECT id, project_id, code, name, color, position, created_at
    FROM statuses WHERE user_id = ? ORDER BY code

# Requêtes unitaires
user_by_email: >
  SELECT id, email, name, password FROM users WHERE email = ?

user_by_id: >
  SELECT id, email, name, created_at FROM users WHERE id = ?
