Class: ListModel

Inherits:
Object
  • Object
show all
Includes:
Conf, DRbUndumped, ManqodCommon
Defined in:
lib/ListHolder/EditableList/DrbListModel.rb

Overview

this file is part of manqod manqod is distributed under the CDDL licence the author of manqod is Dobai-Pataky Balint([email protected])

Constant Summary

Constants included from ManqodCommon

ManqodCommon::CRITICAL, ManqodCommon::DEBUG, ManqodCommon::ERROR, ManqodCommon::INFO, ManqodCommon::NORMAL, ManqodCommon::WARNING

Constants included from Eprint

Eprint::DOMAIN, Eprint::LEVEL

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Conf

#get_conf, #load_conf, #save_conf, #set_conf

Methods included from ManqodCommon

#add_where, #admin, #admin_cache, #admin_qrow, #admin_rows, #backtrace_to_debug, #cache, #changed_ids_of_base, #client, #client_fields, #client_image_of_id, #client_qrow, #client_query, #client_rows, #eeval, #escape_string, #getBinding, #guess_base, #guess_table, #image_of_id, #lzero, #manqod_db, #measure, #myexec, #nick, #nick_id, #number_format, #qrow, #query, #reconnect_manqod_db, #rows, #run_events, #send_message, #sendmail, #set_manqod_db_uri, #set_nick

Methods included from Eprint

#ecode, #edebug, #eerror, #einfo, #enormal, #eprint, #ewarn, #gtk_set_edebug, #set_edebug, #tell_exception

Constructor Details

#initialize(list) ⇒ ListModel

Returns a new instance of ListModel.



10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 10

def initialize(list)
  @filter=nil
  @data=nil
  @id_index=Hash.new
  @sorter=nil
  @parentselected=nil
  @filtered_rowcount=0
  @rowcount=0
  @rows_loaded=nil
  @show_archive=false
  @list=list
  @remote_model=nil
  @key_parent=nil
  @key_parent2=nil
  @moditem=nil
  @base=nil
  @thread=nil
  @headers=Hash.new
  @headertypes=Array.new
end

Instance Attribute Details

#archive_key ⇒ Object (readonly)

Returns the value of attribute archive_key.



40
41
42
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 40

def archive_key
  @archive_key
end

#background_legend ⇒ Object (readonly)

Returns the value of attribute background_legend.



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

def background_legend
  @background_legend
end

#base ⇒ Object (readonly)

Returns the value of attribute base.



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

def base
  @base
end

#column_of_background ⇒ Object (readonly)

Returns the value of attribute column_of_background.



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

def column_of_background
  @column_of_background
end

#column_of_child_key ⇒ Object (readonly)

Returns the value of attribute column_of_child_key.



37
38
39
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 37

def column_of_child_key
  @column_of_child_key
end

#column_of_child_key2 ⇒ Object (readonly)

Returns the value of attribute column_of_child_key2.



37
38
39
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 37

def column_of_child_key2
  @column_of_child_key2
end

#column_of_foreground ⇒ Object (readonly)

Returns the value of attribute column_of_foreground.



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

def column_of_foreground
  @column_of_foreground
end

#column_of_gantt_duration ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_duration.



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

def column_of_gantt_duration
  @column_of_gantt_duration
end

#column_of_gantt_group ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_group.



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

def column_of_gantt_group
  @column_of_gantt_group
end

#column_of_gantt_group_color ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_group_color.



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

def column_of_gantt_group_color
  @column_of_gantt_group_color
end

#column_of_gantt_partial ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_partial.



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

def column_of_gantt_partial
  @column_of_gantt_partial
end

#column_of_gantt_percentage ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_percentage.



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

def column_of_gantt_percentage
  @column_of_gantt_percentage
end

#column_of_gantt_start ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_start.



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

def column_of_gantt_start
  @column_of_gantt_start
end

#column_of_gantt_successors ⇒ Object (readonly)

Returns the value of attribute column_of_gantt_successors.



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

def column_of_gantt_successors
  @column_of_gantt_successors
end

#column_of_id ⇒ Object (readonly)

Returns the value of attribute column_of_id.



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

def column_of_id
  @column_of_id
end

#column_of_parent_key ⇒ Object (readonly)

Returns the value of attribute column_of_parent_key.



37
38
39
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 37

def column_of_parent_key
  @column_of_parent_key
end

#column_of_parent_key2 ⇒ Object (readonly)

Returns the value of attribute column_of_parent_key2.



37
38
39
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 37

def column_of_parent_key2
  @column_of_parent_key2
end

#column_of_sensitive ⇒ Object (readonly)

Returns the value of attribute column_of_sensitive.



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

def column_of_sensitive
  @column_of_sensitive
end

#column_of_visible ⇒ Object (readonly)

Returns the value of attribute column_of_visible.



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

def column_of_visible
  @column_of_visible
end

#data ⇒ Object

Returns the value of attribute data.



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

def data
  @data
end

