Examples with IncrementGenerator com.manydesigns.portofino.model.database.IncrementGenerator used on opensource projects

Example 1 with IncrementGenerator

use of com.manydesigns.portofino.model.database.IncrementGenerator in project Portofino by ManyDesigns.

the class CrudActionTest method setupJPetStore.

protected void setupJPetStore() throws Exception {
    Session session = persistence.getSession("jpetstore");
    session.doWork(new Work() {

        @Override
        public void execute(Connection connection) throws SQLException {
            InputStreamReader reader = new InputStreamReader(getClass().getResourceAsStream("sql/jpetstore-postgres-schema.sql"));
            RunScript.execute(connection, reader);
            reader = new InputStreamReader(getClass().getResourceAsStream("sql/jpetstore-postgres-dataload.sql"));
            RunScript.execute(connection, reader);
        }
    });
    session.getTransaction().commit();
    persistence.syncDataModel("jpetstore");
    // Table ordersTable = DatabaseLogic.findTableByName(persistence.getModel(), "jpetstore", "PUBLIC", "ORDERS");
    // ordersTable.getPrimaryKey().getPrimaryKeyColumns().get(0).setGenerator(new TableGenerator());
    Table supplierTable = DatabaseLogic.findTableByName(persistence.getModel(), "jpetstore", "PUBLIC", "SUPPLIER");
    supplierTable.getPrimaryKey().getPrimaryKeyColumns().get(0).setGenerator(new IncrementGenerator());
// Table testTable = DatabaseLogic.findTableByName(persistence.getModel(), "jpetstore", "PUBLIC", "TEST");
// testTable.getPrimaryKey().getPrimaryKeyColumns().get(0).setGenerator(new SequenceGenerator());
}