class SiSU_DbIndex::Index
Public Class Methods
new(opt,conn,file,sql_type)
click to toggle source
# File lib/sisu/db_indexes.rb, line 57 def initialize(opt,conn,file,sql_type) @opt,@conn,@file,@sql_type=opt,conn,file,sql_type end
Public Instance Methods
base()
click to toggle source
# File lib/sisu/db_indexes.rb, line 96 def base if (@opt.act[:verbose_plus][:set]==:on \ || @opt.act[:maintenance][:set]==:on) print "\n create documents common indexes\n" end sql_arr=[ %{CREATE INDEX idx_ocn ON doc_objects(ocn);}, %{CREATE INDEX idx_digest_clean ON doc_objects(digest_clean);}, %{CREATE INDEX idx_digest_all ON doc_objects(digest_all);}, %{CREATE INDEX idx_lev0 ON doc_objects(lev0);}, %{CREATE INDEX idx_lev1 ON doc_objects(lev1);}, %{CREATE INDEX idx_lev2 ON doc_objects(lev2);}, %{CREATE INDEX idx_lev3 ON doc_objects(lev3);}, %{CREATE INDEX idx_lev4 ON doc_objects(lev4);}, %{CREATE INDEX idx_lev5 ON doc_objects(lev5);}, %{CREATE INDEX idx_lev6 ON doc_objects(lev6);}, %{CREATE INDEX idx_endnote_nr ON endnotes(nr);}, %{CREATE INDEX idx_digest_en ON endnotes(digest_clean);}, %{CREATE INDEX idx_endnote_nr_asterisk ON endnotes_asterisk(nr);}, %{CREATE INDEX idx_endnote_asterisk ON endnotes_asterisk(clean);}, %{CREATE INDEX idx_digest_en_asterisk ON endnotes_asterisk(digest_clean);}, %{CREATE INDEX idx_endnote_nr_plus ON endnotes_plus(nr);}, %{CREATE INDEX idx_endnote_plus ON endnotes_plus(clean);}, %{CREATE INDEX idx_digest_en_plus ON endnotes_plus(digest_clean);}, %{CREATE INDEX idx_title ON metadata_and_text(title);}, %{CREATE INDEX idx_author ON metadata_and_text(creator_author);}, %{CREATE INDEX idx_filename ON metadata_and_text(src_filename);}, %{CREATE INDEX idx_language ON metadata_and_text(language_document_char);}, %{CREATE INDEX idx_topics ON metadata_and_text(classify_topic_register)}, ] conn_execute_array(sql_arr) end
conn_execute_array(sql_arr)
click to toggle source
# File lib/sisu/db_indexes.rb, line 75 def conn_execute_array(sql_arr) begin @conn.transaction do |conn| sql_arr.each do |sql| conn_execute_sql(conn,sql) end end rescue if @conn.is_a?(NilClass) errmsg="No sqlite3 connection (check sqlite3 dependencies)" if @opt.act[:no_stop][:set]==:on SiSU_Utils::CodeMarker.new(__LINE__,__FILE__,:fuchsia). error("#{errmsg}, proceeding without sqlite output (as requested)") else SiSU_Utils::CodeMarker.new(__LINE__,__FILE__,:fuchsia). error("#{errmsg}, STOPPING") exit end end end end
conn_execute_sql(conn,sql)
click to toggle source
# File lib/sisu/db_indexes.rb, line 67 def conn_execute_sql(conn,sql) if @sql_type==:pg conn_execute_sql_pg(conn,sql) elsif @sql_type==:sqlite conn_execute_sql_sqlite(conn,sql) else end end
conn_execute_sql_pg(conn,sql)
click to toggle source
# File lib/sisu/db_indexes.rb, line 61 def conn_execute_sql_pg(conn,sql) conn.exec_params(sql) end
conn_execute_sql_sqlite(conn,sql)
click to toggle source
# File lib/sisu/db_indexes.rb, line 64 def conn_execute_sql_sqlite(conn,sql) conn.execute(sql) end
create_indexes()
click to toggle source
# File lib/sisu/db_indexes.rb, line 60 def create_indexes # check added from pg not tested def conn_execute_sql_pg(conn,sql) conn.exec_params(sql) end def conn_execute_sql_sqlite(conn,sql) conn.execute(sql) end def conn_execute_sql(conn,sql) if @sql_type==:pg conn_execute_sql_pg(conn,sql) elsif @sql_type==:sqlite conn_execute_sql_sqlite(conn,sql) else end end def conn_execute_array(sql_arr) begin @conn.transaction do |conn| sql_arr.each do |sql| conn_execute_sql(conn,sql) end end rescue if @conn.is_a?(NilClass) errmsg="No sqlite3 connection (check sqlite3 dependencies)" if @opt.act[:no_stop][:set]==:on SiSU_Utils::CodeMarker.new(__LINE__,__FILE__,:fuchsia). error("#{errmsg}, proceeding without sqlite output (as requested)") else SiSU_Utils::CodeMarker.new(__LINE__,__FILE__,:fuchsia). error("#{errmsg}, STOPPING") exit end end end end def base if (@opt.act[:verbose_plus][:set]==:on \ || @opt.act[:maintenance][:set]==:on) print "\n create documents common indexes\n" end sql_arr=[ %{CREATE INDEX idx_ocn ON doc_objects(ocn);}, %{CREATE INDEX idx_digest_clean ON doc_objects(digest_clean);}, %{CREATE INDEX idx_digest_all ON doc_objects(digest_all);}, %{CREATE INDEX idx_lev0 ON doc_objects(lev0);}, %{CREATE INDEX idx_lev1 ON doc_objects(lev1);}, %{CREATE INDEX idx_lev2 ON doc_objects(lev2);}, %{CREATE INDEX idx_lev3 ON doc_objects(lev3);}, %{CREATE INDEX idx_lev4 ON doc_objects(lev4);}, %{CREATE INDEX idx_lev5 ON doc_objects(lev5);}, %{CREATE INDEX idx_lev6 ON doc_objects(lev6);}, %{CREATE INDEX idx_endnote_nr ON endnotes(nr);}, %{CREATE INDEX idx_digest_en ON endnotes(digest_clean);}, %{CREATE INDEX idx_endnote_nr_asterisk ON endnotes_asterisk(nr);}, %{CREATE INDEX idx_endnote_asterisk ON endnotes_asterisk(clean);}, %{CREATE INDEX idx_digest_en_asterisk ON endnotes_asterisk(digest_clean);}, %{CREATE INDEX idx_endnote_nr_plus ON endnotes_plus(nr);}, %{CREATE INDEX idx_endnote_plus ON endnotes_plus(clean);}, %{CREATE INDEX idx_digest_en_plus ON endnotes_plus(digest_clean);}, %{CREATE INDEX idx_title ON metadata_and_text(title);}, %{CREATE INDEX idx_author ON metadata_and_text(creator_author);}, %{CREATE INDEX idx_filename ON metadata_and_text(src_filename);}, %{CREATE INDEX idx_language ON metadata_and_text(language_document_char);}, %{CREATE INDEX idx_topics ON metadata_and_text(classify_topic_register)}, ] conn_execute_array(sql_arr) end def text if (@opt.act[:verbose_plus][:set]==:on \ || @opt.act[:maintenance][:set]==:on) print "\n create documents TEXT indexes\n" end sql_arr=[ %{CREATE INDEX idx_clean ON doc_objects(clean);}, %{CREATE INDEX idx_endnote ON endnotes(clean);} ] conn_execute_array(sql_arr) end base @opt.act[:psql][:set]==:on ? '' : text end
text()
click to toggle source
# File lib/sisu/db_indexes.rb, line 128 def text if (@opt.act[:verbose_plus][:set]==:on \ || @opt.act[:maintenance][:set]==:on) print "\n create documents TEXT indexes\n" end sql_arr=[ %{CREATE INDEX idx_clean ON doc_objects(clean);}, %{CREATE INDEX idx_endnote ON endnotes(clean);} ] conn_execute_array(sql_arr) end