com.hangum.tadpole.engine.query.sql.TadpoleSystem_SchemaHistory.java Source code

Introduction

Here is the source code for com.hangum.tadpole.engine.query.sql.TadpoleSystem_SchemaHistory.java

Source

/*******************************************************************************
 * Copyright (c) 2014 hangum.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Lesser Public License v2.1
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 * 
 * Contributors:
 *     hangum - initial API and implementation
 ******************************************************************************/
package com.hangum.tadpole.engine.query.sql;

import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.eclipse.rap.rwt.RWT;

import com.hangum.tadpole.commons.util.ApplicationArgumentUtils;
import com.hangum.tadpole.engine.initialize.TadpoleSystemInitializer;
import com.hangum.tadpole.engine.manager.TadpoleSQLManager;
import com.hangum.tadpole.engine.query.dao.system.SchemaHistoryDAO;
import com.hangum.tadpole.engine.query.dao.system.SchemaHistoryDetailDAO;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.sql.util.SQLUtil;
import com.ibatis.sqlmap.client.SqlMapClient;

/**
 * schema_history  ? .
 * 
 * @author hangum
 *
 */
public class TadpoleSystem_SchemaHistory {
    /**
     * Logger for this class
     */
    private static final Logger logger = Logger.getLogger(TadpoleSystem_SchemaHistory.class);

    /**
     * get schema history detail data
     * @param seq
     */
    public static List<SchemaHistoryDetailDAO> getExecuteQueryHistoryDetail(int seq) throws Exception {
        SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
        return sqlClient.queryForList("getSchemaHistoryDetail", seq);
    }

    /**
     * Get schema history data.
     * 
     * @param dbSeq
     * @param workType
     * @param objectType
     * @param objectId
     * @param startTime
     * @param endTime
     * @return
     * @throws Exception
     */
    public static List<SchemaHistoryDAO> getExecuteQueryHistory(int dbSeq, String workType, String objectType,
            String objectId, long startTime, long endTime) throws Exception {
        List<SchemaHistoryDAO> returnSchemaHistory = new ArrayList<SchemaHistoryDAO>();

        Map<String, Object> queryMap = new HashMap<String, Object>();
        queryMap.put("db_seq", dbSeq);

        queryMap.put("workType", "%" + workType + "%");
        queryMap.put("objectType", "%" + objectType + "%");
        queryMap.put("objectId", "%" + objectId + "%");

        if (ApplicationArgumentUtils.isDBServer()) {
            Date date = new Date(startTime);
            DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
            queryMap.put("startTime", formatter.format(date));

            Date dateendTime = new Date(endTime);
            queryMap.put("endTime", formatter.format(dateendTime));
        } else {
            queryMap.put("startTime", startTime);
            queryMap.put("endTime", endTime);
        }

        SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
        returnSchemaHistory = sqlClient.queryForList("getSchemaHistory", queryMap);

        return returnSchemaHistory;
    }

    /**
     * save schema_history 
     * 
     * @param user_seq
     * @param userDB
     * @param strSQL
     */
    public static SchemaHistoryDAO save(int user_seq, UserDBDAO userDB, String strSQL) {
        SchemaHistoryDAO schemaDao = new SchemaHistoryDAO();

        try {
            //
            //
            //
            String strWorkSQL = strSQL.replaceAll("(\r\n|\n|\r)", ""); // ? .
            strWorkSQL = strWorkSQL.replaceAll("\\p{Space}", " "); // ?  .
            if (logger.isDebugEnabled())
                logger.debug("[start sql]\t" + strWorkSQL);

            String[] arrSQL = StringUtils.split(strWorkSQL);
            if (arrSQL.length != 5)
                return null;
            String strWorkType = arrSQL[0];

            // object type
            String strObjecType = arrSQL[1];

            // objectId
            String strObjectId = StringUtils.remove(arrSQL[2], "(");

            if (StringUtils.equalsIgnoreCase("or", strObjecType)) {
                strObjecType = arrSQL[3];
                strObjectId = StringUtils.remove(arrSQL[4], "(");
            }

            schemaDao = new SchemaHistoryDAO();
            schemaDao.setDb_seq(userDB.getSeq());
            schemaDao.setUser_seq(user_seq);

            schemaDao.setWork_type(strWorkType);
            schemaDao.setObject_type(strObjecType);
            schemaDao.setObject_id(strObjectId);

            schemaDao.setCreate_date(new Timestamp(System.currentTimeMillis()));

            schemaDao.setIpaddress(RWT.getRequest().getRemoteAddr());

            SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
            SchemaHistoryDAO schemaHistoryDao = (SchemaHistoryDAO) sqlClient.insert("sqlHistoryInsert", schemaDao); //$NON-NLS-1$

            insertResourceData(schemaHistoryDao, strSQL);
        } catch (Exception e) {
            logger.error("Schema histor save error", e);
        }

        return schemaDao;
    }

    /**
     * resource data 
     * 
     * @param schemaHistoryDao
     * @param strSQL
     * @throws Exception
     */
    private static void insertResourceData(SchemaHistoryDAO schemaHistoryDao, String strSQL) throws Exception {
        SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());

        // content data .
        SchemaHistoryDetailDAO dataDao = new SchemaHistoryDetailDAO();
        dataDao.setSchema_seq(schemaHistoryDao.getSeq());
        String[] arrayContent = SQLUtil.makeResourceDataArays(strSQL);
        for (String content : arrayContent) {
            dataDao.setSource(strSQL);
            sqlClient.insert("sqlHistoryDataInsert", dataDao); //$NON-NLS-1$            
        }
    }
}