Class: RubyCurses::ResultsetTextView

Inherits:
TextView
  • Object
show all
Defined in:
lib/rbcurse/experimental/widgets/resultsettextview.rb

Overview

An extension of textview that allows viewing a resultset, one record at a time, paging records.

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(form = nil, config = {}, &block) ⇒ ResultsetTextView

Returns a new instance of ResultsetTextView.



44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 44

def initialize form = nil, config={}, &block
  @row_offset = @col_offset = 1 
  @row = 0
  @col = 0
  @should_show_focus = false # don;t show focus and unfocus by default
  @list = [] # this is only the currently visible record
  @rows = nil  # this is the entire resultset
  @old_record = @current_record = 0 # index of currently displayed record from resultset
  @editing_allowed = true
  super
  @win = @graphic
  @datatypes = nil; # to be set when we query data, an array one for each column

  @widget_scrolled = true
  @record_changed = false

  @help_text = "C to edit a column, Navigation: M-lhjk,jk gg G, Space. Next Record M-period or period, Previous M-comma or comma. Last Record '>' First Record '<' <Enter> View sortable tabular view"
  bind(:PRESS){ |eve| 
    s = eve.source
    r = s.current_record
    col = @columns[@current_index]
    #alert "You clicked on #{r} , #{col} , #{eve.text} "
    #edit_record 
  }
  #@selected_attrib = 'standout'
  #@focussed_attrib = 'underline'
end

Instance Attribute Details

#current_record ⇒ Object

The offset of the current record in the resultset, starting 0



28
29
30
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 28

def current_record
  @current_record
end

Instance Method Details

#color_field(index) ⇒ Object 



438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 438

def color_field index
  return unless index
  _r,c = rowcol
  r = _convert_index_to_printable_row index
  return unless r
  # paint field portion separately, take care of when panned
  # hl only field length, not whole thing.
  startpoint = [c+14+1-@pcol,c].max # don't let it go < 0
  clen = @lens[index]
  # take into account when we've scrolled off right
  clen -= @pcol-14-1 if 14+1-@pcol < 0
  hlwidth = [clen,@width-@internal_width-14-1+@pcol, @width-@internal_width].min
  hlwidth = 0 if hlwidth < 0

  @graphic.mvchgat(y=r, x=startpoint, hlwidth, Ncurses::A_NORMAL, @fieldbgcolor, nil)
end

#columns=(list) ⇒ Object 



188
189
190
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 188

def columns=(list)
  @columns = list
end

#current_value ⇒ Object

not sure what to return, returning data value



234
235
236
237
238
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 234

def current_value
  return nil if @list.nil? || @rows.nil?
  #@list[@current_record][@current_index]
  @rows[@current_record][@current_index]
end

#data=(list) ⇒ Object 



185
186
187
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 185

def data=(list)
  @rows = list
end

#datatypes=(list) ⇒ Object

set array of datatypes, one per column



192
193
194
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 192

def datatypes=(list)
  @datatypes = list
end

#DELprint_focussed_row(type, r = nil, c = nil, content = nil, acolor = nil) ⇒ Object

the idea here is to be able to call externally or from loop However, for that content has to be truncated here, not in loop



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
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 456

def DELprint_focussed_row type,  r=nil, c=nil, content=nil, acolor=nil
  return unless @should_show_focus
  case type
  when :FOCUSSED
    r = _convert_index_to_printable_row() unless r
    attrib = @focussed_attrib || 'bold'
    ix = @current_index

  when :UNFOCUSSED
    return if @oldrow.nil? || @oldrow == @current_index
    r = _convert_index_to_printable_row(@oldrow) unless r
    return unless r # row is not longer visible
    ix = @oldrow
    attrib = @attr
  end
  unless c
    _r, c = rowcol
  end
  if content.nil?
    content = @list[ix]
    content = content.dup
    sanitize content if @sanitization_required
    truncate content
  end
  acolor ||= get_color $datacolor
  #@graphic.printstring r+hh, c+@left_margin, "%-*s" % [@width-@internal_width,content], acolor, @focussed_attrib || 'bold'
  @graphic.printstring r, c+@left_margin, "%-*s" % [@width-@internal_width, content], acolor, attrib
