extract_database.md

Extract: Database

Based on Doctrine DBAL

Every PDO drivers are supported, use these identifiers in your uri:

• mysql for MySQL
• sqlite for SQLite
• pgsql for PostgreSQL
• oci for Oracle
• sqlsrv for Microsoft SQL Server

More info

examples:

• mysql://user:password@host:port/database_name
• sqlite://./data/database_in.sqlite (relative path)
• sqlite:////home/data/database_in.sqlite (absolute path)

options:
    select:               []
    from:                 ~ # Required

    # Prepared SQL statements with placeholder: i.e. "size > :size"
    where:                null

    # Associate placeholders from the "where" part with the value you want: i.e. "{ size: 10 }"
    parameters:           []