#!/usr/bin/env python3
import sys
from pathlib import Path

import mysql.connector

ROOT_DIR = Path(__file__).resolve().parents[2]
if str(ROOT_DIR) not in sys.path:
    sys.path.insert(0, str(ROOT_DIR))

from python.db_config import DB_CONFIG

conn = mysql.connector.connect(**DB_CONFIG)
cursor = conn.cursor()

print("=== Pack avatars cool ===")
cursor.execute("""
    SELECT pa.pack_id, pa.avatar_id, pa.display_order, a.code 
    FROM pack_avatars pa 
    JOIN avatars a ON pa.avatar_id = a.id 
    WHERE pa.pack_id = 'cool' 
    ORDER BY pa.display_order 
    LIMIT 5
""")

for row in cursor.fetchall():
    print(f"pack_id: {row[0]}, avatar_id: {row[1]}, display_order: {row[2]}, code: {row[3]}")

cursor.close()
conn.close()