Class: DrbListModel

Inherits:
Object
  • Object
show all
Includes:
DRbUndumped, Eprint
Defined in:
lib/DrbDB/DrbListModel.rb

Constant Summary

Constants included from Eprint

Eprint::TERM_COLOUR

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Eprint

#ecode, #edebug, #eerror, #eeval, #eexception, #efatal, #einfo, #eprint, #ewarn, #report_mail

Constructor Details

#initialize(drbdb, my_id) ⇒ DrbListModel

Returns a new instance of DrbListModel.



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'lib/DrbDB/DrbListModel.rb', line 9

def initialize(drbdb,my_id)
	@my_id=my_id.to_i
	@drbdb=drbdb
	@data=nil
	@rowcount=0
	@tree_key=nil
	@tree_parent_key=nil
	@fetch_filter_key=nil
	@fetch_filter_value=nil
	@fetch_filter_negate=false
	@archive_key=nil
	@clients=Hash.new
	@base=nil
	@last_seq=Hash.new
	@buttons=Array.new
	@childs=Array.new
end

Instance Attribute Details

#archive_key ⇒ Object (readonly)

Returns the value of attribute archive_key.



29
30
31
 
# File 'lib/DrbDB/DrbListModel.rb', line 29

def archive_key
  @archive_key
end

#base ⇒ Object (readonly)

Returns the value of attribute base.



31
32
33
 
# File 'lib/DrbDB/DrbListModel.rb', line 31

def base
  @base
end

#clients ⇒ Object (readonly)

Returns the value of attribute clients.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def clients
  @clients
end

#column_of_archive ⇒ Object (readonly)

Returns the value of attribute column_of_archive.



30
31
32
 
# File 'lib/DrbDB/DrbListModel.rb', line 30

def column_of_archive
  @column_of_archive
end

#column_of_background ⇒ Object (readonly)

Returns the value of attribute column_of_background.



28
29
30
 
# File 'lib/DrbDB/DrbListModel.rb', line 28

def column_of_background
  @column_of_background
end

#column_of_foreground ⇒ Object (readonly)

Returns the value of attribute column_of_foreground.



28
29
30
 
# File 'lib/DrbDB/DrbListModel.rb', line 28

def column_of_foreground
  @column_of_foreground
end

#column_of_id ⇒ Object (readonly)

Returns the value of attribute column_of_id.



28
29
30
 
# File 'lib/DrbDB/DrbListModel.rb', line 28

def column_of_id
  @column_of_id
end

#column_of_iter_depth ⇒ Object (readonly)

Returns the value of attribute column_of_iter_depth.



30
31
32
 
# File 'lib/DrbDB/DrbListModel.rb', line 30

def column_of_iter_depth
  @column_of_iter_depth
end

#column_of_sensitive ⇒ Object (readonly)

Returns the value of attribute column_of_sensitive.



28
29
30
 
# File 'lib/DrbDB/DrbListModel.rb', line 28

def column_of_sensitive
  @column_of_sensitive
end

#column_of_tree ⇒ Object (readonly)

Returns the value of attribute column_of_tree.



30
31
32
 
# File 'lib/DrbDB/DrbListModel.rb', line 30

def column_of_tree
  @column_of_tree
end

#column_of_tree_parent ⇒ Object (readonly)

Returns the value of attribute column_of_tree_parent.



30
31
32
 
# File 'lib/DrbDB/DrbListModel.rb', line 30

def column_of_tree_parent
  @column_of_tree_parent
end

#column_of_visible ⇒ Object (readonly)

Returns the value of attribute column_of_visible.



28
29
30
 
# File 'lib/DrbDB/DrbListModel.rb', line 28

def column_of_visible
  @column_of_visible
end

#data ⇒ Object (readonly)

Returns the value of attribute data.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def data
  @data
end

#fetch_filter_key ⇒ Object (readonly)

Returns the value of attribute fetch_filter_key.



29
30
31
 
# File 'lib/DrbDB/DrbListModel.rb', line 29

def fetch_filter_key
  @fetch_filter_key
end

#fetch_filter_negate ⇒ Object (readonly)

Returns the value of attribute fetch_filter_negate.



29
30
31
 
# File 'lib/DrbDB/DrbListModel.rb', line 29

def fetch_filter_negate
  @fetch_filter_negate
end

#fetch_filter_value ⇒ Object (readonly)

Returns the value of attribute fetch_filter_value.



29
30
31
 
# File 'lib/DrbDB/DrbListModel.rb', line 29

def fetch_filter_value
  @fetch_filter_value
end

#headers ⇒ Object (readonly)

Returns the value of attribute headers.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def headers
  @headers
end

