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.hayabusa.taglib;
017    
018    import static org.opengion.fukurou.util.StringUtil.nval;
019    
020    import java.io.File;
021    import java.io.PrintWriter;
022    import java.sql.Connection;
023    import java.sql.SQLException;
024    
025    import org.opengion.fukurou.db.ConnectionFactory;
026    import org.opengion.fukurou.util.StringUtil;
027    import org.opengion.hayabusa.common.HybsSystem;
028    import org.opengion.hayabusa.common.HybsSystemException;
029    import org.opengion.hayabusa.common.SystemInstaller;
030    
031    /**
032     * 繧ｷ繧ｹ繝?Β縺ｮ繧､繝ｳ繧ｹ繝医?繝ｫ繧定｡後≧縺溘ａ縺ｮ繧ｿ繧ｰ縺ｧ縺吶?
033     *
034     * 繧ｷ繧ｹ繝?Β繧､繝ｳ繧ｹ繝医?繝ｫ逕ｨ縺ｮ繧｢繝ｼ繧ｫ繧､繝?ZIP)蠖｢蠑上ｒ謖?ｮ壹☆繧九％縺ｨ縺ｧ縲∽ｻ･荳九?險ｭ螳壹ｒ閾ｪ蜍輔〒陦後＞縺ｾ縺吶?
035     * 竭?ebapps莉･荳九∈縺ｮ繧ｳ繝ｳ繝?く繧ｹ繝医ヵ繧｡繧､繝ｫ縺ｮ螻暮幕T
036     * 竭｡Tomcat縺ｮ繧ｳ繝ｳ繝?く繧ｹ繝郁ｨｭ螳?
037     * 竭｢蜷?ｨｮDB迺ｰ蠅??繧､繝ｳ繧ｹ繝医?繝ｫ
038     *
039     * 5.6.7.0 (2013/07/27) 
040     * 窶ｻ 繧､繝ｳ繧ｹ繝医?繝ｫ縺吶ｋ繝??繧ｿ繝吶?繧ｹ縺ｯ縲‥bid 繝代Λ繝｡繝ｼ繧ｿ縺ｧ謖?ｮ壹〒縺阪∪縺吶′縲√Μ繧ｽ繝ｼ繧ｹ繧堤匳骭ｲ縺吶ｋ繝??繧ｿ繝吶?繧ｹ縺ｯ
041     * 螳溯｡後＠縺ｦ縺?ｋ 繧ｳ繝ｳ繝?く繧ｹ繝医? RESOURCE_DBID 縺ｧ縲∝､夜Κ縺九ｉ謖?ｮ壹〒縺阪∪縺帙ｓ縲ゅ＃豕ｨ諢上￥縺?＆縺??
042     *
043     * 縺薙?繧｢繝ｼ繧ｫ繧､繝悶?縲√Ν繝ｼ繝医ョ繧｣繝ｬ繧ｯ繝医Μ縺ｫ繧ｳ繝ｳ繝?く繧ｹ繝医ヱ繧ｹ縺ｮ繝峨く繝･繝｡繝ｳ繝医?繝ｼ繧ｹ縺碁?鄂ｮ縺輔ｌ縺ｦ縺?ｋ蠢?ｦ√′縺ゅｊ縺ｾ縺吶?
044     *
045     * [繧｢繝ｼ繧ｫ繧､繝悶?讒区?]
046     * xx.zip - gf - db - ...               (DB迺ｰ蠅?う繝ｳ繧ｹ繝医?繝ｫ逕ｨ縺ｮ繧ｹ繧ｯ繝ｪ繝励ヨ)
047     *             - filetemp - ...         (荳?凾繝輔ぃ繧､繝ｫ縺ｮ菫晏ｭ伜?謇?窶ｻ荳ｭ霄ｫ縺ｯ遨ｺ)
048     *             - jsp - ...              (逕ｻ髱｢JSP)
049     *             - log - ...              (繝ｭ繧ｰ繝輔ぃ繧､繝ｫ縺ｮ菫晏ｭ伜?謇?窶ｻ荳ｭ霄ｫ縺ｯ遨ｺ)
050     *             - WEB-INF -  ...         (謗･邯壼?諠??縲｛penGion縺ｮjar繝輔ぃ繧､繝ｫ)
051     *                       - [CONTEXT].xml(繧ｳ繝ｳ繝?く繧ｹ繝郁ｨｭ螳壹ヵ繧｡繧､繝ｫ)
052     *縲?
053     * 窶ｻWEB-INF逶ｴ荳九?[CONTEXT].xml縺ｯ縲ゝomcat縺ｮconf繝?ぅ繝ｬ繧ｯ繝医Μ莉･荳九↓縲√さ繝ｳ繝?く繧ｹ繝郁ｨｭ螳壹ヵ繧｡繧､繝ｫ縺ｨ縺励※縲√さ繝斐?縺輔ｌ縺ｾ縺吶?
054     *   縺ｪ縺翫?縺薙?[CONTEXT].xml縺後い繝ｼ繧ｫ繧､繝悶↓蜷ｫ縺ｾ繧後※縺?↑縺??蜷医?繧､繝ｳ繧ｹ繝医?繝ｫ縺ｯ陦後ｏ繧後∪縺帙ｓ縲?
055     *
056     * @og.formSample
057     * 笳丞ｽ｢蠑擾ｼ?lt;og:sysInstall fileURL="窶ｦ" insFile="窶ｦ" /&gt;
058     * 笳獣ody?壹↑縺?
059     *
060     * 笳週ag螳夂ｾｩ??
061     *   &lt;og:sysInstall
062     *       insFile          笳九?TAG縲代う繝ｳ繧ｹ繝医?繝ｫ繝輔ぃ繧､繝ｫ繧呈欠螳壹＠縺ｾ縺?蠢??)縲?
063     *       fileURL            縲慎AG縲第桃菴懊☆繧九ヵ繧｡繧､繝ｫ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ繧呈欠螳壹＠縺ｾ縺?(蛻晄悄蛟､:FILE_URL[=filetemp/])
064     *       dbid               縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繧､繝ｳ繧ｹ繝医?繝ｫ繧定｡後≧DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
065     *       debug              縲慎AG縲代ョ繝舌ャ繧ｰ諠??繧貞?蜉帙☆繧九°縺ｩ縺?°[true/false]繧呈欠螳壹＠縺ｾ縺?蛻晄悄蛟､:false)
066     *   /&gt;
067     *
068     * 笳丈ｽｿ逕ｨ萓?
069     *    繝ｻCalc(ods)繝輔ぃ繧､繝ｫ繧単DF縺ｫ螟画鋤
070     *        &lt;og:sysInstall insFile="context.zip" /&gt;
071     *
072     * @og.group 縺昴?莉夜Κ蜩?
073     *
074     * @version  4.0
075     * @author       Hiroki Nakamura
076     * @since    JDK5.0,
077     */
078    public class SysInstallTag extends CommonTagSupport {
079            //* 縺薙?繝励Ο繧ｰ繝ｩ繝??VERSION譁?ｭ怜?繧定ｨｭ螳壹＠縺ｾ縺吶?       {@value} */
080            private static final String VERSION = "5.6.7.0 (2013/07/27)";
081    
082            private static final long serialVersionUID = 567020130727L ;
083    
084            private String  insFile         = null;
085            private String  fileURL         = HybsSystem.sys( "FILE_URL" );
086            private String  dbid            = null;                         // 5.5.4.5 (2012/07/27) 譁ｰ隕剰ｿｽ蜉?
087    
088            private final String RESOURCE_DBID = HybsSystem.sys( "RESOURCE_DBID" );         // 5.6.7.0 (2013/07/27) 繝ｪ繧ｽ繝ｼ繧ｹ邉ｻDBID
089    
090            /**
091             * Taglib縺ｮ髢句ｧ九ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doStartTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
092             *
093             * @return      蠕檎ｶ壼?逅??謖?､ｺ( SKIP_BODY )
094             */
095            @Override
096            public int doStartTag() {
097                    return ( SKIP_BODY );
098            }
099    
100            /**
101             * Taglib縺ｮ邨ゆｺ?ち繧ｰ縺瑚ｦ九▽縺九▲縺溘→縺阪↓蜃ｦ逅?☆繧?doEndTag() 繧?繧ｪ繝ｼ繝舌?繝ｩ繧､繝峨＠縺ｾ縺吶?
102             *
103             * @og.rev 5.5.4.5 (2012/07/27) dbid 譁ｰ隕剰ｿｽ蜉?
104             * @og.rev 5.6.7.0 (2013/07/27) 繝ｪ繧ｽ繝ｼ繧ｹ逋ｻ骭ｲ逕ｨ縺ｨ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ逋ｻ骭ｲ逕ｨ縺ｮ繧ｳ繝阪け繧ｷ繝ｧ繝ｳ繧貞?縺代ｋ
105             *
106             * @return      蠕檎ｶ壼?逅??謖?､ｺ
107             */
108            @Override
109            public int doEndTag() {
110                    debugPrint();
111    
112                    String directory = HybsSystem.url2dir( fileURL );
113                    File buildFile = new File( StringUtil.urlAppend( directory,insFile ) );
114    
115    //              Connection conn = ConnectionFactory.connection( null, null );
116    //              Connection conn = ConnectionFactory.connection( dbid, getApplicationInfo() );   // 5.5.4.5 (2012/07/27)
117    //              PrintWriter out = new PrintWriter( pageContext.getOut() );
118    //              SystemInstaller installer = new SystemInstaller( conn, out );
119    
120    //              try {
121    //                      installer.install( buildFile );
122    //              }
123    ////            catch( SQLException ex ) {
124    //              catch( Throwable ex ) {
125    //                      String msg = "繧､繝ｳ繧ｹ繝医?繝ｫ荳ｭ縺ｫ縲．B蜃ｦ逅?〒繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺ｾ縺励◆縲?;
126    //                      throw new HybsSystemException( msg, ex );
127    //              }
128    
129                    // 5.6.7.0 (2013/07/27) 繝ｪ繧ｽ繝ｼ繧ｹ逋ｻ骭ｲ逕ｨ縺ｨ繧｢繝励Μ繧ｱ繝ｼ繧ｷ繝ｧ繝ｳ逋ｻ骭ｲ逕ｨ縺ｮ繧ｳ繝阪け繧ｷ繝ｧ繝ｳ繧貞?縺代ｋ
130                    // 繧ｨ繝ｩ繝ｼ蜃ｦ逅?ｂ蜷医ｏ縺帙※縲∽ｿｮ豁｣縺励※縺翫″縺ｾ縺吶?
131                    Connection defConn = null;
132                    Connection rscConn = null;
133                    boolean errFlag = true;
134                    try {
135                            defConn = ConnectionFactory.connection( dbid, getApplicationInfo() );
136                            rscConn = ConnectionFactory.connection( RESOURCE_DBID, getApplicationInfo() );
137                            PrintWriter out = new PrintWriter( pageContext.getOut() );
138                            SystemInstaller installer = new SystemInstaller( defConn , rscConn , out );             // 5.6.7.0 (2013/07/27)
139                            installer.install( buildFile );
140                            errFlag = false;                // 繧ｨ繝ｩ繝ｼ縺ｧ縺ｯ縺ｪ縺?
141                    }
142                    catch( Throwable ex ) {
143                            String errMsg = "繧､繝ｳ繧ｹ繝医?繝ｫ荳ｭ縺ｫ縲．B蜃ｦ逅?〒繧ｨ繝ｩ繝ｼ縺檎匱逕溘＠縺ｾ縺励◆縲?
144                                                    + ex.getMessage()  + HybsSystem.CR ;
145                            throw new HybsSystemException( errMsg, ex );
146                    }
147                    finally {
148                            // 莉･荳九?繧ｳ繝ｼ繝?ぅ繝ｳ繧ｰ縺ｮ隕狗峩縺励ｒ閠?∴繧句ｿ?ｦ∵怏繧翫?
149                            // Connection 縺ｯ繝励?繝ｫ縺励※縺?ｋ轤ｺ縲…lose() 縺励※繧ょ?蛻ｩ逕ｨ縺輔ｌ繧九□縺代?
150                            if( errFlag ) {
151                                    ConnectionFactory.remove( defConn,dbid );                       // 蜑企勁
152                                    ConnectionFactory.remove( rscConn,RESOURCE_DBID );
153                            }
154                            else {
155                                    ConnectionFactory.close( defConn,dbid );                        // 霑泌唆
156                                    ConnectionFactory.close( rscConn,RESOURCE_DBID );
157                            }
158                    }
159    
160                    return( EVAL_PAGE );
161            }
162    
163            /**
164             * 繧ｿ繧ｰ繝ｪ繝悶が繝悶ず繧ｧ繧ｯ繝医ｒ繝ｪ繝ｪ繝ｼ繧ｹ縺励∪縺吶?
165             * 繧ｭ繝｣繝?す繝･縺輔ｌ縺ｦ蜀榊茜逕ｨ縺輔ｌ繧九?縺ｧ縲√ヵ繧｣繝ｼ繝ｫ繝峨?蛻晄悄險ｭ螳壹ｒ陦後＞縺ｾ縺吶?
166             *
167             * @og.rev 5.5.4.5 (2012/07/27) dbid 譁ｰ隕剰ｿｽ蜉?
168             */
169            @Override
170            protected void release2() {
171                    super.release2();
172                    insFile         = null;
173                    fileURL         = HybsSystem.sys( "FILE_URL" );
174                    dbid            = null;                         // 5.5.4.5 (2012/07/27) 譁ｰ隕剰ｿｽ蜉?
175            }
176    
177            /**
178             * 縲慎AG縲第桃菴懊☆繧九ヵ繧｡繧､繝ｫ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ繧呈欠螳壹＠縺ｾ縺?
179             *              (蛻晄悄蛟､:FILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
180             *
181             * @og.tag
182             * 縺薙?螻樊?縺ｧ謖?ｮ壹＆繧後ｋ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｮ繝輔ぃ繧､繝ｫ繧呈桃菴懊＠縺ｾ縺吶?
183             * 謖?ｮ壽婿豕輔?縲??蟶ｸ縺ｮ fileURL 螻樊?縺ｨ蜷梧ｧ倥↓縲∝?鬆ｭ縺後?'/' (UNIX) 縺ｾ縺溘?縲?ｼ呈枚蟄礼岼縺後?
184             * ":" (Windows)縺ｮ蝣ｴ蜷医?縲∵欠螳壹?URL縺昴?縺ｾ縺ｾ縺ｮ繝?ぅ繝ｬ繧ｯ繝医Μ縺ｫ縲√◎縺?〒縺ｪ縺??蜷医?縲?
185             * (蛻晄悄蛟､:繧ｷ繧ｹ繝?Β螳壽焚縺ｮFILE_URL[={@og.value org.opengion.hayabusa.common.SystemData#FILE_URL}])縲?
186             *
187             * @param       url 繝輔ぃ繧､繝ｫURL
188             * @see         org.opengion.hayabusa.common.SystemData#FILE_URL
189             */
190            public void setFileURL( final String url ) {
191                    String furl = nval( getRequestParameter( url ),null );
192                    if( furl != null ) {
193                            char ch = furl.charAt( furl.length()-1 );
194                            if( ch != '/' && ch != '\\' ) { furl = furl + "/"; }
195                            fileURL = StringUtil.urlAppend( fileURL,furl );
196                    }
197            }
198    
199            /**
200             * 縲慎AG縲代う繝ｳ繧ｹ繝医?繝ｫ繝輔ぃ繧､繝ｫ繧呈欠螳壹＠縺ｾ縺吶?
201             *
202             * @og.tag
203             * 繧､繝ｳ繧ｹ繝医?繝ｫ繝輔ぃ繧､繝ｫ繧呈欠螳壹＠縺ｾ縺吶?
204             * 蜷?さ繝ｳ繝?く繧ｹ繝医?繧､繝ｳ繧ｹ繝医?繝ｫ逕ｨ繧｢繝ｼ繧ｫ繧､繝悶ｒ謖?ｮ壹☆繧句ｿ?ｦ√′縺ゅｊ縺ｾ縺吶?
205             *
206             * @param       fname 蜃ｺ蜉帙ヵ繧｡繧､繝ｫ蜷?
207             */
208            public void setInsFile( final String fname ) {
209                    insFile = nval( getRequestParameter( fname ),insFile );
210            }
211    
212            /**
213             * 縲慎AG縲?騾壼ｸｸ縺ｯ菴ｿ縺?∪縺帙ｓ)繧､繝ｳ繧ｹ繝医?繝ｫ繧定｡後≧DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
214             *
215             * @og.tag Query繧ｪ繝悶ず繧ｧ繧ｯ繝医ｒ菴懈?縺吶ｋ譎ゅ?DB謗･邯唔D繧呈欠螳壹＠縺ｾ縺吶?
216             *
217             * @og.rev 5.5.4.5 (2012/07/27) dbid 譁ｰ隕剰ｿｽ蜉?
218             *
219             * @param       id 繝??繧ｿ繝吶?繧ｹ謗･邯唔D
220             */
221            public void setDbid( final String id ) {
222                    dbid = nval( getRequestParameter( id ),dbid );
223            }
224    
225            /**
226             * 縺薙?繧ｪ繝悶ず繧ｧ繧ｯ繝医?譁?ｭ怜?陦ｨ迴ｾ繧定ｿ斐＠縺ｾ縺吶?
227             * 蝓ｺ譛ｬ逧?↓繝?ヰ繝?げ逶ｮ逧?↓菴ｿ逕ｨ縺励∪縺吶?
228             *
229             * @return 縺薙?繧ｯ繝ｩ繧ｹ縺ｮ譁?ｭ怜?陦ｨ迴ｾ
230             */
231            @Override
232            public String toString() {
233                    return org.opengion.fukurou.util.ToString.title( this.getClass().getName() )
234                                    .println( "VERSION"             ,VERSION        )
235                                    .println( "insFile"             ,insFile        )
236                                    .println( "fileURL"             ,fileURL        )
237                                    .println( "dbid"                ,dbid           )                               // 5.5.4.5 (2012/07/27) 譁ｰ隕剰ｿｽ蜉?
238                                    .println( "Other..."    ,getAttributes().getAttribute() )
239                                    .fixForm().toString() ;
240            }
241    }