Repository files navigation

This module allows you to export yourJPA classes to anSQL script or to import a database tables toPOJO instances.

In the/conf/application.conf file, enable the DB module by adding this line:

# The db  modulemodule.db=${play.path}/modules/db

You can also define a default schema (as inhibernate.default_schema) with :

# Default Schemadb.default.schema=MY_SCHEMA

play db:export myapplication

This command will create theSQL necessary to create your database. This is extremely usefull if you want to deploy your application in production and you are require to update the database manually.
Be sure to configure correctly yourJPA dialect in your/conf/application.conf file.

Generate only theSQL drop clauses

play db:export myapplication --drop

Generate only theSQL create clauses

play db:export myapplication --create

Specify theSQL delimiter

play db:export myapplication --delimiter=;

Specify the output file

play db:export myapplication  --output=myfile.ddl

Export to the database

play db:export myapplication  --export

Import extra data to the database (to be use with —export)

play db:export myapplication  --import=import.sql

Do not format theSQL.

play db:export myapplication  --noformat

Halt the export / script generation on the first error

play db:export myapplication  --haltonerror

play db:import myapplication

This command will create the classes in the models package based on the database tables. This is useful is you have an existing database and you want to re-use this database.

Be sure to configure correctly your database access using your/conf/application.conf file (db.user,db.pass,db.driver,db.url, etc…).

EnablesCRUD Controller generation (with the secure-module annotation).

play db:import myapplication --crud

DisablesPOJO generation. Useful if you want to keep the already generated files.

play db:import myapplication --no-pojo

Enables reverse engineering customization.
SeeHibernate Tools documentation
WARNING: the<table> elements in the reverse engineering file seems to be ignored forPOJO andCRUD generation.
<schema-selection>,<type-mapping> and<table-filter> work correctly, though.

play db:import myapplication --reveng=path.to/hibernate.reveng.xml