From 9a94aa04a6047dabc98d837fb2b32a164263a0c3 Mon Sep 17 00:00:00 2001 From: Duncan Mac-Vicar P Date: Wed, 6 Jun 2007 11:58:17 +0000 Subject: [PATCH] Not needed --- zypp2/cache/schema/schema.h | 236 -------------------------------- zypp2/cache/schema/schema_filelist1.sql | 11 -- zypp2/cache/schema/schema_filelist2.sql | 16 --- zypp2/cache/schema/schema_filelist3.sql | 9 -- zypp2/cache/schema/sql2c.rb | 45 ------ 5 files changed, 317 deletions(-) delete mode 100644 zypp2/cache/schema/schema.h delete mode 100644 zypp2/cache/schema/schema_filelist1.sql delete mode 100644 zypp2/cache/schema/schema_filelist2.sql delete mode 100644 zypp2/cache/schema/schema_filelist3.sql delete mode 100755 zypp2/cache/schema/sql2c.rb diff --git a/zypp2/cache/schema/schema.h b/zypp2/cache/schema/schema.h deleted file mode 100644 index 4c6097b..0000000 --- a/zypp2/cache/schema/schema.h +++ /dev/null @@ -1,236 +0,0 @@ -char** getsql() { - static char *sql[] = { - "CREATE TABLE db_info (" - " version INTEGER" - ");", - - "CREATE TABLE resolvables (" - " id INTEGER AUTO INCREMENT" - " , name TEXT" - " , version TEXT" - " , release TEXT" - " , epoch INTEGER" - " , arch INTEGER" - " , kind INTEGER" - " , summary TEXT" - " , description TEXT" - " , insnotify TEXT" - " , delnotify TEXT" - " , license_to_confirm TEXT" - " , vendor TEXT" - " , size INTEGER" - " , archive_size INTEGER" - " , repository INTEGER" - " , repository_media_nr INTEGER" - " , install_only INTEGER" - " , build_time INTEGER" - " , install_time INTEGER" - " , PRIMARY KEY (id)" - ");", - - "CREATE TABLE dependencies (" - " resolvable_id INTEGER REFERENCES resolvable(id)" - " , dep_type INTEGER" - " , name TEXT" - " , version TEXT" - " , release TEXT" - " , epoch INTEGER" - " , arch INTEGER" - " , relation INTEGER" - " , dep_target INTEGER" - ");", - - "CREATE TABLE message_details (" - " resolvable_id INTEGER REFERENCES resolvable(id)" - " , text TEXT" - ");", - - "CREATE TABLE repositories (" - " id INTEGER" - " , alias TEXT NOT NULL" - " , url TEXT" - " , description TEXT" - " , enabled INTEGER" - " , autorefresh INTEGER" - " , type VARCHAR(20)" - " , cache_dir TEXT" - " , path TEXT" - " , PRIMARY KEY (id)" - ");", - - "CREATE TABLE patch_details (" - " id INTEGER" - " , resolvable_id INTEGER REFERENCES resolvables (id)" - " , patch_id TEXT" - " , timestamp INTEGER" - " , category TEXT" - " , reboot_needed INTEGER" - " , affects_package_manager INTEGER" - " , PRIMARY KEY (id)" - ");", - - "CREATE TABLE pattern_details (" - " id INTEGER" - " , resolvable_id INTEGER REFERENCES resolvables (id)" - " , user_default INTEGER" - " , user_visible INTEGER" - " , pattern_category TEXT" - " , icon TEXT" - " , script TEXT" - " , pattern_order TEXT" - " , PRIMARY KEY (id)" - ");", - - "CREATE TABLE product_details (" - " id INTEGER" - " , resolvable_id INTEGER REFERENCES resolvables (id)" - " , category TEXT" - " , vendor TEXT" - " , release_notes_url TEXT" - " , update_urls TEXT" - " , extra_urls TEXT" - " , optional_urls TEXT" - " , flags TEXT" - " , short_name TEXT" - " , long_name TEXT" - " , distribution_name TEXT" - " , distribution_edition TEXT" - " , PRIMARY KEY (id)" - ");", - - "CREATE TABLE script_details (" - " id INTEGER" - " , resolvable_id INTEGER REFERENCES resolvables (id)" - " , do_script TEXT" - " , undo_script TEXT" - " , PRIMARY KEY (id)" - ");", - - "CREATE TABLE package_details (" - " resolvable_id INTEGER REFERENCES resolvables (id)" - " , checksum TEXT" - " , changelog TEXT" - " , buildhost TEXT" - " , distribution TEXT" - " , license TEXT" - " , packager TEXT" - " , package_group TEXT" - " , url TEXT" - " , os TEXT" - " , prein TEXT" - " , postin TEXT" - " , preun TEXT" - " , postun TEXT" - " , source_size INTEGER" - " , authors TEXT" - " , filenames TEXT" - " , location TEXT" - ");", - - "CREATE TABLE locks (" - " id INTEGER" - " , name TEXT" - " , version TEXT" - " , release TEXT" - " , epoch INTEGER" - " , arch INTEGER" - " , relation INTEGER" - " , repository TEXT" - " , glob TEXT" - " , importance INTEGER" - " , importance_gteq INTEGER" - " , PRIMARY KEY (id)" - ");", - - "CREATE VIEW messages" - " AS SELECT * FROM resolvables, message_details" - " WHERE resolvables.id = message_details.resolvable_id;", - - "CREATE VIEW packages" - " AS SELECT * FROM resolvables, package_details" - " WHERE resolvables.id = package_details.resolvable_id;", - - "CREATE VIEW patches" - " AS SELECT * FROM resolvables, patch_details" - " WHERE resolvables.id = patch_details.resolvable_id;", - - "CREATE VIEW patterns AS SELECT * FROM resolvables, pattern_details" - " WHERE resolvables.id = pattern_details.resolvable_id;", - - "CREATE VIEW products AS" - " SELECT * FROM resolvables, product_details" - " WHERE resolvables.id = product_details.resolvable_id;", - - "CREATE VIEW scripts AS" - " SELECT * FROM resolvables, script_details" - " WHERE resolvables.id = script_details.resolvable_id;", - - "CREATE TABLE delta_packages (" - " id INTEGER" - " , package_id INTEGER REFERENCES packages(id)" - " , media_nr INTEGER" - " , location TEXT" - " , checksum TEXT" - " , download_size INTEGER" - " , build_time INTEGER" - " , baseversion_version TEXT" - " , baseversion_release TEXT" - " , baseversion_epoch INTEGER" - " , baseversion_checksum TEXT" - " , baseversion_build_time INTEGER" - " , baseversion_sequence_info TEXT" - ");", - - "CREATE TABLE patch_packages (" - " id INTEGER" - " , package_id INTEGER REFERENCES packages(id)" - " , media_nr INTEGER" - " , location TEXT" - " , checksum TEXT" - " , download_size INTEGER" - " , build_time INTEGER" - ");", - - "CREATE TABLE patch_packages_baseversions (" - " patch_package_id INTEGER REFERENCES patch_packages(id)" - " , version TEXT" - " , release TEXT" - " , epoch INTEGER" - ");", - - "CREATE INDEX dependency_resolvable ON dependencies (resolvable_id);", - - "CREATE INDEX package_details_resolvable_id ON package_details (resolvable_id);", - - "CREATE INDEX resolvable_repository ON resolvables (repository);", - - "CREATE TRIGGER remove_repositories" - " AFTER DELETE ON repositories" - " BEGIN" - " DELETE FROM resolvables WHERE repository = old.id;" - " END;", - - "CREATE TRIGGER remove_patch_packages_baseversions" - " AFTER DELETE ON patch_packages" - " BEGIN" - " DELETE FROM patch_packages_baseversions WHERE patch_package_id = old.id;" - " END;", - - "CREATE TRIGGER remove_resolvables" - " AFTER DELETE ON resolvables" - " BEGIN" - " DELETE FROM package_details WHERE resolvable_id = old.id;" - " DELETE FROM patch_details WHERE resolvable_id = old.id;" - " DELETE FROM pattern_details WHERE resolvable_id = old.id;" - " DELETE FROM product_details WHERE resolvable_id = old.id;" - " DELETE FROM message_details WHERE resolvable_id = old.id;" - " DELETE FROM script_details WHERE resolvable_id = old.id;" - " DELETE FROM dependencies WHERE resolvable_id = old.id;" - " DELETE FROM files WHERE resolvable_id = old.id;" - " DELETE FROM delta_packages WHERE package_id = old.id;" - " DELETE FROM patch_packages WHERE package_id = old.id;" - " END;", - - 0}; - return sql; -} diff --git a/zypp2/cache/schema/schema_filelist1.sql b/zypp2/cache/schema/schema_filelist1.sql deleted file mode 100644 index 2290f9d..0000000 --- a/zypp2/cache/schema/schema_filelist1.sql +++ /dev/null @@ -1,11 +0,0 @@ - -DROP TABLE IF EXISTS files; - - -CREATE TABLE files ( - package_id INTEGER NOT NULL - , name TEXT UNIQUE - , PRIMARY KEY (package_id, name) -); - -CREATE INDEX files_name ON files (name); diff --git a/zypp2/cache/schema/schema_filelist2.sql b/zypp2/cache/schema/schema_filelist2.sql deleted file mode 100644 index 1ab40e5..0000000 --- a/zypp2/cache/schema/schema_filelist2.sql +++ /dev/null @@ -1,16 +0,0 @@ - -DROP TABLE IF EXISTS files; -DROP TABLE IF EXISTS dir; - -CREATE TABLE dirs ( - id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL - , name TEXT UNIQUE -); - -CREATE TABLE files ( - dir_id INTEGER NOT NULL REFERENCES dir(id) - , package_id INTEGER NOT NULL - , name TEXT - , PRIMARY KEY (package_id, dir_id, name) -); - diff --git a/zypp2/cache/schema/schema_filelist3.sql b/zypp2/cache/schema/schema_filelist3.sql deleted file mode 100644 index c163ec6..0000000 --- a/zypp2/cache/schema/schema_filelist3.sql +++ /dev/null @@ -1,9 +0,0 @@ - -DROP TABLE IF EXISTS file_entries; - -CREATE TABLE file_entries ( - id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL - , package_id INTEGER - , dir TEXT UNIQUE - , files TEXT -); diff --git a/zypp2/cache/schema/sql2c.rb b/zypp2/cache/schema/sql2c.rb deleted file mode 100755 index 8781e1c..0000000 --- a/zypp2/cache/schema/sql2c.rb +++ /dev/null @@ -1,45 +0,0 @@ -#!/usr/bin/ruby - -class String - def trim(margin=nil) - s = self.dup - # Remove initial blank line. - s.sub!(/\A[ \t]*\n/, "") - # Get rid of the margin, if it's specified. - unless margin.nil? - margin_re = Regexp.escape(margin || "") - margin_re = /^[ \t]*#{margin_re} ?/ - s.gsub!(margin_re, "") - end - # Remove trailing whitespace on each line - s.gsub!(/[ \t]+$/, "") - s - end -end - -if ARGV.size != 1 - puts "Usage: sql2c.rb filename.sql" - exit -end - -filename = ARGV[0] - -puts "char** getsql() {" -puts " static char *sql[] = {" - -File.open(filename, "r") do | f | - f.each_line do |line| - l = line.chomp.trim - next if l == "" - newline = " \"#{l}\"" - lastchar = newline[newline.size - 2, 1] -#puts "#{lastchar}" - (newline = newline + ",\n\n") if ( lastchar == ";") - puts newline - end -end - -puts " 0};" - -puts " return sql;" -puts "}" -- 2.7.4