summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndreas Jaeger <aj@suse.com>2017-02-01 19:44:36 +0100
committerAndreas Jaeger <jaegerandi@gmail.com>2017-02-02 12:13:43 +0000
commit27793e6df9ddf2ce727b05cce31a000b97897c44 (patch)
treec4a53ef88923b13acc883bcbd24b0248a27245d1
parenta1cc77e72dbad29a14313965df73eab439c705ee (diff)
Prepare for using standard python testsmitaka-eol
Add simple script to setup mysql and postgresql databases, this script can be run by users during testing and will be run by CI systems for specific setup before running unit tests. This allows to change in project-config the python-db jobs to python-jobs since python-jobs will call this script initially. Update README for this. See also http://lists.openstack.org/pipermail/openstack-dev/2016-November/107784.html Needed-By: Ic42f8d5392ab1d9b52c6c84c92dee0092bd2779a Change-Id: I253726467151622e8aa3ff40bacc0b3f9903b342 (cherry picked from commit 61933fef10a092b951aae440800531fd8b44c558)
Notes
Notes (review): Code-Review+1: Samuel de Medeiros Queiroz <samueldmq@gmail.com> Code-Review+2: Steve Martinelli <s.martinelli@gmail.com> Workflow+1: Steve Martinelli <s.martinelli@gmail.com> Verified+2: Jenkins Submitted-by: Jenkins Submitted-at: Fri, 03 Feb 2017 04:21:37 +0000 Reviewed-on: https://review.openstack.org/427865 Project: openstack/keystone Branch: refs/heads/stable/mitaka
-rw-r--r--doc/source/devref/development.environment.rst6
-rwxr-xr-xtools/test-setup.sh57
2 files changed, 63 insertions, 0 deletions
diff --git a/doc/source/devref/development.environment.rst b/doc/source/devref/development.environment.rst
index 2718966..bef2aca 100644
--- a/doc/source/devref/development.environment.rst
+++ b/doc/source/devref/development.environment.rst
@@ -173,3 +173,9 @@ You should then be able to `import keystone` using Python without issue:
173 173
174If you can import Keystone without a traceback, you should be ready to move on 174If you can import Keystone without a traceback, you should be ready to move on
175to :doc:`../developing`. 175to :doc:`../developing`.
176
177Database setup
178==============
179
180The script ``tools/test-setup.sh`` sets up databases as used by the
181unit tests.
diff --git a/tools/test-setup.sh b/tools/test-setup.sh
new file mode 100755
index 0000000..07a0785
--- /dev/null
+++ b/tools/test-setup.sh
@@ -0,0 +1,57 @@
1#!/bin/bash -xe
2
3# This script will be run by OpenStack CI before unit tests are run,
4# it sets up the test system as needed.
5# Developers should setup their test systems in a similar way.
6
7# This setup needs to be run as a user that can run sudo.
8
9# The root password for the MySQL database; pass it in via
10# MYSQL_ROOT_PW.
11DB_ROOT_PW=${MYSQL_ROOT_PW:-insecure_slave}
12
13# This user and its password are used by the tests, if you change it,
14# your tests might fail.
15DB_USER=openstack_citest
16DB_PW=openstack_citest
17
18sudo -H mysqladmin -u root password $DB_ROOT_PW
19
20# It's best practice to remove anonymous users from the database. If
21# a anonymous user exists, then it matches first for connections and
22# other connections from that host will not work.
23sudo -H mysql -u root -p$DB_ROOT_PW -h localhost -e "
24 DELETE FROM mysql.user WHERE User='';
25 FLUSH PRIVILEGES;
26 GRANT ALL PRIVILEGES ON *.*
27 TO '$DB_USER'@'%' identified by '$DB_PW' WITH GRANT OPTION;"
28
29# Now create our database.
30mysql -u $DB_USER -p$DB_PW -h 127.0.0.1 -e "
31 SET default_storage_engine=MYISAM;
32 DROP DATABASE IF EXISTS openstack_citest;
33 CREATE DATABASE openstack_citest CHARACTER SET utf8;"
34
35# Same for PostgreSQL
36# The root password for the PostgreSQL database; pass it in via
37# POSTGRES_ROOT_PW.
38DB_ROOT_PW=${POSTGRES_ROOT_PW:-insecure_slave}
39
40# Setup user
41root_roles=$(sudo -H -u postgres psql -t -c "
42 SELECT 'HERE' from pg_roles where rolname='$DB_USER'")
43if [[ ${root_roles} == *HERE ]];then
44 sudo -H -u postgres psql -c "ALTER ROLE $DB_USER WITH SUPERUSER LOGIN PASSWORD '$DB_PW'"
45else
46 sudo -H -u postgres psql -c "CREATE ROLE $DB_USER WITH SUPERUSER LOGIN PASSWORD '$DB_PW'"
47fi
48
49# Store password for tests
50cat << EOF > $HOME/.pgpass
51*:*:*:$DB_USER:$DB_PW
52EOF
53chmod 0600 $HOME/.pgpass
54
55# Now create our database
56psql -h 127.0.0.1 -U $DB_USER -d template1 -c "DROP DATABASE IF EXISTS openstack_citest"
57createdb -h 127.0.0.1 -U $DB_USER -l C -T template0 -E utf8 openstack_citest