#headertypes ⇒ Object (readonly)

Returns the value of attribute headertypes.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def headertypes
  @headertypes
end

#moditem ⇒ Object (readonly)

Returns the value of attribute moditem.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def moditem
  @moditem
end

#my_id ⇒ Object (readonly)

Returns the value of attribute my_id.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def my_id
  @my_id
end

#querysql ⇒ Object (readonly)

Returns the value of attribute querysql.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def querysql
  @querysql
end

#rowcount ⇒ Object (readonly)

Returns the value of attribute rowcount.



26
27
28
 
# File 'lib/DrbDB/DrbListModel.rb', line 26

def rowcount
  @rowcount
end

#tree_key ⇒ Object (readonly)

Returns the value of attribute tree_key.



29
30
31
 
# File 'lib/DrbDB/DrbListModel.rb', line 29

def tree_key
  @tree_key
end

#tree_parent_key ⇒ Object (readonly)

Returns the value of attribute tree_parent_key.



29
30
31
 
# File 'lib/DrbDB/DrbListModel.rb', line 29

def tree_parent_key
  @tree_parent_key
end

Instance Method Details

#alive? ⇒ Boolean

Returns:

  • (Boolean) 


665
666
667
 
# File 'lib/DrbDB/DrbListModel.rb', line 665

def alive?
	@drbdb.alive?
end

#buttons(user_id) ⇒ Object 



650
651
652
653
654
655
656
 
# File 'lib/DrbDB/DrbListModel.rb', line 650

def buttons(user_id)
	ret=Array.new
	@buttons.each{|button|
		ret.push(button) if button["grp_id"].to_i < 1 || @drbdb.user_in_group?(user_id.to_i,button["grp_id"].to_i)
	}
	ret
end

#cache ⇒ Object 



661
662
663
 
# File 'lib/DrbDB/DrbListModel.rb', line 661

def cache
	@drbdb.cache
end

#child_iter_ids(iter_id) ⇒ Object 



103
104
105
106
107
108
109
 
# File 'lib/DrbDB/DrbListModel.rb', line 103

def child_iter_ids(iter_id)
	chs=Array.new
	@data.each{|chid,chrow|
		chs.push(chid) if iter_id==chrow[@column_of_tree]
	}
	chs
end

#childs ⇒ Object 



658
659
660
 
# File 'lib/DrbDB/DrbListModel.rb', line 658

def childs
	@childs
end

#create_skeleton ⇒ Object 



129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
 
# File 'lib/DrbDB/DrbListModel.rb', line 129

