Download the PHP package ray/aura-sql-module without Composer
On this page you can find all versions of the php package ray/aura-sql-module. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download ray/aura-sql-module
More information about ray/aura-sql-module
Files in ray/aura-sql-module
Informations about the package aura-sql-module
Ray.AuraSqlModule
Installation
Getting started
Module install
Use AuraSqlEnvModule to get the value from the environment variable each time at runtime, instead of specifying the value directly.
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($qualifier)]
attribute.
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
with replication
You can set $qualifier
in 2nd parameter of AuraSqlReplicationModule.
Transaction
Any method marked with #[Transactional]
will have a transaction started before, and ended after it is called.
Query Builder
Aura.SqlQuery provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. Following four interfaces are bound and can be injected via constructor:
Aura\SqlQuery\Common\SelectInterface
Aura\SqlQuery\Common\InsertInterface
Aura\SqlQuery\Common\UpdateInterface
Aura\SqlQuery\Common\DeleteInterface
Multiple Query Builders
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 iterable.
View
The view template can be changed with binding. See more at Pagerfanta.
Profile
To log SQL execution, install AuraSqlProfileModule
.
It will be logged by a logger bound to the PSR-3 logger. This example binds a minimal function logger created in an anonymous class.
All versions of aura-sql-module with dependencies
ext-pdo Version *
ray/di Version ^2.18
ray/aop Version ^2.17
aura/sql Version ^6.0
pagerfanta/pagerfanta Version ^3.5 || ^4.7
rize/uri-template Version ^0.4
doctrine/annotations Version ^1.11 || ^2.0
psr/log Version ^1.1 || ^2.0 || ^3.0
aura/sqlquery Version ^3.0