2 desc 'Populate the node_tags table'
4 require File.dirname(__FILE__) + '/../../config/environment'
6 node_count = Node.count
7 limit = 1000 #the number of nodes to grab in one go
10 while offset < node_count
11 Node.find(:all, :limit => limit, :offset => offset).each do |node|
13 node.tags.split(';').each do |tag|
16 nt.k = tag.split('=')[0] || ''
17 nt.v = tag.split('=')[1] || ''
18 nt.sequence_id = seq_id
23 version = 1 #version refers to one set of histories
24 node.old_nodes.find(:all, :order => 'timestamp asc').each do |old_node|
25 sequence_id = 1 #sequence_id refers to the sequence of node tags within a history
26 old_node.tags.split(';').each do |tag|
28 ont.id = node.id #the id of the node tag
29 ont.k = tag.split('=')[0] || ''
30 ont.v = tag.split('=')[1] || ''
32 ont.sequence_id = sequence_id