class SiSU_DbTuple::LoadDocuments

Public Class Methods

new(conn,col,opt,file_maint) click to toggle source
# 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

Public Instance Methods

tuple() click to toggle source
# 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