save information from another table

Question

Hi everyone at this time i have two tables:

clientesultimasgestiones clientesgestiones

And I want to put the whole information from clientesgestiones to clientesultimasgestiones but I want to save it field by field, at this momento I have this

cnx = ActiveRecord::Base.connection
cnx.execute("truncate table clientesultimasgestiones")
@informacion = Clientesgestion.all

    @informacion.each do |f|
        @clientesultimasgestion = Clientesultimasgestion.new
        @clientesultimasgestion.save(f)
        Here will be the code to save field by field from clientesgestiones table to the another one
    end

Thanks for your help

EDIT: Finally i did it this way:

    cnx.execute("truncate table clientesultimasgestiones")
    @informacion = Clientesgestion.all

    @informacion.each do |f|
        l                               = Clientesultimasgestion.new
        l.persona_id                    = f.persona_id
        l.fecha_gestion                 = f.fecha_gestion
        l.clientestipologia_id          = f.clientestipologia_id
        l.observacion                   = f.observacion
        l.user_id                       = f.user_id
        l.fecha_acuerdo                 = f.fecha_acuerdo
        l.valor_apagar                  = f.valor_apagar
        l.clientestipologiaanterior_id  = f.clientestipologiaanterior_id
        l.clientesobligacion_id         = f.clientesobligacion_id
        l.save

    end

Thanks a lot :)

you can save a lot of lines with `update_attributes` – sites Sep 06 '13 at 14:33 — sites, Sep 06 '13 at 14:33

score 1 · Answer 1 · edited May 23 '17 at 11:56

1

I think this question will help you to get lists of attributes and values.

After this, you need to set dynamically fields, for this purpose you can use method send. Something like this: @clientesultimasgestion.send("#{field_name}=",field_value)

edited May 23 '17 at 11:56

Community

1
1

answered Sep 06 '13 at 14:27

dolgishev

44
5

score 1 · Accepted Answer · edited May 23 '17 at 10:31

1

I would replace:

    @clientesultimasgestion.save(f)

with:

    @clientesultimasgestion.update_attibutes(f.attributes)

Also, seems what you want is to copy a table, see https://stackoverflow.com/a/13237661/1197775.

edited May 23 '17 at 10:31

Community

1
1

answered Sep 06 '13 at 14:29

sites

21,417
17
87
146

save information from another table

2 Answers2