simbiat/db-installer

Install database dependencies for a library based on the current version.

dev-main 2025-06-09 13:33 UTC

Requires

• php: ^8.4
• ext-pdo: *
• simbiat/db-query: ^1

Suggests

• simbiat/db-pool: Allows use of database connections pool

AGPL-3.0-or-later

• Dmitrii Kustov

• database
• php
• installer
• pdo
• updater

README

Small library to install or update database dependencies of a library, based on its current version.

new \Simbiat\Database\Installer($dbh)::install(string $pattern, string $version = '0.0.0', string $replace_string = '', string $replace_with = '')

The constructor of the Installer class requires a \PDO object to establish connection, or it can be or null if you are using DB Pool library.

Then pass a pattern for glob() to get the files with SQL commands you need to run and current version string. The function will scan the respective folder(s) for files and then compare their names to the version provided. Those files that have a "greater" version number (based on version_compare()) will be concatenated and then run against the database. If the commands succeed, the function will return true, otherwise an exception will be thrown.

You can also pass $replace_string and $replace_with that will preg_replace() in the resulting set of queries. This is useful if you need to customize a database prefix, for example.