Arsenio04/19/2023, 3:28 PM
*Compatible with:Estimated compatiblity based onthe tables used in the query.*No platforms (check your query for a possible syntax error)
SELECT path json_extract(path, '$.displayName') as displayName, FROM file WHERE path LIKE '%/%/.vscode/extensions/%/package.json' AND type = 'regular';
John Speno04/19/2023, 3:34 PM
would need the actual json data given as its first argument, not a path to a file that contains the json. https://www.sqlite.org/json1.html#jex
Arsenio04/19/2023, 3:35 PM
Lucas Rodriguez04/19/2023, 5:00 PM
table (though it might be tricky to get the data given it's splitted line by line).
Arsenio04/19/2023, 5:03 PM
Kathy Satterlee04/19/2023, 5:07 PM
, but I'm not having any luck with the built-in lenses.
Lucas Rodriguez04/19/2023, 5:07 PM
Arsenio04/19/2023, 5:08 PM
Kathy Satterlee04/19/2023, 5:28 PM
table is an option for you, this query worked nicely for me on Mac:
SELECT path, split(line, ":", 1) as displayName FROM file_lines WHERE path LIKE "/Users/%%/.vscode/extensions/%/package.json" AND line LIKE '%"displayName"%' ;
John Speno04/19/2023, 5:39 PM
Kathy Satterlee04/19/2023, 5:49 PM
fritz04/19/2023, 7:59 PM
table to query json formatted files.
Ignacio04/20/2023, 10:53 AM