package com.ejie.t17i.dao;

public class MunicipioDaoSql {

	/**
	 * StringBuilder initilization value
	 */
	public static final int STRING_BUILDER_INIT = 4096;
	public static final String SEQUENCE_NAME = "";
	public static final String TABLA = " t17i.T17_MUNICIPIO ";
	public static final String ORDER = " ORDER BY NOMBRE";
	public static final String ALIAS = "MUNICIPIO";
	public static final String PK = "ID";
	public static final String SQL_SELECT = "SELECT " + MunicipioDaoSql.ALIAS
			+ ".PROVINCIA_ID PROVINCIAID, " + MunicipioDaoSql.ALIAS
			+ ".ID ID, " + MunicipioDaoSql.ALIAS + ".DS_O NOMBRE, "
			+ MunicipioDaoSql.ALIAS + ".COMARCA_ID COMARCAID";
	public static final String SQL_SELECT_COUNT = "SELECT COUNT(1)";
	public static final String SQL_FROM = " FROM " + MunicipioDaoSql.TABLA
			+ " " + MunicipioDaoSql.ALIAS + " ";
	public static final String SQL_WHERE_ID = " WHERE " + "TO_NUMBER("
			+ MunicipioDaoSql.ALIAS + ".PROVINCIA_ID) = ? AND " + "TO_NUMBER("
			+ PK + ") = ? ";
	public static final String SQL_WHERE_ALL = " WHERE "
			+ MunicipioDaoSql.ALIAS + ".PROVINCIA_ID = ? ";

	public static final String SQL_FIND = SQL_SELECT + SQL_FROM + SQL_WHERE_ID;
	public static final String SQL_FIND_ALL = SQL_SELECT + SQL_FROM;
	public static final String SQL_FIND_ALL_COUNT = SQL_SELECT_COUNT + SQL_FROM;

}
