From 26767cc88c0548ad7978021796d0ccc4c9f7ffed Mon Sep 17 00:00:00 2001
From: Ralph Amissah <ralph.amissah@gmail.com>
Date: Sat, 2 Jun 2007 11:27:06 +0100
Subject: 0.53.0, pre-build, see changelog, library naming changed for scm,
 placed under v0 (instead of 0.53)

---
 lib/sisu/v0/db_drop.rb | 124 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 124 insertions(+)
 create mode 100644 lib/sisu/v0/db_drop.rb

(limited to 'lib/sisu/v0/db_drop.rb')

diff --git a/lib/sisu/v0/db_drop.rb b/lib/sisu/v0/db_drop.rb
new file mode 100644
index 00000000..5a6a28a0
--- /dev/null
+++ b/lib/sisu/v0/db_drop.rb
@@ -0,0 +1,124 @@
+=begin
+ * Name: SiSU information Structuring Universe - Structured information, Serialized Units
+ * Author: Ralph Amissah
+   * http://www.jus.uio.no/sisu
+   * http://www.jus.uio.no/sisu/SiSU/download.html
+
+ * Description: modules shared by the different db types, dbi, postgresql, sqlite
+
+ * Copyright (C) 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007 Ralph Amissah
+
+ * License: GPL 2 or later
+
+  Summary of GPL 2
+
+  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 2 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, write to the Free Software Foundation, Inc.,
+  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
+
+  If you have Internet connection, the latest version of the GPL should be
+  available at these locations:
+    http://www.fsf.org/licenses/gpl.html
+    http://www.gnu.org/copyleft/gpl.html
+    http://www.jus.uio.no/sisu/gpl2.fsf
+
+  SiSU was first released to the public on January 4th 2005
+
+  SiSU uses:
+
+  *  Standard SiSU markup syntax,
+  *  Standard SiSU meta-markup syntax, and the
+  *  Standard SiSU object citation numbering and system
+
+  © Ralph Amissah 1997, current 2007.
+  All Rights Reserved.
+
+ * Ralph Amissah: ralph@amissah.com
+                  ralph.amissah@gmail.com
+=end
+module SiSU_DB_drop
+  class Drop
+    def initialize(opt,conn='',sql_type='')
+      @opt,@conn,@sql_type=opt,conn,sql_type
+    end
+    def drop_tables                                                              #% drop all tables
+      begin
+        case @sql_type
+        when /sqlite/
+          cascade=''
+          commit=@conn.commit
+        else
+          cascade='CASCADE'
+          commit=''
+        end
+        @conn.do(%{
+          DROP TABLE metadata #{cascade};
+          DROP TABLE documents #{cascade};
+          DROP TABLE endnotes #{cascade};
+          DROP TABLE endnotes_asterisk #{cascade};
+          DROP TABLE endnotes_plus #{cascade};
+          DROP TABLE urls #{cascade};
+        })
+        commit
+      rescue
+      end
+    end
+    def drop_indexes                                                             #% drop all indexes
+      #@conn.do(%{
+      #  DROP INDEX object_nr ON documents(ocn);
+      #  DROP INDEX body ON documents(body);
+      #  DROP INDEX clean ON documents(clean);
+      #  DROP INDEX lev1 ON documents(lev1);
+      #  DROP INDEX lev2 ON documents(lev2);
+      #  DROP INDEX lev3 ON documents(lev3);
+      #  DROP INDEX lev4 ON documents(lev4);
+      #  DROP INDEX lev5 ON documents(lev5);
+      #  DROP INDEX lev6 ON documents(lev6);
+      #  DROP INDEX endnote_nr ON endnotes(nr);
+      #  DROP INDEX endnote ON endnotes(body);
+      #  DROP INDEX title ON metadata(title);
+      #  DROP INDEX filename ON metadata(filename)
+      #  /*
+      #  DROP INDEX object_nr ON documents(ocn) CASCADE;
+      #  DROP INDEX body ON documents(body) CASCADE;
+      #  DROP INDEX clean ON documents(clean) CASCADE;
+      #  DROP INDEX lev1 ON documents(lev1) CASCADE;
+      #  DROP INDEX lev2 ON documents(lev2) CASCADE;
+      #  DROP INDEX lev3 ON documents(lev3) CASCADE;
+      #  DROP INDEX lev4 ON documents(lev4) CASCADE;
+      #  DROP INDEX lev5 ON documents(lev5) CASCADE;
+      #  DROP INDEX lev6 ON documents(lev6) CASCADE;
+      #  DROP INDEX endnote_nr ON endnotes(nr) CASCADE;
+      #  DROP INDEX endnote ON endnotes(body) CASCADE;
+      #  DROP INDEX title ON metadata(title) CASCADE;
+      #  DROP INDEX filename ON metadata(filename) CASCADE
+      #  */
+      #})
+    end
+    def db_help                                                                  #% help
+      puts    %{
+        not yet implemented
+        init createall
+        createtable
+        recreate\t(destroy and create)
+        createlex\t()
+        createmetadata\t()
+        import\t(import data)
+        index\t(create index)
+        droptables\t(where tables made and content imported)
+        dropall\t(where tables made, content imported and tables indexed)
+      }
+    end
+  end
+end
+__END__
-- 
cgit v1.2.3