#filter ⇒ Object

Returns the value of attribute filter.



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

def filter
  @filter
end

#filtered_rowcount ⇒ Object

Returns the value of attribute filtered_rowcount.



32
33
34
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 32

def filtered_rowcount
  @filtered_rowcount
end

#foreground_legend ⇒ Object (readonly)

Returns the value of attribute foreground_legend.



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

def foreground_legend
  @foreground_legend
end

#headers ⇒ Object (readonly)

Returns the value of attribute headers.



41
42
43
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 41

def headers
  @headers
end

#headertypes ⇒ Object (readonly)

Returns the value of attribute headertypes.



41
42
43
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 41

def headertypes
  @headertypes
end

#key_child ⇒ Object (readonly)

Returns the value of attribute key_child.



38
39
40
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 38

def key_child
  @key_child
end

#key_child2 ⇒ Object (readonly)

Returns the value of attribute key_child2.



38
39
40
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 38

def key_child2
  @key_child2
end

#key_parent ⇒ Object (readonly)

Returns the value of attribute key_parent.



38
39
40
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 38

def key_parent
  @key_parent
end

#key_parent2 ⇒ Object (readonly)

Returns the value of attribute key_parent2.



38
39
40
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 38

def key_parent2
  @key_parent2
end

#list ⇒ Object

Returns the value of attribute list.



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

def list
  @list
end

#list_key ⇒ Object (readonly)

Returns the value of attribute list_key.



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

def list_key
  @list_key
end

#moditem ⇒ Object

Returns the value of attribute moditem.



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

def moditem
  @moditem
end

#parentM ⇒ Object

Returns the value of attribute parentM.



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

def parentM
  @parentM
end

#parentselected ⇒ Object

Returns the value of attribute parentselected.



34
35
36
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 34

def parentselected
  @parentselected
end

#rowcount ⇒ Object (readonly)

Returns the value of attribute rowcount.



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

def rowcount
  @rowcount
end

#rows_loaded ⇒ Object (readonly)

Returns the value of attribute rows_loaded.



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

def rows_loaded
  @rows_loaded
end

#show_archive ⇒ Object (readonly)

Returns the value of attribute show_archive.



40
41
42
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 40

def show_archive
  @show_archive
end

#sorter ⇒ Object (readonly)

Returns the value of attribute sorter.



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

def sorter
  @sorter
end

#thread ⇒ Object (readonly)

Returns the value of attribute thread.



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

def thread
  @thread
end

Instance Method Details

#add_iter ⇒ Object 



631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 631

def add_iter
  if table=guess_table(@querysql,'id')
    sql="insert into #{table}";
    if @key_child
      sql="#{sql} set #{@key_child}="
      if @key_parent=="id"
        sql="#{sql}'#{parentselected}'"
      else
        if parent_header=parentM.headers[@key_parent] and parent_iter=parentM.iter_at_cursor
          sql="#{sql}'#{parent_iter[parent_header["model_col"]]}'"
        end
      end
      sql="#{sql},#{moditem['additional_on_insert']}" if moditem['additional_on_insert'].length>0
    else
      if lastt=@querysql.index('{parentselected}')
        last=@querysql.rindex('=',lastt)-1
        temp1=@querysql[1 .. last]
        first=temp1.rindex(' ')+1
        sql="#{sql} set "+@querysql[first .. last]+"='#{parentselected}'"
        sql=sql+", "+moditem['additional_on_insert'] if moditem['additional_on_insert'].length>0
      else
        if moditem['additional_on_insert'].length>0 
          sql="#{sql} set #{moditem['additional_on_insert']}"
        else 
          sql="#{sql} () VALUES()";
        end
      end
    end
  end
  query(eeval("\"#{sql}\""))
  inserted_id=qrow("select id from #{table} order by id desc limit 1")["id"].to_i
  row_modified(inserted_id)
  inserted_id
end

#alive? ⇒ Boolean

Returns:

  • (Boolean) 


820
821
822
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 820

def alive?
  true
end

#change_value_of_id(iter_id, column_data, new_value) ⇒ Object 



673
674
675
676
677
678
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 673

def change_value_of_id(iter_id, column_data, new_value)
  sql="update #{@base} set #{column_data}='#{new_value}' where #{@list_key}='#{iter_id}' limit 1"
  einfo("changing #{column_data.inspect} to #{new_value.inspect} updatesql: #{sql.inspect}","list")
  query(eeval("\"#{sql}\""))
  row_modified(iter_id)
end

#change_value_of_iter(iter, column_data, new_value) ⇒ Object 



666
667
668
669
670
671
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 666

def change_value_of_iter(iter, column_data, new_value)
  sql="update #{@base} set #{column_data}='#{new_value}' where #{@list_key}='#{iter[column_of_id]}' limit 1"
  einfo("changing #{column_data.inspect} to #{new_value.inspect} updatesql: #{sql.inspect}","list")
  query(eeval("\"#{sql}\""))
  row_modified(iter[column_of_id])