end

#disp_menu ⇒ Object

this is just a test of the simple “most” menu How can application add to this, or override



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
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 555

def disp_menu  #:nodoc:
  require 'rbcurse/extras/widgets/menutree'
  # we need to put this into data-structure so that i can be manipulated by calling apps
  # This should not be at the widget level, too many types of menus. It should be at the app
  # level only if the user wants his app to use this kind of menu.

  @menu = RubyCurses::MenuTree.new "Main", { s: :goto_start, r: :scroll_right, l: :scroll_left, m: :submenu }
  @menu.submenu :m, "submenu", {s: :noignorecase, t: :goto_last_position, f: :next3 }
  menu = PromptMenu.new self 
  menu.menu_tree @menu

=begin
  menu = PromptMenu.new self 
  menu.add( menu.create_mitem( 's', "Goto start ", "Going to start", Proc.new { goto_start} ))
  menu.add(menu.create_mitem( 'r', "scroll right", "I have scrolled ", :scroll_right ))
  menu.add(menu.create_mitem( 'l', "scroll left", "I have scrolled ", :scroll_left ))
  item = menu.create_mitem( 'm', "submenu", "submenu options" )
  menu1 = PromptMenu.new( self, "Submenu Options")
  menu1.add(menu1.create_mitem( 's', "CASE sensitive", "Ignoring Case in search" ))
  menu1.add(menu1.create_mitem( 't', "goto last position", "moved to previous position", Proc.new { goto_last_position} ))
  item.action = menu1
  menu.add(item)
  # how do i know what's available. the application or window should know where to place
  #menu.display @form.window, 23, 1, $datacolor #, menu
=end
  menu.display @form.window, $error_message_row, $error_message_col, $datacolor #, menu
end

#edit_record ⇒ Object 



71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 71

def edit_record
    unless @editing_allowed
      say "You clicked on #{r} , #{col} , #{eve.text}. If editing_allowed was true you could have modified the db "
      return
    end
    col = @columns[@current_index]
    text = @rows[@current_record][@current_index]
    value = ask("Edit #{col}: "){ |q| q.default = text }
    if value && value != "" && value != text
      @rows[@current_record][@current_index] = value
      @widget_scrolled = true # force repaint of data
      begin
        sql_update @tablename, id=@rows[@current_record][0], col, value
        say_with_wait "Update to database successful"
      rescue => err
        alert "UPDATE ERROR:#{err.to_s} "
      end
    else
      say_with_pause "Editing aborted", :color_pair => $errorcolor
    end
end

#fire_action_event ⇒ Object 



239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 239

def fire_action_event
  if @current_index == @selected_index
    @old_selected_index = @current_index
    unhighlight_row @current_index
    color_field @current_index 
    @selected_index = nil
    return
  end
  unhighlight_row @selected_index
  color_field @selected_index 
  @selected_index = @current_index
  highlight_selected_row
  @old_selected_index = @selected_index
  @repaint_required = true
  super
  tabular
end

#first_record ⇒ Object 



134
135
136
137
138
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 134

def first_record
  @old_record = @current_record
  @record_changed = true
  @current_record = 0; @repaint_required = true
end

#get_content ⇒ Object

prepares row data for paint to print Creates a string for each row, which is great for textview operation, all of them 

work just fine. But does not allow paint to know what part is title and what is 
data



321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 321

def get_content
  return nil unless @rows
  id = @current_record

  row = @rows[id]
  @lens = []
  a = []
  f = "%14s %-*s"
  #f = "%14s %-20s"
  @columns.each_with_index { |e, i| 
    value = row[i]
    len = value.to_s.length
    type = @datatypes[i]
    if type == "TEXT"
      value = value.gsub(/\n/," ") if value
    end
    @lens << len
    a << f % [e, len,  value]
  }
  @list = a # this keeps it compatible with textview operations. 
  return a
