cli.php

<?php

/*
$driver = 'mysql';
$config = http_build_query(data: [
    'host' => 'localhost',
    'port' => 3306,
    'dbname' => 'phpiggy'
], arg_separator:';');

$dsn = "{$driver}:{$config}";
$username = 'root';
$password = '';

try {
    $db = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    die("Unable to connect to database");
}
*/

include __DIR__ . '/src/Framework/Database.php';

use Framework\Database;

$db = new Database('mysql', [
  'host' => 'localhost',
  'port' => 3306,
  'dbname' => 'phpiggy'
], 'root', '');

/*
try {
    $db -> connection -> beginTransaction();
    $db ->connection->query("INSERT INTO products VALUES(99, 'Gloves')");
    $search = "Hats";
    $query = "SELECT FROM * products WHERE name =: name";
    $stmt = $db -> connection -> prepare($query);
    $stmt->bindValue('name', $search, PDO::PARAM_STR);
    $stmt ->execute();
    var_dump($stmt->fetchAll(PDO::FETCH_OBJ));
} catch (Exception $error) {
    if ($db -> connection -> inTransaction) {
        $db -> connection -> rollBack();
    }
    echo "Transaction failed!";
}
*/

$sqlFile = file_get_contents("./database.sql");

$db->query($sqlFile);