Class Atk4\Data\Persistence\Sql

`extends`	`Persistence`
`uses`	`BinaryTypeCompatibilityTypecastTrait`

Atk4\Data\Persistence uses ContainerTrait, DiContainerTrait, DynamicMethodTrait, HookTrait, NameTrait
- Atk4\Data\Persistence\Sql uses BinaryTypeCompatibilityTypecastTrait
  - Atk4\Data\Schema\TestSqlPersistence

Located at data/src/Persistence/Sql.php

Methods
`public`	`__construct( Connection\|string\|array<string, string>\|Connection\|Connection $connection, string $user = null, string $password = null, array<string, mixed> $defaults = [], )` Overriden by `Atk4\Data\Schema\TestSqlPersistence::__construct()`	#
`public`	`getConnection(): Connection` Overriden by `Atk4\Data\Schema\TestSqlPersistence::getConnection()`	#
`public`	`disconnect(): void` Disconnect from database explicitly. Disconnect from database explicitly. Overrides `Atk4\Data\Persistence::disconnect()`	#
`public`	`atomic(Closure $fx)` Atomic executes operations within one begin/end transaction. Not all persistencies will support atomic operations, so… Atomic executes operations within one begin/end transaction. Not all persistencies will support atomic operations, so by default we just don't do anything. Overrides `Atk4\Data\Persistence::atomic()`	#
`public`	`getDatabasePlatform(): AbstractPlatform` Overrides `Atk4\Data\Persistence::getDatabasePlatform()`	#
`public`	`add(Model $model, array $defaults = []): void` Associate model with the data driver. Associate model with the data driver. Overrides `Atk4\Data\Persistence::add()`	#
`protected`	`initPersistence(Model $model): void` Extend this method to enhance model to work with your persistence. Here you can define additional methods or store… Extend this method to enhance model to work with your persistence. Here you can define additional methods or store additional data. This method is executed before model's init(). Overrides `Atk4\Data\Persistence::initPersistence()`	#
`public`	`expr(Model $model, string $template, array<int\|string, mixed> $arguments = []): Expression` Creates new Expression object from expression string. Creates new Expression object from expression string.	#
`public`	`exprNow(int $precision = null): Expression` Creates new Query object with current time expression. Creates new Query object with current time expression.	#
`public`	`dsql(): Query` Creates new Query object. Creates new Query object.	#
`public`	`initQuery(Model $model): Query` Initializes base query for model $m. Initializes base query for model $m.	#
`public`	`initWithCursors(Model $model, Query $query): void`	#
`public`	`initField(Query $query, Field $field): void` Adds Field in Query. Adds Field in Query.	#
`public`	`initQueryFields(Model $model, Query $query, array<int, string>\|null $fields = null): void` Adds model fields in Query. Adds model fields in Query.	#
`protected`	`setLimitOrder(Model $model, Query $query): void` Will set limit defined inside $m onto query $q. Will set limit defined inside $m onto query $q.	#
`public`	`initQueryConditions(Model $model, Query $query): void` Will apply model scope/conditions onto $query. Will apply model scope/conditions onto $query.	#
`private`	`fixMssqlOracleMissingFieldsInGroup(Model $model, Query $query): void`	#
`private`	`_initQueryConditions(Query $query, AbstractScope $condition = null): void`	#
`public`	`action(Model $model, string $type, array<mixed> $args = []): Query`	#
`public`	`tryLoad(Model $model, $id): ?array` Tries to load data record, but will not fail if record can't be loaded. Tries to load data record, but will not fail if record can't be loaded. Overrides `Atk4\Data\Persistence::tryLoad()`	#
`public`	`export(Model $model, array<int, string>\|null $fields = null, bool $typecast = true): array<int, array<string, mixed>>` Export all DataSet. Export all DataSet.	#
`public`	`prepareIterator(Model $model): Traversable<array<string, mixed>>`	#
`private`	`assertExactlyOneRecordUpdated(Model $model, mixed $idRaw, int $affectedRows, string $operation): void`	#
`protected`	`insertRaw(Model $model, array<scalar\|Expressionable\|null> $dataRaw)` Overrides `Atk4\Data\Persistence::insertRaw()`	#
`protected`	`updateRaw(Model $model, $idRaw, array<scalar\|Expressionable\|null> $dataRaw): void` Overrides `Atk4\Data\Persistence::updateRaw()`	#
`protected`	`deleteRaw(Model $model, $idRaw): void` Overrides `Atk4\Data\Persistence::deleteRaw()`	#
`public`	`typecastSaveField(Field $field, $value)` Prepare value of a specific field by converting it to persistence-friendly format. Prepare value of a specific field by converting it to persistence-friendly format. Overrides `Atk4\Data\Persistence::typecastSaveField()`	#
`public`	`typecastLoadField(Field $field, $value)` Cast specific field value from the way how it's stored inside persistence to a PHP format. Cast specific field value from the way how it's stored inside persistence to a PHP format. Overrides `Atk4\Data\Persistence::typecastLoadField()`	#
`protected`	`_typecastSaveField(Field $field, $value)` This is the actual field typecasting, which you can override in your persistence to implement necessary typecasting. This is the actual field typecasting, which you can override in your persistence to implement necessary typecasting. Overrides `Atk4\Data\Persistence::_typecastSaveField()`	#
`public`	`getFieldSqlExpression(Field $field, Expression $expression): Expression`	#
`public`	`lastInsertId(Model $model): string`	#

