Transfer data from one database to another with Datamapper

Question

I have two repositories set up within data mapper as follows:

DataMapper.setup(:default, "sqlite://path/to/db1")
DataMapper.setup(:another, "sqlite://path/to/otherdb")

Lets say I have a model Foo that they both share a schema for. This is the pseudocode that I want to accomplish:

DataMapper.repository(:default){
    Foo.each do |f|
        # do some transformations
        # write to Foo table in DataMapper.repository(:another)
    end
}

How would I go about this?

Here is what you are looking for: http://stackoverflow.com/a/8809259/4136098 — Kh Ammad, Oct 21 '15 at 06:50

score 0 · Accepted Answer · answered Oct 25 '15 at 18:36

0

The way I ended up doing it:

DataMapper.repository(:default){
    Foo.each do |foo|
        DataMapper.repository(:another){
            newFoo = Foo.new
            newFoo.attributes = foo.attributes
            newFoo.save
        }
    end
}

answered Oct 25 '15 at 18:36

Omar Darwish

1,536
2
15
23

Transfer data from one database to another with Datamapper

1 Answers1