DatabaseCreate.lddl

/*
 * This script can be used to create the LAPPS database in PostgreSQL. Any
 * existing database is dropped before a new one is created.
 *
 * The indices and stored procedure can not be added at this time as the
 * service manager needs to be run to create all the required tables.
 */

// Connect as the PostgreSQL superuser since we need to drop
// an entire database.

if (args.username == null || args.password == null) {
   println "Please provide a username and password to use."
   return
}

postgres {
    url 'jdbc:postgresql://localhost'
    username args.username
    password args.password
}

comment 'Dropping the existing database.'
sql 'drop database if exists langrid'


// The SQL required to create the database.
def create_stmt = """
CREATE DATABASE langrid
  WITH OWNER = langrid
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;
"""

// The original create statement.
def old_create_stmt = """
CREATE DATABASE langrid
  WITH OWNER = langrid
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'C'
       LC_CTYPE = 'C'
       CONNECTION LIMIT = -1;
"""

comment 'Creating the new database.'
sql create_stmt