001    /*
002     * Copyright (c) 2009 The openGion Project.
003     *
004     * Licensed under the Apache License, Version 2.0 (the "License");
005     * you may not use this file except in compliance with the License.
006     * You may obtain a copy of the License at
007     *
008     *     http://www.apache.org/licenses/LICENSE-2.0
009     *
010     * Unless required by applicable law or agreed to in writing, software
011     * distributed under the License is distributed on an "AS IS" BASIS,
012     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,
013     * either express or implied. See the License for the specific language
014     * governing permissions and limitations under the License.
015     */
016    package org.opengion.plugin.column;
017    
018    import org.opengion.fukurou.util.StringUtil;
019    import org.opengion.hayabusa.db.AbstractDBType;
020    
021    /**
022     * DATA_DEFAULT 繧ｫ繝ｩ繝?〒縲∝?螳ｹ縺ｮ謨ｴ蜷域?繧呈紛縺医∪縺吶?
023     *
024     * DATA_DEFAULT(蛻晄悄蛟､)繧ｫ繝ｩ繝??縲√ョ繝ｼ繧ｿ繝吶?繧ｹ荳翫↓險ｭ螳壹＆繧後※縺?∪縺吶′縲?
025     * DB螳夂ｾｩ繧ｹ繧ｯ繝ｪ繝励ヨ繧??繝??繧ｿ繝吶?繧ｹ縺ｮ遞ｮ鬘槭↓繧医▲縺ｦ縲∵悽譚･蠢?ｦ√↑蠖｢蠑上〒
026     * 蜿門ｾ励〒縺阪↑縺?→縺阪′縺ゅｊ縺ｾ縺吶?
027     * 縺薙％縺ｧ縺ｯ縲∝?譛溷?縺ｮ蠕後ｍ縺ｫ 繧ｳ繝｡繝ｳ繝医′縺ゅｋ蝣ｴ蜷医?縲∝炎髯､縺励?
028     * 繝??繧ｿ縺昴?繧ゅ?縺ｫ縲√す繝ｳ繧ｰ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ縺ｯ縺壹＠縺ｾ縺吶?
029     * 螳夂ｾｩ諠??蜃ｺ蜉帶凾縺ｫ縺ｯ縲√き繝ｩ繝??螻樊?(謨ｰ蟄怜梛縲∵枚蟄怜梛)
030     * 縺ｾ縺溘?postgreSQL 蟇ｾ蠢懊→縺励※縲?:螻樊?諠??縺悟?繧九?縺ｧ縲∝炎髯､縺励∪縺吶?
031     * 繧ｷ繝ｼ繧ｱ繝ｳ繧ｹ菴ｿ逕ｨ譎ゅ↓繧ゅ?nextval 縺瑚?蜍慕噪縺ｫ繧ｻ繝?ヨ縺輔ｌ縺ｾ縺吶′縲?
032     * 蜑企勁縺励∪縺吶?
033     *
034     * 縺薙?繧ｯ繝ｩ繧ｹ縺ｯ縲」alueAction 繝｡繧ｽ繝?ラ縺ｧ縲∥ction="VALSET" 縺ｧ縺ｮ縺ｿ
035     * 蜍穂ｽ懊＠縺ｾ縺吶?
036     *
037     * @og.group 繝??繧ｿ螻樊?
038     * @og.rev 5.1.3.0 (2010/02/01) 譁ｰ隕丈ｽ懈?
039     *
040     * @version  4.0
041     * @author       Kazuhiko Hasegawa
042     * @since    JDK5.0,
043     */
044    public class DBType_DD extends AbstractDBType {
045            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
046            private static final String VERSION = "5.7.6.3 (2014/05/23)" ;
047    
048            /**
049             * action 縺ｧ謖?ｮ壹＆繧後◆繧ｳ繝槭Φ繝峨ｒ螳溯｡後＠縺ｦ縲∝?縺ｮ螟画鋤繧定｡後＞縺ｾ縺吶?
050             * oldValue(譌ｧ繝??繧ｿ)縺ｯ縲∝?縺ｮDBTableModel縺ｫ險ｭ螳壹＆繧後※縺?◆蛟､縺ｧ縺吶?騾壼ｸｸ縺ｯ縲?
051             * 縺薙?蛟､繧剃ｽｿ逕ｨ縺励※繧ｫ繝ｩ繝?ｯ弱↓螟画鋤繧定｡後＞縺ｾ縺吶?newValue(譁ｰ繝??繧ｿ)縺ｯ縲∝ｼ墓焚縺ｧ
052             * 謖?ｮ壹＆繧後◆譁ｰ縺励＞蛟､縺ｧ縺吶?縺薙?蛟､縺ｫ縺ｯ縲√ヱ繝ｩ繝｡繝ｼ繧ｿ繧呈欠螳壹＠縺ｦ螟画鋤譁ｹ豕輔ｒ
053             * 蛻ｶ蠕｡縺吶ｋ縺薙→繧ょ庄閭ｽ縺ｧ縺吶?
054             * 謖?ｮ壹?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺後き繝ｩ繝?〒蜃ｦ逅?〒縺阪↑縺??蜷医?縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
055             *
056             * @og.rev 5.1.3.0 (2010/02/01) 譁ｰ隕剰ｿｽ蜉?
057             * @og.rev 5.7.6.2 (2014/05/16) -- 繧ｳ繝｡繝ｳ繝亥ｯｾ蠢懊?蜃ｦ逅??蜈ｨ髱｢隕狗峩縺?
058             * @og.rev 5.7.6.3 (2014/05/23) 蜃ｦ逅?ｯｾ雎｡莉･螟悶?縲］ewValue 繧定ｿ斐☆縺?￠縲?
059             *
060             * @param   action 繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝?
061             * @param   oldValue 蜈･蜉帙ョ繝ｼ繧ｿ(譌ｧ繝??繧ｿ)
062             * @param   newValue 蜈･蜉帙ョ繝ｼ繧ｿ(譁ｰ繝??繧ｿ)
063             *
064             * @return      螳溯｡悟ｾ後?繝??繧ｿ
065             */
066            @Override
067            public String valueAction( final String action,final String oldValue,final String newValue ) {
068    //              if( "VALSET".equals( action ) ) {
069                    if( "VALSET".equals( action ) && oldValue != null ) {
070    //                      String val = StringUtil.rTrim( oldValue ) ;
071                            String val = oldValue.trim() ;
072    
073    //                      if( val != null && val.length() > 0 ) {
074                            if( val.length() > 0 ) {
075                                    // 蜈ｱ騾夲ｼ壼?譛溷?縺ｫ /* */ 繧ｳ繝｡繝ｳ繝医′蜈･繧九％縺ｨ縺後≠繧九?縺ｧ縲∝炎髯､
076                                    int pos = val.indexOf( "/*" );
077                                    if( pos > 0 ) { val = val.substring( 0,pos ); }
078    
079                                    // 蜈ｱ騾夲ｼ壼?譛溷?縺ｫ -- 繧ｳ繝｡繝ｳ繝医′蜈･繧九％縺ｨ縺後≠繧九?縺ｧ縲∝炎髯､
080                                    pos = val.indexOf( "--" );
081                                    if( pos > 0 ) { val = val.substring( 0,pos ); }
082    
083                                    // postgreSQL 蟇ｾ蠢懶ｼ壼ｱ樊?諠??縺悟?繧九?縺ｧ縲∝炎髯､
084                                    pos = val.indexOf( "::" );
085                                    if( pos > 0 ) { val = val.substring( 0,pos ); }
086    
087                                    // postgreSQL 蟇ｾ蠢懶ｼ壹す繝ｼ繧ｱ繝ｳ繧ｹ菴ｿ逕ｨ譎ゅ↓繧ゅ?nextval 縺瑚?蜍慕噪縺ｫ繧ｻ繝?ヨ縺輔ｌ繧九?縺ｧ縲∝炎髯､
088                                    pos = val.indexOf( "nextval" );
089                                    if( pos > 0 ) { val = val.substring( 0,pos ); }
090    
091                                    val = val.trim();                               // 荳?率縲》rim 縺励∪縺吶?
092    
093                                    // 蜈ｱ騾夲ｼ?.7.6.3 (2014/05/23) 繧ｷ繝ｳ繧ｰ繝ｫ繧ｯ繧ｪ繝ｼ繝医?縺壹＠(蜈磯?縺九?譛ｫ蟆ｾ縺ｫ莉倥＞縺ｦ縺?ｋ蝣ｴ蜷医?縲√☆縺ｹ縺ｦ縺ｮ繧ｷ繝ｳ繧ｰ繝ｫ繧ｯ繧ｪ繝ｼ繝医ｒ螟悶＠縺ｾ縺吶?)
094                                    if( val.startsWith("'") || val.endsWith("'") ) {
095                                            val = StringUtil.replace( val,"'","" );
096                                    }
097    
098    // 蜈ｱ騾夲ｼ壹す繝ｳ繧ｰ繝ｫ繧ｯ繧ｪ繝ｼ繝医?縺壹＠(蜈磯?縺ｫ莉倥＞縺ｦ縺?ｋ蝣ｴ蜷医?谺｡縺ｮ菴咲ｽｮ繧堤匱隕九＠縺ｦ縲∽ｻ･髯阪ｒ蜑企勁)
099    //                              if( val.indexOf( "'" ) == 0 ) {
100    //                                      pos = val.indexOf( "'",1 );
101    //                                      if( pos > 1 ) { val = val.substring( 1,pos ); }
102    //                              }
103                            }
104    
105                            return val ;
106                    }
107                    else {
108                            // 5.7.6.3 (2014/05/23) 蜃ｦ逅?ｯｾ雎｡莉･螟悶?縲］ewValue 繧定ｿ斐☆縺?￠縲?
109    //                      return super.valueAction( action,oldValue,newValue ) ;
110                            return newValue;
111                    }
112            }
113    }