<?php
// Generated by setup_mariadb_project.sh — edit as needed.
define('DB_HOST', '127.0.0.1');
define('DB_NAME', 'app_30855');
define('DB_USER', 'app_30855');
define('DB_PASS', 'eee81949-37de-47f9-a26f-14ebc8402f7f');

function db() {
    static $pdo;
    if ($pdo) {
        return $pdo;
    }

    $dsn = 'mysql:host=' . DB_HOST . ';charset=utf8mb4';
    $options = [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ];

    try {
        // Try connecting to the database directly
        $pdo = new PDO($dsn . ';dbname=' . DB_NAME, DB_USER, DB_PASS, $options);
    } catch (PDOException $e) {
        // If the database doesn't exist, create it
        if (strpos($e->getMessage(), 'Unknown database') !== false) {
            try {
                $tempPdo = new PDO($dsn, DB_USER, DB_PASS, $options);
                $tempPdo->exec('CREATE DATABASE IF NOT EXISTS `' . DB_NAME . '`');
                // Now, connect to the newly created database
                $pdo = new PDO($dsn . ';dbname=' . DB_NAME, DB_USER, DB_PASS, $options);
            } catch (PDOException $ce) {
                throw new PDOException("Failed to create database and connect: " . $ce->getMessage());
            }
        } else {
            throw new PDOException("Database connection failed: " . $e->getMessage());
        }
    }

    return $pdo;
}