Class: SiSU_DbTuple::LoadDocuments

Inherits:
Object
  • Object
show all
Includes:
SiSU_Param
Defined in:
lib/sisu/db_load_tuple.rb

Direct Known Subclasses

SiSU_DbDBI::LoadDocuments

Instance Method Summary collapse

Constructor Details

#initialize(conn, col, opt, file_maint) ⇒ LoadDocuments

Returns a new instance of LoadDocuments.



60
61
62
63
64
65
66
67
68
69
 
# File 'lib/sisu/db_load_tuple.rb', line 60

def initialize(conn,col,opt,file_maint)
  @conn,@col,@opt,@file_maint=conn,col,opt,file_maint
  @col[:lev]=@col[:lev].to_i
  unless @col[:lev].inspect=~/^[0-7]/ \
  or @col[:lev]==0..7
    @col[:lev]=9
  end
  @col[:ocn]=0 unless @col[:ocn].inspect=~/\d+/
  @cX=SiSU_Screen::Ansi.new(@opt.act[:color_state][:set]).cX
end

Instance Method Details

#tuple ⇒ Object

% import line



70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
 
# File 'lib/sisu/db_load_tuple.rb', line 70

def tuple                                                                    #% import line
  sql_entry=if @col[:en_a]
    "INSERT INTO doc_objects (lid, metadata_tid, lev, lev_an, clean, body, book_idx, ocn, ocnd, ocns, seg, lev0, lev1, lev2, lev3, lev4, lev5, lev6, lev7, en_a, en_z, t_of, t_is, node, parent, digest_clean, digest_all) " +
    "VALUES (#{@col[:lid]}, #{@col[:tid]}, #{@col[:lev]}, '#{@col[:lev_an]}', '#{@col[:plaintext]}', '#{@col[:body]}', '#{@col[:book_idx]}', '#{@col[:ocn]}', '#{@col[:ocnd]}', '#{@col[:ocns]}', '#{@col[:seg]}', '#{@col[:lv0]}', '#{@col[:lv1]}', '#{@col[:lv2]}', '#{@col[:lv3]}', '#{@col[:lv4]}', '#{@col[:lv5]}', '#{@col[:lv6]}', '#{@col[:lv7]}', '#{@col[:en_a]}', '#{@col[:en_z]}', '#{@col[:t_of]}', '#{@col[:t_is]}', '#{@col[:node]}', '#{@col[:parent]}', '#{@col[:digest_clean]}', '#{@col[:digest_all]}');"
  else
    "INSERT INTO doc_objects (lid, metadata_tid, lev, lev_an, clean, body, book_idx, ocn, ocnd, ocns, seg, lev0, lev1, lev2, lev3, lev4, lev5, lev6, lev7, t_of, t_is, node, parent, digest_clean, digest_all) " +
    "VALUES (#{@col[:lid]}, #{@col[:tid]}, #{@col[:lev]}, '#{@col[:lev_an]}', '#{@col[:plaintext]}', '#{@col[:body]}', '#{@col[:book_idx]}', '#{@col[:ocn]}', '#{@col[:ocnd]}', '#{@col[:ocns]}', '#{@col[:seg]}', '#{@col[:lv0]}', '#{@col[:lv1]}', '#{@col[:lv2]}', '#{@col[:lv3]}', '#{@col[:lv4]}', '#{@col[:lv5]}', '#{@col[:lv6]}', '#{@col[:lv7]}', '#{@col[:t_of]}', '#{@col[:t_is]}', '#{@col[:node]}', '#{@col[:parent]}', '#{@col[:digest_clean]}', '#{@col[:digest_all]}');"
  end
  if @opt.act[:verbose_plus][:set]==:on
    if @opt.act[:maintenance][:set]==:on
      puts @file_maint.inspect
      puts sql_entry
    end
    @file_maint.puts sql_entry
  else
    if @opt.act[:verbose_plus][:set]==:on
      puts sql_entry
      @file_maint.puts sql_entry
    end
  end
  if @opt.act[:verbose][:set]==:on
    if @col[:lev].inspect =~/[0-35-7]/
      lev=case @col[:lev].inspect
      when /0/ then ':A'
      when /1/ then ':B'
      when /2/ then ':C'
      when /3/ then ':D'
      when /5/ then ' 2'
      when /6/ then ' 3'
      when /7/ then ' 4'
      end
      puts %{#{lev}>\t#{@col[:lv0]}\t#{@col[:lv1]}\t#{@col[:lv2]}\t#{@col[:lv3]}\t#{@col[:lv4]}\t#{@col[:lv5]}\t#{@col[:lv6]}\t#{@col[:lv7]}\t#{@col[:ocn]}\t#{@col[:node]}\t#{@col[:ocns]}}
    elsif @col[:lev].inspect =~/[4]/
      puts %{ #{@cX.green}1>#{@cX.off}\t#{@col[:lv0]}\t#{@col[:lv1]}\t#{@col[:lv2]}\t#{@col[:lv3]}\t#{@col[:lv4]}\t#{@col[:lv5]}\t#{@col[:lv6]}\t#{@col[:lv7]}\t#{@col[:ocn]}\t#{@col[:node]}\t#{@col[:ocns]}\t#{@col[:seg]}}
    end
  end
  sql_entry
end