DDL scripts as of 2022

JustinBloom · May 18, 2022, 8:34am

Hello,
I want to use Axon without the Server and was wondering what’s the correct way of initialising the event store based on Postgres. I’ve found an old topic DDL scripts but cannot reply there and it’s from 2017.

If I’d leave jpa.hibernate.ddl-auto in any state other than ‘none’ in production environment my team leader would kill me.

How do I proceed?

lfgcampos · May 20, 2022, 1:57pm

Hi @JustinBloom,

The closest to what you are looking for is probably this

github.com

AxonIQ/initializr/blob/main/initializr-be/src/main/resources/configuration/axon-framework/flyway/create_axon_framework_related_tables_baseline.sql

-- this script is compatible with PostgreSQL only
-- to use in other databases please adapt the script

DROP TABLE IF EXISTS association_value_entry;
DROP TABLE IF EXISTS token_entry;
DROP TABLE IF EXISTS saga_entry;

CREATE TABLE IF NOT EXISTS association_value_entry
(
    id SERIAL,
    association_key VARCHAR(255) NOT NULL,
    association_value VARCHAR(255),
    saga_id VARCHAR(255) NOT NULL,
    saga_type VARCHAR(255),
    PRIMARY KEY (id)
    );

CREATE INDEX IF NOT EXISTS association_value_entry_saga_type_association_key_association_value_idx
    on association_value_entry (saga_type, association_key, association_value);

This file has been truncated. show original

Other than that, checking inside the AxonFramework code for entities and how they are generated is an option. Also exporting a DDL from a local/dev database is another option.

But no ‘official’ DDL out there AFAIK.

KR,