1 class Relation < ActiveRecord::Base
6 has_many :relation_members, :foreign_key => 'id'
7 has_many :relation_tags, :foreign_key => 'id'
9 has_many :old_relations, :foreign_key => 'id', :order => 'version'
11 set_table_name 'current_relations'
13 def self.from_xml(xml, create=false)
19 relation = Relation.new
21 doc.find('//osm/relation').each do |pt|
22 if !create and pt['id'] != '0'
23 relation.id = pt['id'].to_i
27 relation.timestamp = Time.now
28 relation.visible = true
31 relation.timestamp = Time.parse(pt['timestamp'])
35 pt.find('tag').each do |tag|
36 relation.add_tag_keyval(tag['k'], tag['v'])
39 pt.find('member').each do |member|
40 relation.add_member(member['type'], member['ref'], member['role'])
51 doc = OSM::API.new.get_xml_doc
52 doc.root << to_xml_node()
56 def to_xml_node(user_display_name_cache = nil)
57 el1 = XML::Node.new 'relation'
58 el1['id'] = self.id.to_s
59 el1['visible'] = self.visible.to_s
60 el1['timestamp'] = self.timestamp.xmlschema
62 user_display_name_cache = {} if user_display_name_cache.nil?
64 if user_display_name_cache and user_display_name_cache.key?(self.user_id)
65 # use the cache if available
66 elsif self.user.data_public?
67 user_display_name_cache[self.user_id] = self.user.display_name
69 user_display_name_cache[self.user_id] = nil
72 el1['user'] = user_display_name_cache[self.user_id] unless user_display_name_cache[self.user_id].nil?
74 self.relation_members.each do |member|
77 # # if there is a list of visible members then use that to weed out deleted segments
78 # if visible_members[member.member_type][member.member_id]
82 # otherwise, manually go to the db to check things
83 if member.member.visible?
88 e = XML::Node.new 'member'
89 e['type'] = member.member_type
90 e['ref'] = member.member_id.to_s
91 e['role'] = member.member_role
96 self.relation_tags.each do |tag|
97 e = XML::Node.new 'tag'
105 def self.find_for_nodes_and_ways(node_ids, way_ids)
106 # collect relationships. currently done in one big block at the end;
107 # may need to move this upwards if people want automatic completion of
108 # relationships, i.e. deliver referenced objects like we do with ways...
109 relations = Array.new
110 if node_ids.length > 0
111 relations += Relation.find_by_sql("select e.* from current_relations e,current_relation_members em where " +
113 "em.id = e.id and em.member_type='node' and em.member_id in (#{node_ids.join(',')})")
115 if way_ids.length > 0
116 relations += Relation.find_by_sql("select e.* from current_relations e,current_relation_members em where " +
118 "em.id = e.id and em.member_type='way' and em.member_id in (#{way_ids.join(',')})")
123 # FIXME is this really needed?
127 self.relation_members.each do |member|
128 @members += [[member.member_type,member.member_id,member.member_role]]
137 self.relation_tags.each do |tag|
152 def add_member(type,id,role)
153 @members = Array.new unless @members
154 @members += [[type,id,role]]
157 def add_tag_keyval(k, v)
158 @tags = Hash.new unless @tags
162 def save_with_history!
163 Relation.transaction do
170 RelationTag.delete_all(['id = ?', self.id])
173 tag = RelationTag.new
180 members = self.members
182 RelationMember.delete_all(['id = ?', self.id])
185 mem = RelationMember.new
187 mem.member_type = n[0];
188 mem.member_id = n[1];
189 mem.member_role = n[2];
193 old_relation = OldRelation.from_relation(self)
194 old_relation.timestamp = t
195 old_relation.save_with_dependencies!
199 def preconditions_ok?
200 self.members.each do |m|
202 n = Node.find(:first, :conditions => ["id = ?", m[1]])
203 unless n and n.visible
206 elsif (m[0] == "way")
207 w = Way.find(:first, :conditions => ["id = ?", m[1]])
208 unless w and w.visible and w.preconditions_ok?
211 elsif (m[0] == "relation")
212 e = Relation.find(:first, :conditions => ["id = ?", m[1]])
213 unless e and e.visible and e.preconditions_ok?