end

#change_value_of_path(path, column_data, new_value) ⇒ Object 



680
681
682
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 680

def change_value_of_path(path, column_data, new_value)
  change_value_of_iter(@sorter.get_iter(path), column_data, new_value)
end

#create_skeleton ⇒ Object 



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
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 170

def create_skeleton
  unless get_id
    edebug("can't update, no list_id set","list","error")
    return
  end
#   list.progress.pulse(list.get_id)
#   @thread=Thread.new{
  begin
    drbmodel.unsubscribe(ManqodRPC.instance.to_s) unless @remote_model.nil?
  rescue => err
    ewarn("server model is gone")
  end
  begin
    @remote_model=manqod_db.moditem(get_id)
  rescue =>err
    eerror(backtrace_to_debug(err),'list')
    if reconnect_manqod_db
      retry
    else
      tell_exception("server is gone")
    end
  end
  @moditem=cache.get("#{get_id}moditem")
  @headers=cache.get("#{get_id}headers")
  @headertypes=cache.get("#{get_id}headertypes")
  moditem_attributes=cache.get("#{get_id}attributes")
  @querysql=moditem_attributes[:querySQL]
  @base=moditem_attributes[:base]
  @list_key=moditem_attributes[:list_key]
  @key_child=moditem_attributes[:child_key]
  @key_parent=moditem_attributes[:parent_key]

  @key_child2=moditem_attributes[:child_key2]
  @key_parent2=moditem_attributes[:parent_key2]
  @tree_key=moditem_attributes[:tree_key]
  @column_of_id=moditem_attributes[:column_of_id]
  @column_of_visible=moditem_attributes[:column_of_visible]
  @column_of_sensitive=moditem_attributes[:column_of_sensitive]
  @column_of_background=moditem_attributes[:column_of_background]
  @column_of_foreground=moditem_attributes[:column_of_foreground]
  @column_of_archive=moditem_attributes[:column_of_archive]
  @column_of_tree_parent=moditem_attributes[:column_of_tree_parent]
  @column_of_tree=moditem_attributes[:column_of_tree]
  @fetch_filter_key=moditem_attributes[:fetch_filter_key]
  @fetch_filter_value=moditem_attributes[:fetch_filter_value]
  @fetch_filter_negate=moditem_attributes[:fetch_filter_negate]
  @column_of_fetch_filter=moditem_attributes[:column_of_fetch_filter]
  @archive_key=moditem_attributes[:archive_key]

  drbmodel.subscribe(ManqodRPC.instance.to_s,self)


  @parentM=list.parentM.get_model if list.parentM
  
  if @tree_key
    @data = Gtk::TreeStore.new(*headertypes)
    else
    @data = Gtk::ListStore.new(*headertypes)
  end

  hdebug="#{hdebug}\nheadertypes: #{headertypes.inspect}\nheaders:[result]order<[editable]>[rgrp_id]\n"
  
  headers.delete_if{|key,val|      
    hdebug="#{hdebug}[#{val['data']}]#{val['model_col']}#{val['editable'] == 'true' ? '[ed]' : ''}[#{val['rgrp_id']}]\n"
    val['rgrp_id'].to_i>0 && !Nick.instance.ingroup_id?(val['rgrp_id'].to_i)
  }
  edebug("#{hdebug}","list")
  @column_of_child_key=nil
  if @key_child && headers.has_key?(@key_child)
    @column_of_child_key=headers[@key_child]["model_col"]
  end
  @column_of_child_key2=nil
  if @key_child2 && headers.has_key?(@key_child2)
    @column_of_child_key2=headers[@key_child2]["model_col"]
  end
  #if child_key defined, but parent_key is not, we set parent_key=parentM.list_key
  @key_parent=parentM.list_key if @key_child && @key_parent.nil?
  #if child_key2 defined, but parent_key2 is not, we set parent_key2='id'
  @key_parent2=parentM.list_key if @key_child2 && @key_parent2.nil?

  @column_of_parent_key=nil
  if @key_parent && parentM && parentM.headers.has_key?(@key_parent)
    @column_of_parent_key=parentM.headers[@key_parent]["model_col"]
  end
  @column_of_parent_key2=nil
  if @key_parent2 && parentM && parentM.headers.has_key?(@key_parent2)
    @column_of_parent_key2=parentM.headers[@key_parent2]["model_col"]
  end
  @filter=Gtk::TreeModelFilter.new(@data)
  @filter.set_visible_column(column_of_visible)
  @sorter=Gtk::TreeModelSort.new(@filter)
  if sortcolumn=get_conf(get_id,0,"sortcolumn") and sortorder=get_conf(get_id,0,"sortorder")
    @sorter.set_sort_column_id(sortcolumn.to_i,sortorder=="asc" ? Gtk::SORT_ASCENDING : Gtk::SORT_DESCENDING)
  end

  if gantt_start=list.gtk_attribute('gantt_start')
    @column_of_gantt_start=headers[gantt_start]
  end
  
  if gantt_duration=list.gtk_attribute('gantt_duration')
    @column_of_gantt_duration=headers[gantt_duration]
  end
  if gantt_successors=list.gtk_attribute('gantt_successors')
    @column_of_gantt_successors=headers[gantt_successors]
  end
  if gantt_group=list.gtk_attribute('gantt_group')
    @column_of_gantt_group=headers[gantt_group]
  end

  if gantt_group=list.gtk_attribute('gantt_group')
    @column_of_gantt_group=headers[gantt_group]
  end
  if gantt_group_color=list.gtk_attribute('gantt_group_color')
    @column_of_gantt_group_color=headers[gantt_group_color]
  end
  if gantt_partial=list.gtk_attribute('gantt_partial')
    @column_of_gantt_partial=headers[gantt_partial]
  end
  if gantt_percentage=list.gtk_attribute('gantt_percentage')
    @column_of_gantt_percentage=headers[gantt_percentage]
  end
  
  @foreground_legend=cache.get("#{get_id}foreground")
  @background_legend=cache.get("#{get_id}background")

  list.set_info("created")
