Pular para o conteúdo principal

Running Unit tests

Unit Tests (no DBConnection)​

vendor/bin/phpunit

Running database tests​

Run integration tests require you to have the databases up and running. We provided a basic docker-compose.yml and you can use to start the databases for test.

Starting the target databases​

docker-compose up -d postgres mysql

Running the tests against the databases​

vendor/bin/testsdb/PdoMySqlTest.php 
vendor/bin/testsdb/PdoSqliteTest.php 
vendor/bin/testsdb/PdoDuckdbTest.php 
vendor/bin/testsdb/PdoPostgresTest.php 
vendor/bin/testsdb/PdoDblibTest.php 
vendor/bin/testsdb/PdoSqlsrvTest.php

Optionally you can set the host and password used by the unit tests

export MYSQL_TEST_HOST=localhost     # defaults to localhost
export MYSQL_PASSWORD=newpassword    # use '.' if want have a null password
export PSQL_TEST_HOST=localhost      # defaults to localhost
export PSQL_PASSWORD=newpassword     # use '.' if want have a null password
export MSSQL_TEST_HOST=localhost     # defaults to localhost
export MSSQL_PASSWORD=Pa55word            
export SQLITE_TEST_HOST=/tmp/test.db      # defaults to /tmp/test.db
export ORACLE_TEST_HOST=localhost    # defaults to 127.0.0.1
export ORACLE_PASSWORD=password      # use '.' if want have a null password
export ORACLE_DATABASE=XE            # defaults to XE

A test class is skipped when its PHP extension is not loaded: pdo_dblib, pdo_sqlsrv, oci8 (Oci8Test), pdo_oci (PdoOciTest) and pdo_duckdb (PdoDuckdbTest, which uses the file /tmp/test.duckdb). See Installing the PHP database extensions to install them. The PDO OCI tests also need NLS_LANG=.AL32UTF8 in the environment.

With the shellscript.download PHP wrappers, one command installs oci8, pdo_oci, pdo_sqlsrv and pdo_duckdb and sets that variable:

load.sh php-docker -- 8.5 --postinstall testsdb/install-db-extensions.sh

The Oracle tests need the oracle service of docker-compose.yml running.

Cloudflare D1​

D1 has no local emulator exposing the Cloudflare REST API, so testsdb/D1Test.php runs against a real (throwaway) D1 database and is skipped unless all three variables below are set. The driver itself is fully covered without credentials by tests/D1DriverTest.php.

export D1_ACCOUNT_ID=your-account-id
export D1_DATABASE_ID=your-database-uuid
export D1_API_TOKEN=your-api-token
export D1_HOST=api.cloudflare.com    # defaults to api.cloudflare.com