diff options
| author | Ralph Amissah <ralph@amissah.com> | 2010-04-20 19:01:55 -0400 |
|---|---|---|
| committer | Ralph Amissah <ralph@amissah.com> | 2010-04-20 19:01:55 -0400 |
| commit | 63c5a3cead1fb5cbd9b1bff653f269dce8d8052c (patch) | |
| tree | eb3e09a1199ae2dc79b3f7db97ff1024b25cfb0c /lib/sisu/v2/db_remove.rb | |
| parent | dal, minor cosmetic re-arrangement (diff) | |
db name, tables, columns, indexes changes, review (need another version bump 2.2.0)
* db (sql) table structure, further review and changes (hence breakage & version bump)
* new pgsql db name prefix "sisu_v2b_"
* new table column words in doc_objects & endnotes, VARCHAR 3000 to contain
list of unique sorted words in object
* increase use of VARCHAR
* constants takes on related additions
* param, extensive db column size checks for metadata
Diffstat (limited to 'lib/sisu/v2/db_remove.rb')
| -rw-r--r-- | lib/sisu/v2/db_remove.rb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/sisu/v2/db_remove.rb b/lib/sisu/v2/db_remove.rb index e7942a15..5a7f1244 100644 --- a/lib/sisu/v2/db_remove.rb +++ b/lib/sisu/v2/db_remove.rb @@ -72,9 +72,9 @@ module SiSU_DB_remove : false end del_id=if driver_sqlite3 - @conn.get_first_value(%{ SELECT tid FROM metadata_and_text WHERE filename = '#{@opt.fns}'; }).to_i + @conn.get_first_value(%{ SELECT tid FROM metadata_and_text WHERE src_filename = '#{@opt.fns}'; }).to_i else - x=@conn.select_one(%{ SELECT metadata_and_text.tid FROM metadata_and_text WHERE metadata_and_text.filename = '#{@opt.fns}'; }) + x=@conn.select_one(%{ SELECT metadata_and_text.tid FROM metadata_and_text WHERE metadata_and_text.src_filename = '#{@opt.fns}'; }) x ? (x.join.to_i) : nil end if del_id |