#   }
#   @thread.join
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



138
139
140
141
142
143
144
145
146
147
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 138

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

#data_of_column(colname, lid = list.get_cursor_id) ⇒ Object 



163
164
165
166
167
168
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 163

def data_of_column(colname,lid=list.get_cursor_id)
  ret=nil
  if di=iter_of_id(lid) and col=headers[colname]
    ret=di[col["model_col"]]
  end
end

#display_lock(locked_id) ⇒ Object 



121
122
123
124
125
126
127
128
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 121

def display_lock(locked_id)
  einfo("display lock called for: #{locked_id}")
  if iter=@id_index[locked_id]
    iter[@column_of_sensitive]=drbmodel.data[locked_id][@column_of_sensitive]
    list.changed
    list.notify_observers(list)
  end
end

#drbmodel ⇒ Object 



45
46
47
48
49
50
51
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 45

def drbmodel
  begin
    @remote_model
    rescue =>err
    edebug("error: #{err}\n#{err.backtrace.joint("\n")}\n","list","error")
  end
end

#duplicate_iter(iter_to_dup) ⇒ Object 



623
624
625
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 623

def duplicate_iter(iter_to_dup)
  drbmodel.duplicate_iter(iter_to_dup)
end

#filter_one_iter(iter) ⇒ Object 



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
437
438
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 393

def filter_one_iter(iter)
  if @key_child.nil? || (@key_child && iter[@column_of_child_key] == @current_parent_key) || (@key_child2 && iter[@column_of_child_key2] == @current_parent_key2)
    filter_count=0
    filter_hits=0
    list.columns.each{|column|
        fl=get_conf(get_id,column.header["id"],"filter").to_s.upcase
        case column.header['type']
          when 'gtk_combo', 'gtk_const_combo' then fl = (fl=="-1" or fl=="") ? "" : "=#{fl}"
        end
        #if timestamp, then we convert the comparision data to the timestamp format specified by attributes
        comp=case column.header['type']
          when 'gtk_timestamp' then Time.at(iter[column.header["model_col"]]).strftime(column.timestamp_format).upcase
          else iter[column.header["model_col"]].to_s.upcase
        end

        if fl.length>0
          filter_count=filter_count+1
          filter_hits=filter_hits+
            case column.header['type']
            when 'gtk_int','Integer','gtk_float','gtk_progress','gtk_duration' then
              case fl[0].chr
                when "<" then comp.to_f <  fl[1 .. fl.length].to_f ? 1: 0
                when ">" then comp.to_f >  fl[1 .. fl.length].to_f ? 1: 0
                when "!" then comp.to_f != fl[1 .. fl.length].to_f ? 1: 0
                when "=" then comp.to_f == fl[1 .. fl.length].to_f ? 1: 0
                else comp.to_f == fl[0 .. fl.length].to_f ? 1: 0
              end
            else
              case fl[0].chr
                when "=" then comp == fl[1 .. fl.length] ? 1: 0
                when "<" then comp <  fl[1 .. fl.length] ? 1: 0
                when ">" then comp >  fl[1 .. fl.length] ? 1: 0
                when "!" then comp != fl[1 .. fl.length] ? 1: 0
                else comp.index(fl) ? 1: 0
              end
            end
        end
      } unless list.destroyed?
      iter[column_of_visible]=filter_hits == filter_count
    #make sure parent iters are visible, only when we're tree
    unhide_tree_parent_iters(iter) if @column_of_tree && iter[@column_of_visible]
    else
        iter[@column_of_visible]=false
  end
  iter[@column_of_visible]
end

#from_csv(filename) ⇒ Object 



729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 729

