package com.ejie.t17i.dao;

public class TipoViaDaoSql {

	/**
	 * StringBuilder initilization value
	 */
	public static final int STRING_BUILDER_INIT = 4096;
	public static final String SEQUENCE_NAME = "";
	public static final String TABLA = " t17i.T17_TIPO_VIA ";
	public static final String ORDER = " ORDER BY NOMBRE";
	public static final String ALIAS = "TIPOVIA";
	public static final String PK = "ID";
	public static final String SQL_SELECT = "SELECT " + 
		TipoViaDaoSql.ALIAS + ".PROVINCIA_ID PROVINCIAID, " + 
		TipoViaDaoSql.ALIAS + ".ID ID, " + 
		TipoViaDaoSql.ALIAS + ".DS_O NOMBRE, " + 
		TipoViaDaoSql.ALIAS + ".ENTIDAD_ID ENTIDADID," +
		TipoViaDaoSql.ALIAS + ".MUNICIPIO_ID MUNICIPIOID";
	public static final String SQL_SELECT_COUNT = "SELECT COUNT(1)";
	public static final String SQL_FROM = " FROM " + TipoViaDaoSql.TABLA
			+ " " + TipoViaDaoSql.ALIAS + " ";
	public static final String SQL_WHERE_ID = " WHERE " + TipoViaDaoSql.ALIAS + ".PROVINCIA_ID = ? AND " + TipoViaDaoSql.ALIAS + ".MUNICIPIO_ID = ? AND " + PK + " = ? ";
	public static final String SQL_WHERE_ALL = " WHERE " + TipoViaDaoSql.ALIAS + ".PROVINCIA_ID = ? AND " + TipoViaDaoSql.ALIAS + ".MUNICIPIO_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;

}