def create_skeleton
	@moditem=@drbdb.admin.qrow("select moditems.*,`queries`.`sql`,tables.name as base_table from moditems left join `queries` on `queries`.`id` = `moditems`.`query_sql_id` left join tables on queries.base = tables.id where moditems.id='#{my_id}'")

	#querysql
	@querysql=@moditem['sql'] if !@moditem["sql"].nil? and @moditem["sql"].length>5
	@querysql=@moditem['querysql'] if @moditem["querysql"].length>5

	#base
	@base=@moditem["base_table"]
	@base=@drbdb.guess_table(querysql,"id") if @base.nil?

	#id/list_key
	@list_key=gtk_attribute("list_key") || "#{@base}.id"

	@key_child=gtk_attribute("child_key")
	@key_parent=gtk_attribute("parent_key")
	@key_child2=gtk_attribute("second_child_key")
	@key_parent2=gtk_attribute("second_parent_key")

	if @tree_key=gtk_attribute("tree_key")
		@tree_parent_key=gtk_attribute("tree_parent_key") || @list_key
	end
	
	@fetch_filter_key=gtk_attribute("fetch_filter_key")
	@fetch_filter_value=gtk_attribute("fetch_filter_value")
	@fetch_filter_negate=gtk_attribute("fetch_filter_negate") == 'true'
	@background_key=gtk_attribute("background_key")
	@foreground_key=gtk_attribute("foreground_key")
	@archive_key=gtk_attribute("archive_key")

	einfo("base:#{@base}, list_key:#{@list_key}, tree_key:#{@tree_key}, child_key: #{@key_child}, parent_key: #{@key_parent}, child_key2: #{@key_child2}, parent_key2: #{@key_parent2}") unless @drbdb.main_server.starting_up

	@headers=Hash.new
	headers[@list_key]= { "type" => "Bignum", "visible" => false, "data" => @list_key }  #id
	headers["visible_for_filter"]= { "type" => "TrueClass", "visible" => false, "data" => "visible_for_filter" }  #visible_for_filter
	headers["sensitive"]= { "type" => "TrueClass", "visible" => false, "data" => "sensitive" }  #sensitive
	headers[@background_key]= { "type" => "String", "visible" => false, "data" => @background_key }  if @background_key
	headers[@foreground_key]= { "type" => "String", "visible" => false, "data" => @foreground_key }  if @foreground_key
	headers[@tree_key]= { "type" => "Bignum", "visible" => false, "data" => @tree_key }  if @tree_key
	headers[@tree_parent_key]= { "type" => "Bignum", "visible" => false, "data" => @tree_parent_key }  if (!@tree_parent_key.nil?)
	headers["iter_depth"]= { "type" => "Bignum", "visible" => false, "data" => "iter_depth" }  if @tree_key
	headers[@key_child]= { "type" => "Bignum", "visible" => false, "data" => @key_child }  if @key_child
	headers[@key_child2]= { "type" => "Bignum", "visible" => false, "data" => @key_child2 }  if @key_child2
	headers[@fetch_filter_key]= { "type" => "String", "visible" => false, "data" => @fetch_filter_key }  if @fetch_filter_key
	headers[@archive_key]= { "type" => "TrueClass", "visible" => false, "data" => @archive_key }  if @archive_key
	
	hdebug="\nheaders from query:"
	@drbdb.admin.rows("select * from gtkheaders where listing='#{my_id}' order by oid asc").each{|row|
		headers[row["data"]]= row
		headers[row["data"]]["visible"] = !(['gtk_invisible_int','gtk_invisible_string'].include?(row['type']))
		hdebug="#{hdebug}\n #{row['data']} #{row['type']}"
	}

	@headertypes=Array.new
	header_n=0
	headers.each_value{|header| 
		header["model_col"]=header_n
		case header['type']
			when 'gtk_int','Integer','gtk_invisible_int','Bignum','gtk_duration','gtk_timestamp' then headertypes.push(Bignum)
			when 'gtk_float','gtk_progress' then headertypes.push(Float)
			when 'gtk_toggle','TrueClass' then  headertypes.push(TrueClass)
#				when 'gtk_pixbuf' then  headertypes.push(Gdk::Pixbuf)
			when 'gtk_pixbuf' then headertypes.push(Fixnum)
		else
			headertypes.push(String)
		end
		header_n+=1
	}

	@data=Hash.new

	@column_of_id=headers[@list_key]["model_col"]
	@column_of_visible=headers["visible_for_filter"]["model_col"]
	@column_of_background=headers[@background_key]["model_col"] unless headers[@background_key].nil?
	@column_of_foreground=headers[@foreground_key]["model_col"] unless headers[@foreground_key].nil?
	@column_of_sensitive=headers["sensitive"]["model_col"]
	@column_of_fetch_filter=if @fetch_filter_key then headers[@fetch_filter_key]["model_col"] else nil end
	@column_of_archive=if @archive_key then headers[@archive_key]["model_col"] else nil end
	hdebug="#{hdebug}\nheadertypes: #{@headertypes.inspect}\nheaders:\n"

	@background_legend=Hash.new
	@foreground_legend=Hash.new

	@headers.each_value{|val| hdebug="#{hdebug} #{val['data']} #{val['model_col']}\n"}
#		print "#{self} #{hdebug}\n"
	@column_of_tree=nil
	@column_of_tree_parent=nil
	if @tree_key
		@column_of_tree=if tree_header=headers[@tree_key] then tree_header["model_col"]; else nil;end
		@column_of_tree_parent=if tree_parent_header=headers[@tree_parent_key] then tree_parent_header["model_col"] else nil end
		@column_of_iter_depth=headers["iter_depth"]["model_col"]
	end


	
	@relations=Array.new
	@drbdb.admin.rows("select * from relations where src_table='#{base}' or dst_table='#{base}'").each{|relation|
		@relations.push(relation)
	}
	
	cache.set("#{@my_id}moditem",@moditem)
	cache.set("#{@my_id}headers",@headers)
	cache.set("#{@my_id}headertypes",@headertypes)
	cache.set("#{@my_id}attributes",{
		:querySQL=>@querysql,
		:base=>@base,
		:list_key=>@list_key,
		:child_key=>@key_child,
		:parent_key=>@key_parent,
		:child_key2=>@key_child2,
		:parent_key2=>@key_parent2,
		:tree_key=>@tree_key,
		:column_of_id=>@column_of_id,
		:column_of_visible=>@column_of_visible,
		:column_of_sensitive=>@column_of_sensitive,
		:column_of_background=>@column_of_background,
		:column_of_foreground=>@column_of_foreground,
		:column_of_archive=>@column_of_archive,
		:column_of_tree_parent=>@column_of_tree_parent,
		:column_of_tree=>@column_of_tree,
		:fetch_filter_key=>@fetch_filter_key,
		:column_of_fetch_filter=>@column_of_fetch_filter,
		:fetch_filter_value=>@fetch_filter_value,
		:fetch_filter_negate=>@fetch_filter_negate,
		:archive_key=>@archive_key
		})

	reset_buttons
	reset_childs
	self
