AbstractFetch

The GenericDatabase\Abstract\AbstractFetch class implements the IFetchAbstract interface and serves as a base class for fetching data in a generic database context. It manages the database connection and the fetch strategy, and provides a set of methods for fetching data in various formats (e.g., as objects, associative arrays, numeric arrays, etc.).

Main functionalities:

• Manages the database connection and fetch strategy.
• Provides a base implementation for fetching data from a database using a generic approach.
• Supports fetching data in various formats (e.g., as objects, associative arrays, numeric arrays, etc.).
• Acts as a foundation for implementing the IFetchAbstract interface.

Methods:

• getStrategy(): IFetchStrategy: Returns the current fetch strategy.
• getInstance(): IConnection: Returns the database connection instance.
• setStrategy(IFetchStrategy $strategy): void: Sets the fetch strategy.
• internalFetchAssoc(): array|false|null: Fetches the current row as an associative array.
• internalFetchNum(): array|false|null: Fetches the current row as a numeric array.
• internalFetchBoth(): bool|array: Fetches the current row as both an associative and a numeric array.
• internalFetchColumn(int $columnIndex = 0): false|string: Fetches a single value from the result set, or false if there are no more rows.
• internalFetchClass(?array $constructorArguments = null, ?string $aClassOrObject = '\stdClass'): object|false: Fetches a single row from the result set as an object.
• internalFetchAllAssoc(): array: Fetches all rows from the result set as an associative array, or an empty array if there are no more rows.
• internalFetchAllNum(): array: Fetches all rows from the result set as a numeric array, or an empty array if there are no more rows.
• internalFetchAllBoth(): array: Fetches all rows from the result set as an array of arrays, where each row is both numerically and associatively indexed.
• internalFetchAllColumn(int $columnIndex = 0): array: Fetches all values of a single column from the result set as an array of strings.
• internalFetchAllClass(?array $constructorArguments = [], ?string $aClassOrObject = '\stdClass'): array: Fetches all rows from the result set as an array of objects, each one being an instance of the provided class.

Fields:

• $instance: The connection instance used for dynamic operations.
• $fetchStrategy: The options handler for managing configuration.

Concrete implementations of this class should inherit from AbstractFetch and provide their own implementation of the database connection and fetch strategy.