Download the PHP package tworzenieweb/sql-provisioner without Composer
On this page you can find all versions of the php package tworzenieweb/sql-provisioner. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download tworzenieweb/sql-provisioner
More information about tworzenieweb/sql-provisioner
Files in tworzenieweb/sql-provisioner
Package sql-provisioner
Short Description Simple CLI tool for validating SQL files before inserting them into DB.
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package sql-provisioner
SQL Provisioner
Simple CLI tool for database changes deploying. It allows to review each dbdeploy file before executution.
Getting Started
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
Prerequisites
To use this library, you would need to have composer installed and have a table for storing already performed DB deploys.
Lastly, you would need to provide .env file with connection information and table and column name for checks
Installing
It installs just like any other composer project
Then you should be able to run command from vendor/bin/sql-provisioner
Using
The vendor/bin/sql-provisioner [path-to-folder] command will scan the content of [path-to-folder] directory.
The script will look for .env file containing connection information in format:
If you want to create initial .env use
The next step is searching for sql files and trying to queue them in numerical order. First n-th digits of a filename will be treated as candidate number. This will be used then to check in database if a certain file was already deployed (PROVISIONING_TABLE_CANDIDATE_NUMBER_COLUMN). Before the insert, it will print the formatted output of a file and result of internal syntax check. Then you can either skip or execute each.
If you would like to skip already provisioned candidates use If you would like to skip syntax checking (for speed purpose) of candidates use
Demo
This is cinerama demo of usage
Versioning
We use SemVer for versioning. For the versions available, see the tags on this repository.
Authors
- Luke Adamczewski - Initial work - tworzenieweb
License
This project is licensed under the MIT License - see the LICENSE.md file for details
All versions of sql-provisioner with dependencies
ext-pdo Version *
jdorn/sql-formatter Version ^1.2
symfony/console Version ^3.2
symfony/dependency-injection Version ^3.2
symfony/config Version ^3.2
symfony/finder Version ^3.2
symfony/filesystem Version ^3.2
vlucas/phpdotenv Version ^2.4
cweiske/php-sqllint Version ^0.1.3
symfony/process Version ^3.2
swiftmailer/swiftmailer Version ^6.0
symfony/expression-language Version ^3.4
twig/twig Version ^2.4