PR#1350: Allow to run tests with PostgreSQL inside Vagrant machine - fm-orchestrator

fm-orchestrator

#1350 Allow to run tests with PostgreSQL inside Vagrant machine

Merged 4 years ago by cqi. Opened 4 years ago by cqi.

cqi/fm-orchestrator run-tests-with-pgsql-inside-vagrant into master

Allow to run tests with PostgreSQL inside Vagrant machine

Chenxiong Qi • 4 years ago

68fe2b6

Vagrantfile

file modified

+41

		`@@ -80,6 +80,46 @@`
		`fi`
		`DEVENV`

		`+ $config_pgsql = <<PGSQL`
		`+ dnf install -y postgresql postgresql-server python2-psycopg2`
		`+`
		`+ pg_hba_conf=/var/lib/pgsql/data/pg_hba.conf`
		`+`
		`+ if [[ ! -e "$pg_hba_conf" ]]; then`
		`+ postgresql-setup --initdb`
		`+ fi`
		`+`
		`+ systemctl start postgresql`
		`+ systemctl enable postgresql`
		`+`
		`+ cp "$pg_hba_conf" "${pg_hba_conf}.orig"`
		`+`
		`+ # Allow to connect to PostgreSQL without password`
		`+ if ! grep "host all all 127.0.0.1/32 trust" "$pg_hba_conf" >/dev/null; then`
		`+ echo "host all all 127.0.0.1/32 trust" > "$pg_hba_conf"`
		`+ fi`
		`+`
		`+ # Avoid SQL query statement being truncated in pg_stat_activity, which is`
		`+ # convenient for debugging.`
		`+ pg_conf=/var/lib/pgsql/data/postgresql.conf`
		`+ if ! grep "track_activity_query_size = 4096" "$pg_conf" >/dev/null; then`
		`+ echo "track_activity_query_size = 4096" >> "$pg_conf"`
		`+ fi`
		`+`
		`+ # Restart to apply configuration changes`
		`+ systemctl restart postgresql`
		`+`
		`+ psql -U postgres -h 127.0.0.1 -c "DROP DATABASE IF EXISTS mbstest"`
		`+ psql -U postgres -h 127.0.0.1 -c "CREATE DATABASE mbstest"`
		`+`
		`+ bashrc=/home/vagrant/.bashrc`
		`+`
		`+ echo "****** Run Tests with PostgreSQL ******"`
		`+ echo "Set this environment variable to test with PostgreSQL"`
		`+ echo "export DATABASE_URI=postgresql+psycopg2://postgres:@127.0.0.1/mbstest"`
		`+ echo`
		`+ PGSQL`
		`+`
		`$script_services = <<SCRIPT_SERVICES`
		`bin_dir=~/devenv/bin`
		`cd /opt/module_build_service`
		`@@ -98,6 +138,7 @@`
		`config.vm.network "forwarded_port", guest_ip: "0.0.0.0", guest: 13747, host: 13747`
		`config.vm.provision "shell", inline: $script`
		`config.vm.provision "shell", inline: "usermod -a -G mock vagrant"`
		`+ config.vm.provision "shell", inline: $config_pgsql`
		`config.vm.provision "shell", inline: $make_devenv, privileged: false`
		`config.vm.provision "shell", inline: $script_services, privileged: false, run: "always"`
		`config.vm.provider "libvirt" do \|v, override\|`

docs/CONTRIBUTING.rst

file modified

+15

		`@@ -1,6 +1,9 @@`
		`Running Tests`
		`=============`

		`+ Inside Container`
		`+ ----------------`
		`+`
		`Since MBS requires Python dependencies that aren't available using PyPi (e.g.`
		`libsolv bindings), there are container images (based on CentOS and Fedora) that`
		`can be used to run the code analysis and unit tests.`
		`@@ -38,6 +41,18 @@`
		`/src/tests/test_mmd_resolver.py \`
		`/src/tests/test_builder/test_koji.py::TestKojiBuilder::test_tag_to_repo`

		`+ Inside Vagrant machine`
		`+ ----------------------`
		`+`
		`+ You can run tests with either SQLite or PostgreSQL as well. The former is default.`
		`+`
		+ To start to run tests with SQLite, you could simply run ``py.test`` or ``tox``.
		`+`
		`+ To start to run tests with PostgreSQL, set environment variable`
		+ ``DATABASE_URI`` before running ``py.test`` or ``tox``::
		`+`
		`+ export DATABASE_URI=postgresql+psycopg2://postgres:@127.0.0.1/mbstest`
		`+`
		`Style Guide`
		`===========`