end

#data_iter_of_col_num(col_num, col_num_data) ⇒ Object

finds iter by col_num, col_num=colnum number to search for, col_num_data=the data we’re looking for



74
75
76
77
78
79
80
81
82
83
 
# File 'lib/DrbDB/DrbListModel.rb', line 74

def data_iter_of_col_num(col_num,col_num_data)
	found_iter=nil
	@data.each{|row_id,iter|
		if iter[col_num]==col_num_data
			found_iter=iter
			break
		end
	}
	found_iter
end

#data_of_column(colname, lid) ⇒ Object 



122
123
124
125
126
127
 
# File 'lib/DrbDB/DrbListModel.rb', line 122

def data_of_column(colname,lid)
	ret=nil
	if di=@data[lid] and col=headers[colname]
		ret=di[col["model_col"]]
	end
end

#duplicate_iter(iter_to_dup) ⇒ Object 



566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
 
# File 'lib/DrbDB/DrbListModel.rb', line 566

def duplicate_iter(iter_to_dup)
	sql="insert into #{base} set ";
	q=@drbdb.query("select * from #{base} where #{@list_key}='#{iter_to_dup[@column_of_id]}'")
	colon=false
	if row=q.fetch_hash()
		row.each { |field,data|
			if "#{base}.#{field}"!=@list_key and data
				sql="#{sql}, " if colon
				colon=true
				sql="#{sql} `#{field}`='#{@drbdb.escape_string(data)}' " 
			end
		}
	end
	@drbdb.query(sql)
	rows_changed("last")
#		load_data(nil,"last")
end

#filtered_fetch(ff_value = nil) ⇒ Object 



448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
 
# File 'lib/DrbDB/DrbListModel.rb', line 448

def filtered_fetch(ff_value=nil)
	t=Thread.new{
	einfo("serving")
	before=Time.now
	served_rows=0
	tree_sorted.each{|row_id,row|
		if @column_of_fetch_filter.nil? or ff_value.nil? or (not @fetch_filter_negate and row[@column_of_fetch_filter].to_s == ff_value.to_s) or (@fetch_filter_negate and row[@column_of_fetch_filter].to_s != ff_value.to_s)
			yield row
			served_rows+=1
		end
	}
	yield served_rows
	serve_time=Time.now.to_f-before.to_f
	einfo("served #{served_rows}(of #{@rowcount}) in "+sprintf("%.2fs",serve_time))
	}
end

#filtered_fetch2(ff_value = nil, archive = false) ⇒ Object 



465
466
467
468
469
470
471
472
473
474
475
476
477
478
 
# File 'lib/DrbDB/DrbListModel.rb', line 465

def filtered_fetch2(ff_value=nil,archive=false)
#		t=Thread.new{
		before=Time.now.to_f
		tree=tree_sorted
		sort_time=Time.now.to_f
		ret=Array.new
		tree.each{|row| 
			ret.push(row) if (@column_of_fetch_filter.nil? || ff_value.nil? || (!@fetch_filter_negate && row[@column_of_fetch_filter].to_s == ff_value.to_s) || (@fetch_filter_negate && row[@column_of_fetch_filter].to_s != ff_value.to_s) ) && (@column_of_archive.nil? || (archive || !row[@column_of_archive]))
		}
		end_time=Time.now.to_f
		einfo("serving #{ret.size}(of #{@rowcount}) (sort:"+sprintf("%.2fs",sort_time-before)+" filter:"+sprintf("%.2fs",end_time-sort_time)+") "+sprintf("%.2fs",end_time-before))
#		}
ret
end

#get_id ⇒ Object 



36
37
38
 
# File 'lib/DrbDB/DrbListModel.rb', line 36

def get_id
	@my_id
end

#getBinding ⇒ Object

def method_missing(sym,*args) print “n!#self missing method: #sym(#args)n” end



689
690
691
 
# File 'lib/DrbDB/DrbListModel.rb', line 689

def getBinding
	binding
end

#gtk_attribute(gattr) ⇒ Object 



42
43
44
 
# File 'lib/DrbDB/DrbListModel.rb', line 42

def gtk_attribute(gattr)
	@drbdb.gtk_attribute(gattr,self)
end

#lock_iter(locked_id) ⇒ Object 



46
47
48
49
50
51
52
53
54
55
56
57
 
# File 'lib/DrbDB/DrbListModel.rb', line 46

