public Object listarSQL(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
return jpo.tablas(new String[] {"ATRIBUTO_SQL", "ATRIBUTO"}, new String[] {"ATR", "ABT"})
.dondeUnir(new String[] {"ATR", "ABT"}, new String[] {"COD_ATRIBUTO"})
.seleccionar(
"ATR.*,ABT.cod_clase AS atr_cod_clase,ABT.NOMBRE AS ATR_NOMBRE,ABT.WEB_NOMBRE AS ATR_WEB_NOMBRE");
}
public Object listarDetalle(Jpo jpo, HttpServletRequest request, HttpServletResponse response)
throws Exception {
return jpo.tablas(
new String[] {"CLASE", "ATRIBUTO", "ATRIBUTO_SQL"}, new String[] {"CLA", "ATR", "ASQ"})
.dondeUnir(new String[] {"ATR", "CLA"}, new String[] {"cod_clase"})
.dondeUnirIzquierda("ASQ", "ATR", new String[] {"COD_ATRIBUTO"})
.seleccionar(
"ATR.*,CLA.nombre AS cla_nombre,ASQ.longitud AS sql_longitud,ASQ.precision AS sql_precision,ASQ.obligatorio AS sql_obligatorio");
}