elricstorm · September 4, 2009 13:19 · Sep 4, 2009 · Sep 4, 2009 · Sep 4, 2009 · Sep 4, 2009
diff --git a/gistfile1.rb b/gistfile1.rb
@@ -52,6 +52,8 @@ def scrape(url,type,name,deep,constant,model)
         # This will work below but update the last row of data on top of all data for the current week
         # Please note I was just trying a test to see if it was actually processing the right data
         # model.update_all(values)
+
+        # The output of values is a hash => {:compiled_on=>"2009-09-04", :rank=>"1"}:Hash
       end
     end
   end
diff --git a/gistfile1.rb b/gistfile1.rb
@@ -18,8 +18,7 @@ def scrape(url,type,name,deep,constant,model)
     parser_object.clean_celldata
 
     if model.compiled_this_week.find(:all).empty?
-      #if model.compiled_this_week.first.empty?
-      puts "Updating #{model} for the following teams:"
+      puts "Creating data for #{model} for the following teams:"
       parser_object.rows.each do |row|
         team = Team.find_by_name(row[1])
         values = {:compiled_on => Date.today.strftime('%Y-%m-%d')}

diff --git a/gistfile1.rb b/gistfile1.rb
@@ -1,3 +1,5 @@
+named_scope :compiled_this_week, lambda { { :conditions => ['created_at > ? and created_at < ?', Time.now.beginning_of_week, Time.now.end_of_week] } }
+
 # I have a series of constants that use the following format:
 
 OFFENSE_RUSHING = [:rank, :team_id, :games, :carries, :net, :avg, :tds, :ydspg, :wins, :losses, :ties]

diff --git a/gistfile1.rb b/gistfile1.rb
@@ -46,7 +46,11 @@ def scrape(url,type,name,deep,constant,model)
         end
         # List each team we update
         puts team.name + " ID = " + team.id.to_s
-        model.update_all(values)
+        # This will fail below because only 1 of 2 arguments presented
+        model.update(values)
+        # This will work below but update the last row of data on top of all data for the current week
+        # Please note I was just trying a test to see if it was actually processing the right data
+        # model.update_all(values)
       end
     end
   end
diff --git a/gistfile1.rb b/gistfile1.rb
@@ -0,0 +1,52 @@
+# I have a series of constants that use the following format:
+
+OFFENSE_RUSHING = [:rank, :team_id, :games, :carries, :net, :avg, :tds, :ydspg, :wins, :losses, :ties]
+
+# These constants are called in the method below 
+# url, name, deep only apply to my scraper class and is used for parsing so it's not an issue here
+
+# If no data is found for the current week, new data is created - this works fine
+# However, if data is found for the current week, I want to update that data using the constant above
+# Keep in mind that I have 37 constants which house different fields and this method is being used for all of them.
+# If I try update it says that wrong number of arguments 1 for 2.  I'm not sure how to use update with values
+
+def scrape(url,type,name,deep,constant,model)
+    parser_object = Scraper.new(url,type,name,deep)
+    parser_object.scrape_data
+    parser_object.clean_celldata
+
+    if model.compiled_this_week.find(:all).empty?
+      #if model.compiled_this_week.first.empty?
+      puts "Updating #{model} for the following teams:"
+      parser_object.rows.each do |row|
+        team = Team.find_by_name(row[1])
+        values = {:compiled_on => Date.today.strftime('%Y-%m-%d')}
+        constant.each_with_index do |field, i|
+          if row[i] == row[1]
+            values[field] = team.id
+          else
+            values[field] = row[i]
+          end
+        end
+        # List each team we create
+        puts team.name + " ID = " + team.id.to_s
+        model.create values
+      end
+    else
+      puts "Updating Current Data in #{model} for the following teams:"
+      parser_object.rows.each do |row|
+        team = Team.find_by_name(row[1])
+        values = {:compiled_on => Date.today.strftime('%Y-%m-%d')}
+        constant.each_with_index do |field, i|
+          if row[i] == row[1]
+            values[field] = team.id
+          else
+            values[field] = row[i]
+          end
+        end
+        # List each team we update
+        puts team.name + " ID = " + team.id.to_s
+        model.update_all(values)
+      end
+    end
+  end