20170423

[rapideact/rapideact.git] / com / rapide_act / CmnProperty.java

diff --git a/com/rapide_act/CmnProperty.java b/com/rapide_act/CmnProperty.java
index e65d878..7cab140 100644 (file)
--- a/com/rapide_act/CmnProperty.java
+++ b/com/rapide_act/CmnProperty.java
@@ -71,16 +71,60 @@ public class CmnProperty{
        protected static final int D_FILEEXT = 27;
        protected static final int D_SQLQUOTED = 28;
        protected static final int D_PHYSICAL = 29;
-       protected static final int KEYS = 30;
+       protected static final int D_DROP = 30;
+       protected static final int KEYS = 31;
        protected static final String [] PROP_KEY = { "us","pw","url","dr","out","in","ls","ils","fe","nm",
                                                                                                  "dm","ts","tks","od","qt","bc","it","et","ic","ec",
-                                                                                                 "icm","ecm","smc","dmc","mp","pf","sp","ext","sq", "ph"};
+                                                                                                 "icm","ecm","smc","dmc","mp","pf","sp","ext","sq", "ph", "dp"};
 
        protected String [] prop_val = new String[KEYS];
        protected static final String [] MASK_PTN = {"ALL", "ALT", "EDGE"};
        protected static final String DEFAULT_IN_FOLDER = "input";
        protected static final String DEFAULT_OUT_FOLDER = "output";
        protected static final String DEFAULT_PROP_FILE = "RapideAct.properties";
+
+       protected static final int CREATE_TABLE = 0;
+       protected static final int DROP_TABLE = 1;
+       protected static final int TRUNCATE_TABLE = 2;
+       protected static final int CREATE_PKEY = 3;
+       protected static final int DROP_PKEY = 4;
+       protected static final int CREATE_UKEY = 5;
+       protected static final int DROP_UKEY = 6;
+       protected static final int CREATE_INDEX = 7;
+       protected static final int DROP_INDEX = 8;
+       protected static final int CREATE_VIEW = 9;
+       protected static final int DROP_VIEW = 10;
+       protected static final int CREATE_PROCEDURE = 11;
+       protected static final int DROP_PROCEDURE = 12;
+       protected static final int CREATE_SYNONYM = 13;
+       protected static final int DROP_SYNONYM = 14;
+       protected static final int CREATE_SEQUENCE = 15;
+       protected static final int DROP_SEQUENCE = 16;
+       protected static final int CREATE_FK = 17;
+       protected static final int DROP_FK = 18;
+       
+       protected static final String [] SQL_FILE_NAME = {
+               "createTable.sql",
+               "dropTable.sql",
+               "truncateTable.sql",
+               "createPrimaryKey.sql",
+               "dropPrimaryKey.sql",
+               "createUniqueKey.sql",
+               "dropUniqueKey.sql",
+               "createIndex.sql",
+               "dropIndex.sql",
+               "createView.sql",
+               "dropView.sql",
+               "createProcedure.sql",
+               "dropProcedure.sql",
+               "createSynonym.sql",
+               "dropSynonym.sql",
+               "createSequence.sql",
+               "dropSequence.sql",
+               "createFk.sql",
+               "dropFk.sql"
+       };
+       
        protected static final String [] T_SQL_ARRAY = {
                "select "
                + " table_name "
@@ -287,6 +331,7 @@ public class CmnProperty{
        protected boolean isOrder                               = false;
        protected boolean isQuotation                   = true;
        protected boolean isPhysical                    = false;
+       protected boolean isDrop                                = false;
        protected int batchCount                                = 1000;
        protected String inclTables                     = null;
        protected String exclTables                     = null;
@@ -379,6 +424,7 @@ public class CmnProperty{
                if(!CmnUtils.isEmpty(prop_val[D_ORDER]) && prop_val[D_ORDER].toUpperCase().equals("Y"))isOrder = true;
                if(!CmnUtils.isEmpty(prop_val[D_QUOTATION]) && prop_val[D_QUOTATION].toUpperCase().equals("N"))isQuotation = false;
                if(!CmnUtils.isEmpty(prop_val[D_PHYSICAL]) && prop_val[D_PHYSICAL].toUpperCase().equals("Y"))isPhysical = true;
+               if(!CmnUtils.isEmpty(prop_val[D_DROP]) && prop_val[D_DROP].toUpperCase().equals("Y"))isDrop = true;
                if(!CmnUtils.isEmpty(prop_val[D_BATCOUNT]) && CmnUtils.isNumeric(prop_val[D_BATCOUNT]))batchCount = Integer.parseInt(prop_val[D_BATCOUNT]);
                if(!CmnUtils.isEmpty(prop_val[D_INCLTAB]))isInclTables = true;
                if(!CmnUtils.isEmpty(prop_val[D_EXCLTAB]))isExclTables = true;