Download the PHP package metarush/data-mapper without Composer
On this page you can find all versions of the php package metarush/data-mapper. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download metarush/data-mapper
More information about metarush/data-mapper
Files in metarush/data-mapper
Package data-mapper
Short Description A generic data access layer for basic CRUD operations. Can act as a layer between database and repositories/services.
License MIT
Informations about the package data-mapper
metarush/data-mapper
A generic data access layer for basic CRUD operations. Can act as a layer between database and repositories/services.
Install
Install via composer as metarush/data-mapper
Usage
Init library
Create new row
Find column
Find row
Find rows
Update rows
Delete rows
Using $where
clause
As per Atlas.Query
documentation, if the value of the column given is an array, the condition will be IN (). Given a null value, the condition will be IS NULL. For all other values, the condition will be =. If you pass a key without a value, that key will be used as a raw unescaped condition.
The above sample is equivalent to
WHERE foo IN (:__1__, :__2__, :__3__) AND bar IS NULL AND baz = :__4__ AND zim = NOW()
Other examples using other WHERE
operators:
Remember, if you pass a key without a value (like these other WHERE
operators), they will be unescaped.
Transaction methods
Custom SQL query
You can use prepared statements with placeholders or named parameters
SELECT
Single INSERT
Multiple INSERT in one statement
UPDATE
DELETE
Optional config/builder methods
If set totrue
,create()
and update()
methods will strip missing columns in their $data
parameter.
Required when using setStripMissingColumns(true)
Example parameter for $tablesDefinition
:
Current adapters
- PDO (via Atlas.Query)