File: setup-db

package info (click to toggle)
openqa 5.1764349525.ffb594867-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 18,264 kB
  • sloc: perl: 57,599; sql: 26,462; javascript: 8,466; xml: 2,229; sh: 1,705; makefile: 443; python: 249
file content (9 lines) | stat: -rwxr-xr-x 381 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
 
#!/bin/sh -e
[ "$1" = "-h" ] || [ "$1" = "--help" ] && echo "Create local database with user for a local openQA instance" && exit

dbuser="${1:-"geekotest"}"
dbname="${2:-"openqa"}"
# prevent "could not change directory, permission denied"
cd "$HOME"
psql -t -c '\du' | grep -q "$dbuser" || createuser -D "$dbuser"
psql -l -t | grep -q "$dbname" || createdb -O "$dbuser" "$dbname"