end

#getvalue ⇒ Object 



230
231
232
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 230

def getvalue
  @list
end

#handle_key(ch) ⇒ Object

:nodoc:



256
257
258
259
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 256

def handle_key ch #:nodoc:
  return :UNHANDLED if @rows.nil?
  super
end

#highlight_focussed_row(type, r = nil, c = nil, acolor = nil) ⇒ Object 



499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 499

def highlight_focussed_row type, r=nil, c=nil, acolor=nil
  return unless @should_show_focus
  case type
  when :FOCUSSED
    r = _convert_index_to_printable_row() unless r
    attrib = @focussed_attrib || 'bold'
    ix = @current_index

  when :UNFOCUSSED
    return if @oldrow.nil? || @oldrow == @current_index
    r = _convert_index_to_printable_row(@oldrow) unless r
    return unless r # row is not longer visible
    ix = @oldrow
    attrib = @attr
  end
  unless c
    _r, c = rowcol
  end
  acolor ||= get_color $datacolor
  att = get_attrib(attrib) #if @focussed_attrib
  @graphic.mvchgat(y=r, x=c, @width-@internal_width, att , acolor , nil)
  #@graphic.printstring r, c+@left_margin, "%-*s" % [@width-@internal_width,content], acolor, @focussed_attrib || 'reverse'
end

#highlight_selected_row(r = nil, c = nil, acolor = nil) ⇒ Object

this only highlights the selcted row, does not print data again so its safer and should be used instead of print_selected_row



487
488
489
490
491
492
493
494
495
496
497
498
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 487

def highlight_selected_row r=nil, c=nil, acolor=nil
  return unless @selected_index # no selection
  r = _convert_index_to_printable_row(@selected_index) unless r
  return unless r # not on screen
  unless c
    _r, c = rowcol
  end
  acolor ||= get_color $datacolor
  att = FFI::NCurses::A_REVERSE
  att = get_attrib(@selected_attrib) if @selected_attrib
  @graphic.mvchgat(y=r, x=c, @width-@internal_width, att , acolor , nil)
end

#is_row_selected(row) ⇒ Object 



534
535
536
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 534

def is_row_selected row
  @selected_index == row
end

#last_record ⇒ Object 



129
130
131
132
133
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 129

def last_record
  @old_record = @current_record
  @record_changed = true
  @current_record = @rows.count-1; @repaint_required = true
end

#map_keys ⇒ Object 



139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 139

def map_keys
  super
  bind_key([?\C-x, ?6], :scroll_backward)
  bind_key([?\C-x, ?v], :scroll_forward)
  bind_key([?\C-x, ?n], :next_record) 
  bind_key([?\C-x, ?p], :previous_record) 
  bind_keys([?\M-,,?,], :previous_record ) 
  bind_keys([?\M-.,?.], :next_record) 
  bind_keys([?\M-<,?<], :first_record ) 
  bind_keys([?\M->,?>], :last_record) 
  bind_key('C', :edit_record) 
  #bind_key([?\C-x, ?>], :scroll_right)
  #bind_key([?\C-x, ?<], :scroll_left)
  #bind_key([?\C-x, ?\C-s], :saveas)
  #bind_key(?r) { getstr("Enter a word: ") }
  #bind_key(?m, :disp_menu)
end

#next_record(num = (($multiplier.nil? or $multiplier == 0) ? 1 : $multiplier)) ⇒ Object 



111
112
113
114
115
116
117
118
119
120
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 111

def next_record num=(($multiplier.nil? or $multiplier == 0) ? 1 : $multiplier)
  @old_record = @current_record
  @record_changed = true
  num.times {
    @current_record += 1 if @current_record < @rows.count-1; 
  }
  
  @repaint_required = true
  $multiplier = 0
end

#on_enter_row(arow) ⇒ Object 



537
538
539
540
541
542
543
544
545
546
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 537

