MARBEN

J'ai corrigé la base de donnée en fusionnant les stations doublon.

J'ai appliqué ce script pour cela :

query = "SELECT site_id,point_id, date_trunc('day',date) as d, count(1) as count FROM stations GROUP BY d, point_id, site_id HAVING count(1) > 1;" 
results = ActiveRecord::Base.connection.execute(query)
# {"site_id"=>nil, "point_id"=>"72", "d"=>"2014-09-10 00:00:00", "count"=>"2"}

results.each do |r|
  day = r['d'].to_date
  if r['site_id'].nil?
    stations = Station.where(point_id: r['point_id']).to_a
  else
    stations = Station.where(site_id: r['site_id']).to_a
  end
  stations.select!{|s| s.date.to_date == day}
  stations.sort!{|a,b| a.collections.count <=> b.collections.count}
  # Normalement on n'a plus que 2 stations
  puts "Pour le point #{r['point_id']}, on a #{stations.count} stations à la date #{day}: " 
  puts "#{stations[0].collections.count} collections le #{stations[0].date} et" 
  puts "#{stations[1].collections.count} collections le #{stations[1].date}" 

  # Déplacer les collections
  stations[0].collections.each do |c|
    c.station = stations[1]
    c.save
  end
  stations[0].delete
end