def lock_iter(locked_id)
	edebug("lock for #{locked_id}") unless @clients.size==0
	if @data.has_key?(locked_id) && @data[locked_id][@column_of_sensitive]
		@data[locked_id][@column_of_sensitive]=false
		begin
			cache.set("#{@my_id}[#{locked_id}]",@data[locked_id])
		rescue => err
			eerror("Locking: #{err}")
		end
		notify_clients(locked_id)
	end
end

#mod_type ⇒ Object 



39
40
41
 
# File 'lib/DrbDB/DrbListModel.rb', line 39

def mod_type
	"list"
end

#notify_clients(*args) ⇒ Object 



619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
 
# File 'lib/DrbDB/DrbListModel.rb', line 619

def notify_clients(*args)
		to_remove=Array.new
		th=Array.new
	edebug("notifying #{@clients.size} clients for #{args.inspect}") unless @drbdb.main_server.starting_up || @clients.size==0
		@clients.each_pair{|client_id,client|
			th << Thread.new{
			begin
				if client.alive?
					client.update(self.class.name,*args)
				end
			rescue =>err
				eexception(err)
				to_remove.push(client_id)
			end
			}
		}
		th.each{|t| t.join}
		to_remove.each{|dead|
			@clients.delete(dead)
			edebug("dead client deleted: #{dead}")
		}
end

#remove_dead_clients ⇒ Object 



669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
 
# File 'lib/DrbDB/DrbListModel.rb', line 669

def remove_dead_clients
	alive_clients=0
	clients.delete_if{|client_id,client|
		begin
			Timeout.timeout(30){
				client.alive?
				alive_clients+=1
				false
			}
		rescue 
			ewarn("removing dead subscription: #{client_id.inspect}")
			true
		end
	}
	alive_clients
end

#remove_iters(ids_to_remove, nick = nil) ⇒ Object 



584
585
586
587
588
589
590
 
# File 'lib/DrbDB/DrbListModel.rb', line 584

def remove_iters(ids_to_remove,nick=nil)
	unless base.nil?
		@drbdb.query("delete from #{base} where #{@list_key} in (#{ids_to_remove.join(",")})")
		einfo("removing ids: #{ids_to_remove.inspect}")
		rows_changed(ids_to_remove,nick)
	end
end

#reset_buttons ⇒ Object 



270
271
272
273
274
275
276
277
278
 
# File 'lib/DrbDB/DrbListModel.rb', line 270

def reset_buttons
	#loading buttons
	einfo("resetting buttons") unless @drbdb.main_server.starting_up
	@buttons.clear
	@drbdb.admin.rows("select * from buttons where moditemid='#{my_id}' order by oid").each{|button|
		@buttons.push(button)
	}
	notify_clients(nil,"buttons")
end

#reset_childs ⇒ Object 



261
262
263
264
265
266
267
268
 
# File 'lib/DrbDB/DrbListModel.rb', line 261

def reset_childs
	#loading childs
	einfo("resetting childs") unless @drbdb.main_server.starting_up
	@childs.clear
	@drbdb.admin.rows("select moditems.id,moditems.display,moditems.oid,modules.modname from moditems left join modules on modid = modules.id where parent='#{my_id}' order by oid").each{|moditem|
		@childs.push(moditem)
	}
end

#rows_changed(chids, nick = nil, chseq = 0) ⇒ Object 



480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
 
# File 'lib/DrbDB/DrbListModel.rb', line 480

def rows_changed(chids,nick=nil,chseq=0)
	ids=if chids.class.name == "Array" then chids.clone else [chids] end
	#prevent circular calling of rows_changed
	chseq=Time.new.to_f-@my_id  if chseq == 0 #FIXME: not unique

