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.1.3.0 (2010/02/01)" ;
047    
048            /**
049             * action 縺ｧ謖?ｮ壹＆繧後◆繧ｳ繝槭Φ繝峨ｒ螳溯｡後＠縺ｦ縲∝?縺ｮ螟画鋤繧定｡後＞縺ｾ縺吶?
050             * oldValue(譌ｧ繝??繧ｿ)縺ｯ縲∝?縺ｮDBTableModel縺ｫ險ｭ螳壹＆繧後※縺?◆蛟､縺ｧ縺吶?騾壼ｸｸ縺ｯ縲?
051             * 縺薙?蛟､繧剃ｽｿ逕ｨ縺励※繧ｫ繝ｩ繝?ｯ弱↓螟画鋤繧定｡後＞縺ｾ縺吶?newValue(譁ｰ繝??繧ｿ)縺ｯ縲∝ｼ墓焚縺ｧ
052             * 謖?ｮ壹＆繧後◆譁ｰ縺励＞蛟､縺ｧ縺吶?縺薙?蛟､縺ｫ縺ｯ縲√ヱ繝ｩ繝｡繝ｼ繧ｿ繧呈欠螳壹＠縺ｦ螟画鋤譁ｹ豕輔ｒ
053             * 蛻ｶ蠕｡縺吶ｋ縺薙→繧ょ庄閭ｽ縺ｧ縺吶?
054             * 謖?ｮ壹?繧｢繧ｯ繧ｷ繝ｧ繝ｳ縺後き繝ｩ繝?〒蜃ｦ逅?〒縺阪↑縺??蜷医?縲√お繝ｩ繝ｼ縺ｫ縺ｪ繧翫∪縺吶?
055             *
056             * @og.rev 5.1.3.0 (2010/02/01) 譁ｰ隕剰ｿｽ蜉?
057             *
058             * @param   action 繧｢繧ｯ繧ｷ繝ｧ繝ｳ繧ｳ繝槭Φ繝?
059             * @param   oldValue 蜈･蜉帙ョ繝ｼ繧ｿ(譌ｧ繝??繧ｿ)
060             * @param   newValue 蜈･蜉帙ョ繝ｼ繧ｿ(譁ｰ繝??繧ｿ)
061             *
062             * @return      螳溯｡悟ｾ後?繝??繧ｿ
063             */
064            @Override
065            public String valueAction( final String action,final String oldValue,final String newValue ) {
066                    if( "VALSET".equals( action ) ) {
067                            String val = StringUtil.rTrim( oldValue ) ;
068    
069                            if( val != null && val.length() > 0 ) {
070                                    // 蜈ｱ騾夲ｼ壹す繝ｳ繧ｰ繝ｫ繧ｯ繧ｪ繝ｼ繝医?縺壹＠
071                                    int pos1 = val.indexOf( "'",1 );
072                                    if( pos1 > 1 ) { val = val.substring( 1,pos1 ); }
073                                    // 蜈ｱ騾夲ｼ壼?譛溷?縺ｫ /* */ 繧ｳ繝｡繝ｳ繝医′蜈･繧九％縺ｨ縺後≠繧九?縺ｧ縲∝炎髯､
074                                    int pos2 = val.indexOf( "/*" );
075                                    if( pos2 > 0 ) { val = val.substring( 0,pos2 ); }
076    
077                                    // postgreSQL 蟇ｾ蠢懶ｼ壼ｱ樊?諠??縺悟?繧九?縺ｧ縲∝炎髯､
078                                    int pos3 = val.indexOf( "::" );
079                                    if( pos3 > 0 ) { val = val.substring( 0,pos3 ); }
080                                    // postgreSQL 蟇ｾ蠢懶ｼ壼ｱ樊?諠??縺悟?繧九?縺ｧ縲∝炎髯､
081                                    // ??oldValue 縺ｧ蛻､譁ｭ縺励※縺?ｋ縺ｮ縺ｯ縲」al 縺ｯ縲∝?縺ｫ濶ｲ縲?→蜉?ｷ･縺励※縺?ｋ轤ｺ
082                                    if( oldValue.startsWith( "nextval" ) ) { val = ""; }
083                            }
084    
085                            return val ;
086                    }
087                    else {
088                            return super.valueAction( action,oldValue,newValue ) ;
089                    }
090            }
091    }