org.frameworkset.persitent.util.SQLCache Maven / Gradle / Ivy

Go to download
/*
 *  Copyright 2008 biaoping.yin
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */

package org.frameworkset.persitent.util;

import com.frameworkset.common.poolman.sql.PoolManResultSetMetaData;
import com.frameworkset.util.VariableHandler;
import com.frameworkset.util.VariableHandler.SQLStruction;
import org.frameworkset.cache.EdenConcurrentCache;
import org.frameworkset.cache.MissingStaticCache;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

/**
 * Title: SQLCache.java 
 * Description: 
 * bboss workgroup
 * Copyright (c) 2007
 * @Date 2012-12-5 下午6:15:07
 * @author biaoping.yin
 * @version 1.0
 */
public class SQLCache extends SQLBaseCache{
	private static final Logger logger = LoggerFactory.getLogger(SQLCache.class);

	private Map> parserTPLSQLStructions ;
	private Map> parserTPLTotalsizeSQLStructions ;

	protected  Map> metas ;
	protected  Map> missingCacheMetas ;
	public SQLCache(String sqlfile,int resultMetaCacheSize,int perKeySqlStructionCacheSize) {
		super(sqlfile,resultMetaCacheSize,perKeySqlStructionCacheSize);
		parserTPLSQLStructions = new java.util.HashMap>();
		parserTPLTotalsizeSQLStructions = new java.util.HashMap>();
		metas = new HashMap>( );

	}


	public void clear()
	{
		metas.clear();
		parserTPLSQLStructions.clear();
		parserTPLTotalsizeSQLStructions.clear();
		super.clear();

	}


	public PoolManResultSetMetaData getPoolManResultSetMetaData(com.frameworkset.orm.adapter.DB db,String dbname,String sqlkey,ResultSetMetaData rsmetadata) throws SQLException
	{
		PoolManResultSetMetaData meta = null;
		EdenConcurrentCache dbmetas = metas.get(dbname);
		if(dbmetas == null)
		{
			synchronized(metas)
			{
				dbmetas = metas.get(dbname);
				if(dbmetas == null)
				{
					dbmetas = new EdenConcurrentCache(resultMetaCacheSize);
					metas.put(dbname, dbmetas);
				}
			}
		}

		meta =  dbmetas.get(sqlkey);
		boolean outOfSize = false;
		boolean newMeta = false;
		if(meta == null) {
			try {
				metaLock.lock();
				meta = dbmetas.get(sqlkey);
				if (meta == null) {
					newMeta = true;
					meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
					outOfSize = dbmetas.put(sqlkey, meta);
				}
			} finally {
				metaLock.unlock();
			}
		}

		//检测从缓冲中获取的数据是否发生变化
		if(!newMeta && needRefreshMeta(meta,rsmetadata))
		{
			meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
			outOfSize = dbmetas.put(sqlkey, meta);

		}
		if(outOfSize && logger.isWarnEnabled()) {
			logMetaWarn(logger,sqlkey, dbmetas.getMaxSize());
		}
		return meta;
	}




	/**
	 * vtpl需要进行分级缓存
	 * @param sqlinfo
	 * @param newsql
	 * @return
	 */
	protected VariableHandler.SQLStruction _getVTPLSQLStruction(boolean isTotalSize,
															  SQLInfo sqlinfo, String newsql, String okey,int cacheSize)
	{
		Map> _parserTPLSQLStructions = !isTotalSize ? parserTPLSQLStructions:parserTPLTotalsizeSQLStructions;
		String ikey = newsql;
		EdenConcurrentCache sqlstructionMap =  _parserTPLSQLStructions.get(okey);
		if(sqlstructionMap == null)
		{
			try
			{
				this.vtplLock.lock();
				sqlstructionMap =  _parserTPLSQLStructions.get(okey);
				if(sqlstructionMap == null)
				{
					sqlstructionMap = new   EdenConcurrentCache(cacheSize);
					_parserTPLSQLStructions.put(okey,sqlstructionMap);
				}
			}
			finally {
				vtplLock.unlock();
			}
		}
		VariableHandler.SQLStruction urlStruction = sqlstructionMap.get(ikey);
		boolean outOfSize = false;
		if(urlStruction == null){
			try
			{
				this.vtplLock.lock();
				urlStruction = sqlstructionMap.get(ikey);
				if(urlStruction == null){
					urlStruction = VariableHandler.parserSQLStruction(newsql);
					outOfSize = sqlstructionMap.put(ikey,urlStruction);
				}
			}
			finally {
				this.vtplLock.unlock();
			}
			if(outOfSize && logger.isWarnEnabled()) {
				this.logSqlStructionWarn(logger, ikey, sqlstructionMap.getMaxSize(),okey);
			}
		}
		return urlStruction;
	}
	


}