From 49120f48474fc8fdc2448c75d961bc238213cfac Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?J=C3=B6rg=20Frings-F=C3=BCrst?= Date: Tue, 1 May 2018 14:34:32 +0200 Subject: New upstream version 0.28.2 --- .../FSpotPhotoVersionsTable.vala | 271 --------------------- 1 file changed, 271 deletions(-) delete mode 100644 plugins/shotwell-data-imports/FSpotPhotoVersionsTable.vala (limited to 'plugins/shotwell-data-imports/FSpotPhotoVersionsTable.vala') diff --git a/plugins/shotwell-data-imports/FSpotPhotoVersionsTable.vala b/plugins/shotwell-data-imports/FSpotPhotoVersionsTable.vala deleted file mode 100644 index 4c500fe..0000000 --- a/plugins/shotwell-data-imports/FSpotPhotoVersionsTable.vala +++ /dev/null @@ -1,271 +0,0 @@ -/* Copyright 2016 Software Freedom Conservancy Inc. - * - * This software is licensed under the GNU Lesser General Public License - * (version 2.1 or later). See the COPYING file in this distribution. - */ - -namespace DataImports.FSpot.Db { - -/** - * The value object for the "photo_versions" table, representing a single database row. - */ -public class FSpotPhotoVersionRow : Object { - public int64 photo_id; - public int64 version_id; - public string name; - public File? base_path; - public string? filename; - public string md5_sum; - public bool is_protected; -} - -/** - * This class represents the F-Spot photo_versions table. - */ -public class FSpotPhotoVersionsTable : FSpotDatabaseTable { - public const string TABLE_NAME = "Photo_versions"; - - public FSpotPhotoVersionsTable(Sqlite.Database db, FSpotDatabaseBehavior db_behavior) { - base(db); - set_behavior(db_behavior.get_photo_versions_behavior()); - } - - public Gee.ArrayList get_by_photo_id(int64 photo_id) throws DatabaseError { - Gee.ArrayList rows = new Gee.ArrayList(); - - Sqlite.Statement stmt; - - string column_list = get_joined_column_list(); - string sql = "SELECT %s FROM %s WHERE photo_id=?".printf( - column_list, table_name - ); - - int res = fspot_db.prepare_v2(sql, -1, out stmt); - if (res != Sqlite.OK) - throw_error("Statement failed: %s".printf(sql), res); - - res = stmt.bind_int64(1, photo_id); - if (res != Sqlite.OK) - throw_error("Bind failed for photo_id", res); - - res = stmt.step(); - while (res == Sqlite.ROW) { - FSpotPhotoVersionRow row; - behavior.build_row(stmt, out row); - rows.add(row); - res = stmt.step(); - } - - return rows; - } -} - -// Photo_versions table behavior for v0-8 -// Note: there is a change in the URI format in version 8 but the File.new_for_uri -// constructor should be able to deal with the variation, so the v8 behavior should -// be handled in a way identical to v0-7 -public class FSpotPhotoVersionsV0Behavior : FSpotTableBehavior, Object { - private static FSpotPhotoVersionsV0Behavior instance; - - private FSpotPhotoVersionsV0Behavior() { - } - - public static FSpotPhotoVersionsV0Behavior get_instance() { - if (instance == null) - instance = new FSpotPhotoVersionsV0Behavior(); - return instance; - } - - public string get_table_name() { - return FSpotPhotoVersionsTable.TABLE_NAME; - } - - public string[] list_columns() { - return { "photo_id", "version_id", "name", "uri" }; - } - - public void build_row(Sqlite.Statement stmt, out FSpotPhotoVersionRow row, int offset = 0) { - row = new FSpotPhotoVersionRow(); - row.photo_id = stmt.column_int64(offset + 0); - row.version_id = stmt.column_int64(offset + 1); - row.name = stmt.column_text(offset + 2); - - string? full_path = stmt.column_text(offset + 3); - if (full_path != null) { - File uri = File.new_for_uri(full_path); - row.base_path = uri.get_parent(); - row.filename = uri.get_basename(); - } - - row.md5_sum = ""; - row.is_protected = false; - } -} - -// Photo_versions table behavior for v9-15 -// add protected field -public class FSpotPhotoVersionsV9Behavior : FSpotTableBehavior, Object { - private static FSpotPhotoVersionsV9Behavior instance; - - private FSpotPhotoVersionsV9Behavior() { - } - - public static FSpotPhotoVersionsV9Behavior get_instance() { - if (instance == null) - instance = new FSpotPhotoVersionsV9Behavior(); - return instance; - } - - public string get_table_name() { - return FSpotPhotoVersionsTable.TABLE_NAME; - } - - public string[] list_columns() { - return { "photo_id", "version_id", "name", "uri", - "protected" }; - } - - public void build_row(Sqlite.Statement stmt, out FSpotPhotoVersionRow row, int offset = 0) { - row = new FSpotPhotoVersionRow(); - row.photo_id = stmt.column_int64(offset + 0); - row.version_id = stmt.column_int64(offset + 1); - row.name = stmt.column_text(offset + 2); - - string? full_path = stmt.column_text(offset + 3); - if (full_path != null) { - File uri = File.new_for_uri(full_path); - row.base_path = uri.get_parent(); - row.filename = uri.get_basename(); - } - - row.md5_sum = ""; - row.is_protected = (stmt.column_int(offset + 4) > 0); - } -} - -// Photo_versions table behavior for v16 -// add md5_sum in photo_versions -public class FSpotPhotoVersionsV16Behavior : FSpotTableBehavior, Object { - private static FSpotPhotoVersionsV16Behavior instance; - - private FSpotPhotoVersionsV16Behavior() { - } - - public static FSpotPhotoVersionsV16Behavior get_instance() { - if (instance == null) - instance = new FSpotPhotoVersionsV16Behavior(); - return instance; - } - - public string get_table_name() { - return FSpotPhotoVersionsTable.TABLE_NAME; - } - - public string[] list_columns() { - return { "photo_id", "version_id", "name", "uri", - "md5_sum", "protected" }; - } - - public void build_row(Sqlite.Statement stmt, out FSpotPhotoVersionRow row, int offset = 0) { - row = new FSpotPhotoVersionRow(); - row.photo_id = stmt.column_int64(offset + 0); - row.version_id = stmt.column_int64(offset + 1); - row.name = stmt.column_text(offset + 2); - - string? full_path = stmt.column_text(offset + 3); - if (full_path != null) { - File uri = File.new_for_uri(full_path); - row.base_path = uri.get_parent(); - row.filename = uri.get_basename(); - } - - row.md5_sum = stmt.column_text(offset + 4); - row.is_protected = (stmt.column_int(offset + 5) > 0); - } -} - -// Photo_versions table behavior for v17 -// v17 split the URI into base_uri and filename (reverting back to the original -// design introduced in v0, albeit with a URI rather than a file system path) -public class FSpotPhotoVersionsV17Behavior : FSpotTableBehavior, Object { - private static FSpotPhotoVersionsV17Behavior instance; - - private FSpotPhotoVersionsV17Behavior() { - } - - public static FSpotPhotoVersionsV17Behavior get_instance() { - if (instance == null) - instance = new FSpotPhotoVersionsV17Behavior(); - return instance; - } - - public string get_table_name() { - return FSpotPhotoVersionsTable.TABLE_NAME; - } - - public string[] list_columns() { - return { "photo_id", "version_id", "name", "base_uri", "filename", - "md5_sum", "protected" }; - } - - public void build_row(Sqlite.Statement stmt, out FSpotPhotoVersionRow row, int offset = 0) { - row = new FSpotPhotoVersionRow(); - row.photo_id = stmt.column_int64(offset + 0); - row.version_id = stmt.column_int64(offset + 1); - row.name = stmt.column_text(offset + 2); - - string? base_path = stmt.column_text(offset + 3); - string? filename = stmt.column_text(offset + 4); - if (base_path != null && filename != null) { - row.base_path = File.new_for_uri(base_path); - row.filename = filename; - } - - row.md5_sum = stmt.column_text(offset + 5); - row.is_protected = (stmt.column_int(offset + 6) > 0); - } -} - -// Photo_versions table behavior for v18 -// md5_sum renamed import_md5 -public class FSpotPhotoVersionsV18Behavior : FSpotTableBehavior, Object { - private static FSpotPhotoVersionsV18Behavior instance; - - private FSpotPhotoVersionsV18Behavior() { - } - - public static FSpotPhotoVersionsV18Behavior get_instance() { - if (instance == null) - instance = new FSpotPhotoVersionsV18Behavior(); - return instance; - } - - public string get_table_name() { - return FSpotPhotoVersionsTable.TABLE_NAME; - } - - public string[] list_columns() { - return { "photo_id", "version_id", "name", "base_uri", "filename", - "import_md5", "protected" }; - } - - public void build_row(Sqlite.Statement stmt, out FSpotPhotoVersionRow row, int offset = 0) { - row = new FSpotPhotoVersionRow(); - row.photo_id = stmt.column_int64(offset + 0); - row.version_id = stmt.column_int64(offset + 1); - row.name = stmt.column_text(offset + 2); - - string? base_path = stmt.column_text(offset + 3); - string? filename = stmt.column_text(offset + 4); - if (base_path != null && filename != null) { - row.base_path = File.new_for_uri(base_path); - row.filename = filename; - } - - row.md5_sum = stmt.column_text(offset + 5); - row.is_protected = (stmt.column_int(offset + 6) > 0); - } -} - -} - -- cgit v1.2.3