diff options
author | Ralph Amissah <ralph@amissah.com> | 2008-12-17 20:57:46 -0500 |
---|---|---|
committer | Ralph Amissah <ralph@amissah.com> | 2008-12-20 22:54:44 -0500 |
commit | 2f97cf3f9e13280da9d161d39b8d9b0d66555307 (patch) | |
tree | 07ee35d65bb4d79fc69ccbc7595c08e8635928be /lib/sisu/v0/db_import.rb | |
parent | html & css cosmetic changes (index & concordance), run "sisu -CC"; changelog (diff) |
SiSU's sqlite module still broken for the time being: inconsistent ruby dbi api
for sqlite3, (unable to begin and commit transaction) provide explicit message
problem noted already in v.0.66.2 (2008-04) and last in v.0.66.3 (2008-05)
module (& rb dbi) apparently worked at end 2007 (v.0.62.4) and start of 2008
(v.0.64.0) ... (did not expect broken state to last, sorry)
include maintenance mode info with -M flag
Diffstat (limited to 'lib/sisu/v0/db_import.rb')
-rw-r--r-- | lib/sisu/v0/db_import.rb | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/lib/sisu/v0/db_import.rb b/lib/sisu/v0/db_import.rb index 1e1e25d7..bcdfc497 100644 --- a/lib/sisu/v0/db_import.rb +++ b/lib/sisu/v0/db_import.rb @@ -112,7 +112,15 @@ module SiSU_DB_import tell.print_grey if @opt.cmd =~/v/ case @sql_type when /sqlite/ #fix logic for sqlite ! +#sqlite watch +unless @opt.cmd =~/[MVv]/ + puts "\nSiSU's sqlite module for the time being broken: inconsistent ruby dbi api for sqlite3, (unable to begin and commit transaction)\n".upcase + p @conn.methods.sort + #p "here #{__FILE__} #{__LINE__}" + exit +else #pf_db_import_transaction_open if @opt =~/M/ + #@conn.begin db_import_metadata db_import_documents(@dal_array) db_import_urls(@dal_array,@fnm) #import OID on/off @@ -120,6 +128,14 @@ module SiSU_DB_import #@conn.commit #@conn.close #@conn.disconnect + puts "\nSiSU's sqlite module for the time being broken: inconsistent ruby dbi api for sqlite3, (unable to begin and commit transaction)\n".upcase + p @conn.methods.sort + if @opt.cmd =~/M/ + puts "\n" + @conn.inspect + puts "\nat #{__FILE__} #{__LINE__}" + end + exit +end #sqlite watch else file_exist=@conn.select_one(%{ SELECT metadata.tid FROM metadata WHERE metadata.filename ~ '#{@opt.fns}'; }) @@ -129,6 +145,10 @@ module SiSU_DB_import db_import_documents(@dal_array) db_import_urls(@dal_array,@fnm) #import OID on/off @conn.execute('COMMIT') + if @opt.cmd =~/[MV]/ + puts "\n" + @conn.inspect + puts "\nat #{__FILE__} #{__LINE__}" + end else @db=SiSU_Env::Info_db.new puts "\n#{@cX.grey}file #{@cX.off} #{@cX.blue}#{@opt.fns}#{@cX.off} #{@cX.grey}already exists in database#{@cX.off} #{@cX.blue}#{@db.psql.db}#{@cX.off} #{@cX.brown}update instead?#{@cX.off}" |