shopware / SwagConnect

        $sql = 'SELECT name, value FROM s_plugin_connect_config WHERE shopId IS NULL AND groupName = ?';

        $result = Shopware()->Db()->fetchPairs($sql, ['export']);

        foreach ($result as $name => $value) {

            if (json_decode($value, true) !== null) {

                $value = json_decode($value, true);

            }

            $this->assertEquals($value, $exportConfig[$name]);

        }

    }

    public function testSetExportConfigs()

        $result = Shopware()->Db()->fetchPairs($query);

        foreach ($result as $key => $value) {

            $decodedString = json_decode($value, true);

            if ($decodedString !== null) {

                $result[$key] = $decodedString;

            }

        }

        return $result;

    }