Download the PHP package napp/dbalcore without Composer
On this page you can find all versions of the php package napp/dbalcore. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download napp/dbalcore
More information about napp/dbalcore
Files in napp/dbalcore
Informations about the package dbalcore
Napp DBAL Core
This package extends the Laravel Query Builder, has a nice Base Repository
and has a collection of helpful Criteria
to build queries.
Repositories
The Basereposity has various helpful methods.
Transactions
Criteria
A Criterion
is a way to build custom query logic in its own class and reuse within your project.
Use it together with the BaseRepository to
QueryBuilder Usage
This package extends the Laravel QueryBuilder by the following methods:
Replace
Makes it possible to use the REPLACE INTO
MySQL grammar in Laravel. Simply do:
insertOnDuplicateKey
Call insertOnDuplicateKey
or insertIgnore
from a model with the array of data to insert in its table.
Customizing the ON DUPLICATE KEY UPDATE clause
Update only certain columns
If you want to update only certain columns, pass them as the 2nd argument.
Update with custom values
You can customize the value with which the columns will be updated when a row already exists by passing an associative array.
In the following example, if a user with id = 1 doesn't exist, it will be created with name = 'created user'. If it already exists, it will be updated with name = 'updated user'.
The generated SQL is:
You may combine key/value pairs and column names in the 2nd argument to specify the columns to update with a custom literal or expression or with the default VALUES(column)
. For example:
will generate
Pivot tables
Call attachOnDuplicateKey
and attachIgnore
from a BelongsToMany
relation to run the inserts in its pivot table. You can pass the data in all of the formats accepted by attach
.
All versions of dbalcore with dependencies
illuminate/database Version ^5.8|^6.0|^7.0|^8.0
illuminate/support Version ^5.8|^6.0|^7.0|^8.0