Arsenio
04/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 Speno
04/19/2023, 3:34 PMjson_extract()
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#jexArsenio
04/19/2023, 3:35 PMLucas Rodriguez
04/19/2023, 5:00 PMfile_lines
table (though it might be tricky to get the data given it's splitted line by line).Arsenio
04/19/2023, 5:03 PMKathy Satterlee
04/19/2023, 5:07 PMaugeas
, but I'm not having any luck with the built-in lenses.Lucas Rodriguez
04/19/2023, 5:07 PMArsenio
04/19/2023, 5:08 PMKathy Satterlee
04/19/2023, 5:28 PMfile_lines
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 Speno
04/19/2023, 5:39 PMKathy Satterlee
04/19/2023, 5:49 PMfritz
04/19/2023, 7:59 PMkolide_json
table to query json formatted files.Ignacio
04/20/2023, 10:53 AM