com.hangum.tadpole.commons.sql/src/com/hangum/tadpole/engine/query/dao/system/userdb/TDBDBDAO.java

   1 /*******************************************************************************
   2  * Copyright (c) 2015 hangum.
   3  * All rights reserved. This program and the accompanying materials
   4  * are made available under the terms of the GNU Lesser Public License v2.1
   5  * which accompanies this distribution, and is available at
   6  * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
   7  *
   8  * Contributors:
   9  *     hangum - initial API and implementation
  10  ******************************************************************************/
  11 package com.hangum.tadpole.engine.query.dao.system.userdb;
  12
  13 import java.sql.Timestamp;
  14 import java.util.ArrayList;
  15 import java.util.HashMap;
  16 import java.util.List;
  17 import java.util.Map;
  18
  19 import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine;
  20 import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine.OBJECT_TYPE;
  21 import com.hangum.tadpole.commons.util.DateUtil;
  22
  23 /**
  24  * Define Tadpole DB Hub db.
  25  *
  26  * @author hangum
  27  *
  28  */
  29 public class TDBDBDAO extends ManagerListViewDAO {
  30
  31         /** 디비 객체의 사영 여부 */
  32         protected boolean _isUseEnable = true;
  33         /** {@code _isUseEnable} 가 false 일 경우 시스템 메시지에서 보여줄 메시지를 기록한다. */
  34         protected String  _sysMessage = PublicTadpoleDefine.AUTH_CODE_DEFINE.VALID.name();
  35
  36         /** schema list */
  37         protected List<String> schemas = new ArrayList<String>();
  38
  39         /** This variable is schema assist */
  40         protected String schemaListSeparator = "";
  41         /** This variable is content assist */
  42         protected String tableListSeparator = null;
  43         /** This variable is content assit */
  44         protected String viewListSeparator = null;
  45         protected String functionLisstSeparator = null;
  46
  47         /**
  48          * db object cache
  49          *
  50          * {@code PublicTadpoleDefine#OBJECT_TYPE}, <SchemaName, Object>
  51          */
  52         protected Map<OBJECT_TYPE, Map<String, List<?>>> dbObjectCache= new HashMap<OBJECT_TYPE, Map<String, List<?>>>();
  53
  54         // TadpoleUserDbRoleDAO start ======================================
  55         protected int role_seq;
  56         protected String role_id;
  57         protected String access_ip;
  58         protected String is_resource_download;
  59         // default value is 00:00
  60         protected Timestamp terms_of_use_starttime      = new Timestamp(System.currentTimeMillis());
  61
  62         // default value is 100 years after
  63         protected  Timestamp terms_of_use_endtime       = new Timestamp(DateUtil.afterMonthToMillsMonth(24));
  64         // user db role description
  65         protected String description = "";
  66
  67         public TDBDBDAO() {
  68         }
  69
  70         /**
  71          * @return the role_seq
  72          */
  73         public int getRole_seq() {
  74                 return role_seq;
  75         }
  76
  77         /**
  78          * @param role_seq the role_seq to set
  79          */
  80         public void setRole_seq(int role_seq) {
  81                 this.role_seq = role_seq;
  82         }
  83
  84         /**
  85          * @return the role_id
  86          */
  87         public String getRole_id() {
  88                 return role_id;
  89         }
  90
  91         /**
  92          * @param role_id the role_id to set
  93          */
  94         public void setRole_id(String role_id) {
  95                 this.role_id = role_id;
  96         }
  97
  98         /**
  99          * @return the access_ip
 100          */
 101         public String getAccess_ip() {
 102                 return access_ip;
 103         }
 104
 105         /**
 106          * @param access_ip the access_ip to set
 107          */
 108         public void setAccess_ip(String access_ip) {
 109                 this.access_ip = access_ip;
 110         }
 111
 112         /**
 113          * @return the is_resource_download
 114          */
 115         public String getIs_resource_download() {
 116                 return is_resource_download;
 117         }
 118
 119         /**
 120          * @return the terms_of_use_starttime
 121          */
 122         public Timestamp getTerms_of_use_starttime() {
 123                 return terms_of_use_starttime;
 124         }
 125
 126         /**
 127          * @param terms_of_use_starttime the terms_of_use_starttime to set
 128          */
 129         public void setTerms_of_use_starttime(Timestamp terms_of_use_starttime) {
 130                 this.terms_of_use_starttime = terms_of_use_starttime;
 131         }
 132
 133         /**
 134          * @return the terms_of_use_endtime
 135          */
 136         public Timestamp getTerms_of_use_endtime() {
 137                 return terms_of_use_endtime;
 138         }
 139
 140         /**
 141          * @param terms_of_use_endtime the terms_of_use_endtime to set
 142          */
 143         public void setTerms_of_use_endtime(Timestamp terms_of_use_endtime) {
 144                 this.terms_of_use_endtime = terms_of_use_endtime;
 145         }
 146
 147         /**
 148          * @param is_resource_download the is_resource_download to set
 149          */
 150         public void setIs_resource_download(String is_resource_download) {
 151                 this.is_resource_download = is_resource_download;
 152         }
 153
 154         public void setDescription(String description) {
 155                 this.description = description;
 156         }
 157
 158         public String getDescription() {
 159                 return description;
 160         }
 161         // ====================================== end
 162
 163         /**
 164          * @return the schemaListSeparator
 165          */
 166         public String getSchemaListSeparator() {
 167                 return schemaListSeparator;
 168         }
 169
 170         /**
 171          * @param schemaListSeparator the schemaListSeparator to set
 172          */
 173         public void setSchemaListSeparator(String schemaListSeparator) {
 174                 this.schemaListSeparator = schemaListSeparator;
 175         }
 176
 177         /**
 178          * @return the viewListSeparator
 179          */
 180         public String getViewListSeparator() {
 181                 return viewListSeparator;
 182         }
 183
 184         /**
 185          * @param viewListSeparator the viewListSeparator to set
 186          */
 187         public void setViewListSeparator(String viewListSeparator) {
 188                 this.viewListSeparator = viewListSeparator;
 189         }
 190
 191         /**
 192          * @return the tableListSeparator
 193          */
 194         public String getTableListSeparator() {
 195                 return tableListSeparator;
 196         }
 197
 198         /**
 199          * @param tableListSeparator the tableListSeparator to set
 200          */
 201         public void setTableListSeparator(String tableListSeparator) {
 202                 this.tableListSeparator = tableListSeparator;
 203         }
 204
 205         /**
 206          * get db object
 207          *
 208          * @param objecType
 209          * @param schemaName
 210          * @return
 211          */
 212         public List<?> getDBObject(OBJECT_TYPE objecType, String schemaName) {
 213                 Map<String, List<?>> mapDBObject = dbObjectCache.get(objecType);
 214                 if(mapDBObject == null) {
 215                         return new ArrayList();
 216                 } else {
 217                         List listObject = mapDBObject.get(schemaName);
 218                         if(listObject == null) return new ArrayList();
 219                         else return listObject;
 220                 }
 221         }
 222
 223         /**
 224          * set db object
 225          *
 226          * @param objecType
 227          * @param schemaName
 228          * @param objectList
 229          */
 230         public void setDBObject(OBJECT_TYPE objecType, String schemaName, List objectList) {
 231                 Map<String, List<?>> mapDBObject = dbObjectCache.get(objecType);
 232                 if(mapDBObject == null) {
 233                         Map<String, List<?>> map = new HashMap<String, List<?>>();
 234                         map.put(schemaName, objectList);
 235
 236                         dbObjectCache.put(objecType, map);
 237                 } else {
 238                         mapDBObject.put(schemaName, objectList);
 239                 }
 240         }
 241
 242         /**
 243          * @return the functionLisstSeparator
 244          */
 245         public String getFunctionLisstSeparator() {
 246                 return functionLisstSeparator;
 247         }
 248
 249         /**
 250          * @param functionLisstSeparator the functionLisstSeparator to set
 251          */
 252         public void setFunctionLisstSeparator(String functionLisstSeparator) {
 253                 this.functionLisstSeparator = functionLisstSeparator;
 254         }
 255
 256         /**
 257          * get schemas
 258          * @return
 259          */
 260         public List<String> getSchemas() {
 261                 return schemas;
 262         }
 263
 264         /**
 265          * set schema
 266          * @param schemas
 267          */
 268         public void setSchemas(List<String> schemas) {
 269                 this.schemas = schemas;
 270         }
 271
 272         /**
 273          * list schema list
 274          * @param strSchema
 275          */
 276         public void addSchema(String strSchema) {
 277                 this.schemas.add(strSchema);
 278         }
 279
 280         /**
 281          * @return the _isUseEnable
 282          */
 283         public boolean is_isUseEnable() {
 284                 return _isUseEnable;
 285         }
 286
 287         /**
 288          * @param _isUseEnable the _isUseEnable to set
 289          */
 290         public void set_isUseEnable(boolean _isUseEnable) {
 291                 this._isUseEnable = _isUseEnable;
 292         }
 293
 294         /**
 295          * @return the _sysMessage
 296          */
 297         public String get_sysMessage() {
 298                 return _sysMessage;
 299         }
 300
 301         /**
 302          * @param _sysMessage the _sysMessage to set
 303          */
 304         public void set_sysMessage(String _sysMessage) {
 305                 this._sysMessage = _sysMessage;
 306         }
 307
 308
 309 }