Queries saving in DBManager

[qgib]

Author Name: didier peeters (@dd-a)
Original Redmine Issue: 9344

Redmine category:db_manager

---

Wouldn't be nice to have the possibility to store the queries written in DBManager either in the project file OR in QGis a file in the personnal directory (~/.qgis2 on Mac OS X) for example. There are queries specific to a project but others are of more general use.

[qgib]

Author Name: Médéric RIBREUX (Médéric RIBREUX)

---

Hello,

DBManager stores queries inside the current project (storePreset, deletePreset, loadPreset methods of dlg_sql_windo.py). You need to save the project after query building and storing to be sure to save the query.

Queries are stored inside the project under the savedQueries tag.

Here is an example of stored queries inside a project (XML):

<savedQueries>
        <q530639571>
          <query type="QString">SELECT * FROM ENS</query>
          <name type="QString">ENS</name>
        </q530639571>
        <q1704340978>
          <query type="QString">SELECT * FROM PAE</query>
          <name type="QString">SDF</name>
        </q1704340978>
</savedQueries>

This has been introduced in this #6bd1b78b18e25a6775863f0eef1079391a910dea

---

• resolution was changed from to fixed/implemented
• fixed_version_id was changed from Future Release - High Priority to Version 2.10
• status_id was changed from Open to Closed