JSON mode for cell editor

Support for JSON in the Database Cell editor using the QScintilla library. The lexJSON lexer has been added to the compilation, including the necessary files from the QScintilla source package. See issue sqlitebrowser#1173
myjsproject · Nov 18, 2017 · 3c910a9 · 3c910a9
1 parent 1d701ad
commit 3c910a9
Show file tree

Hide file tree

Showing 11 changed files with 1,145 additions and 23 deletions.
diff --git a/CMakeLists.txt b/CMakeLists.txt
@@ -105,6 +105,7 @@ set(SQLB_MOC_HDR
 	src/VacuumDialog.h
 	src/sqlitetablemodel.h
 	src/sqltextedit.h
+	src/jsontextedit.h
 	src/DbStructureModel.h
 	src/Application.h
 	src/CipherDialog.h
@@ -139,6 +140,7 @@ set(SQLB_SRC
 	src/sqlitetablemodel.cpp
 	src/sqlitetypes.cpp
 	src/sqltextedit.cpp
+	src/jsontextedit.cpp
 	src/csvparser.cpp
 	src/DbStructureModel.cpp
 	src/grammar/Sqlite3Lexer.cpp

diff --git a/libs/qscintilla/Qt4Qt5/CMakeLists.txt b/libs/qscintilla/Qt4Qt5/CMakeLists.txt
@@ -22,6 +22,7 @@ set(QSCINTILLA_SRC
 	qscilexer.cpp
 	qscilexercustom.cpp
 	qscilexersql.cpp
+	qscilexerjson.cpp
 	qscimacro.cpp
 	qsciprinter.cpp
 	qscistyle.cpp
@@ -33,6 +34,7 @@ set(QSCINTILLA_SRC
 	PlatQt.cpp
 	ScintillaQt.cpp
 	../lexers/LexSQL.cpp
+	../lexers/LexJSON.cpp
 	../lexlib/Accessor.cpp
 	../lexlib/CharacterCategory.cpp
 	../lexlib/CharacterSet.cpp
@@ -143,6 +145,7 @@ set(QSCINTILLA_MOC_HDR
 	./Qsci/qscilexer.h
 	./Qsci/qscilexercustom.h
 	./Qsci/qscilexersql.h
+	./Qsci/qscilexerjson.h
 	./Qsci/qscimacro.h
 	SciClasses.h
 	ScintillaQt.h

diff --git a/libs/qscintilla/Qt4Qt5/qscilexerjson.cpp b/libs/qscintilla/Qt4Qt5/qscilexerjson.cpp
@@ -0,0 +1,298 @@
+// This module implements the QsciLexerJSON class.
+//
+// Copyright (c) 2017 Riverbank Computing Limited <info@riverbankcomputing.com>
+// 
+// This file is part of QScintilla.
+// 
+// This file may be used under the terms of the GNU General Public License
+// version 3.0 as published by the Free Software Foundation and appearing in
+// the file LICENSE included in the packaging of this file.  Please review the
+// following information to ensure the GNU General Public License version 3.0
+// requirements will be met: http://www.gnu.org/copyleft/gpl.html.
+// 
+// If you do not wish to use this file under the terms of the GPL version 3.0
+// then you may purchase a commercial license.  For more information contact
+// info@riverbankcomputing.com.
+// 
+// This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
+// WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
+
+
+#include "Qsci/qscilexerjson.h"
+
+#include <qcolor.h>
+#include <qfont.h>
+#include <qsettings.h>
+
+
+// The ctor.
+QsciLexerJSON::QsciLexerJSON(QObject *parent)
+    : QsciLexer(parent),
+      allow_comments(true), escape_sequence(true), fold_compact(true)
+{
+}
+
+
+// The dtor.
+QsciLexerJSON::~QsciLexerJSON()
+{
+}
+
+
+// Returns the language name.
+const char *QsciLexerJSON::language() const
+{
+    return "JSON";
+}
+
+
+// Returns the lexer name.
+const char *QsciLexerJSON::lexer() const
+{
+    return "json";
+}
+
+
+// Returns the foreground colour of the text for a style.
+QColor QsciLexerJSON::defaultColor(int style) const
+{
+    switch (style)
+    {
+    case UnclosedString:
+    case Error:
+        return QColor(0xff, 0xff, 0xff);
+
+    case Number:
+        return QColor(0x00, 0x7f, 0x7f);
+
+    case String:
+        return QColor(0x7f, 0x00, 0x00);
+
+    case Property:
+        return QColor(0x88, 0x0a, 0xe8);
+
+    case EscapeSequence:
+        return QColor(0x0b, 0x98, 0x2e);
+
+    case CommentLine:
+    case CommentBlock:
+        return QColor(0x05, 0xbb, 0xae);
+
+    case Operator:
+        return QColor(0x18, 0x64, 0x4a);
+
+    case IRI:
+        return QColor(0x00, 0x00, 0xff);
+
+    case IRICompact:
+        return QColor(0xd1, 0x37, 0xc1);
+
+    case Keyword:
+        return QColor(0x0b, 0xce, 0xa7);
+
+    case KeywordLD:
+        return QColor(0xec, 0x28, 0x06);
+    }
+
+    return QsciLexer::defaultColor(style);
+}
+
+
+// Returns the end-of-line fill for a style.
+bool QsciLexerJSON::defaultEolFill(int style) const
+{
+    switch (style)
+    {
+    case UnclosedString:
+        return true;
+    }
+
+    return QsciLexer::defaultEolFill(style);
+}
+
+
+// Returns the font of the text for a style.
+QFont QsciLexerJSON::defaultFont(int style) const
+{
+    QFont f;
+
+    switch (style)
+    {
+    case CommentLine:
+        f = QsciLexer::defaultFont(style);
+        f.setItalic(true);
+        break;
+
+    case Keyword:
+        f = QsciLexer::defaultFont(style);
+        f.setBold(true);
+        break;
+
+    default:
+        f = QsciLexer::defaultFont(style);
+    }
+
+    return f;
+}
+
+
+// Returns the set of keywords.
+const char *QsciLexerJSON::keywords(int set) const
+{
+    if (set == 1)
+        return "false true null";
+
+    if (set == 2)
+        return
+            "@id @context @type @value @language @container @list @set "
+            "@reverse @index @base @vocab @graph";
+
+    return 0;
+}
+
+
+// Returns the user name of a style.
+QString QsciLexerJSON::description(int style) const
+{
+    switch (style)
+    {
+    case Default:
+        return tr("Default");
+
+    case Number:
+        return tr("Number");
+
+    case String:
+        return tr("String");
+
+    case UnclosedString:
+        return tr("Unclosed string");
+
+    case Property:
+        return tr("Property");
+
+    case EscapeSequence:
+        return tr("Escape sequence");
+
+    case CommentLine:
+        return tr("Line comment");
+
+    case CommentBlock:
+        return tr("Block comment");
+
+    case Operator:
+        return tr("Operator");
+
+    case IRI:
+        return tr("IRI");
+
+    case IRICompact:
+        return tr("JSON-LD compact IRI");
+
+    case Keyword:
+        return tr("JSON keyword");
+
+    case KeywordLD:
+        return tr("JSON-LD keyword");
+
+    case Error:
+        return tr("Parsing error");
+    }
+
+    return QString();
+}
+
+
+// Returns the background colour of the text for a style.
+QColor QsciLexerJSON::defaultPaper(int style) const
+{
+    switch (style)
+    {
+    case UnclosedString:
+    case Error:
+        return QColor(0xff, 0x00, 0x00);
+    }
+
+    return QsciLexer::defaultPaper(style);
+}
+
+
+// Refresh all properties.
+void QsciLexerJSON::refreshProperties()
+{   
+    setAllowCommentsProp();
+    setEscapeSequenceProp();
+    setCompactProp();
+}
+
+
+// Read properties from the settings.
+bool QsciLexerJSON::readProperties(QSettings &qs,const QString &prefix)
+{
+    allow_comments = qs.value(prefix + "allowcomments", true).toBool();
+    escape_sequence = qs.value(prefix + "escapesequence", true).toBool();
+    fold_compact = qs.value(prefix + "foldcompact", true).toBool();
+
+    return true;
+}
+
+
+// Write properties to the settings.
+bool QsciLexerJSON::writeProperties(QSettings &qs,const QString &prefix) const
+{
+    qs.setValue(prefix + "allowcomments", allow_comments);
+    qs.setValue(prefix + "escapesequence", escape_sequence);
+    qs.setValue(prefix + "foldcompact", fold_compact);
+
+    return true;
+}
+
+
+// Set if comments are highlighted
+void QsciLexerJSON::setHighlightComments(bool highlight)
+{
+    allow_comments = highlight;
+
+    setAllowCommentsProp();
+}
+
+
+// Set the "lexer.json.allow.comments" property.
+void QsciLexerJSON::setAllowCommentsProp()
+{
+    emit propertyChanged("lexer.json.allow.comments",
+            (allow_comments ? "1" : "0"));
+}
+
+
+// Set if escape sequences are highlighted.
+void QsciLexerJSON::setHighlightEscapeSequences(bool highlight)
+{
+    escape_sequence = highlight;
+
+    setEscapeSequenceProp();
+}
+
+
+// Set the "lexer.json.escape.sequence" property.
+void QsciLexerJSON::setEscapeSequenceProp()
+{
+    emit propertyChanged("lexer.json.escape.sequence",
+            (escape_sequence ? "1" : "0"));
+}
+
+
+// Set if folds are compact.
+void QsciLexerJSON::setFoldCompact(bool fold)
+{
+    fold_compact = fold;
+
+    setCompactProp();
+}
+
+
+// Set the "fold.compact" property.
+void QsciLexerJSON::setCompactProp()
+{
+    emit propertyChanged("fold.compact", (fold_compact ? "1" : "0"));
+}
diff --git a/libs/qscintilla/Qt4Qt5/qscintilla.pro b/libs/qscintilla/Qt4Qt5/qscintilla.pro
@@ -86,6 +86,7 @@ HEADERS = \
 	./Qsci/qscilexer.h \
 	./Qsci/qscilexercustom.h \
 	./Qsci/qscilexersql.h \
+	./Qsci/qscilexerjson.h \
 	./Qsci/qscimacro.h \
 	./Qsci/qsciprinter.h \
 	./Qsci/qscistyle.h \
@@ -158,6 +159,7 @@ SOURCES = \
 	qscilexer.cpp \
     qscilexercustom.cpp \
     qscilexersql.cpp \
+    qscilexerjson.cpp \
 	qscimacro.cpp \
 	qsciprinter.cpp \
 	qscistyle.cpp \
@@ -169,6 +171,7 @@ SOURCES = \
 	PlatQt.cpp \
     ScintillaQt.cpp \
     ../lexers/LexSQL.cpp \
+    ../lexers/LexJSON.cpp \
 	../lexlib/Accessor.cpp \
 	../lexlib/CharacterCategory.cpp \
 	../lexlib/CharacterSet.cpp \