module SiSU_DbAction

** Description: documents, structuring, processing, publishing, search *** modules shared by the different db types, dbi, postgresql, sqlite

** Author: Ralph Amissah

[ralph@amissah.com]
[ralph.amissah@gmail.com]

** Copyright: (C) 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006,

2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016 Ralph Amissah,
All Rights Reserved.

** License: GPL 3 or later:

SiSU, a framework for document structuring, publishing and search

Copyright (C) Ralph Amissah

This program is free software: you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation, either version 3 of the License, or (at your option)
any later version.

This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.

You should have received a copy of the GNU General Public License along with
this program. If not, see [http://www.gnu.org/licenses/].

If you have Internet connection, the latest version of the GPL should be
available at these locations:
[http://www.fsf.org/licensing/licenses/gpl.html]
[http://www.gnu.org/licenses/gpl.html]

** SiSU uses:

* Standard SiSU markup syntax,
* Standard SiSU meta-markup syntax, and the
* Standard SiSU object citation numbering and system

** Hompages:

[http://www.jus.uio.no/sisu]
[http://www.sisudoc.org]

** Git

[http://git.sisudoc.org/gitweb/?p=code/sisu.git;a=summary]
[http://git.sisudoc.org/gitweb/?p=code/sisu.git;a=blob;f=lib/sisu/db_select.rb;hb=HEAD]

Public Instance Methods

create() click to toggle source
# File lib/sisu/db_select.rb, line 69
def create
  @sdb[:create].output_dir?
  begin
    @sdb[:create].create_table.metadata_and_text
    @sdb[:create].create_table.doc_objects
    @sdb[:create].create_table.endnotes
    @sdb[:create].create_table.endnotes_asterisk
    @sdb[:create].create_table.endnotes_plus
    @sdb[:create].create_table.urls
    @sdb[:index].create_indexes
  rescue
    SiSU_Errors::Rescued.new($!,$@,'--sqlite').location
    @sdb[:create].output_dir? do
      __LINE__.to_s + ':' + __FILE__
    end
  end
end
createdb() click to toggle source
# File lib/sisu/db_select.rb, line 58
def createdb
  @sdb[:create].output_dir?
  begin
    @sdb[:create].create_db
  rescue
    @sdb[:create].output_dir?
  end
end
db_action(sdb) click to toggle source
# File lib/sisu/db_select.rb, line 56
def db_action(sdb)
  @sdb=sdb
  def createdb
    @sdb[:create].output_dir?
    begin
      @sdb[:create].create_db
    rescue
      @sdb[:create].output_dir?
    end
  end
  def drop
    @sdb[:drop].drop.tables
  end
  def create
    @sdb[:create].output_dir?
    begin
      @sdb[:create].create_table.metadata_and_text
      @sdb[:create].create_table.doc_objects
      @sdb[:create].create_table.endnotes
      @sdb[:create].create_table.endnotes_asterisk
      @sdb[:create].create_table.endnotes_plus
      @sdb[:create].create_table.urls
      @sdb[:index].create_indexes
    rescue
      SiSU_Errors::Rescued.new($!,$@,'--sqlite').location
      @sdb[:create].output_dir? do
        __LINE__.to_s + ':' + __FILE__
      end
    end
  end
  def import
    db_exist?
    @sdb[:import].marshal_load
    tell=case @sql_type
    when :sqlite
      SiSU_Screen::Ansi.new(
        @opt.act[:color_state][:set],
        "sqlite3 #{@db.sqlite.db} database?"
      )
    when :pg
      SiSU_Screen::Ansi.new(
        @opt.act[:color_state][:set],
        "pgaccess or psql #{@db.psql.db} database?"
      )
    else '???'
    end
    tell.puts_grey if @opt.act[:verbose][:set]==:on
  end
  def remove
    db_exist?
    @sdb[:remove_doc].remove
  end
  def update
    remove
    import
  end
  self
end
drop() click to toggle source
# File lib/sisu/db_select.rb, line 66
def drop
  @sdb[:drop].drop.tables
end
import() click to toggle source
# File lib/sisu/db_select.rb, line 86
def import
  db_exist?
  @sdb[:import].marshal_load
  tell=case @sql_type
  when :sqlite
    SiSU_Screen::Ansi.new(
      @opt.act[:color_state][:set],
      "sqlite3 #{@db.sqlite.db} database?"
    )
  when :pg
    SiSU_Screen::Ansi.new(
      @opt.act[:color_state][:set],
      "pgaccess or psql #{@db.psql.db} database?"
    )
  else '???'
  end
  tell.puts_grey if @opt.act[:verbose][:set]==:on
end
remove() click to toggle source
# File lib/sisu/db_select.rb, line 104
def remove
  db_exist?
  @sdb[:remove_doc].remove
end
update() click to toggle source
# File lib/sisu/db_select.rb, line 108
def update
  remove
  import
end