com.fs.commons.apps.templates.dao.TemplateDao Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of smart-desktop Show documentation
Smart-Desktop
There is a newer version: 0.0.9-3
/*
 * Copyright 2002-2016 Jalal Kiswani.
 *
 * 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 com.fs.commons.apps.templates.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.fs.commons.apps.templates.beans.Query;
import com.fs.commons.apps.templates.beans.QueryType;
import com.fs.commons.apps.templates.beans.Template;
import com.fs.commons.apps.templates.beans.TemplateVariable;
import com.fs.commons.apps.templates.beans.Variable;
import com.fs.commons.dao.JKAbstractPlainDataAccess;
import com.fs.commons.dao.JKDataAccessException;
import com.fs.commons.dao.JKRecordNotFoundException;
import com.jk.db.dataaccess.plain.JKFinder;

public class TemplateDao extends JKAbstractPlainDataAccess {
	////////////////////////////////////////////////////////////////////////////////////
	public Query findQuery(final int queryId) throws JKRecordNotFoundException, JKDataAccessException {
		final JKFinder finder = new JKFinder() {

			@Override
			public String getQuery() {
				return "SELECT * FROM conf_queries WHERE query_id=?";
			}

			@Override
			public Object populate(final ResultSet rs) throws SQLException, JKRecordNotFoundException, JKDataAccessException {
				final Query query = new Query();
				query.setQueryId(rs.getInt("query_id"));
				query.setDesc(rs.getString("desc"));
				query.setQueryType(findQueryType(rs.getInt("query_type_id")));
				query.setQueryText(rs.getString("query_text"));
				return query;
			}

			@Override
			public void setParamters(final PreparedStatement ps) throws SQLException {
				ps.setInt(1, queryId);
			}
		};
		return (Query) findRecord(finder);
	}

	////////////////////////////////////////////////////////////////////////////////////
	protected QueryType findQueryType(final int typeId) throws JKRecordNotFoundException, JKDataAccessException {
		final JKFinder finder = new JKFinder() {

			@Override
			public String getQuery() {
				return "SELECT  * FROM conf_query_types WHERE query_type_id=?";
			}

			@Override
			public Object populate(final ResultSet rs) throws SQLException, JKRecordNotFoundException, JKDataAccessException {
				final QueryType type = new QueryType();
				type.setId(rs.getInt(1));
				type.setName(rs.getString(2));
				return type;
			}

			@Override
			public void setParamters(final PreparedStatement ps) throws SQLException {
				ps.setInt(1, typeId);
			}
		};
		return (QueryType) findRecord(finder);
	}

	// ///////////////////////////////////////////////////////////////
	public Template findTemplate(final int tempId) throws JKRecordNotFoundException, JKDataAccessException {
		final JKFinder finder = new JKFinder() {

			@Override
			public String getQuery() {
				return "SELECT * FROM conf_templates WHERE template_id=? ";
			}

			@Override
			public Object populate(final ResultSet rs) throws SQLException, JKRecordNotFoundException, JKDataAccessException {
				final Template template = new Template();
				template.setTempId(rs.getInt("template_id"));
				template.setTempName(rs.getString("template_name"));
				template.setTempTitle(rs.getString("template_title"));
				template.setTempText(rs.getString("template_text"));
				template.setVariables(lstTemplateVariables(tempId));
				return template;
			}

			@Override
			public void setParamters(final PreparedStatement ps) throws SQLException {
				ps.setInt(1, tempId);
			}
		};
		return (Template) findRecord(finder);
	}

	////////////////////////////////////////////////////////////////////////////////////
	public Variable findVariable(final int varId) throws JKRecordNotFoundException, JKDataAccessException {
		final JKFinder finder = new JKFinder() {

			@Override
			public String getQuery() {
				return "SELECT * FROM conf_vars WHERE var_id=?";
			}

			@Override
			public Object populate(final ResultSet rs) throws SQLException, JKRecordNotFoundException, JKDataAccessException {
				final Variable variable = new Variable();
				variable.setVarId(rs.getInt("var_id"));
				variable.setVarName(rs.getString("var_name"));
				variable.setTableName(rs.getString("table_name"));
				variable.setFieldName(rs.getString("field_name"));
				if (rs.getInt("query_id") != 0) {
					variable.setQuery(findQuery(rs.getInt("query_id")));
				}
				return variable;
			}

			@Override
			public void setParamters(final PreparedStatement ps) throws SQLException {
				ps.setInt(1, varId);

			}
		};
		return (Variable) findRecord(finder);
	}

	// ///////////////////////////////////////////////////////////////
	public ArrayList lstTemplateVariables(final int tempId) throws JKRecordNotFoundException, JKDataAccessException {
		final JKFinder finder = new JKFinder() {

			@Override
			public String getQuery() {
				return "SELECT * FROM conf_template_vars WHERE template_id=? ORDER BY var_index";
			}

			@Override
			public Object populate(final ResultSet rs) throws SQLException, JKRecordNotFoundException, JKDataAccessException {
				final TemplateVariable var = new TemplateVariable();
				var.setTempVarId(rs.getInt("template_var_id"));
				// var.setTemp(findTemplate(rs.getInt("template_id")));
				var.setVarIndex(rs.getInt("var_index"));
				var.setVar(findVariable(rs.getInt("var_id")));
				return var;
			}

			@Override
			public void setParamters(final PreparedStatement ps) throws SQLException {
				ps.setInt(1, tempId);

			}
		};
		return lstRecords(finder);
	}
}