okcandidate-v1 | A platform for matching candidates with voters

OKCandidate uses Postgres as its database. A couple of fixture files are available to create the initial tables and populate them with fixture data. There are two approaches to setting up the database:. You will additionally want to create a user to connect to the database. From within PGAdmin3 you can do this by right-clicking on Login Roles in the Object Browser. From the postgres console you do this with the command:CREATE USER username WITH PASSWORD 'MyPassword'Replacing username and 'MyPassword' with your choice of user name and password respectively.
Using PGAdmin3
After connecting to your local instance, right click on databases and select New Database. Give it a name like okcandidate_dev or okcandidate. Everything else can be left default. Click OK
Click on your newly created database in the Object Browser and select the SQL button in the top ribbon to open a new SQL editor window.
Open okcandidate_database_create.sql in the SQL editor and run the file with the play button. This will create your table structure.
If you want to install sample data open okcandidate_database_sampledata.sql and run it as well.
From the command line
run psql to get to the postgres console. Create the database using the first line in the okcandidate_database_create.sql file or something similar. a simple command would be:CREATE DATABASE okcandidate_dev
Exit the postgres console with \q.
Assuming your database name is okcandidate_dev you would then run following commands from the database directory: