DB Candy

copydb.fish

function copydb --description 'Copy a remote database locally.'
    dropdb (dbname $argv)_development
    createdb (dbname $argv)_development
    pg_dump -h (dbhost $argv) -U inside_track -d (dbname $argv) | psql -d (dbname $argv)_development -f -
end

dbhost.fish

function dbhost
    echo (echo $argv-db | sed s/-staging-db/-db-staging/).ucoachapp.com
end

dbname.fish

function dbname
    echo (echo $argv | sed s/-staging//)
end

pgr.fish

function pgr --description 'Connect to a remote PostgreSQL instance.'
    psql -h (dbhost $argv) -U inside_track -d (dbname $argv)
end