Run CI on h2/mysql/postgres

1 files changed, 39 insertions, 0 deletions

diff --git a/travis.sh b/travis.sh
new file mode 100755
index 00000000000..b8a1b126d3f
--- /dev/null
+++ b/travis.sh
@@ -0,0 +1,39 @@
+#!/bin/bash
+
+set -euo pipefail
+
+function installTravisTools {
+  curl -sSL https://raw.githubusercontent.com/dgageot/travis-utils/master/install.sh | sh
+  source /tmp/travis-utils/utils.sh
+}
+
+case "$DATABASE" in
+
+H2)
+  mvn verify -B -e -V
+  ;;
+
+POSTGRES)
+  installTravisTools
+
+  psql -c 'create database sonar;' -U postgres
+
+  runDatabaseCI "postgresql" "jdbc:postgresql://localhost/sonar" "postgres" ''
+  ;;
+
+MYSQL)
+  installTravisTools
+
+  mysql -e "CREATE DATABASE sonar CHARACTER SET UTF8;" -uroot
+  mysql -e "CREATE USER 'sonar'@'localhost' IDENTIFIED BY 'sonar';" -uroot
+  mysql -e "GRANT ALL ON sonar.* TO 'sonar'@'localhost';" -uroot
+  mysql -e "FLUSH PRIVILEGES;" -uroot
+
+  runDatabaseCI "mysql" "jdbc:mysql://localhost/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance" "sonar" 'sonar'
+  ;;
+
+*)
+  echo "Invalid DATABASE choice [$DATABASE]"
+  exit 1
+
+esac