👁 Screen-Shot-2014-10-15-at-23.34.25
Ok, so you have been using the hiber­nate prop­erty name=“hibernate.hbm2ddl.auto” value=“update” to con­tin­u­ously update your data­base schema, but now you need a com­plete DDL script?

Use this method from you Global Class onStart to export the DDL scripts.  Just give it the pack­age name (with path) of your Enti­ties as well as a file name:

public void onStart(Application app) {
 exportDatabaseSchema("models", "create_tables.sql");
 }

 public void exportDatabaseSchema(String packageName, String scriptFilename) {

 final Configuration configuration = new Configuration();
 final Reflections reflections = new Reflections(packageName);
 final Set<Class<?>> classes = reflections.getTypesAnnotatedWith(Entity.class);
 // iterate all Entity classes in the package indicated by the name
 for (final Class<?> clazz : classes) {
 configuration.addAnnotatedClass(clazz);
 }
 configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.PostgreSQL9Dialect");

 SchemaExport schema = new SchemaExport(configuration);
 schema.setOutputFile(scriptFilename);
 schema.setDelimiter(";");
 schema.execute(Target.SCRIPT, SchemaExport.Type.CREATE ); // just export the create statements in the script
 }

That is it!

Thanks to @MonCalamari for answer­ing my Ques­tion on Stack­over­flow here.