Schema DDL Generator with PlayFramework

gistfile1.txt

 /**
   * Populate test database with sample data.
   * 
   * @throws IOException
   */
  public static void setUpDb() throws IOException {
    server = Ebean.getServer("default");
    ServerConfig config = new ServerConfig();
    config.setDdlGenerate(true);
    config.setDdlRun(true);

   
    
    H2Platform plata = new H2Platform();
    plata.getDbDdlSyntax().setMaxConstraintNameLength(10);
    
    ddl = new DdlGenerator();
    ddl.setup((SpiEbeanServer) server, plata, config);
    
    File beforeRun = Play.current().getFile("test/ddl/HSQL_BEFORE_TEST.sql");
    String sqlBefore = StringUtils.trim(FileUtils.readFileToString(beforeRun, "UTF-8"));
    Ebean.execute(Ebean.createCallableSql(sqlBefore));
   
    // create
    Logger.debug("generating create ddl");
    String createScript = ddl.generateCreateDdl();
    System.out.println( createScript);
    Ebean.execute(Ebean.createCallableSql(createScript));
    

    // Load and execute script file in test/ddl/HSQL_INSERT.sql
    File insertScript = Play.current().getFile("test/ddl/HSQL_INSERT.sql");
    String sql = StringUtils.trim(FileUtils.readFileToString(insertScript, "UTF-8"));

    // Execute insert instructions
    Ebean.execute(Ebean.createSqlUpdate(sql));
  }