def from_csv(filename)
  separator=(list.gtk_attribute("csv_field_separator") ? list.gtk_attribute("csv_field_separator") : ',')
  skip_header_lines=(list.gtk_attribute("csv_skip_header_lines") ? list.gtk_attribute("csv_skip_header_lines").to_i : 1)
  row_counter=0
  ids=Array.new
  IO.foreach(filename){|line|
    row=line.chomp.split(separator)
    row_counter+=1
    if row_counter > skip_header_lines && row.size>0
      sql="insert into #{base} set"
      comma=false
      #child key auto adding
      if @key_child
        comma=true
        sql="#{sql} #{@key_child}="
        if @key_parent=="id"
          sql="#{sql}'#{parentselected}'"
        else
          if parent_header=parentM.headers[@key_parent] and parent_iter=parentM.iter_at_cursor
            sql="#{sql}'#{parent_iter[parent_header["model_col"]]}'"
          end
        end
      end
      #values
      list.columns.each{|col|
        if c=col.gtk_attribute("csv_column_number")
          sql="#{sql}#{comma ? ",": ""} #{col.header['data']}=\"#{row[c.to_i-1]}\""
          comma=true
        end
      }
      sql="#{sql};" #unless sql.nil?
      sql="#{sql} #{moditem['additional_on_insert']}" if moditem['additional_on_insert'].length>0
      query(sql)
      inserted_id=qrow("select id from #{base} order by id desc limit 1")["id"].to_i
      ids.push(inserted_id)
    end
  }
  drbmodel.rows_changed(ids,nick) if ids.size>0
  edebug("csv loaded","list")
end

#get_id ⇒ Object 



87
88
89
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 87

def get_id
  list.get_id
end

#iter2csv(iter) ⇒ Object 



691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 691

def iter2csv(iter)
  separator=(list.gtk_attribute("csv_field_separator") ? list.gtk_attribute("csv_field_separator") : ',')
  row=""
  list.columns.each{|col|
    case col.header["type"] 
      when "gtk_const_text" then ct=col.renderer.get_display(iter[col.colnum].to_s)
      when "gtk_const_combo","gtk_combo" then ct=col.renderer.get_text_from_value(iter[col.colnum].to_s)
      else
      ct=case col.data_type.to_s
          when "Integer" then number_format(iter[col.colnum],0)
          when "Float" then number_format(iter[col.colnum],2)
          else iter[col.colnum].to_s
      end
    end
    row="#{row}#{ct.to_s}#{separator}"
  }
  row="#{row[0..row.length]}\n"
end

#iter_at_cursor ⇒ Object 



159
160
161
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 159

def iter_at_cursor
  iter_of_id(list.get_cursor_id) if list.get_cursor_id
end

#iter_of_id(id_of_iter) ⇒ Object 



148
149
150
151
152
153
154
155
156
157
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 148

def iter_of_id(id_of_iter)
  found_iter=nil
  @sorter.each{|model,path,iter|
    if iter[@column_of_id] == id_of_iter.to_i
      found_iter=iter
      break
    end
  } if @sorter
  found_iter   
end

#load_data(notifier, ids = nil) ⇒ Object 



446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
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
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 446

def load_data(notifier,ids=nil)
#   @thread=Thread.new{
  ids=[ids] if !ids.nil? and ids.class != Array
  ids.uniq! if ids.class == Array
  edebug("called for data_load for #{ids.inspect} by #{notifier}","list","info")
  begin
      we_have_server=drbmodel.alive?
    rescue => err
      if reconnect_manqod_db
        retry
      else
        tell_exception("server is gone")
      end
  end

  return unless we_have_server

  before=Time.now
  @rows_loaded=0
  @rowcount=drbmodel.rowcount
  ffv=if @fetch_filter_value then eeval(@fetch_filter_value) else nil end
  edebug("fetch-filter: key:#{@fetch_filter_key}, value:#{@fetch_filter_value}=#{ffv}","list")
  if ids.nil?
    list.set_model(nil)
    list.set_info("0")
    @data.clear
    @id_index.clear
    parent_iter=parentM.iter_at_cursor if parentM
    @current_parent_key=if @column_of_parent_key and parent_iter
      parent_iter[@column_of_parent_key]
    end
    @current_parent_key2=if @column_of_parent_key2 and parent_iter
      parent_iter[@column_of_parent_key2]
    end

    list.progress.zero(list.object_id,0,@moditem["display"])

    prep_time=Time.now.to_f-before.to_f
    before=Time.now
    ff=nil
    pkeys=Array.new
#     @thread=Thread.new{
      keys=cache.get("#{@moditem["id"]}[ids]")
      keys.each{|v| pkeys.push("#{@moditem["id"]}[#{v}]")}
      ff=cache.get(pkeys)
      @rowcount=ff ? ff.size : 0
#     }
#     @thread.join

