PHP Classes

File: tests/dialect_mysql_test.php

Recommend this page to a friend!
  Packages of Adrian M   PHP CRUD API Generator   tests/dialect_mysql_test.php   Download  
File: tests/dialect_mysql_test.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP CRUD API Generator
Create an API to access MySQL database record
Author: By
Last change:
Date: 3 months ago
Size: 881 bytes
 

Contents

Class file image Download
<?php
require_once __DIR__ . '/../vendor/autoload.php';

use
App\Database\Dialect\MySqlDialect;
use
App\Database\SchemaInspector;
use
App\Database\Database;

echo
"Dialect MySQL Test\n";

// Basic quoteIdent
$dialect = new MySqlDialect();
$quoted = $dialect->quoteIdent('users');
if (
$quoted !== '`users`') {
    echo
"? quoteIdent failed: $quoted\n";
    exit(
1);
}

echo
"? quoteIdent passed\n";

// Optional: if DB configured, ensure inspector delegates
try {
   
$dbConfig = require __DIR__ . '/../config/db.php';
   
$db = new Database($dbConfig);
   
$inspector = new SchemaInspector($db->getPdo(), $dialect);
   
$tables = $inspector->getTables();
    echo
"? inspector.getTables returned array (" . count($tables) . ")\n";
} catch (
Throwable $e) {
    echo
"(info) Skipping DB-based dialect test: " . $e->getMessage() . "\n";
}

echo
"? Dialect tests completed\n";