/**
* @deprecated use from_dbal_queries() instead
*
* @param null|ParametersSet $parameters_set - each one parameters array will be evaluated as new query
* @param array<int|string, DbalArrayType|DbalParameterType|DbalType|int|string> $types
*/
dbal_from_queries(Connection $connection, string $query, ?ParametersSet $parameters_set, array $types) : DbalQueryExtractor
DSL References
DSL stands for Domain Specific Language. In the case of Flow, the DSL is used to define simple functions that can be used to transform data. Most of those functions are initializing a new instance of a class under the hood since Flow is fully object-oriented. Please look at the examples below to get a better understanding of how to use the DSL functions.
EXTRACTOR
/**
* @deprecated use from_dbal_query() instead
*
* @param array<string, mixed>|list<mixed> $parameters - @deprecated use DbalQueryExtractor::withParameters() instead
* @param array<int|string, DbalArrayType|DbalParameterType|DbalType|int|string> $types - @deprecated use DbalQueryExtractor::withTypes() instead
*/
dbal_from_query(Connection $connection, string $query, array $parameters, array $types) : DbalQueryExtractor
/**
* @param Connection $connection
* @param string|Table $table
* @param array<OrderBy>|OrderBy $order_by
* @param int $page_size
* @param null|int $maximum
*
* @throws InvalidArgumentException
*/
from_dbal_limit_offset(Connection $connection, Table|string $table, OrderBy|array $order_by, int $page_size, ?int $maximum) : DbalLimitOffsetExtractor
/**
* @param Connection $connection
* @param int $page_size
* @param null|int $maximum
*/
from_dbal_limit_offset_qb(Connection $connection, QueryBuilder $queryBuilder, int $page_size, ?int $maximum) : DbalLimitOffsetExtractor
/**
* @param null|ParametersSet $parameters_set - each one parameters array will be evaluated as new query
* @param array<int|string, DbalArrayType|DbalParameterType|DbalType|int|string> $types
*/
from_dbal_queries(Connection $connection, string $query, ?ParametersSet $parameters_set, array $types) : DbalQueryExtractor
/**
* @param array<string, mixed>|list<mixed> $parameters - @deprecated use DbalQueryExtractor::withParameters() instead
* @param array<int|string, DbalArrayType|DbalParameterType|DbalType|int|string> $types - @deprecated use DbalQueryExtractor::withTypes() instead
*/
from_dbal_query(Connection $connection, string $query, array $parameters, array $types) : DbalQueryExtractor
HELPER
/**
* @param array<string, mixed>|Connection $connection
* @param string $query
* @param QueryParameter ...$parameters
*/
dbal_dataframe_factory(Connection|array $connection, string $query, QueryParameter $parameters) : DbalDataFrameFactory
LOADER
/**
* In order to control the size of the single insert, use DataFrame::chunkSize() method just before calling DataFrame::load().
*
* @param array<string, mixed>|Connection $connection
* @param array{
* skip_conflicts?: boolean,
* constraint?: string,
* conflict_columns?: array<string>,
* update_columns?: array<string>,
* primary_key_columns?: array<string>
* } $options - @deprecated use DbalLoader::withOperationOptions() instead
*
* @throws InvalidArgumentException
*/
to_dbal_table_insert(Connection|array $connection, string $table, array $options) : DbalLoader
/**
* In order to control the size of the single request, use DataFrame::chunkSize() method just before calling DataFrame::load().
*
* @param array<string, mixed>|Connection $connection
* @param array{
* skip_conflicts?: boolean,
* constraint?: string,
* conflict_columns?: array<string>,
* update_columns?: array<string>,
* primary_key_columns?: array<string>
* } $options - @deprecated use DbalLoader::withOperationOptions() instead
*
* @throws InvalidArgumentException
*/
to_dbal_table_update(Connection|array $connection, string $table, array $options) : DbalLoader