org.frameworkset.persitent.util.SQLMissingCache 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.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 SQLMissingCache extends SQLBaseCache{
	private static final Logger logger = LoggerFactory.getLogger(SQLMissingCache.class);
	private Map> parserTPLSQLStructions ;
	private Map> parserTPLTotalsizeSQLStructions ;

	protected  Map> missingCacheMetas ;
	public SQLMissingCache(String sqlfile, int resultMetaCacheSize, int perKeySqlStructionCacheSize) {
		super(sqlfile,resultMetaCacheSize,perKeySqlStructionCacheSize);
		parserTPLSQLStructions = new HashMap>();
		parserTPLTotalsizeSQLStructions = new HashMap>();
		missingCacheMetas = new HashMap>( );

	}


	public void clear()
	{
		missingCacheMetas.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;
		MissingStaticCache dbmetas = missingCacheMetas.get(dbname);
		if(dbmetas == null)
		{
			synchronized(missingCacheMetas)
			{
				dbmetas = missingCacheMetas.get(dbname);
				if(dbmetas == null)
				{
					dbmetas = new MissingStaticCache(resultMetaCacheSize);
					missingCacheMetas.put(dbname, dbmetas);
				}
			}
		}

		if(dbmetas.stopCache()){
			meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
			if(logger.isWarnEnabled()) {
				logMetaWarn(logger,sqlkey, dbmetas.getMissesMax());
			}
			return meta;
		}
		else {
			boolean newMeta = false;
			meta = dbmetas.get(sqlkey);
			if (meta == null) {
				try {
					metaLock.lock();
					meta = dbmetas.get(sqlkey);
					if (meta == null) {
						dbmetas.increamentMissing();
						newMeta = true;
						meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
						if(!dbmetas.stopCache()) {
							dbmetas.put(sqlkey, meta);
						}
					}
				}
				finally {
					metaLock.unlock();
				}
			}
			//检测从缓冲中获取的数据是否发生变化
			if(!newMeta && needRefreshMeta(meta,rsmetadata))
			{
				meta = PoolManResultSetMetaData.getCopy(db, rsmetadata);
				dbmetas.put(sqlkey, meta);

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

	}


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

		if(sqlstructionMap.stopCache()){
			if( logger.isWarnEnabled()) {
				this.logSqlStructionWarn(logger, ikey, sqlstructionMap.getMissesMax(),okey);
			}
			return VariableHandler.parserSQLStruction(newsql);
		}
		else {
			SQLStruction urlStruction = sqlstructionMap.get(ikey);
			if (urlStruction == null) {
				try {
					this.vtplLock.lock();
					urlStruction = sqlstructionMap.get(ikey);
					if (urlStruction == null) {
						sqlstructionMap.increamentMissing();
						urlStruction = VariableHandler.parserSQLStruction(newsql);
						if (!sqlstructionMap.stopCache()) {
							sqlstructionMap.put(ikey, urlStruction);
						}
					}
				} finally {
					this.vtplLock.unlock();
				}
				if (sqlstructionMap.stopCache() && logger.isWarnEnabled()) {
					this.logSqlStructionWarn(logger,ikey, sqlstructionMap.getMissesMax(), okey);
				}
			}
			return urlStruction;
		}
	}
	


}