Populate DB with pruduction-like data

This article assumes that you have access to copr-fe-dev machine.

While setting your local development environment you might want to populate your database with production-like data.

First, obtain some SQL dump from copr-fe-dev (i.e. coprdb-2015-06-02.dump). This assumes that you are a Copr developer.

Then stop your httpd service because copr-frontend holds session to your database:

sudo service httpd stop

If you are using Vagrantfile provided together with Copr source code, you already have a database created and if the dump creates the whole DB, you need to drop it first. Then import the dump:

[vagrant@localhost ~]$ sudo su - postgres

-bash-4.3$ psql

postgres=# drop database coprdb;

postgres=# \q

-bash-4.3$ psql < /vagrant/coprdb-2015-06-02.dump

-bash-4.3$ exit

To keep your database schema up-to-date, use alembic:

[vagrant@localhost ~]$ sudo su - copr-fe

-bash-4.3$ alembic upgrade head

-bash-4.3$ exit

Finally start the httpd service again:

[vagrant@localhost ~]$ sudo service httpd start