README

This library contains a common interface for connecting to database and writing data to, various sources:

• It is intended for use with db-writer-common.
• It supports PDO and ODBC connections for now.
• The interfaces defined in this library can be easily used to support other methods, e.g. cli BCP tool.

Main Classes

• Interface Connection is an abstraction that represents a connection to the database.
  • Abstract class BaseConnection contains common code and retry mechanisms.
  • Class PdoConnection implements connection using PDO extension.
  • Class OdbcConnection implements connection using ODBC extension.
• Interface WriteAdapter is an abstraction which defines how the data is written.
  • Abstract class BaseWriteAdapter contains common code.
  • Class PdoWriteAdapter implements write for PDO connection.
  • Class OdbcWriteAdapter implements write for ODBC connection.
• Interface QueryBuilder used to generate SQL query for adapter.
  • Class DefaultQueryFactory is base implementation for MySQL/MariaDb compatible SQL dialects.

Development

Clone this repository and init the workspace with following command:

git clone https://github.com/keboola/db-writer-adapter
cd db-writer-adapter
docker-compose build
docker-compose run --rm dev composer install --no-scripts

Run the test suite using this command:

docker-compose run --rm dev composer tests

License

MIT licensed, see LICENSE file.