Use BETWEEN for the node selection in the map API call as MySQL seems to

[rails.git] / lib / daemons / gpx_import.rb

diff --git a/lib/daemons/gpx_import.rb b/lib/daemons/gpx_import.rb
index f597c87959127f4893203f987cc11840ab30b4c7..793fde94b8f54c4fe3cb5c000c53c1d72c4c0b4c 100755 (executable)
--- a/lib/daemons/gpx_import.rb
+++ b/lib/daemons/gpx_import.rb
@@ -12,7 +12,7 @@ logger = ActiveRecord::Base.logger
 while(true) do
   ActiveRecord::Base.logger.info("GPX Import daemon wake @ #{Time.now}.")
 
-  Trace.find(:all, :conditions => ['inserted = ?', false]).each do |trace|
+  Trace.find(:all, :conditions => 'inserted = 0 and visible = 1').each do |trace|
     Signal.trap("TERM") do 
       terminated = true
     end
@@ -27,7 +27,7 @@ while(true) do
         Notifier::deliver_gpx_failure(trace, '0 points parsed ok. Do they all have lat,lng,alt,timestamp?')
       end
     rescue Exception => ex
-      logger.info ex
+      logger.info ex.to_s
       ex.backtrace.each {|l| logger.info l }
       trace.destroy
       Notifier::deliver_gpx_failure(trace, ex.to_s + "\n" + ex.backtrace.join("\n"))
@@ -38,5 +38,22 @@ while(true) do
     exit if terminated
   end
 
-  sleep 15.minutes
+  Trace.find(:all, :conditions => 'visible = 0').each do |trace|
+    Signal.trap("TERM") do 
+      terminated = true
+    end
+
+    begin
+      trace.destroy
+    rescue Exception => ex
+      logger.info ex.to_s
+      ex.backtrace.each {|l| logger.info l }
+    end
+
+    Signal.trap("TERM", "DEFAULT")
+
+    exit if terminated
+  end
+
+  sleep 5.minutes
 end