Guest User

Untitled

a guest
May 24th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. curr_video_id = -1
  2. curr_video_predispositions = {}
  3.  
  4. execute("SELECT v.id, dp.name, dp.scalar_value FROM disposition_parameters dp JOIN content_dispositions cd ON cd.legacy_id = dp.content_disposition_legacy_id JOIN videos v ON v.legacy_id = cd.legacy_parent_id ORDER BY dp.content_disposition_legacy_id").each_hash do |row|
  5. if curr_video_id != row["id"]
  6. Predisposition.create(curr_video_predispositions.merge(:predispositioned_id => row["id"], :predispositioned_type => "Video")) unless curr_video_predispositions.empty?
  7. curr_video_id = row["id"]
  8. curr_video_predispositions = {}
  9. end
  10.  
  11. disposition_name = row["name"].downcase
  12. disposition_name = "logical" if disposition_name == "mathematical-logical"
  13.  
  14. curr_video_predispositions[disposition_name.to_sym] = row["scalar_value"].to_i
  15. end
Add Comment
Please, Sign In to add comment