Class: MusicStory::Utils::XMLToDBImporter

Inherits:
Object
  • Object
show all
Defined in:
lib/music_story/utils/xml_to_db_importer.rb

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(xml_repo, sequel_repos) ⇒ XMLToDBImporter

Returns a new instance of XMLToDBImporter.



13
14
15
16
# File 'lib/music_story/utils/xml_to_db_importer.rb', line 13

def initialize(xml_repo, sequel_repos)
  @xml_repo = xml_repo
  @sequel_repos = sequel_repos
end

Class Method Details

.import_file_into_db(filename, db, create_tables = false) ⇒ Object



3
4
5
6
7
8
9
10
11
# File 'lib/music_story/utils/xml_to_db_importer.rb', line 3

def self.import_file_into_db(filename, db, create_tables=false)
  sequel_repos = Repository::Sequel.new(db)
  sequel_repos.create_tables! if create_tables
  results = Repository::ArtistXMLFile.new_with_open_file(filename) do |xml_repo|
    new(xml_repo, sequel_repos).import
  end

  return results.merge(:sequel_repos => sequel_repos)
end

Instance Method Details

#importObject



18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
# File 'lib/music_story/utils/xml_to_db_importer.rb', line 18

def import
  failures = []
  successes = []

  @xml_repo.each do |artist|
    begin
      @sequel_repos.artist_repo.transaction do
        artist.all_associated_artists.each do |a|
          @sequel_repos.artist_repo.store(a)
        end
        artist.all_genres.each do |g|
          @sequel_repos.genre_repo.store(g)
        end
        @sequel_repos.artist_repo.store(artist)
      end
    rescue => e
      failures << [artist, e]
    end

    successes << artist
  end

  {:successes => successes, :failures => failures}
end