liquipedia/sqllint

A thin wrapper around the SqlParser from the phpMyAdmin project which can be used to lint any amount of sql files from the command line.

1.2.1 2022-06-16 23:32 UTC

Requires

• phpmyadmin/sql-parser: *

Requires (Dev)

• mediawiki/mediawiki-codesniffer: *
• mediawiki/minus-x: *
• php-parallel-lint/php-console-highlighter: *
• php-parallel-lint/php-parallel-lint: *
• phpstan/phpstan: *

GPL-2.0-or-later

• Alex Winkler

• sql
• lint
• junit

README

This is a thin wrapper around the SqlParser from the phpMyAdmin project which can be used to lint any amount of sql files from the command line.

Installation

Please use Composer to install:

composer require liquipedia/sqllint --dev

Usage

Command line utility

./vendor/bin/sqllint

./vendor/bin/sqllint --report=junit > report-junit.xml

Via composer script

Add this to your composer.json

{
	"require-dev": {
		"liquipedia/sqllint": "*"
	},
	"scripts": {
		"sqllint": [
			"sqllint"
		],
		"sqllint-junit": [
			"sqllint --report=junit > report-junit.xml"
		]
	}
}

and run

composer sqllint

Parameter

To check out parameters, please refer to the src/Parameters.php file or use the --help parameter.

.sqllint.json

Parameters for SqlLint can optionally also be provided via a .sqllint.json file in the project root. Parameters passed via command line always have precedence over the parameters set in .sqllint.json.

Example:

{
	"report": "junit"
}