#!/usr/bin/env ruby

require 'builder/builder.rb'

module Prick::SubCommand
  def self.setup(database, username)
    conn = PgConn.new("template1") # Connect to template1 because database might not exist
    if !conn.role.exist? username
      # FIXME Should not be created as superuser but we can't do that before we
      # have a super: option in build
      conn.role.create username, superuser: true, can_login: true, create_role: true
    end
    if !conn.rdbms.exist? database
      conn.rdbms.create database, owner: username
    end
    builder = Prick::Build::Builder.new(conn, "schema")
    # TODO Run builder setup scrips
  end
end