#     ff=drbmodel.filtered_fetch2(ffv,@show_archive)
    fetch_time=Time.now.to_f-before.to_f
    list.progress.zero(list.object_id,@rowcount,@moditem["display"])

    before=Time.now
        pkeys.each{|idx|
          row=ff[idx]
          eerror("row #{idx} is nil!","list") if row.nil?
#             next if !@show_archive && !@column_of_archive.nil? && row[@column_of_archive]
          next unless (@column_of_fetch_filter.nil? || ffv.nil? || 
              (!@fetch_filter_negate && 
                row[@column_of_fetch_filter].to_s == ffv.to_s
              ) || 
              (@fetch_filter_negate && row[@column_of_fetch_filter].to_s != ffv.to_s) 
            ) && row && (@column_of_archive.nil? || (@show_archive || !row[@column_of_archive]))
            #we recieve a row
          iter=if @tree_key then @data.append(@id_index[row[@column_of_tree].to_i]) else @data.append end
          begin
            row.each_pair{|key,val| iter[key]=val}
          rescue =>err
#             eerror("filling row: #{err}\n#{key.inspect}=>#{val}\niter:#{iter.inspect}, row:#{row.inspect}","list")
          end
          @id_index[row[@column_of_id].to_i]=iter
          @rows_loaded+=1
          Thread.new{list.progress.step(list.object_id,@rows_loaded)}
  #        Thread.pass

        } unless ff.nil? #nil if no keys found, the list is empty

    load_time=Time.now.to_f-before.to_f
      t=Time.new
      refilter
      filtert=Time.new.to_f-t.to_f
      update_time=Time.now.to_f-before.to_f
      enormal("total: #{@filtered_rowcount}/#{@rows_loaded}/#{@rowcount} (prep:"+sprintf("%.2fs",prep_time)+",fetch:"+sprintf("%.2fs",fetch_time)+",load:"+sprintf("%.2fs",load_time)+",refilter:"+sprintf("%.2fs",filtert)+")"+sprintf("%.2fs",update_time),"time")
      einfo("data loaded #{ids or 'all rows'}","list")
  else
    ids.each{|row_id|
      begin
        row=cache.get("#{@moditem["id"]}[#{row_id}]")
#           eerror("row #{row_id} is nil!","list") if row.nil?
      #row=drbmodel.data[row_id]
        if row && (@column_of_fetch_filter.nil? || ffv.nil? || 
              (!@fetch_filter_negate && 
                row[@column_of_fetch_filter].to_s == ffv.to_s
              ) || 
              (@fetch_filter_negate && row[@column_of_fetch_filter].to_s != ff_value.to_s) 
            )  && (@column_of_archive.nil? || (@show_archive || !row[@column_of_archive]))
      
        piter=@id_index[row[@column_of_tree].to_i]
        if iter=@id_index[row_id]
          #iter is found
          if iter && iter.parent!=piter
            edebug("current parent:#{iter.parent.inspect}!=new parent:#{piter.inspect} -> we remove iter, so we readd it later, thus reparenting it","list")
            parent_iter=iter.parent
            rec_save_childs(iter)
            iter=nil
            need_to_reload=true
          end
        end
        unless iter=@id_index[row_id]
          edebug("new iter, id:#{row_id.inspect}","list")
          if @tree_key then
            list.set_model(nil) if !piter.nil? and !piter.has_child?
            iter=@data.append(piter)
          else 
            iter=@data.append 
          end
        end

        begin
          row.each_pair{|key,val| iter[key]=val}
        rescue =>err
          edebug("filling one row: #{err}\n iter:#{iter}, row:#{row.inspect}, id:#{row_id}","list","error")
        end
        @id_index[row[@column_of_id].to_i]=iter
        @data.row_changed(iter.path,iter)
        reload_saved_childs if need_to_reload
        refilter(iter)
      else
        edebug("we were called to load_data of a non existing id:#{row_id}, which means it's archive and we don't show archive","list")
        if iter_to_remove=@id_index[row_id]
          data.remove(iter_to_remove)
          @id_index.delete(row_id)
        end
      end
      rescue Memcached::NotFound
        eerror("cache not found: id:[#{row_id}]")
        data.remove(iter_to_remove)
        @id_index.delete(row_id)
      
      rescue => err
        eerror("#{err}\n\t#{err.backtrace.join("\n\t")}")
        #we were called to load_data of a non existing id, which means it's deleted
      end
    }
    gstart=Time.new
    list.set_model(@sorter) if list.model.nil?
    gtime=Time.new.to_f-gstart.to_f
    Gtk.thread_protect{list.scroll_to_cursor}

    update_time=Time.now.to_f-before.to_f
#     edebug("total: #{@filtered_rowcount}/#{@rowcount} "+sprintf("%.2fs",update_time) + +sprintf("%.2fs",gtime),"time","normal")
    edebug("data loaded #{ids.inspect or 'all rows'}","list","info")
  end

#   }
end

#lock_iter(locked_id) ⇒ Object 



91
92
93
94
95
96
97
98
99
100
101
102
103
104
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 91

