protected void setup() {
super.setup();
// CR2114; Project.class passed as an argument
String appendString =
getAbstractSession()
.getPlatform(org.eclipse.persistence.testing.models.employee.domain.Project.class)
.getTableQualifier();
if (appendString.length() != 0) {
appendString = appendString + ".";
}
// Must drop references first to appease constraints.
Session session =
getAbstractSession()
.getSessionForClass(
org.eclipse.persistence.testing.models.employee.domain.Project.class);
session.executeNonSelectingCall(
new org.eclipse.persistence.queries.SQLCall(
"delete from "
+ appendString
+ "\u305f_\u304a\u3059\u305f where \u305f\u3064\u305d\u3053_\u3051\u3048 = "
+ ((org.eclipse.persistence.testing.models.employee.domain.Project)
getOriginalObject())
.getId()));
}
/** Drop table constraints */
public void dropTableConstraints(Session session) {
if (!SchemaManager.FAST_TABLE_CREATOR) {
if (session.getLogin().getPlatform().isOracle()) {
try {
session.executeNonSelectingCall(new SQLCall("drop table BUS CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table CAR CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table COMPANY CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table FUEL_VEH CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table NH_COMP CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table INH_MF CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(
new SQLCall("drop table KING_DEVELOPER CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(
new SQLCall("drop table KING_PERSONG CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table PARTNUMS CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
try {
session.executeNonSelectingCall(new SQLCall("drop table VEHICLE CASCADE CONSTRAINTS"));
} catch (Exception e) {
}
}
// Drop old constraints.
try {
if (session.getPlatform().supportsUniqueKeyConstraints()
&& !session.getPlatform().requiresUniqueConstraintCreationOnTableCreate()) {
session.executeNonSelectingSQL(
"Alter TABLE PROJECT_WORKER_BATCH DROP CONSTRAINT PROJECT_WORKER_BATCH_HD");
session.executeNonSelectingSQL(
"Alter TABLE PROJECT_BATCH DROP CONSTRAINT PROJECT_WORKER_BATCH_FK");
session.executeNonSelectingSQL(
"Alter TABLE ALLIGATOR DROP CONSTRAINT FK_ALLIGATOR_VICTIM_ID");
session.executeNonSelectingSQL(
"Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_FRND");
session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_REP");
session.executeNonSelectingSQL("Alter TABLE PERSON2 DROP CONSTRAINT PERSON2_PERSON2_BS");
}
} catch (Exception ignore) {
}
}
}
