summaryrefslogtreecommitdiff
path: root/tools/checksql.sh
diff options
context:
space:
mode:
authorAndrei Karas <akaras@inbox.ru>2019-11-18 12:11:56 +0300
committerAndrei Karas <akaras@inbox.ru>2019-11-18 22:53:48 +0300
commit05ea79929aa099d25b543f4a86db721f5f7e700e (patch)
treeea79ae74ce0aef63f5503a5c4f4258e622be354a /tools/checksql.sh
parent61e6b22b12cb66bd3bb6bc1268228ea7d5e2519b (diff)
downloadhercules-05ea79929aa099d25b543f4a86db721f5f7e700e.tar.gz
hercules-05ea79929aa099d25b543f4a86db721f5f7e700e.tar.bz2
hercules-05ea79929aa099d25b543f4a86db721f5f7e700e.tar.xz
hercules-05ea79929aa099d25b543f4a86db721f5f7e700e.zip
Add phpsqllint for check sql queries
Diffstat (limited to 'tools/checksql.sh')
-rwxr-xr-xtools/checksql.sh13
1 files changed, 13 insertions, 0 deletions
diff --git a/tools/checksql.sh b/tools/checksql.sh
new file mode 100755
index 000000000..f7fb23700
--- /dev/null
+++ b/tools/checksql.sh
@@ -0,0 +1,13 @@
+#!/bin/bash
+
+function checkdir {
+ for sql in $1/*.sql
+ do
+ echo "checking ${sql}"
+ php -d memory_limit=4G ./tools/php-sqllint/bin/php-sqllint "${sql}" || exit 1
+ done
+}
+
+checkdir "sql-files"
+checkdir "sql-files/upgrades"
+checkdir "sql-files/tools"