Overview

Classes

Interfaces

Traits

Exceptions

Functions

Trait Manipulation

Direct Known Users

MvcCore\Ext\Models\Db\Providers\Resource, MvcCore\Ext\Models\Db\Providers\Resources\MySql, MvcCore\Ext\Models\Db\Providers\Resources\PgSql, MvcCore\Ext\Models\Db\Providers\Resources\SQLite, MvcCore\Ext\Models\Db\Providers\Resources\SqlSrv

Namespace: MvcCore\Ext\Models\Db\Providers\Resources
Located at ext-model-db/src/MvcCore/Ext/Models/Db/Providers/Resources/Manipulation.php

Methods summary
`public array`	# `Insert( integer\|string $connNameOrIndex, string $tableName, array $dataColumns, string $className, string $autoIncrColumnName )` Execute SQL code to insert new database table row in transaction, in default database isolation. Execute SQL code to insert new database table row in transaction, in default database isolation. Parameters `$connNameOrIndex` Connection name or index in system config. `$tableName` Database table name. `$dataColumns` Data to use in insert clause, keys are column names, values are column values. `$className` model class full name. `$autoIncrColumnName` Auto increment column name. Returns array First item is boolean result, second is affected rows count.
`public array`	# `Update( integer\|string $connNameOrIndex, string $tableName, array $keyColumns, array $dataColumns )` Execute SQL code to update database table row by key columns. Execute SQL code to update database table row by key columns. Parameters `$connNameOrIndex` Connection name or index in system config. `$tableName` Database table name. `$keyColumns` Data to use in where condition, keys are column names, values are column values. `$dataColumns` Data to use in update set clause, keys are column names, values are column values. Returns array First item is boolean result, second is affected rows count.
`public array`	# `Delete( integer\|string $connNameOrIndex, string $tableName, array $keyColumns )` Execute SQL code to remove database table row. Execute SQL code to remove database table row. Parameters `$connNameOrIndex` Connection name or index in system config. `$tableName` Database table name. `$keyColumns` Data to use in where condition, keys are column names, values are column values. Returns array First item is boolean result, second is affected rows count.