README

A drop-in replacement for FluentPDO, powered by DoctrineORM. This library allows you to migrate existing applications from FluentPDO to DoctrineORM with minimal code changes.

Features

• FluentPDO-like API for easy migration
• Internally uses DoctrineORM for database operations
• Supports multiple database platforms (as supported by DoctrineORM)

• Complete CRUD operations with FluentPDO-compatible methods:

  • getColumnsFromSQL(): Fetch specific columns with conditions
  • getDataFromSQL(): Load records by ID
  • loadFromSQL(): Load data with conditions
  • saveToSQL(): Insert or update records
  • deleteFromSQL(): Remove records
  • recordExists(): Check record existence

• Query builder and transaction support
• Table and column property compatibility (myTable, keyColumn, nameColumn, etc.)
• Compatible with PHP 8.4+
• PSR-12 compliant
• Secure, extensible, and well-tested

Installation

composer require vitexsoftware/ease-doctrineorm

Usage Example

use Ease\Doctrine\Engine;

$connectionParams = [
    'driver' => 'pdo_sqlite',
    'path' => __DIR__ . '/var/data.sqlite',
];
$config = [
    'entityPath' => __DIR__ . '/src/Entity',
    'devMode' => true,
];
$easeDoctrine = new Engine($connectionParams, $config);
$easeDoctrine->setmyTable('User');
$easeDoctrine->keyColumn = 'id';
$easeDoctrine->nameColumn = 'username';

// Basic operations
$allUsers = $easeDoctrine->getAll();
$userName = $easeDoctrine->getRecordName();

// FluentPDO-compatible operations
// Load specific columns with conditions
$users = $easeDoctrine->getColumnsFromSQL(
    ['username', 'email'],
    ['active' => true],
    'username',
    null,
    10
);

// Load by ID
$user = $easeDoctrine->getDataFromSQL(123);

// Save (insert or update)
$userData = ['username' => 'john_doe', 'email' => 'john@example.com'];
$userId = $easeDoctrine->saveToSQL($userData);

// Check existence
if ($easeDoctrine->recordExists('john_doe')) {
    echo 'User exists!';
}

// Delete
$easeDoctrine->deleteFromSQL(['id' => 123]);

// Load with conditions
$activeUsers = $easeDoctrine->loadFromSQL(['active' => true]);

Detailed API Documentation

The library provides several FluentPDO-compatible methods for database operations:

getColumnsFromSQL(array $columnsList, $conditions = null, $orderBy = null, $indexBy = null, $limit = null)

Fetch specific columns with conditions, ordering, and limits.

getDataFromSQL($itemID, array $columnsList = ['*'])

Load a record by its ID, optionally selecting specific columns.

loadFromSQL($itemID)

Load data for specified conditions or ID.

saveToSQL($data = null)

Save (insert or update) data to the database.

updateToSQL($data = null, $conditions = [])

Update existing records matching conditions.

insertToSQL($data = null)

Insert a new record.

deleteFromSQL($data = null)

Delete records matching conditions.

recordExists($data)

Check if a record exists. Can check by ID, name, or conditions.

dbreload()

Reload current record from database.

dbsync(array $data = [])

Save data and reload from database.

Testing

./vendor/bin/phpunit --bootstrap vendor/autoload.php tests

License

MIT License

Author

Vitex Software <info@vitexsoftware.cz>