How to get every single value from a special json #68

Activity

1. gkorland commented on Feb 24, 2022

   

   gkorland

   on Feb 24, 2022

   Contributor

   More actions

   Did you try ?

   127.0.0.1:6379> json.get doc $.*
   "[\"empty\",\"slash\",\"quote\",\"enter\",\"double quote\",\"quote quote\",\"tab\",\"value\"]"
   
2. gkorland

   added

   help wanted

   on Feb 24, 2022
3. leonchen83 commented on Feb 25, 2022

   

   leonchen83

   on Feb 25, 2022

   Last edited by leonchen83

   Author

   More actions

   @gkorland
   the purpose of doing this is we want to test some escape character of rejson.
   so we want to get every single value of above json. and if test done, we could create a PR that convert RFC6901 style json path to rejson style json path. like PR67. and the above json could be a test case in that pr
4. leonchen83

   changed the title [-]How to get every value from a specially json `json.set doc . '{"":"empty", "\\":"slash","\'":"quote","\n":"enter", "\"":"double quote", "\'\'":"quote quote", "\t":"tab", "/":"value"}'`[/-] [+]How to get every single value from a specially json[/+] on Feb 25, 2022
5. leonchen83

   changed the title [-]How to get every single value from a specially json[/-] [+]How to get every single value from a special json[/+] on Feb 25, 2022
6. gkorland commented on Feb 27, 2022

   

   gkorland

   on Feb 27, 2022

   Contributor

   More actions

   I assume you're getting an error like that:

   127.0.0.1:6379> json.get doc '$.["\\"]'
   (error) JSON Path error: path error: \n$.["\\"]\n^^^^^^^^\n

   If you encountered issues it seems like the issue above the source is a redis-cli parsing issue.
   If you'll try to run it with one of Redis clients e.g. redis-py it works without issues.

   >>> r.json().get('doc', '$.["\n"]' )
   ['enter']
   >>> r.json().get('doc', '$.["\t"]' )
   ['tab']
   >>> r.json().get('doc', '$.["\"]' )
   ['empty']
   >>> r.json().get('doc', '$.["\'"]' )
   ['quote']
7. leonchen83 commented on Feb 28, 2022

   

   leonchen83

   on Feb 28, 2022

   Last edited by leonchen83

   Author

   More actions

   I try to use JRedisJson got the same error

   String v = client.get("doc", String.class, Path.of(".[\"\\\\\"]"));
   

   SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
   Exception in thread "main" redis.clients.jedis.exceptions.JedisDataException: JSON Path error: path error: \n$.["\\"]\n^^^^^^^^\n
   	at redis.clients.jedis.Protocol.processError(Protocol.java:139)
   	at redis.clients.jedis.Protocol.process(Protocol.java:173)
   	at redis.clients.jedis.Protocol.read(Protocol.java:227)
   	at redis.clients.jedis.Connection.readProtocolWithCheckingBroken(Connection.java:352)
   	at redis.clients.jedis.Connection.getBinaryBulkReply(Connection.java:289)
   	at redis.clients.jedis.Connection.getBulkReply(Connection.java:279)
   	at com.redislabs.modules.rejson.JReJSON.get(JReJSON.java:246)
   	at com.redislabs.modules.rejson.Main.main(Main.java:25)
   

   and try String v = client.get("doc", String.class, Path.of(".[\"\\\"]"));

   Exception in thread "main" redis.clients.jedis.exceptions.JedisDataException: JSON Path error: path error: \n$.["\"]\n^^^^^^^\n
   	at redis.clients.jedis.Protocol.processError(Protocol.java:139)
   	at redis.clients.jedis.Protocol.process(Protocol.java:173)
   	at redis.clients.jedis.Protocol.read(Protocol.java:227)
   	at redis.clients.jedis.Connection.readProtocolWithCheckingBroken(Connection.java:352)
   	at redis.clients.jedis.Connection.getBinaryBulkReply(Connection.java:289)
   	at redis.clients.jedis.Connection.getBulkReply(Connection.java:279)
   	at com.redislabs.modules.rejson.JReJSON.get(JReJSON.java:246)
   	at com.redislabs.modules.rejson.Main.main(Main.java:25)
   

   so I think it's not a redis-cli bug but a rejson module bug.
8. leonchen83

   closed this as completedon Jan 1, 2024