D17887: Fix detection of .kexi file types after recent change of mime database on Linux for SQLite type (2018-06-17)

[Jarosław Staniek]

staniek created this revision.
staniek added a reviewer: piggz.
Herald added a project: KDb.
Herald added a subscriber: Kexi-Devel-list.
staniek requested review of this revision.

REVISION SUMMARY
  Add application/vnd.sqlite3 and application/x-vnd.kde.kexi to be sure everything is catch while detecting .kexi file types.
  The change is apparently needed after this commit:
  
  https://cgit.freedesktop.org/xdg/shared-mime-info/commit/freedesktop.org.xml.in?id=36a88b01f6ae90da35a2f6a072db159c84cea768
  
  From https://cgit.freedesktop.org/xdg/shared-mime-info/tree/freedesktop.org.xml.in:
  it's apparent that .kexi mime type still inherits from application/x-sqlite3 which is now only an alias:
  
  <mime-type type="application/x-kexiproject-sqlite3">
  
    <_comment>Kexi database file-based project</_comment>
    <sub-class-of type="application/x-sqlite3"/>
    <glob pattern="*.kexi"/>
    <alias type="application/x-vnd.kde.kexi"/>
  
  Also update the driver's autotest.
  
  BUG:396999
  FIXED-IN:3.2.0
  
  Big thanks to therapon at netzero.com for extensive testing!
  
  CCMAIL:therapon at netzero.com
  CCMAIL:ville.skytta at iki.fi
  CCMAIL:hadess at hadess.net
  CCMAIL:teuf at gnome.org

TEST PLAN
  1. Run autotests.
  2. Test KEXI with this KDb: try to open .kexi file while you miss the /usr/share/mime/application/x-sqlite3.xml file but have
  
  the new /usr/share/mime/application/vnd.sqlite3.xml present.
  
  3. Test KEXI with this KDb: try to open .kexi file while you miss the /usr/share/mime/application/vnd.sqlite3.xml file but have
  
  the old /usr/share/mime/application/x-sqlite3.xml present.
  
  4. Verify that opening from the Welcome sceen's recent list still works.
  
  Expected: KEXI opens the file.

REPOSITORY
  R15 KDb

BRANCH
  396999-fix-sqlite-mime

REVISION DETAIL
  https://phabricator.kde.org/D17887

AFFECTED FILES
  autotests/KDbTestUtils.cpp
  autotests/KDbTestUtils.h
  src/drivers/sqlite/kdb_sqlitedriver.json

To: staniek, piggz
Cc: Kexi-Devel-list, barman, wicik, staniek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kexi-devel/attachments/20181231/e5de06dd/attachment.html>