#		edebug("rows_changed:@#{chseq}:#{nick}:#{ids.inspect}")
	ids_to_remove=Array.new
	ids.each{|ch_id|
		if @last_seq[ch_id] == chseq
			ids_to_remove.push(ch_id)
		else
			@last_seq[ch_id]=chseq
		end
	}
	ids_to_remove.each{|to_rem| ids.delete(to_rem)}

	return unless ids.size > 0

	#precaching related ids, thus if update deletes a row, we still have the required data to walk the map
	pre_ids=Hash.new
	@drbdb.moditems_with_base(base){|other_list|
		unless other_list == self
			pre_ids[other_list]=Array.new unless pre_ids.has_key?(other_list)
			ids.each{|i| pre_ids[other_list].push(i)}
		end
	}

	@relations.each{|relation|
		if (relation['src_table'] == base) || (relation['dst_table'] == base && relation['rel_type'] == 'o')
			#forward, update parent lists for group_by queries
			#update lists with relation.src_table.src_field == relation.dst_table.dst_field
			@drbdb.moditems_with_base(relation['dst_table']){|other_list|
				pre_ids[other_list]=Array.new unless pre_ids.has_key?(other_list) #might already be there if multiple relations to each other
				ids.each{|changed_id|
					if other_id=data_of_column(relation['src_table']+"."+relation['src_field'],changed_id)
						pre_ids[other_list].push(other_id.to_i)
					end
				}
			}
			#else
			#reverse, update client lists, should be used only if this relation_id is used in the client query
			#update lists with dst_field == src_table.src_field
		end
	}
	
	rnick=if nick.nil? then nil else nick.clone end
	ids=update(nil,ids,rnick)

	#postcaching again, if update was insert we have the data to walk the map
	@relations.each{|relation|
		if (relation['src_table'] == base) || (relation['dst_table'] == base && relation['rel_type'] == 'o')
			#forward, update parent lists for group_by queries
			#update lists with relation.src_table.src_field == relation.dst_table.dst_field
			@drbdb.moditems_with_base(relation['dst_table']){|other_list|
				pre_ids[other_list]=Array.new unless pre_ids.has_key?(other_list) #might already be there
				ids.each{|changed_id|
					if other_id=data_of_column(relation['src_table']+"."+relation['src_field'],changed_id)
						pre_ids[other_list].push(other_id.to_i)
					end
				}
#					ecode("postcache #{other_list}:#{pre_ids[other_list].inspect}")
			}
			#else
			#reverse, update client lists, should be used only if this relation_id is used in the client query
			#update lists with dst_field == src_table.src_field
		end
	}
#		ecode("notifying other drblists with base:#{@base} for #{ids.inspect}")
	@drbdb.moditems_with_base(base){|other_list|
		#drblist.rows_changed(ids,nil,chseq) unless drblist == self
		unless other_list == self
			pre_ids[other_list]=Array.new unless pre_ids.has_key?(other_list)
			ids.each{|i| pre_ids[other_list].push(i)}
#				ecode("postcache #{other_list}:#{pre_ids[other_list].inspect}")
		end
	}

#		ecode("notifying other drblists related to:#{@base} for #{ids.inspect}")
#		ecode("pre_ids:#{pre_ids.inspect}")
	pre_ids.each{|other_model,other_ids|
		other_ids.uniq!
#			ecode("#{other_model}:#{other_ids.inspect}/@#{chseq}")
		other_model.rows_changed(other_ids,nil,chseq)
	}
end

#set_children_depth(ids, have_seen = Array.new) ⇒ Object 



111
112
113
114
115
116
117
118
119
120
 
# File 'lib/DrbDB/DrbListModel.rb', line 111

def set_children_depth(ids,have_seen=Array.new)
	ids.each{|iid|
		if @data.has_key?(iid) && !have_seen.include?(iid)
			edebug("setting depth for: #{iid}")
			have_seen.push(iid)
			set_iter_depth(@data[iid])
			set_children_depth(child_iter_ids(iid),have_seen)
		end
	}
end

#set_iter_depth(row, depth_check = Array.new) ⇒ Object 



85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
# File 'lib/DrbDB/DrbListModel.rb', line 85

def set_iter_depth(row,depth_check=Array.new)
	begin
	if @tree_key
		if piter=data_iter_of_col_num(@column_of_tree_parent,row[@column_of_tree])
			unless depth_check.include?(piter[@column_of_id])
				depth_check.push(piter[@column_of_id])
				set_iter_depth(piter,depth_check)
				else
				edebug("circular child=>parent relation: #{depth_check.join("->")} -/> #{piter[@column_of_id]}")
			end
			row[@column_of_iter_depth]=piter[@column_of_iter_depth]+1
		end
	end
	rescue =>err
		eexception(err)
	end
end

#store_history(nick, row_id, operation, header_id = nil, data = nil) ⇒ Object 



642
643
644
645
646
647
648
 
# File 'lib/DrbDB/DrbListModel.rb', line 642

def store_history(nick,row_id,operation,header_id=nil,data=nil)
#		ecode("storing history: nick:#{nick},op:#{operation}, id:#{row_id}, header:#{header_id}, data:#{data}")
	sql="insert into `history` set `ctime`=now(), `nick`='#{nick}', `base`='#{@base}', `row_id`='#{row_id}', `operation`='#{operation}'"
	sql+=", `header_id`='#{header_id}'" unless header_id.nil?
	sql+=",`data`='#{@drbdb.escape_string(data.to_s)}'" unless data.nil?
	@drbdb.admin.query(sql)
end

#subscribe(client_id, client) ⇒ Object

