diff options
| author | Michel Etienne | 2013-02-07 16:22:58 +0100 |
|---|---|---|
| committer | Michel Etienne | 2013-02-07 16:22:58 +0100 |
| commit | ced4e122d9204e0e507f0a34c53f978c4d73c45d (patch) | |
| tree | d22becd1906fd07959295ef1e2273c99e140bbb2 /app | |
| parent | 02f3f3276c4d8c62791f4f76688f01af0f1ceb97 (diff) | |
| download | chouette-core-ced4e122d9204e0e507f0a34c53f978c4d73c45d.tar.bz2 | |
import foreign keys from ninoxe
Diffstat (limited to 'app')
| -rw-r--r-- | app/models/clean_up.rb | 27 |
1 files changed, 14 insertions, 13 deletions
diff --git a/app/models/clean_up.rb b/app/models/clean_up.rb index a6d26d882..70c763146 100644 --- a/app/models/clean_up.rb +++ b/app/models/clean_up.rb @@ -20,32 +20,33 @@ class CleanUp end def clean + # as foreign keys are presents , delete method can be used for faster performance result = CleanUpResult.new # find and remove time_tables tms = Chouette::TimeTable.validity_out_from_on?(Date.parse(expected_date)) result.time_table_count = tms.size tms.each do |tm| - tm.destroy + tm.delete end # remove vehiclejourneys without timetables Chouette::VehicleJourney.find_each(:conditions => "id not in (select distinct vehicle_journey_id from time_tables_vehicle_journeys)") do |vj| if vj.time_tables.size == 0 result.vehicle_journey_count += 1 - vj.destroy + vj.delete end end # remove journeypatterns without vehicle journeys Chouette::JourneyPattern.find_each(:conditions => "id not in (select distinct journey_pattern_id from vehicle_journeys)") do |jp| if jp.vehicle_journeys.size == 0 result.journey_pattern_count += 1 - jp.destroy + jp.delete end end # remove routes without journeypatterns Chouette::Route.find_each(:conditions => "id not in (select distinct route_id from journey_patterns)") do |r| if r.journey_patterns.size == 0 result.route_count += 1 - r.destroy + r.delete end end # if asked remove lines without routes @@ -53,7 +54,7 @@ class CleanUp Chouette::Line.find_each(:conditions => "id not in (select distinct line_id from routes)") do |l| if l.routes.size == 0 result.line_count += 1 - l.destroy + l.delete end end end @@ -62,31 +63,31 @@ class CleanUp Chouette::StopArea.find_each(:conditions => { :area_type => "BoardingPosition" }) do |bp| if bp.stop_points.size == 0 result.stop_count += 1 - bp.destroy + bp.delete end end Chouette::StopArea.find_each(:conditions => { :area_type => "Quay" }) do |q| if q.stop_points.size == 0 result.stop_count += 1 - q.destroy + q.delete end end Chouette::StopArea.find_each(:conditions => { :area_type => "CommercialStopPoint" }) do |csp| if csp.children.size == 0 result.stop_count += 1 - csp.destroy + csp.delete end end Chouette::StopArea.find_each(:conditions => { :area_type => "StopPlace" }) do |sp| if sp.children.size == 0 result.stop_count += 1 - sp.destroy + sp.delete end end Chouette::StopArea.find_each(:conditions => { :area_type => "ITL" }) do |itl| if itl.routing_stops.size == 0 result.stop_count += 1 - itl.destroy + itl.delete end end end @@ -95,7 +96,7 @@ class CleanUp Chouette::Company.find_each do |c| if c.lines.size == 0 result.company_count += 1 - c.destroy + c.delete end end end @@ -105,7 +106,7 @@ class CleanUp Chouette::Network.find_each do |n| if n.lines.size == 0 result.network_count += 1 - n.destroy + n.delete end end end @@ -115,7 +116,7 @@ class CleanUp Chouette::GroupOfLine.find_each do |n| if n.lines.size == 0 result.group_of_line_count += 1 - n.destroy + n.delete end end end |