def on_enter_row arow
  if @should_show_focus
    highlight_focussed_row :FOCUSSED
    unless @oldrow == @selected_index
      highlight_focussed_row :UNFOCUSSED
      color_field @oldrow
    end
  end
  super
end

#on_leave_row(arow) ⇒ Object

no such method in superclass !!! XXX FIXME no such event too



548
549
550
551
552
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 548

def on_leave_row arow
  #print_focussed_row :UNFOCUSSED
  #print_normal_row
  #super
end

#paint ⇒ Object

NOTE: earlier print_border was called only once in constructor, but when + a window is resized, and destroyed, then this was never called again, so the + border would not be seen in splitpane unless the width coincided exactly with + what is calculated in divider_location.



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
437
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 348

def paint  #:nodoc:

  $log.debug "XXX TEXTVIEW PAINT HAPPENING #{@current_index} "
  #@left_margin ||= @row_selected_symbol.length
  @left_margin = 0
  @fieldbgcolor ||= get_color($datacolor,@bgcolor, 'cyan')
  my_win = nil
  if @form
    my_win = @form.window
  else
    my_win = @target_window
  end
  @graphic = my_win unless @graphic
  @win_left = my_win.left
  @win_top = my_win.top

  print_borders if (@suppress_borders == false && @repaint_all) # do this once only, unless everything changes
  maxlen = @maxlen || @width-@internal_width
  #$log.debug " #{@name} textview repaint width is #{@width}, height is #{@height} , maxlen #{maxlen}/ #{@maxlen}, #{@graphic.name} roff #{@row_offset} coff #{@col_offset}" 
  tm = get_content
  return unless tm  # no data
  rc = tm.size # row_count
  tr = @toprow
  acolor = get_color $datacolor
  h = scrollatrow() 
  r,c = rowcol
  @longest_line = @width-@internal_width #maxlen
            $log.debug "XXX: SELECTED ROW IS  #{@selected_index} "
  0.upto(h) do |hh|
    crow = tr+hh
    if crow < rc
          focussed = @current_index == crow  # row focussed ?
          selected = is_row_selected crow
          content = tm[crow]
          content = content.dup
          sanitize content if @sanitization_required
          truncate content

          @graphic.printstring r+hh, c+@left_margin, "%-*s" % [@width-@internal_width,content], acolor, @attr

          if selected
            #print_selected_row r+hh, c+@left_margin, content, acolor
            highlight_selected_row r+hh, c
            #@graphic.printstring r+hh, c+@left_margin, "%-*s" % [@width-@internal_width,content], acolor, @focussed_attrib || 'reverse'
          elsif focussed
            # i am keeping this here just since sometimes repaint gets called
            highlight_focussed_row :FOCUSSED, r+hh, c
          end
            #print_focussed_row :FOCUSSED, nil, nil, content, acolor
            #@graphic.printstring r+hh, c+@left_margin, "%-*s" % [@width-@internal_width,content], acolor, @focussed_attrib || 'bold'

          color_field crow
=begin
          # paint field portion separately, take care of when panned
          # hl only field length, not whole thing.
          startpoint = [c+14+1-@pcol,c].max # don't let it go < 0
          clen = @lens[crow]
          # take into account when we've scrolled off right
          clen -= @pcol-14-1 if 14+1-@pcol < 0
          hlwidth = [clen,@width-@internal_width-14-1+@pcol, @width-@internal_width].min
          hlwidth = 0 if hlwidth < 0
          
          @graphic.mvchgat(y=r+hh, x=startpoint, hlwidth, Ncurses::A_NORMAL, @fieldbgcolor, nil)
          #@graphic.mvchgat(y=r+hh, x=startpoint, hlwidth, Ncurses::A_BOLD, acolor, nil)
