Download the PHP package ray/aura-sql-module without Composer

Ray.AuraSqlModule

An Aura.Sql Module for Ray.Di

Installation

Composer install

$ composer require ray/aura-sql-module

Module install

Use AuraSqlEnvModule to get the value from the environment variable each time at runtime, instead of specifying the value directly.

DI trait

• AuraSqlInject for Aura\Sql\ExtendedPdoInterface interface

  Replication

  Installing AuraSqlReplicationModule using a connection locator for master/slave connections.

You will now have a slave db connection when using HTTP GET, or a master db connection in other HTTP methods.

Multiple DB

You may want to inject different connection destinations on the same DB interface with @Named($qaulifier) annotation. Two modules are provided. NamedPdoModule is for non replication use. and AuraSqlReplicationModule is for replication use.

with no replication

Use NamedPdoModule to inject different named Pdo instance for non Replication use. For instance, This module install log_db named Pdo instance.

Or

php class AppModule extends AbstractModule { protected function configure() { $this->install(new AuraSqlReplicationModule($locator, 'log_db')); } }

## Transaction

Any method marked with `@Transactional` will have a transaction started before, and ended after it is called.

## Query Builder

[Aura.SqlQuery](https://github.com/auraphp/Aura.SqlQuery) provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. Following four interfaces are bound and setter trait for them are available.

QueryBuilder interface

 * `Aura\SqlQuery\Common\SelectInterface`
 * `Aura\SqlQuery\Common\InsertInterface`
 * `Aura\SqlQuery\Common\UpdateInterface`
 * `Aura\SqlQuery\Common\DeleteInterface`

QueryBuilder setter trait

 * `Ray\AuraSqlModule\AuraSqlSelectInject`
 * `Ray\AuraSqlModule\AuraSqlInsertInject`
 * `Ray\AuraSqlModule\AuraSqlUpdateInject`
 * `Ray\AuraSqlModule\AuraSqlDeleteInject`

## Pagination

Pagination service is provided for both `ExtendedPdo` raw sql and `Select` query builder. 

**ExtendedPdo**

**Select query builder**

An array access with page number returns `Page` value object.

It is iteratable.

### View

The view template can be changed with binding. See more at [Pagerfanta](https://github.com/whiteoctober/Pagerfanta#views).

## Profile

To log SQL execution, install `AuraSqlProfileModule`. 
It will be logged by a logger bound to the [PSR-3](https://www.php-fig.org/psr/psr-3/) logger. This example binds a minimal function logger created in an unnamed class.