PHP download

Download the PHP package davidlienhard/database-query-validator without Composer

On this page you can find all versions of the php package davidlienhard/database-query-validator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download davidlienhard/database-query-validator
More information about davidlienhard/database-query-validator
Files in davidlienhard/database-query-validator

Vendor davidlienhard
Package database-query-validator
Short Description 🐘 php tool to validate database queries
License MIT
Homepage https://github.com/davidlienhard/database-query-validator/

Keywords database php library mysql

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

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 PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

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.

Please rate this library. Is it a good library?

Example code of davidlienhard/database-query-validator

Informations about the package database-query-validator

davidlienhard/database-query-validator

🐘 php tool to validate database queries written using davidlienhard/database

Configuration

This tool requires a file named query-validator.json in your main project directory. CLI arguments are not supported at the moment. The following configuration options are possible:

paths (array): list of paths (folders or files) to scan.
exclusions (array): list of paths to exclude from the scans
dumpfile (string): path to a mysql dump file to use for type-checks
parameters (object):
- ignoresyntax (bool): whether or not to ignore syntax-errors in the queries
- strictinserts (bool): checks if inserts contains all text-colums of table that are set to not null
- strictinsertsignoremissingtablenames (bool): whether to ignore queries where the tablename could not be extracted on strict imports

All paths are relative to the path of the configuration file. If no configuration file can be found all the files in your currect folder will be scanned.

Example Configuration-File

JSON

YAML

Todo

This project is still work in progress and there is a lot of work todo.

improve validation of queries
improve documentation (of course)
add unit tests
improve recognition of database-queries
improve config
- add support of CLI arguments

License

The MIT License (MIT). Please see LICENSE for more information.

All versions of database-query-validator with dependencies

PHP Build Version

Package Version

Version 0.4.7 Release 07. Nov 2022
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of database-query-validator from vendor davidlienhard

Requires php Version ^8.0
league/flysystem Version ^3
nikic/php-parser Version ^4
phpmyadmin/sql-parser Version ^5
symfony/filesystem Version ^6
symfony/yaml Version ^6
webmozart/glob Version ^4

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package davidlienhard/database-query-validator contains the following files

Loading the files please wait ....