=end
        
          # highlighting search results.
          if @search_found_ix == tr+hh
            if !@find_offset.nil?
              # handle exceed bounds, and if scrolling
              if @find_offset1 < maxlen+@pcol and @find_offset > @pcol
                  @graphic.mvchgat(y=r+hh, x=c+@find_offset-@pcol, @find_offset1-@find_offset, Ncurses::A_NORMAL, $reversecolor, nil)
                end
              end
            end
    else
      # clear rows
      @graphic.printstring r+hh, c, " " * (@width-@internal_width), acolor,@attr
    end

  end
  @repaint_required = false
  @repaint_footer_required = true
  @repaint_all = false 
  # 2011-10-13 
  @widget_scrolled = false
  @record_changed = false
  @old_pcol = @pcol

end

#previous_record(num = (($multiplier.nil? or $multiplier == 0) ? 1 : $multiplier)) ⇒ Object 



121
122
123
124
125
126
127
128
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 121

def previous_record num=(($multiplier.nil? or $multiplier == 0) ? 1 : $multiplier)
  @old_record = @current_record
  @record_changed = true
  num.times {
    @current_record -= 1 if @current_record > 0 ; 
  }
  @repaint_required = true
end

#print_foot ⇒ Object

:nodoc:



216
217
218
219
220
221
222
223
224
225
226
227
228
229
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 216

def print_foot #:nodoc:
  return unless @rows
  @footer_attrib ||= Ncurses::A_DIM
  gb = get_color($datacolor, 'green','black')
  footer = "%15s" % " [#{@current_record+1}/ #{@rows.length} ]"
  $log.debug " print_foot calling printstring with #{@row} + #{@height} -1, #{@col}+2"
  pos = @col + 2
  right = true
  if right
    pos = @col + @width - footer.length - 1
  end
  @graphic.printstring( @row + @height -1 , pos, footer, gb, @footer_attrib) 
  @repaint_footer_required = false # 2010-01-23 22:55 
end

#remove_all ⇒ Object 



195
196
197
198
199
200
201
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 195

def remove_all
  $log.warn "ResultsetTextView remove_all not yet tested XXX"
  @list = []
  @rows = []
  init_vars
  @repaint_required = true
end

#repaint ⇒ Object

textview :nodoc:



203
204
205
206
207
208
209
210
211
212
213
214
215
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 203

def repaint # textview :nodoc:
  #$log.debug "TEXTVIEW repaint r c #{@row}, #{@col} "  
  $log.debug "RESULTSETTEXTVIEW repaint r c #{@row}, #{@col}, key: #{$current_key}, reqd #{@repaint_required} "  

  # TRYING OUT dangerous 2011-10-13 
  @repaint_required = false
  @repaint_required = true if @widget_scrolled || @pcol != @old_pcol || @record_changed


  paint if @repaint_required

  print_foot if @print_footer && !@suppress_borders && @repaint_footer_required
end

#repaint_all(tf) ⇒ Object 



107
108
109
110
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 107

def repaint_all tf
  super
  @widget_scrolled = true
end

#set_content(list, columns) ⇒ Object

send in a dataset (array of arrays) and array of column names e.g. set_content File.open(“README.txt”,“r”).readlines set wrap at time of passing :WRAP_NONE :WRAP_WORD XXX if we widen the textview later, as in a vimsplit that data will still be wrapped at this width !!



178
179
180
181
182
183
184
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 178

def set_content list, columns
  @rows = list
  @columns = columns
  @current_record = 0
  init_vars
  self
end

#set_form_col(col1 = @curpos) ⇒ Object

newly added to check curpos when moving up or down set cursor on correct column tview



294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 294

def set_form_col col1=@curpos #:nodoc:
  @cols_panned ||= 0
  @pad_offset ||= 0 # added 2010-02-11 21:54 since padded widgets get an offset.
  @curpos = col1
  maxlen = @maxlen || @width-@internal_width
  #@curpos = maxlen if @curpos > maxlen
  if @curpos > maxlen
    @pcol = @curpos - maxlen
    @curpos = maxlen - 1
    @repaint_required = true # this is required so C-e can pan screen
  else
    @pcol = 0
  end
  # the rest only determines cursor placement
  win_col = 0 # 2010-02-07 23:19 new cursor stuff
  col2 = win_col + @col + @col_offset + @curpos + @cols_panned + @pad_offset
  $log.debug "TV SFC #{@name} setting c to #{col2} #{win_col} #{@col} #{@col_offset} #{@curpos} "
  #@form.setrowcol @form.row, col
  setrowcol nil, col2
  @repaint_footer_required = true