def lock_iter(locked_id)
  counter=0
  begin
    counter+=1
    manqod_db.lock_id_of_base(@base,locked_id)
  rescue =>err
    resubscribe
    if counter==3
      warn("server is gone",err.to_s,"list",ERROR,false,false)
    else
      retry
    end
  end
end

#locked?(locked_id) ⇒ Boolean

Returns:

  • (Boolean) 


129
130
131
132
133
134
135
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 129

def locked?(locked_id)
  locked=nil
  if iter=@id_index[locked_id]
    locked=!iter[@column_of_sensitive]
  end
  locked
end

#move_down_id(uid) ⇒ Object 



804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 804

def move_down_id(uid)
  ordering=@list.gtk_attribute("ordering")
  if ordering && (ocolh=headers[ordering]) && (iter=iter_of_id(uid))
    ocol=ocolh["model_col"]
    if next_iter=next_sorted_iter(iter) #only if we have next
      if nnext_iter=next_sorted_iter(next_iter)
        #middle of next and nnext
        change_value_of_iter(iter,ordering,(nnext_iter[ocol]+next_iter[ocol])/2.0)
      else
        #next +1
        change_value_of_iter(iter,ordering,next_iter[ocol]+1)
      end
    end
  end
end

#move_up_id(uid) ⇒ Object 



788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 788

def move_up_id(uid)
  ordering=@list.gtk_attribute("ordering")
  if ordering && (ocolh=headers[ordering]) && (iter=iter_of_id(uid))
    ocol=ocolh["model_col"]
    if prev_iter=prev_sorted_iter(iter) #only if we have previous
      if pprev_iter=prev_sorted_iter(prev_iter)
        #middle of prev and pprev
        change_value_of_iter(iter,ordering,(prev_iter[ocol]+pprev_iter[ocol])/2.0)
      else
        #prev -1
        change_value_of_iter(iter,ordering,prev_iter[ocol]-1)
      end
    end
  end
end

#next_sorted_iter(iter) ⇒ Object 



781
782
783
784
785
786
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 781

def next_sorted_iter(iter)
  pp=iter.path
  if pp.next!
    @sorter.get_iter(pp)
  end
end

#prev_sorted_iter(iter) ⇒ Object 



774
775
776
777
778
779
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 774

def prev_sorted_iter(iter)
  pp=iter.path
  if pp.prev!
    @sorter.get_iter(pp)
  end
end

#print_iter(iter) ⇒ Object 



52
53
54
55
56
57
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 52

def print_iter(iter)
  if iter
    headers.each_value{|h| print h['data'],":",iter[h['model_col']]," "}
    print "\n"
  end
end

#print_iter_of_id(id_to_print) ⇒ Object 



66
67
68
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 66

def print_iter_of_id(id_to_print)
  print_iter(iter_of_id(id_to_print))
end

#rec_save_childs(root_iter) ⇒ Object 



604
605
606
607
608
609
610
611
612
613
614
615
616
617
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 604

def rec_save_childs(root_iter)
  @childs_to_readd=Array.new if @childs_to_readd.nil?
  if iter=root_iter.first_child
    loop{
      @childs_to_readd.push(iter[column_of_id])
      prev_iter=iter.clone
      finished=!iter.next!
      rec_save_childs(prev_iter)
      break if finished
    }
  end
  @id_index.delete(root_iter[@column_of_id].to_i)
  @data.remove(root_iter)
end

#refilter(one = nil) ⇒ Object 



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
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 359

def refilter(one=nil)
  edebug("refiltering #{one}")
  if one.nil?
    list.set_model(nil)
    list.progress.zero(list.object_id,@rows_loaded,@moditem["display"])
    @thread=Thread.new{
      r=0
      @data.each{|model, path, iter|
        filter_one_iter(iter)
        r+=1
        list.progress.step(list.object_id,r)
      }
    }
    @thread.join
    einfo("refiltered","list")
    list.set_model(@sorter)
    list.progress.done(list.object_id)
    unless list.destroyed?
      list.scroll_to_cursor
      list.update_tip
      list.caller.list_panel.list_sum.calculate
    end
  else
    filter_one_iter(one)
  end
  
  #update filtered count
  
  @filtered_rowcount=0
  @data.each{|model, path, iter| @filtered_rowcount+=1 if iter[column_of_visible]}
  list.set_info("#{@filtered_rowcount}/#{@rows_loaded}")
  self
end

#reload_saved_childs ⇒ Object 



619
620
621
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 619

def reload_saved_childs
  load_data(self,@childs_to_readd) if @childs_to_readd.class == Array && @childs_to_readd.size>0
end

#remove_iters(iters_to_remove) ⇒ Object 



627
628
629
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 627

def remove_iters(iters_to_remove)
  drbmodel.remove_iters(iters_to_remove,nick)
end

#resubscribe ⇒ Object 



58
59
60
61
62
63
64
65
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 58

def resubscribe
  begin
    @remote_model=manqod_db.moditem(get_id)
    drbmodel.subscribe(ManqodRPC.instance.to_s,self)
  rescue =>err
    retry if warn("can't reconnect to server",err.to_s,"list",ERROR,false,true)
  end
