Skip to content

[source]

SQL Table#

The SQL table extractor iterates over the rows of a relational database table. It works with the PHP Data Objects (PDO) interface to connect to a broad selection of databases such MySQL, PostgreSQL, and Sqlite.

Note

This extractor requires the PDO extension.

Note

The order in which the rows are iterated over is not guaranteed. Use a custom query with ORDER BY statement if ordering matters.

Interfaces: Extractor

Parameters#

# Name Default Type Description
1 connection PDO The PDO connection to the database.
2 table string The name of the table to select from.
3 batch size 100 int The number of rows of the table to load in a single query.

Example#

use Rubix\ML\Extractors\SQLTable;
use PDO;

$connection = new PDO('sqlite:/example.sqlite');

$this->extractor = new SQLTable($connection, 'users', 200);

Additional Methods#

This extractor does not have any additional methods.


Last update: 2021-04-01