#not yet used def change_value_of_iter(iter, column_data, new_value) sql=“update ##base set ‘#column_data`=’#new_value‘ where `id`=’##column_of_id‘ limit 1” einfo(“changing #column_data to #new_value updatesql: #sql”,“list”) @drbdb.query(prepare_sql(sql,self)) rows_changed(iter.to_i) end def change_value_of_path(path, column_data, new_value) change_value_of_iter(@sorter.get_iter(path), column_data, new_value) end



604
605
606
607
608
609
610
611
612
 
# File 'lib/DrbDB/DrbListModel.rb', line 604

def subscribe(client_id,client)
if @clients.has_key?(client_id)
	false
else
		edebug("subscribing: #{client_id}")
		@clients[client_id]=client
		true
	end
end

#to_s ⇒ Object 



33
34
35
 
# File 'lib/DrbDB/DrbListModel.rb', line 33

def to_s
	"Drbmodel{#{@drbdb.name}:#{moditem['display']}(#{my_id})}"
end

#tree_sorted ⇒ Object 



438
439
440
441
442
443
444
445
446
 
# File 'lib/DrbDB/DrbListModel.rb', line 438

def tree_sorted
	if @tree_key
		@data.values.sort{|a,b| 
			a[@column_of_iter_depth]<=>b[@column_of_iter_depth]
		}
		else
		@data.values
	end
end

#unlock_iter(unlocked_id) ⇒ Object 



59
60
61
62
63
64
65
66
67
68
69
70
71
 
# File 'lib/DrbDB/DrbListModel.rb', line 59

def unlock_iter(unlocked_id)
	if @data.has_key?(unlocked_id) && !@data[unlocked_id][@column_of_sensitive]
		edebug("unlock for #{unlocked_id}") unless @clients.size==0
		@data[unlocked_id][@column_of_sensitive]=true
		begin
			cache.set("#{@my_id}[#{unlocked_id}]",@data[unlocked_id])
		rescue => err
			eerror("Unlocking: #{err}")
		end
		notify_clients(unlocked_id)
		#else the row was locked and removed. we do not unlock it
	end
end

#unsubscribe(client_id) ⇒ Object 



614
615
616
617
 
# File 'lib/DrbDB/DrbListModel.rb', line 614

def unsubscribe(client_id)
edebug("unsubscribing: #{client_id}")
@clients.delete(client_id)
end

#update(notifier, ids = nil, rnick = nil) ⇒ Object 



280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
 
# File 'lib/DrbDB/DrbListModel.rb', line 280

def update(notifier,ids=nil,rnick=nil)
	before_update=Time.now
	before=Time.now
	if ids
		if ids=='last' || ids == ["last"]
			begin
					sql=@drbdb.select_last(eval("\"#{querysql}\""),@list_key)
					edebug(sql)
				rescue =>err
					eerror("update last: #{err}\n#{querysql}")
					@drbdb.report_mail("update last: #{err}",{'self'=>self.inspect,'error'=>err.inspect,'query'=>querysql.inspect,'backtrace'=>err.backtrace.join("\n")})
			end
		else
			ids=[ids] if ids.class != Array
			begin
#						sql=eval("\"select * from (#{querysql}) as the_query where #{@list_key} in (#{ids.join(',')})\"")
					s=@drbdb.add_where("#{querysql}","#{@list_key} in (#{ids.join(',')})")
#						edebug("query:#{s}")
					sql=eeval("\"#{@drbdb.escape_string(s)}\"")
