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