jarjak/dbal-manager

Helper classes for Doctrine DBAL

DBALManager

, _(*1)

Set of helper classes for Doctrine DBAL. It has been made maily to ease creating bulk imports. It provides a method to execute INSERT ... ON DUPLICATE KEY UPDATE query on MySQL-compatible databases, which is what I miss in Doctrine's MySQL driver., _(*2)

Symfony installation

To use this class in Symfony 2/3, please look at DBALManagerBundle., _(*3)

In Symfony 4, thanks to autowiring you are not forced to use a bundle, just add these lines in your services.yaml:, _(*4)

services:
    _defaults:
        autowire: true

    JarJak\DBALManager: ~

Integration with other frameworks

Run:, _(*5)

composer require jarjak/dbal-manager

The class is PSR-0/PSR-4 compatible, so it can be integrated easily with any modern framework. Here is an example for Silex:, _(*6)

//Application.php

$app['dbal_manager'] = $app->share(function ($app) {
    $manager = new JarJak\DBALManager($app['db']);
    return $manager;
});

Simple example:

You want to insert data or update them if row already exists., _(*7)

$sqlArray = [
    'id' => 1,
    'username' => 'JohnKennedy',
    'email' => 'john@kennedy.gov'
];

/* @var $manager JarJak\DBALManager */
$manager->insertOrUpdate('user', $sqlArray);

Or you want to just skip this row if it exists:, _(*8)

$manager->insertIgnore('user', $sqlArray);

Advanced example:

Lets say we have user table with: - unique usernames and emails - column active can contain only 0 or 1 (not nullable) - column address can be null, _(*9)

$sqlArray = [
    'username' => 'JohnKennedy',
    'email' => 'john@kennedy.gov',
    'password' => $password,
    'address' => '',
    'active' => 0,
];

/* @var $manager JarJak\DBALManager */
$manager->insertOrUpdate('user', $sqlArray, 2, ['active']);

Dumping Queries

DBALManager can use VarDumper to dump SQL queries from QueryBuilder ready to be copypasted into database server (with parameters already included)., _(*10)

/* @var QueryBuilder $queryBuilder */
\JarJak\SqlDumper::dumpQuery($queryBuilder);

If you don't use QueryBuilder you can still dump parametrized SQL with:, _(*11)

\JarJak\SqlDumper::dumpSql($sql, $params);

Testing

Run tests with:, _(*12)

composer run-script test

Fix code style with:, _(*13)

composer run-script csfix