#						edebug("query:#{sql}")
				rescue =>err
					eerror("update #{ids.inspect}: #{err}\n#{querysql}")
					@drbdb.report_mail("update ids:#{ids.inspect}",{'self'=>self.inspect,'error'=>err.inspect,'query'=>querysql.inspect,'backtrace'=>err.backtrace.join("\n")})
			end
		end
		else
			begin
					sql=eeval("\"#{@drbdb.escape_string(querysql)}\"") #'
				rescue =>err
					@drbdb.report_mail("update full: #{err}",{'self'=>self.inspect,'error'=>err.inspect,'query'=>querysql.inspect,'backtrace'=>err.backtrace.join("\n")})
			end
	end
	begin
		qres=@drbdb.rows(sql,true) if sql
	rescue =>err
		eerror("update: #{err}\n#{sql}")
		@drbdb.report_mail("update: #{err}",{'self'=>self.inspect,'error'=>err.inspect,'query'=>querysql.inspect,'backtrace'=>err.backtrace.join("\n")})
	end

	sql_time_diff=Time.now.to_f-before.to_f

	if qres then
		unless ids
			@data.clear
			@rowcount=0 
		end
		last_ids=nil
		before=Time.now
		qres.each{|row|
			last_ids=[row[@list_key].to_i] if ids == "last" || ids == ["last"]
			#warning about wrongly implemented queries, which force us to overwrite rows
			ewarn("overwriting row ##{row[@list_key].to_i}:#{@data[row[@list_key].to_i].inspect}") if @data.has_key?(row[@list_key].to_i) and ids.class.name != "Array"
			#history
			row_backup=if !rnick.nil? && @data.has_key?(row[@list_key].to_i) then @data[row[@list_key].to_i].clone else nil end
			#preserve row insensitivity(lock state)
			row_insens=@data.has_key?(row[@list_key].to_i) ? @data[row[@list_key].to_i][@column_of_sensitive] : true
			@data[row[@list_key].to_i]=Hash.new
			iter=@data[row[@list_key].to_i]
			headers.each_value{|header|
				if row.has_key?(header['data'])
					iter[header['model_col']]=
						case header['type']
							when 'gtk_toggle','TrueClass' then row[header['data']]=='true'
							when 'gtk_int','Integer','gtk_invisible_int','Bignum','gtk_duration','gtk_timestamp' then row[header['data']].to_i
							when 'gtk_float','gtk_progress' then row[header['data']].to_f
							when 'gtk_pixbuf' then row[header['data']].to_i #we hold only ids here
							else
								row[header['data']]
						end
					#prepare background color
					if @column_of_background == header['model_col'] && iter[@column_of_background].class == String
						cl=iter[@column_of_background].split(":")
						iter[@column_of_background]=cl[0]
						@background_legend[cl[0]]=cl[1]
					end
					#prepare foreground color
					if @column_of_foreground == header['model_col'] && iter[@column_of_foreground].class == String
						cl=iter[@column_of_foreground].split(":") 
						iter[@column_of_foreground]=cl[0]
						@foreground_legend[cl[0]]=cl[1]
					end
					#history
					unless row_backup.nil?
						if header.has_key?("id") && row_backup[header['model_col']] != iter[header['model_col']]
							store_history(rnick,row[@list_key],"u",header['id'],row_backup[header['model_col']])
						end
					end
				end
			}
			#history
			store_history(rnick,row[@list_key],"i") if row_backup.nil? and !rnick.nil?
			#defaults
			iter[@column_of_sensitive]=row_insens
			iter[@column_of_visible]=false
			iter[@column_of_iter_depth]=0 if @tree_key
			@rowcount+=1 unless ids
		}
		
		#store fore and background legends
		cache.set("#{@my_id}foreground",@foreground_legend)
		cache.set("#{@my_id}background",@background_legend)
		
		if ids and qres.size == 0
			edebug("removed #{ids.inspect}")
			#we were called to load_data of a non existing id, which means it was deleted
			ids.each{|id_to_remove|
				@data.delete(id_to_remove.to_i);
				einfo("removing from cache: #{id_to_remove.inspect}")
				begin
					cache.delete("#{@my_id}[#{id_to_remove}]")
				rescue Memcached::NotFound
				end
				@rowcount-=1;
				store_history(rnick,id_to_remove,"d") unless rnick.nil?
			}
		end
	end
	download_time_diff=Time.now.to_f-before.to_f
	before=Time.now
	if @tree_key
		#set up the iter depth, for tree building
		if ids.nil?
			#full reload
			@data.each_value{|row| set_iter_depth(row)}
			else
			#set iter_depth for all recursive children
			set_children_depth(ids)
		end
	end
	tree_prep_time_diff=Time.now.to_f-before.to_f
	before=Time.now
	if @tree_key
		keys=Array.new
		tree_sorted.each{|row| keys.push(row[@column_of_id])}
		else
		keys=@data.keys
	end

		if ids.nil?
			@data.each{|key,row| 
				cache.set("#{@my_id}[#{key}]",row)
			}
			else
			ids.each{|iid|
				cache.set("#{@my_id}[#{iid}]",@data[iid])
			}
		end
	cache.set("#{@my_id}[ids]",keys)
	
	cache_time_diff=Time.now.to_f-before.to_f
	
	ids=last_ids unless last_ids.nil?
	update_time_diff=Time.now.to_f-before_update.to_f
	einfo("loaded #{if ids then ids.inspect else @rowcount end}/#{@data.size} in q:"+sprintf("%.1fs",sql_time_diff)+",d:"+sprintf("%.1fs",download_time_diff)+",t:"+sprintf("%.1fs",tree_prep_time_diff)+",c:"+sprintf("%.1fs",cache_time_diff)+"/"+sprintf("%.1fs",update_time_diff)) unless @drbdb.main_server.starting_up
	notify_clients(ids)
	ids
end