Methods inherited from Atk4\Data\Persistence
`connect(), load(), insert(), update(), delete(), typecastSaveRow(), typecastLoadRow(), _typecastLoadField()`

Methods used from Atk4\Core\ContainerTrait
`_uniqueElementName(), _addContainer(), removeElement(), _shorten(), getElement(), hasElement()`

Methods used from Atk4\Core\DiContainerTrait
`setDefaults(), setMissingProperty(), assertInstanceOf(), _fromSeedPrecheck(), fromSeed(), fromSeedUnsafe()`

Methods used from Atk4\Core\DynamicMethodTrait
`__call(), buildMethodHookName(), addMethod(), hasMethod(), removeMethod()`

Methods used from Atk4\Core\HookTrait
`_rebindHookFxToFakeInstance(), _unbindHookFxIfBoundToThis(), _rebindHooksIfCloned(), onHook(), onHookShort(), _makeHookDynamicFx(), onHookDynamic(), onHookDynamicShort(), hookHasCallbacks(), removeHook(), hook(), breakHook()`

Methods used from Atk4\Data\Persistence\Sql\BinaryTypeCompatibilityTypecastTrait
`binaryTypeValueGetPrefixConst(), binaryTypeValueEncode(), binaryTypeValueIsEncoded(), binaryTypeValueDecode(), binaryTypeIsEncodeNeeded(), binaryTypeIsDecodeNeeded()`

Constants
`public`	`HOOK_INIT_SELECT_QUERY = self::class . '@initSelectQuery'`	#
`public`	`HOOK_BEFORE_INSERT_QUERY = self::class . '@beforeInsertQuery'`	#
`public`	`HOOK_AFTER_INSERT_QUERY = self::class . '@afterInsertQuery'`	#
`public`	`HOOK_BEFORE_UPDATE_QUERY = self::class . '@beforeUpdateQuery'`	#
`public`	`HOOK_AFTER_UPDATE_QUERY = self::class . '@afterUpdateQuery'`	#
`public`	`HOOK_BEFORE_DELETE_QUERY = self::class . '@beforeDeleteQuery'`	#
`public`	`HOOK_AFTER_DELETE_QUERY = self::class . '@afterDeleteQuery'`	#

Constants inherited from Atk4\Data\Persistence
`HOOK_AFTER_ADD, ID_LOAD_ONE, ID_LOAD_ANY`

Properties
`private`	`Connection`	`$_connection`	#
`protected`	`array<mixed>`	`$_defaultSeedAddField` Default class when adding new field. Default class when adding new field.	#
`protected`	`array<mixed>`	`$_defaultSeedAddExpression = [SqlExpressionField::class]` Default class when adding Expression field. Default class when adding Expression field.	#
`protected`	`array<mixed>`	`$_defaultSeedHasOne = [HasOneSql::class]` Default class when adding hasOne field. Default class when adding hasOne field.	#
`protected`	`array<mixed>`	`$_defaultSeedHasMany` Default class when adding hasMany field. Default class when adding hasMany field.	#
`protected`	`array<mixed>`	`$_defaultSeedJoin = [Join::class]` Default class when adding join. Default class when adding join.	#

Properties inherited from Atk4\Data\Persistence
`$typecastSaveSkipNormalize`

Properties used from Atk4\Core\ContainerTrait
`$elements, $_elementNameCounts`

Properties used from Atk4\Core\HookTrait
`$hooks, $_hookIndexCounter, $_hookOrigThis`

Properties used from Atk4\Core\NameTrait
`$name`

Namespaces

Classes

Class Atk4\Data\Persistence\Sql

Overriden by

Overriden by

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides

Overrides