module SiSU_DbAction
-
Name:
SiSU
** 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