end

#row_modified(modified_id = list.get_cursor_id) ⇒ Object 



684
685
686
687
688
689
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 684

def row_modified(modified_id=list.get_cursor_id)
  edebug("row modified #{modified_id.inspect}","list","info")
  drbmodel.rows_changed(modified_id,nick)
list.set_model(@sorter) if list.model.nil?
list.scroll_to_cursor
end

#set_show_archive(ns) ⇒ Object 



770
771
772
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 770

def set_show_archive(ns)
  @show_archive=ns.to_s == 'true'
end

#to_csv(filename, ids = nil) ⇒ Object 



710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 710

def to_csv(filename,ids=nil)
  file = File.new(filename, "wb+")
  ids=Array.new
  separator=(list.gtk_attribute("csv_field_separator") ? list.gtk_attribute("csv_field_separator") : ',')
  row=""
  list.columns.each{|col|
    row="#{row}#{col.header['header']}#{separator}"
  }
  file.write("#{row[0..row.length]}\n")

  if @list.selection.count_selected_rows > 1
    @list.selection.selected_each{|model, path, iter| file.write(iter2csv(iter))}
    else
    @filter.each{|model,path,iter| file.write(iter2csv(iter))}
  end
  file.close
  edebug("saved","list")
end

#to_s ⇒ Object 



70
71
72
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 70

def to_s
  "model of #{list}"
end

#unhide_tree_parent_iters(iter) ⇒ Object

recursive show parent iters



441
442
443
444
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 441

def unhide_tree_parent_iters(iter)
  iter[@column_of_visible]=true;
  unhide_tree_parent_iters(iter.parent) if iter.parent
end

#unlock_iter(unlocked_id) ⇒ Object 



106
107
108
109
110
111
112
113
114
115
116
117
118
119
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 106

def unlock_iter(unlocked_id)
  counter=0
  begin
    counter+=1
    manqod_db.unlock_id_of_base(@base,unlocked_id)
  rescue =>err
    resubscribe
    if counter==3
      warn("server is gone",err.to_s,"list",ERROR,false,false)
    else
      retry
    end
  end
end

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



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
 
# File 'lib/ListHolder/EditableList/DrbListModel.rb', line 300

def update(notifier,ids=nil,notification_subect=nil)
=begin
notifier is the notifier object
ids is the array of ids which should be reloaded/deleted
notification_subject:
  @column_of: lock/unlock the ids
  "structure": for create_skeleton
  "buttons" : reload the list buttons
  else : load ids
=end

  before=Time.now
  case notifier.class.name
    when 'BarMenuItem'
      #we're main list, menu is notifying
      load_data(notifier)
    when 'MyEditableList'
      #we're sublist
      unless(@parentselected == notifier.get_cursor_id)
        @parentselected=notifier.get_cursor_id
        @current_parent_key=if @column_of_parent_key and parent_iter=parentM.iter_at_cursor
          parent_iter[@column_of_parent_key]
        end

        @current_parent_key2=if @column_of_parent_key2 and parent_iter
          parent_iter[@column_of_parent_key2]
        end
        if @key_child.nil? and !parentM.nil?
          tell_exception("[#{self}] add child_key attribute!","list","warning")
          load_data(notifier)
        end
        refilter
      end
    when 'String'
        case notification_subect
          when @column_of_sensitive
            einfo("lock change recieved: #{ids}","list")
            Gtk.thread_protect{display_lock(ids)}
          when "structure"
            einfo("structure change recieved","list")
            Gtk.thread_protect{@list.create_skeleton}
            Gtk.thread_protect{@list.update(self)}
          when "buttons"
            einfo("button change recieved","list")
            Gtk.thread_protect{list.caller.buttonholder.update(list,true)}
          else
            #no subject, we recieved just ids, so reload them
            einfo("load #{ids.inspect} recieved","list")
            Gtk.thread_protect{load_data(notifier,ids)}
        end
    when 'ListModel','ArchiveButton'
      #it's self
      load_data(self)
    else
      ewarn("unknown notifier #{notifier}[#{notifier.class.name}] for list update","list")
  end
  update_time=Time.now.to_f-before.to_f
  edebug("updateed in "+sprintf("%.2fs",update_time),"time","debug")
end

#wipe ⇒ Object 



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

def wipe
  begin
    drbmodel.unsubscribe(ManqodRPC.instance.to_s) if @remote_model && @remote_model.alive?
  rescue =>err
    eerror("unsubscribing: #{err}","main")
  end
    if @sorter and @sorter.sort_column_id
      edebug("saving model's sortcolumn: #{@sorter.sort_column_id}","config","info")
      set_conf(get_id,0,"sortcolumn",@sorter.sort_column_id[0])
      set_conf(get_id,0,"sortorder",if @sorter.sort_column_id[1]==Gtk::SORT_ASCENDING then "asc" else "desc";end)
    end
end