end

#sql_update(table, id, field, value) ⇒ Object

update a row from bugs based on id, giving one fieldname and value I need to know keyfields for 2 reasons , disallow update and use in update XXX

Examples:

sql_update “bugs”, 9, :name, “Roger”

Parameters:

  • id (Fixnum) —

    unique key

  • fieldname (String)
  • value (String) —

    to update



99
100
101
102
103
104
105
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 99

def sql_update table, id, field, value
  # 2010-09-12 11:42 added to_s to now, due to change in sqlite3 1.3.x
  alert "No database connection" unless @db
  return unless @db
  ret = @db.execute( "update #{table} set #{field} = ? where id = ?", [value, id])
  $log.debug "SQLITE ret value : #{ret}, #{table} #{field} #{id} #{value}  "
end

#sqlite(dbname, table, sql) ⇒ Object

connect to database, run sql and set data, columns and datatypes Similar can be done with another database



158
159
160
161
162
163
164
165
166
167
168
169
170
171
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 158

def sqlite dbname, table, sql
  raise "App error: file not found: #{dbname} " unless File.exist? dbname
  require 'sqlite3'
  db = SQLite3::Database.new(dbname)
  columns, *rows = db.execute2(sql)
  @db = db # for update
  @dbname = dbname
  @tablename = table
  $log.debug "XXX sql #{sql}, #{rows.count}  "
  content = rows
  return nil if content.nil? or content[0].nil?
  self.datatypes = content[0].types 
  set_content rows, columns
end

#tabular ⇒ Object 



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
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 260

def tabular
  require 'rbcurse/core/widgets/tabularwidget'
  w = Ncurses.COLS
  h = Ncurses.LINES-1
  v_window = VER::Window.new(h,w,0,0)
  v_form = RubyCurses::Form.new v_window
  tabula = TabularWidget.new v_form, :width => w, :height => h-1, :print_footer => true
  begin
    tabula.set_content @rows, @columns
    yield tabula if block_given? 
    v_form.repaint
    v_window.wrefresh
    Ncurses::Panel.update_panels
    # allow closing using q and Ctrl-q in addition to any key specified
    #  user should not need to specify key, since that becomes inconsistent across usages
    while((ch = v_window.getchar()) != ?\C-q.getbyte(0) )
      break if ch == config[:close_key] || ch == ?q.ord
      # if you've asked for RETURN then i also check for 10 and 13
      break if (ch == 10 || ch == 13) && config[:close_key] == KEY_RETURN
      v_form.handle_key ch
      #v_form.repaint
      v_window.wrefresh
    end
  rescue => err
      $log.error " Tabularwidget Resultsetview ERROR #{err} "
      $log.error(err.backtrace.join("\n"))
    alert err.to_s

  ensure
    v_window.destroy if !v_window.nil?
  end
end

#unhighlight_row(index, r = nil, c = nil, acolor = nil) ⇒ Object 



522
523
524
525
526
527
528
529
530
531
532
533
 
# File 'lib/rbcurse/experimental/widgets/resultsettextview.rb', line 522

def unhighlight_row index,  r=nil, c=nil, acolor=nil
  return unless index # no selection
  r = _convert_index_to_printable_row(index) unless r
  return unless r # not on screen
  unless c
    _r, c = rowcol
  end
  acolor ||= get_color $datacolor
  att = FFI::NCurses::A_NORMAL
  att = get_attrib(@normal_attrib) if @normal_attrib
  @graphic.mvchgat(y=r, x=c, @width-@internal_width, att , acolor , nil)
end