<table><tr><td style="">staniek created this revision.<br />staniek added a reviewer: piggz.<br />Herald added a project: KDb.<br />Herald added a subscriber: Kexi-Devel-list.<br />staniek requested review of this revision.
</td><a style="text-decoration: none; padding: 4px 8px; margin: 0 8px 8px; float: right; color: #464C5C; font-weight: bold; border-radius: 3px; background-color: #F7F7F9; background-image: linear-gradient(to bottom,#fff,#f1f0f1); display: inline-block; border: 1px solid rgba(71,87,120,.2);" href="https://phabricator.kde.org/D17887">View Revision</a></tr></table><br /><div><strong>REVISION SUMMARY</strong><div><p>Add application/vnd.sqlite3 and application/x-vnd.kde.kexi to be sure everything is catch while detecting .kexi file types.<br />
The change is apparently needed after this commit:</p>

<p><a href="https://cgit.freedesktop.org/xdg/shared-mime-info/commit/freedesktop.org.xml.in?id=36a88b01f6ae90da35a2f6a072db159c84cea768" class="remarkup-link" target="_blank" rel="noreferrer">https://cgit.freedesktop.org/xdg/shared-mime-info/commit/freedesktop.org.xml.in?id=36a88b01f6ae90da35a2f6a072db159c84cea768</a></p>

<p>From <a href="https://cgit.freedesktop.org/xdg/shared-mime-info/tree/freedesktop.org.xml.in" class="remarkup-link" target="_blank" rel="noreferrer">https://cgit.freedesktop.org/xdg/shared-mime-info/tree/freedesktop.org.xml.in</a>:<br />
it's apparent that .kexi mime type still inherits from application/x-sqlite3 which is now only an alias:</p>

<p><mime-type type="application/x-kexiproject-sqlite3"></p>

<div class="remarkup-code-block" style="margin: 12px 0;" data-code-lang="text" data-sigil="remarkup-code-block"><pre class="remarkup-code" style="font: 11px/15px "Menlo", "Consolas", "Monaco", monospace; padding: 12px; margin: 0; background: rgba(71, 87, 120, 0.08);"><_comment>Kexi database file-based project</_comment>
<sub-class-of type="application/x-sqlite3"/>
<glob pattern="*.kexi"/>
<alias type="application/x-vnd.kde.kexi"/></pre></div>

<p>Also update the driver's autotest.</p>

<p>BUG:396999<br />
FIXED-IN:3.2.0</p>

<p>Big thanks to therapon@netzero.com for extensive testing!</p>

<p>CCMAIL:therapon@netzero.com<br />
CCMAIL:ville.skytta@iki.fi<br />
CCMAIL:hadess@hadess.net<br />
CCMAIL:teuf@gnome.org</p></div></div><br /><div><strong>TEST PLAN</strong><div><ol class="remarkup-list">
<li class="remarkup-list-item">Run autotests.</li>
<li class="remarkup-list-item">Test KEXI with this KDb: try to open .kexi file while you miss the /usr/share/mime/application/x-sqlite3.xml file but have</li>
</ol>

<p>the new /usr/share/mime/application/vnd.sqlite3.xml present.</p>

<ol class="remarkup-list" start="3">
<li class="remarkup-list-item">Test KEXI with this KDb: try to open .kexi file while you miss the /usr/share/mime/application/vnd.sqlite3.xml file but have</li>
</ol>

<p>the old /usr/share/mime/application/x-sqlite3.xml present.</p>

<ol class="remarkup-list" start="4">
<li class="remarkup-list-item">Verify that opening from the Welcome sceen's recent list still works.</li>
</ol>

<p>Expected: KEXI opens the file.</p></div></div><br /><div><strong>REPOSITORY</strong><div><div>R15 KDb</div></div></div><br /><div><strong>BRANCH</strong><div><div>396999-fix-sqlite-mime</div></div></div><br /><div><strong>REVISION DETAIL</strong><div><a href="https://phabricator.kde.org/D17887">https://phabricator.kde.org/D17887</a></div></div><br /><div><strong>AFFECTED FILES</strong><div><div>autotests/KDbTestUtils.cpp<br />
autotests/KDbTestUtils.h<br />
src/drivers/sqlite/kdb_sqlitedriver.json</div></div></div><br /><div><strong>To: </strong>staniek, piggz<br /><strong>Cc: </strong>Kexi-Devel-list, barman, wicik, staniek<br /></div>