Fix Map-based JSON handling in QgsField's convertCompatible()

nirvn · github-actions[bot] · commit d5200d78081f · 2023-04-14T07:41:22.000Z
diff --git a/src/core/qgsfield.cpp b/src/core/qgsfield.cpp
@@ -570,16 +570,28 @@ bool QgsField::convertCompatible( QVariant &v, QString *errorMessage ) const
     }
   }
 
-  if ( d->type == QVariant::String && ( d->typeName.compare( QLatin1String( "json" ), Qt::CaseInsensitive ) == 0 || d->typeName == QLatin1String( "jsonb" ) ) )
+  if ( d->typeName.compare( QLatin1String( "json" ), Qt::CaseInsensitive ) == 0 || d->typeName.compare( QLatin1String( "jsonb" ), Qt::CaseInsensitive ) == 0 )
   {
-    const QJsonDocument doc = QJsonDocument::fromVariant( v );
-    if ( !doc.isNull() )
+    if ( d->type == QVariant::String )
     {
-      v = QString::fromUtf8( doc.toJson( QJsonDocument::Compact ).constData() );
-      return true;
+      const QJsonDocument doc = QJsonDocument::fromVariant( v );
+      if ( !doc.isNull() )
+      {
+        v = QString::fromUtf8( doc.toJson( QJsonDocument::Compact ).constData() );
+        return true;
+      }
+      v = QVariant( d->type );
+      return false;
+    }
+    else if ( d->type == QVariant::Map )
+    {
+      if ( v.type() == QVariant::StringList || v.type() == QVariant::List || v.type() == QVariant::Map )
+      {
+        return true;
+      }
+      v = QVariant( d->type );
+      return false;
     }
-    v = QVariant( d->type );
-    return false;
   }
 
   if ( ( d->type == QVariant::StringList || ( d->type == QVariant::List && d->subType == QVariant::String ) )
diff --git a/tests/src/core/testqgsfield.cpp b/tests/src/core/testqgsfield.cpp
@@ -806,19 +806,37 @@ void TestQgsField::convertCompatible()
   QVariant vZero = 0;
   QVERIFY( intField.convertCompatible( vZero ) );
 
-  // Test json field conversion
-  const QgsField jsonField( QStringLiteral( "json" ), QVariant::String, QStringLiteral( "json" ) );
-  QVariant jsonValue = QVariant::fromValue( QVariantList() << 1 << 5 << 8 );
-  QVERIFY( jsonField.convertCompatible( jsonValue ) );
-  QCOMPARE( jsonValue.type(), QVariant::String );
-  QCOMPARE( jsonValue, QString( "[1,5,8]" ) );
-  QVariantMap variantMap;
-  variantMap.insert( QStringLiteral( "a" ), 1 );
-  variantMap.insert( QStringLiteral( "c" ), 3 );
-  jsonValue = QVariant::fromValue( variantMap );
-  QVERIFY( jsonField.convertCompatible( jsonValue ) );
-  QCOMPARE( jsonValue.type(), QVariant::String );
-  QCOMPARE( jsonValue, QString( "{\"a\":1,\"c\":3}" ) );
+  // Test string-based json field conversion
+  {
+    const QgsField jsonField( QStringLiteral( "json" ), QVariant::String, QStringLiteral( "json" ) );
+    QVariant jsonValue = QVariant::fromValue( QVariantList() << 1 << 5 << 8 );
+    QVERIFY( jsonField.convertCompatible( jsonValue ) );
+    QCOMPARE( jsonValue.type(), QVariant::String );
+    QCOMPARE( jsonValue, QString( "[1,5,8]" ) );
+    QVariantMap variantMap;
+    variantMap.insert( QStringLiteral( "a" ), 1 );
+    variantMap.insert( QStringLiteral( "c" ), 3 );
+    jsonValue = QVariant::fromValue( variantMap );
+    QVERIFY( jsonField.convertCompatible( jsonValue ) );
+    QCOMPARE( jsonValue.type(), QVariant::String );
+    QCOMPARE( jsonValue, QString( "{\"a\":1,\"c\":3}" ) );
+  }
+
+  // Test map-based json field (i.e. OGR geopackage JSON fields) conversion
+  {
+    const QgsField jsonField( QStringLiteral( "json" ), QVariant::Map, QStringLiteral( "json" ) );
+    QVariant jsonValue = QVariant::fromValue( QVariantList() << 1 << 5 << 8 );
+    QVERIFY( jsonField.convertCompatible( jsonValue ) );
+    QCOMPARE( jsonValue.type(), QVariant::List );
+    QCOMPARE( jsonValue, QVariantList() << 1 << 5 << 8 );
+    QVariantMap variantMap;
+    variantMap.insert( QStringLiteral( "a" ), 1 );
+    variantMap.insert( QStringLiteral( "c" ), 3 );
+    jsonValue = QVariant::fromValue( variantMap );
+    QVERIFY( jsonField.convertCompatible( jsonValue ) );
+    QCOMPARE( jsonValue.type(), QVariant::Map );
+    QCOMPARE( jsonValue, variantMap );
+  }
 
   // geometry field conversion
   const QgsField geometryField( QStringLiteral( "geometry" ), QVariant::UserType, QStringLiteral( "geometry" ) );

Original file line number	Diff line number	Diff line change
`@@ -570,16 +570,28 @@ bool QgsField::convertCompatible( QVariant &v, QString *errorMessage ) const`
`570`	`570`	`}`
`571`	`571`	`}`
`572`	`572`
`573`		`- if ( d->type == QVariant::String && ( d->typeName.compare( QLatin1String( "json" ), Qt::CaseInsensitive ) == 0 \|\| d->typeName == QLatin1String( "jsonb" ) ) )`
	`573`	`+ if ( d->typeName.compare( QLatin1String( "json" ), Qt::CaseInsensitive ) == 0 \|\| d->typeName.compare( QLatin1String( "jsonb" ), Qt::CaseInsensitive ) == 0 )`
`574`	`574`	`{`
`575`		`- const QJsonDocument doc = QJsonDocument::fromVariant( v );`
`576`		`- if ( !doc.isNull() )`
	`575`	`+ if ( d->type == QVariant::String )`
`577`	`576`	`{`
`578`		`- v = QString::fromUtf8( doc.toJson( QJsonDocument::Compact ).constData() );`
`579`		`- return true;`
	`577`	`+ const QJsonDocument doc = QJsonDocument::fromVariant( v );`
	`578`	`+ if ( !doc.isNull() )`
	`579`	`+ {`
	`580`	`+ v = QString::fromUtf8( doc.toJson( QJsonDocument::Compact ).constData() );`
	`581`	`+ return true;`
	`582`	`+ }`
	`583`	`+ v = QVariant( d->type );`
	`584`	`+ return false;`
	`585`	`+ }`
	`586`	`+ else if ( d->type == QVariant::Map )`
	`587`	`+ {`
	`588`	`+ if ( v.type() == QVariant::StringList \|\| v.type() == QVariant::List \|\| v.type() == QVariant::Map )`
	`589`	`+ {`
	`590`	`+ return true;`
	`591`	`+ }`
	`592`	`+ v = QVariant( d->type );`
	`593`	`+ return false;`
`580`	`594`	`}`
`581`		`- v = QVariant( d->type );`
`582`		`- return false;`
`583`	`595`	`}`
`584`	`596`
`585`	`597`	`if ( ( d->type == QVariant::StringList \|\| ( d->type == QVariant::List && d->subType == QVariant::String ) )`