3 DATABASENAME=${MYSQL_DATABASE:-test}
4 DATABASEUSER=${MYSQL_USERNAME:-friendica}
5 DATABASEHOST=${MYSQL_HOST:-localhost}
8 DBCONFIGS="mysql mariadb"
10 export MYSQL_DATABASE="$DATABASENAME"
11 export MYSQL_USERNAME="$DATABASEUSER"
12 export MYSQL_PASSWORD="friendica"
14 if [ -z "$PHP_EXE" ]; then
17 PHP=$(which "$PHP_EXE")
18 # Use the Friendica internal composer
19 COMPOSER="$BASEDIR/bin/composer.phar"
23 _XDEBUG_CONFIG=$XDEBUG_CONFIG
26 if [ -x "$PHP" ]; then
27 echo "Using PHP executable $PHP"
29 echo "Could not find PHP executable $PHP_EXE" >&2
33 echo "Installing depdendencies"
34 $PHP "$COMPOSER" install
36 PHPUNIT="$BASEDIR/vendor/bin/phpunit"
38 if [ -x "$PHPUNIT" ]; then
39 echo "Using PHPUnit executable $PHPUNIT"
41 echo "Could not find PHPUnit executable after composer $PHPUNIT" >&2
45 if ! [ \( -w config -a ! -f config/local.config.php \) -o \( -f config/local.config.php -a -w config/local.config.php \) ]; then
46 echo "Please enable write permissions on config and config/config.php" >&2
52 for DBCONFIG in $DBCONFIGS; do
53 if [ "$1" = "$DBCONFIG" ]; then
58 if [ $FOUND = 0 ]; then
59 echo -e "Unknown database config name \"$1\"\n" >&2
64 # Back up existing (dev) config if one exists and backup not already there
65 if [ -f config/local.config.php ] && [ ! -f config/local.config-autotest-backup.php ]; then
66 mv config/local.config.php config/local.config-autotest-backup.php
69 function cleanup_config {
71 if [ -n "$DOCKER_CONTAINER_ID" ]; then
72 echo "Kill the docker $DOCKER_CONTAINER_ID"
73 docker stop "$DOCKER_CONTAINER_ID"
74 docker rm -f "$DOCKER_CONTAINER_ID"
79 # Restore existing config
80 if [ -f config/local.config-autotest-backup.php ]; then
81 mv config/local.config-autotest-backup.php config/local.config.php
85 # restore config on exit
86 trap cleanup_config EXIT
88 function execute_tests {
90 echo "Setup environment for $DB testing ..."
94 # backup current config
95 if [ -f config/local.config.php ]; then
96 mv config/local.config.php config/local.config-autotest-backup.php
99 if [ -z "$NOINSTALL" ]; then
101 if [ "$DB" == "mysql" ]; then
102 if [ -n "$USEDOCKER" ]; then
103 echo "Fire up the mysql docker"
104 DOCKER_CONTAINER_ID=$(docker run \
105 -e MYSQL_ROOT_PASSWORD=friendica \
106 -e MYSQL_USER="$DATABASEUSER" \
107 -e MYSQL_PASSWORD=friendica \
108 -e MYSQL_DATABASE="$DATABASENAME" \
110 DATABASEHOST=$(docker inspect --format="{{.NetworkSettings.IPAddress}}" "$DOCKER_CONTAINER_ID")
113 if [ -z "$DRONE" ]; then # no need to drop the DB when we are on CI
114 if [ "mysql" != "$(mysql --version | grep -o mysql)" ]; then
115 echo "Your mysql binary is not provided by mysql"
116 echo "To use the docker container set the USEDOCKER environment variable"
119 mysql -u "$DATABASEUSER" -pfriendica -e "DROP DATABASE IF EXISTS $DATABASENAME" -h $DATABASEHOST || true
120 mysql -u "$DATABASEUSER" -pfriendica -e "CREATE DATABASE $DATABASENAME DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci" -h $DATABASEHOST
126 echo "Waiting for MySQL $DATABASEHOST initialization..."
127 if ! bin/wait-for-connection $DATABASEHOST 3306 300; then
128 echo "[ERROR] Waited 300 seconds, no response" >&2
134 if [ "$DB" == "mariadb" ]; then
135 if [ -n "$USEDOCKER" ]; then
136 echo "Fire up the mariadb docker"
137 DOCKER_CONTAINER_ID=$(docker run \
138 -e MYSQL_ROOT_PASSWORD=friendica \
139 -e MYSQL_USER="$DATABASEUSER" \
140 -e MYSQL_PASSWORD=friendica \
141 -e MYSQL_DATABASE="$DATABASENAME" \
143 DATABASEHOST=$(docker inspect --format="{{.NetworkSettings.IPAddress}}" "$DOCKER_CONTAINER_ID")
146 if [ -z "$DRONE" ]; then # no need to drop the DB when we are on CI
147 if [ "MariaDB" != "$(mysql --version | grep -o MariaDB)" ]; then
148 echo "Your mysql binary is not provided by mysql"
149 echo "To use the docker container set the USEDOCKER environment variable"
152 mysql -u "$DATABASEUSER" -pfriendica -e "DROP DATABASE IF EXISTS $DATABASENAME" -h $DATABASEHOST || true
153 mysql -u "$DATABASEUSER" -pfriendica -e "CREATE DATABASE $DATABASENAME DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci" -h $DATABASEHOST
159 echo "Waiting for MariaDB $DATABASEHOST initialization..."
160 if ! bin/wait-for-connection $DATABASEHOST 3306 300; then
161 echo "[ERROR] Waited 300 seconds, no response" >&2
165 echo "MariaDB is up."
168 if [ -n "$USEDOCKER" ]; then
169 echo "Initialize database..."
170 docker exec $DOCKER_CONTAINER_ID mysql -u root -pfriendica -e 'CREATE DATABASE IF NOT EXISTS $DATABASENAME;'
173 export MYSQL_HOST="$DATABASEHOST"
176 echo "Installing Friendica..."
177 "$PHP" ./bin/console.php autoinstall --dbuser="$DATABASEUSER" --dbpass=friendica --dbdata="$DATABASENAME" --dbhost="$DATABASEHOST" --url=https://friendica.local --admin=admin@friendica.local
182 rm -fr "coverage-html"
183 mkdir "coverage-html"
184 if [[ "$_XDEBUG_CONFIG" ]]; then
185 export XDEBUG_CONFIG=$_XDEBUG_CONFIG
189 if [ -z "$NOCOVERAGE" ]; then
190 COVER="--coverage-clover tests/autotest-clover.xml --coverage-html tests/coverage-html"
195 # per default, there is no cache installed
196 GROUP='--exclude-group REDIS,MEMCACHE,MEMCACHED,APCU'
197 if [ "$TEST_SELECTION" == "REDIS" ]; then
198 GROUP="--group REDIS"
200 if [ "$TEST_SELECTION" == "MEMCACHE" ]; then
201 GROUP="--group MEMCACHE"
203 if [ "$TEST_SELECTION" == "MEMCACHED" ]; then
204 GROUP="--group MEMCACHED"
206 if [ "$TEST_SELECTION" == "APCU" ]; then
209 if [ "$TEST_SELECTION" == "NODB" ]; then
210 GROUP="--exclude-group DB,SLOWDB"
213 INPUT="$BASEDIR/tests"
218 echo "${PHPUNIT[@]}" --configuration tests/phpunit.xml $GROUP $COVER --log-junit "autotest-results.xml" "$INPUT" "$3"
219 "${PHPUNIT[@]}" --configuration tests/phpunit.xml $GROUP $COVER --log-junit "autotest-results.xml" "$INPUT" "$3"
222 if [ -n "$DOCKER_CONTAINER_ID" ]; then
223 echo "Kill the docker $DOCKER_CONTAINER_ID"
224 docker stop $DOCKER_CONTAINER_ID
225 docker rm -f $DOCKER_CONTAINER_ID
226 unset $DOCKER_CONTAINER_ID
231 # Start the test execution
233 if [ -z "$1" ] && [ -n "$TEST_SELECTION" ]; then
234 # run all known database configs
235 for DBCONFIG in $DBCONFIGS; do
236 execute_tests "$DBCONFIG"
240 if [ -n "$2" ] && [ ! -f "tests/$FILENAME" ] && [ "${FILENAME:0:2}" != "--" ]; then
241 FILENAME="../$FILENAME"
243 execute_tests "$1" "$FILENAME" "$3"