)]}'
{"tools/test-setup.sh":[{"author":{"_account_id":6482,"name":"Steve Martinelli","email":"s.martinelli@gmail.com","username":"stevemar"},"change_message_id":"458d5ad56720c290714709310ebea898bef24da3","unresolved":false,"context_lines":[{"line_number":32,"context_line":"    DROP DATABASE IF EXISTS openstack_citest;"},{"line_number":33,"context_line":"    CREATE DATABASE openstack_citest CHARACTER SET utf8;\""},{"line_number":34,"context_line":""},{"line_number":35,"context_line":"# Same for PostgreSQL"},{"line_number":36,"context_line":"# The root password for the PostgreSQL database; pass it in via"},{"line_number":37,"context_line":"# POSTGRES_ROOT_PW."},{"line_number":38,"context_line":"DB_ROOT_PW\u003d${POSTGRES_ROOT_PW:-insecure_slave}"},{"line_number":39,"context_line":""},{"line_number":40,"context_line":"# Setup user"},{"line_number":41,"context_line":"root_roles\u003d$(sudo -H -u postgres psql -t -c \""},{"line_number":42,"context_line":"   SELECT \u0027HERE\u0027 from pg_roles where rolname\u003d\u0027$DB_USER\u0027\")"},{"line_number":43,"context_line":"if [[ ${root_roles} \u003d\u003d *HERE ]];then"},{"line_number":44,"context_line":"    sudo -H -u postgres psql -c \"ALTER ROLE $DB_USER WITH SUPERUSER LOGIN PASSWORD \u0027$DB_PW\u0027\""},{"line_number":45,"context_line":"else"},{"line_number":46,"context_line":"    sudo -H -u postgres psql -c \"CREATE ROLE $DB_USER WITH SUPERUSER LOGIN PASSWORD \u0027$DB_PW\u0027\""},{"line_number":47,"context_line":"fi"},{"line_number":48,"context_line":""},{"line_number":49,"context_line":"# Store password for tests"},{"line_number":50,"context_line":"cat \u003c\u003c EOF \u003e $HOME/.pgpass"},{"line_number":51,"context_line":"*:*:*:$DB_USER:$DB_PW"},{"line_number":52,"context_line":"EOF"},{"line_number":53,"context_line":"chmod 0600 $HOME/.pgpass"},{"line_number":54,"context_line":""},{"line_number":55,"context_line":"# Now create our database"},{"line_number":56,"context_line":"psql -h 127.0.0.1 -U $DB_USER -d template1 -c \"DROP DATABASE IF EXISTS openstack_citest\""}],"source_content_type":"text/x-sh","patch_set":3,"id":"3a461143_972f98f5","line":53,"range":{"start_line":35,"start_character":0,"end_line":53,"end_character":24},"updated":"2017-02-02 16:32:03.000000000","message":"with the recent mailing list activity about dropping postgres we may have to remove this at a later date","commit_id":"6603d40e0b5b978fd92c8238fb98e4e2de14f330"}]}