laminas/laminas-db

Database abstraction layer, SQL abstraction, result set abstraction, and RowDataGateway and TableDataGateway implementations

Fund package maintenance!
Community Bridge

Installs: 3 941 791

Dependents: 150

Suggesters: 9

Security: 0

Stars: 72

Watchers: 22

Forks: 40

Open Issues: 18


README

Build Status

Laminas\Db is a component that abstract the access to a Database using an object oriented API to build the queries. Laminas\Db consumes different storage adapters to access different database vendors such as MySQL, PostgreSQL, Oracle, IBM DB2, Microsoft Sql Server, PDO, etc.

Contributing

Please be sure to read the contributor's guide for general information on contributing. This section outlines specifics for laminas-db.

Test suites

The phpunit.xml.dist file defines two test suites, "unit test" and "integration test". You can run one or the other using the --testsuite option to phpunit:

$ ./vendor/bin/phpunit --testsuite "unit test" # unit tests only
$ ./vendor/bin/phpunit --testsuite "integration test" # integration tests only

Unit tests do not require additional functionality beyond having the appropriate database extensions present and loaded in your PHP binary.

Integration tests

To run the integration tests, you need databases. The repository includes a Vagrantfile which allows you to fire up a vagrant box with several of our target databases, including:

  • MySQL
  • PostgreSQL
  • SQL Server

To start up vagrant:

$ vagrant up

Copy phpunit.xml.dist to phpunit.xml, and change the following ENV var declaration values to "true":

  • TESTS_LAMINAS_DB_ADAPTER_DRIVER_MYSQL
  • TESTS_LAMINAS_DB_ADAPTER_DRIVER_SQLSRV
  • TESTS_LAMINAS_DB_ADAPTER_DRIVER_PGSQL
  • TESTS_LAMINAS_DB_ADAPTER_DRIVER_SQLITE_MEMORY

From there, you can run the integration tests:

$ ./vendor/bin/phpunit --testsuite "integration test"