org.apache.james.mailbox.jpa.migrator.command

Class IMAP180JpaMigrateCommand

java.lang.Object

org.apache.james.mailbox.jpa.migrator.command.IMAP180JpaMigrateCommand

All Implemented Interfaces:

JpaMigrateCommand

public class IMAP180JpaMigrateCommand
extends Object
implements JpaMigrateCommand

JIRA IMAP-180 is "Add @ElementJoinColumn for Property and Header tables". 1. Add the needed columns on HEADER and PROPERTY ALTER TABLE HEADER ADD COLUMN MESSAGE_ID BIGINT ALTER TABLE PROPERTY ADD COLUMN MESSAGE_ID BIGINT 2. Link the HEADER/PROPERTY tables with the MESSAGE table SELECT * FROM MESSAGE_HEADER / MESSAGE_HEADER 3. Add the needed FK and indexes on HEADER and PROPERTY CREATE INDEX SQL100727182411700 ON HEADER(MESSAGE_ID) ALTER TABLE HEADER ADD CONSTRAINT SQL100727182411700 FOREIGN KEY (MESSAGE_ID) REFERENCES MESSAGE(ID) CREATE INDEX SQL100727182411780 ON PROPERTY(MESSAGE_ID) ALTER TABLE PROPERTY ADD CONSTRAINT SQL100727182411780 FOREIGN KEY (MESSAGE_ID) REFERENCES MESSAGE(ID) 4. Drop the MESSAGE_HEADER and MESSAGE_PROPERY tables DROP TABLE MESSAGE_HEADER DROP TABLE MESSAGE_PROPERTY

Constructor Summary

Constructors

Constructor and Description
IMAP180JpaMigrateCommand()

Method Summary

Methods

Modifier and Type	Method and Description
void	migrate(javax.persistence.EntityManager em) Executes the needed SQL commands on the database via the provided JPA entity manager.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

IMAP180JpaMigrateCommand

public IMAP180JpaMigrateCommand()

Method Detail

migrate

public void migrate(javax.persistence.EntityManager em)
             throws JpaMigrateException

Description copied from interface: JpaMigrateCommand

Executes the needed SQL commands on the database via the provided JPA entity manager. A transaction on the provided entity manager must be begun by the caller. It is also the reponsibility of the caller to commit the opened transaction after calling the migrate method.

Specified by:

migrate in interface JpaMigrateCommand

Parameters:

em - the provided Entity Manager

Throws:

JpaMigrateException

See Also:

org.apache.james.mailbox.jpa.migrator.command