#!/usr/bin/env python
# -*- coding: utf-8 -*-
import pymysql
import sys

# UTF-8 출력 설정
if sys.platform == 'win32':
    import io
    sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8')

# 데이터베이스 연결
conn = pymysql.connect(
    host='officialsite.kr',
    user='admin',
    password='dlgks~123',
    database='app_master',
    port=23306,
    charset='utf8mb4'
)

try:
    cursor = conn.cursor()

    # 일기 정보 조회
    print('===== 일기 정보 =====')
    cursor.execute('''
        SELECT id, title, content, image_url, created_at
        FROM babynote_diaries
        WHERE id = %s
    ''', ('6cb79f51-c3da-44e5-9f36-d3d5e6e414bd',))

    diary = cursor.fetchone()
    if diary:
        print(f'ID: {diary[0]}')
        print(f'제목: {diary[1]}')
        content_preview = diary[2][:50] if diary[2] else 'None'
        print(f'내용: {content_preview}...')
        print(f'image_url (레거시): {diary[3]}')
        print(f'생성일: {diary[4]}')
    else:
        print('일기를 찾을 수 없습니다.')

    print()
    print('===== 일기 이미지 목록 =====')

    # 일기 이미지 조회
    cursor.execute('''
        SELECT id, image_url, s3_key, image_order
        FROM babynote_diary_images
        WHERE diary_id = %s
        ORDER BY image_order
    ''', ('6cb79f51-c3da-44e5-9f36-d3d5e6e414bd',))

    images = cursor.fetchall()
    if images:
        for idx, img in enumerate(images, 1):
            print(f'{idx}. image_url: {img[1]}')
            print(f'   s3_key: {img[2]}')
            print(f'   order: {img[3]}')
            print()
    else:
        print('등록된 이미지가 없습니다.')

finally:
    cursor.close()
    conn.close()