01: /**********************************************************************************
02: * $URL: https://source.sakaiproject.org/svn/osp/tags/sakai_2-4-1/warehouse/api-impl/src/java/org/theospi/portfolio/util/db/Cascade.java $
03: * $Id: Cascade.java 9134 2006-05-08 20:28:42Z chmaurer@iupui.edu $
04: ***********************************************************************************
05: *
06: * Copyright (c) 2005, 2006 The Sakai Foundation.
07: *
08: * Licensed under the Educational Community License, Version 1.0 (the "License");
09: * you may not use this file except in compliance with the License.
10: * You may obtain a copy of the License at
11: *
12: * http://www.opensource.org/licenses/ecl1.php
13: *
14: * Unless required by applicable law or agreed to in writing, software
15: * distributed under the License is distributed on an "AS IS" BASIS,
16: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17: * See the License for the specific language governing permissions and
18: * limitations under the License.
19: *
20: **********************************************************************************/package org.theospi.portfolio.util.db;
21:
22: /**
23: * Adds cascade constraint to database specific
24: *
25: * @author <a href="felipeen@udel.edu">Luis F.C. Mendes</a> - University of Delaware
26: * @version $Revision 1.0 $
27: */
28: public class Cascade {
29:
30: private static DbLoader loader = null;
31:
32: protected static void setLoader(DbLoader dbloader) {
33: loader = dbloader;
34: }
35:
36: protected static String cascadeConstraint(String statement) {
37: if (loader.getDbName().equalsIgnoreCase("postgresql"))
38: return (statement += " CASCADE");
39: else if (loader.getDbName().equalsIgnoreCase("oracle"))
40: return (statement += " CASCADE CONSTRAINTS");
41: else
42: return statement;
43: }
44: }
|