#!/usr/bin/env python3
"""
Create nexuscrm database via Python + mysql-connector-python.
mysql-connector-python auto-negotiates TLS with TiDB Cloud serverless.
"""
import os
import sys

try:
    import mysql.connector
except ImportError:
    import subprocess
    subprocess.run([sys.executable, "-m", "pip", "install", "mysql-connector-python", "-q"], check=True)
    import mysql.connector


def main():
    host = os.environ.get("TIDB_HOST", "127.0.0.1")
    port = int(os.environ.get("TIDB_PORT", "4000"))
    user = os.environ.get("TIDB_USER", "root")
    password = os.environ.get("TIDB_PASSWORD", "")
    db_name = os.environ.get("TIDB_DATABASE", "nexuscrm")

    print(f"DEBUG: TIDB_HOST={repr(host)}")
    print(f"DEBUG: TIDB_PORT={repr(port)}")
    print(f"DEBUG: TIDB_USER={repr(user)}")
    print(f"DEBUG: TIDB_PASSWORD={repr(password)}")

    print(f"Connecting to {host}:{port} as {user}...")
    # mysql-connector auto-handles TLS for TiDB Cloud serverless
    conn = mysql.connector.connect(
        host=host, port=port, user=user, password=password,
    )
    print("Connected successfully!")
    cursor = conn.cursor()
    cursor.execute(f"CREATE DATABASE IF NOT EXISTS `{db_name}`")
    conn.commit()
    cursor.close()
    conn.close()
    print(f"Database '{db_name}' created/verified.")


if __name__ == "__main__":
    main()