sqlitebrowser-recipe:no_savepoints_ro_db

Branch merges

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related charm recipes

51db507... by Manuel Gomez on 2018-09-20

Never mark the DB dirty if it is read-only. Issue #1514

Setting save points does not make sense for read-only databases, so
do never set a save-point while executing a user query if the database has
been opened in read-only mode.

If setSavePoint is ever called in read-only mode, a warning is printed and
the save-point is not set.

If ever a read-write query is executed, it would be rejected by SQLite so
there is no risk of immediately committing any change to the DB.

18f0ef6... by Manuel Gomez on 2018-09-16

Enhancement #1435: pragmas invoked from Tools menu

Pragmas integrity_check, quick_check, foreign_key_check and optimize are
integrated in the Tools menu. The actions open a confirmation dialog
(with Help button that opens the corresponding reference page in
sqlite.org) and, after confirmation, opens a new SQL editor tab and runs
there the pragma, showing the possible results.

Sender in executeQuery is null in this case, so a check is added.

Added accelerator to Tools menu entry, which lacked one.

9ca3878... by Manuel Gomez on 2018-09-16

Fix XML filter for import in Edit Database Cell dock and more.

The XML branch in the import was incorrectly programmed. Now it sets the
appropriate selected filter.

The list of filters is initialised once and the selected filter is passed
to the dialog using the specific parameter.

Chopped the last space in the image formats list for better style.

Case insensitivity applied to the suffix check as done in other parts of
the code.

See issue #1535.

60c229c... by Manuel Gomez on 2018-09-16

Printing support: print dialog from QScintilla widgets

Add printing support for QScintilla widgets (SQL, JSON and XML). It can be
access through the contextual menu, shortcut (Ctrl+P) or (in the case of
the "Execute SQL" tab) from a button in the toolbar.

Ctrl+P was previously assigned to Plot Dock since
63c338c3595ef4c828f75d40d598eccf9ee24ec5 but, as it was foreseen in that
commit, it should be assign to print is ever supported. This change must
be mentioned in release notes.

First part of printing support. See issue #1525.

9daf265... by Manuel Gomez on 2018-09-15

Issue #1534: add schema name for qualified fields dropped from DB Schema

For the "Drag & Drop Qualified Names" option, the schema name for
attached databases is also added for field names dropped from the DB
Schema dock.

71f26cb... by Manuel Gomez on 2018-09-15

Allow exporting the textual representation of binary data

For binary data, the file save dialog allows to select text files. When
the user saves to a text file (*.txt) the visual representation of the
hex buffer is saved to the file (addresses, hexadecimal bytes and ASCII
view). In this dump, only US-ASCII seems to be considered printable, while
in screen, Latin-1 is also considered.

This was one of the enhancement suggestions in issue #1438.

6779ad8... by Manuel Gomez on 2018-09-15

Issue #1535: select appropriate file filter corresponding to "Mode"

This reorders the filters in the import file dialog of the Edit Cell dock
so the first entry is always in accordance to the currently selected mode.

This will also facilitate the translation of the filters, because the
translations can be reused and written without special syntax characters
(";;").

"%1 Image" is also used instead of a concatenation, because the word
order in translations will vary.

5b4dea9... by Manuel Gomez on 2018-09-10

Add "Feature Request..." entry and body templates in both types of issue

New entry under Help menu for requesting issues with the same template
used for a New Issue inside GitHub.

The "Bug Report..." entry has also been updated for adding the
corresponding template body.

Separators added in Help menu, since there are currently several different
options.

See related issue #1497

dfa599d... by Manuel Gomez on 2018-09-10

Merge branch 'qualified_completion'

f33943f... by Manuel Gomez on 2018-09-09

Improvements for drag and drop of items from the DB Schema dock to editor

Two new options editable from a new context menu of the dock:
- Drag & Drop Qualified Names: add table name to fields and schema name
to other objects (except for "main" schema)
- Drag & Drop Enquoted Names: whether to surround the identifiers by the
configured quoting characters for identifiers.

Support for dragging & dropping of attached databases names.

Add "." as separator for multiple dropped objects other than fields (since
they are not usually used in SQL as a list). This allows to compose
qualified names by dropping the parent and the child items together. This
is only generally useful when the "Qualified Names" option is disabled.

See related issue #1433