Well, you are using so many database features, I would guess it is
improbable you can create this statement more readable by creating it via
criteria.
However, what you could do is to create a view corresponding to the select
in the database, and use a criteria-based query to select from the view.
Thomas
Ernesto Celis <[EMAIL PROTECTED]> schrieb am 28.06.2005
01:25:14:
> I'm very new to torque and some new to Java, I'd like to learn new
> skills by using them on real projects.
> At this time I choose to learn Torque, I have data to use to populate
> certain tables on my DB.
>
> The ne_q table has a lot of data to be distributed among other tables,
> i.e. the employees data, I wrote this to populate the
> employees(empleados) table.
>
> I added a method doSelectEmpleados() to NeQPeer to store the data needed
> on an object.
> And a method doInsertNeQEmpleados() to Empleados.java to insert the data.
>
> Then I call the doInsertNeQEmpleados() method from somewhere else. This
> works fine, but I'd like to have some feedbakc to know how this could be
> improved.
>
> I have only one problem on doInsertNeQEmpleados(), when the line
>
empleado.setIdUmed(Integer.parseInt(record.getValue("id_umed").asString()));
> receives a null from the table, maybe this could be fixed with an If
> sentence, but I wrote this around 5:00 A.M, I will try to fix this later.
>
> Thanks in advance for your feedback, i think torque is a great tool.
>
> ------------ NeQPeer.java --------------
>
> import java.util.List;
> import org.apache.torque.TorqueException;
>
> public class NeQPeer
> extends mx.gob.ssatam.om.BaseNeQPeer
> {
> public static List doSelectEmpleados() throws TorqueException
> {
> String SQL = "select trim(rfc) as rfc, null as curp, " +
> "trim(right(right(nombre,length(nombre)-locate('
> ',nombre)),length(right(nombre,length(nombre)-locate(' ',nombre))) -
> locate(' ',right(nombre,length(nombre)-locate(' ',nombre))))) as nombre,
" +
> "trim(left(nombre,locate(' ',nombre)-1)) as apaterno,
> trim(left(right(nombre,length(nombre)-locate(' ',nombre)),locate('
> ',right(nombre,length(nombre)-locate(' ',nombre)))-1)) as amaterno, " +
> "1 as id_umed, case tiponom when 'F' then 8 when 'H' then 4 when
'R'
> then 6 when 'N' then 5 end as tipo_nomina " +
> "from ne_q order by nce;";
>
> List records = NeQPeer.executeQuery(SQL);
>
> return records;
> }
> }
>
> ----------- Empleados.java -----------
>
> import java.util.*;
> import org.apache.torque.TorqueException;
> import com.workingdogs.village.Record;
> import com.workingdogs.village.DataSetException;
> import mx.gob.ssatam.om.NeQPeer.*;
> import org.apache.torque.om.Persistent;
>
> public class Empleados
> extends mx.gob.ssatam.om.BaseEmpleados
> implements Persistent
> {
> public static void doInsertNeQEmpleados() throws TorqueException,
> DataSetException
> {
> List records = NeQPeer.doSelectEmpleados();
>
> for (Iterator i = records.iterator(); i.hasNext();)
> {
> Record record = (Record) i.next();
> Empleados empleado = new Empleados();
> empleado.setRfc(record.getValue("rfc").asString());
> empleado.setCurp(record.getValue("curp").asString());
> empleado.setNombre(record.getValue("nombre").asString());
> empleado.setApaterno(record.getValue("apaterno").asString());
> empleado.setAmaterno(record.getValue("amaterno").asString());
>
>
empleado.setIdUmed(Integer.parseInt(record.getValue("id_umed").asString()));
>
> empleado.setTipoNomina(Integer.parseInt(record.
> getValue("tipo_nomina").asString()));
> EmpleadosPeer.doInsert(empleado);
> }
> }
> }
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
