1 files changed, 65 insertions, 0 deletions
diff --git a/build/prepareTestsOracle.sh b/build/prepareTestsOracle.sh
new file mode 100755
index 00000000000..65a59036659
--- /dev/null
+++ b/build/prepareTestsOracle.sh
@@ -0,0 +1,65 @@
+#!/bin/bash
+#
+# ownCloud - prepareTestOracle.sh
+#
+# @author Morris Jobke
+# @copyright 2014 Morris Jobke hey@morrisjobke.de
+#
+
+DATABASENAME=$1
+DATABASEUSER=$2
+ADMINLOGIN=$3
+DATADIR=$4
+
+# set oracle home if it is not set
+TRAVIS_ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
+[ -z "$ORACLE_HOME" ] && ORACLE_HOME=$TRAVIS_ORACLE_HOME
+
+echo "Load Oracle environment variables so that we can run 'sqlplus'."
+ . $ORACLE_HOME/bin/oracle_env.sh
+
+echo "drop the database"
+sqlplus64 -s -l / as sysdba <<EOF
+	drop user $DATABASENAME cascade;
+EOF
+
+echo "create the database"
+sqlplus64 -s -l / as sysdba <<EOF
+	create user $DATABASENAME identified by owncloud;
+	alter user $DATABASENAME default tablespace users
+	temporary tablespace temp
+	quota unlimited on users;
+	grant create session
+	, create table
+	, create procedure
+	, create sequence
+	, create trigger
+	, create view
+	, create synonym
+	, alter session
+	to $DATABASENAME;
+	exit;
+EOF
+
+# there was a maximum cursor limit exceed
+# therefore increase the limit
+sqlplus64 -s -l / as sysdba <<EOF
+	ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH;
+EOF
+
+cat > ./config/autoconfig.php <<DELIM
+<?php
+\$AUTOCONFIG = array (
+  'installed' => false,
+  'dbtype' => 'oci',
+  'dbtableprefix' => 'oc_',
+  'adminlogin' => '$ADMINLOGIN',
+  'adminpass' => 'admin',
+  'directory' => '$DATADIR',
+  'dbuser' => '$DATABASEUSER',
+  'dbname' => 'XE',
+  'dbhost' => 'localhost',
+  'dbpass' => 'owncloud',
+);
+DELIM
+