Module: Export::Coldp::Files::Distribution

Defined in:
lib/export/coldp/files/distribution.rb

Overview

taxonID areaID area gazetteer status referenceID remarks

Class Method Summary collapse

Class Method Details

.add_asserted_distributions(otus, csv, project_members) ⇒ Object 



77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
 
# File 'lib/export/coldp/files/distribution.rb', line 77

def self.add_asserted_distributions(otus, csv, project_members)
  ads = asserted_distributions(otus)

  ads.each do |ad|
    if !ad.iso_3166_a3.blank?
      gazetteer = 'iso'
      area_id = ad.iso_3166_a3
      area = ad.iso_3166_a3
    elsif !ad.iso_3166_a2.blank?
      gazetteer = 'iso'
      area_id = ad.iso_3166_a2
      area = ad.iso_3166_a2
    elsif !ad.tdwgID.blank?
      gazetteer = 'tdwg'
      if ad.data_origin == 'tdwg_l3' or ad.data_origin == 'tdwg_l4'
        area_id = ad.tdwgID.gsub(/^[0-9]{1,2}(.+)$/, '\1')  # fixes mismatch in TW vs CoL TDWG level 3 & 4 identifiers
      else
        area_id = ad.tdwgID
      end
      area = area_id
    else
      gazetteer = 'text'
      area_id = nil
      area = ad.name
    end

    csv << [
      ad.asserted_distribution_object_id,
      area_id,
      area,
      gazetteer,
      nil,
      ad.source_id,                                                  # reference_id - only 1 distribution reference allowed
      Export::Coldp.modified(ad.updated_at),                         # modified
      Export::Coldp.modified_by(ad.updated_by_id, project_members),  # modified_by
      nil
    ]
  end


  ads # return scope for reference handling
end

.add_content_distributions(otus, csv, project_members, project_id:) ⇒ Object 



120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
 
# File 'lib/export/coldp/files/distribution.rb', line 120

def self.add_content_distributions(otus, csv, project_members, project_id: )
  cd = content_distributions(otus, project_id: )
  cd.length # TODO: remove !?

  cd.each do |o|
    csv << [
      o.id,
      nil,
      o.text,
      'text',
      nil,
      nil,
      Export::Coldp.modified(o.updated_at),
      Export::Coldp.modified_by(o.updated_by_id, project_members),
      nil
    ]
  end
  cd # return scope for reference handling
end

.asserted_distributions(otus) ⇒ Object

TODO:

Arbitrarily using MAX to grab one source is janky, but if CoL doesn't have
extended model perhaps it doesn't matter.



14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/export/coldp/files/distribution.rb', line 14

def self.asserted_distributions(otus)
  # TODO: Include Gaz ADs.
  AssertedDistribution.with(otu_scope: otus.unscope(:order).select(:id))
    .joins("JOIN otu_scope on otu_scope.id = asserted_distributions.asserted_distribution_object_id AND asserted_distributions.asserted_distribution_object_type = 'Otu'")
    .joins("JOIN geographic_areas on asserted_distributions.asserted_distribution_shape_id = geographic_areas.id AND asserted_distributions.asserted_distribution_shape_type = 'GeographicArea'")
    .joins(:sources)
    .where(is_absent: [false, nil])
    .select('asserted_distribution_shape_id, asserted_distribution_object_id, name, iso_3166_a3, iso_3166_a2, "tdwgID", data_origin, asserted_distributions.updated_at, asserted_distributions.updated_by_id,
            MAX(sources.cached) AS cached, MAX(sources.id) AS source_id')
    .group('asserted_distribution_shape_id, asserted_distribution_object_id, name, iso_3166_a3, iso_3166_a2, "tdwgID", data_origin, asserted_distributions.updated_at, asserted_distributions.updated_by_id' )
end

.content_distributions(otus, project_id: nil) ⇒ Object 



26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/export/coldp/files/distribution.rb', line 26

def self.content_distributions(otus, project_id: nil)
  # TODO: change to CVT URI
  cvt_name  = 'Distribution text'

  topic_id = ControlledVocabularyTerm.find_by(
    project_id:,
    name: cvt_name)

  return [] if topic_id.blank?

  Content.with(otu_scope: otus.unscope(:order).select(:id))
    .joins('JOIN otu_scope on otu_scope.id = contents.otu_id')
    .where(contents: {topic_id: })
    .select('otus.id, contents.text, contents.updated_at, contents.updated_by_id')
    .distinct
end

.generate(otus, project_members, reference_csv = nil, project_id: nil) ⇒ Object 



43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
 
# File 'lib/export/coldp/files/distribution.rb', line 43

def self.generate(otus, project_members, reference_csv = nil, project_id: nil )
  CSV.generate(col_sep: "\t") do |csv|

    csv << %w{
      taxonID
      areaID
      area
      gazetteer
      status
      referenceID
      modified
      modifiedBy
      remarks
    }

    # We gather the scope (not data) so we can add references en-masse after
    ad_scope = add_asserted_distributions(otus, csv, project_members)
    cd_scope = add_content_distributions(otus, csv, project_members, project_id:)

    r1 = Source.with(d_scope: ad_scope)
      .joins('JOIN d_scope on d_scope.source_id = sources.id')
      .select('sources.id, sources.cached, sources.updated_at, sources.updated_by_id')
      .distinct

    r2 = Source.with(d_scope: cd_scope)
      .joins('JOIN d_scope on d_scope.source_id = sources.id')
      .select('sources.id, sources.cached, sources.updated_at, sources.updated_by_id')
      .distinct

    Export::Coldp::Files::Reference.add_reference_rows(r1.to_a, reference_csv, project_members) unless ad_scope.empty?
    Export::Coldp::Files::Reference.add_reference_rows(r2.to_a, reference_csv, project_members) unless cd_scope.empty?
  end
end