how to get the codeql-pack a query belongs to

[Lslightly]

I use codeql database run-queries -- <database> <ql> to run queries. The results are stored in <database>/results/<scope/name>/<path/to/ql>.bqrs.

How can I know <scope/name> for a <ql>?

I find codeql resolve queries <ql> can output the <scope/name>. Is the correct way to get the pack name?

example output:

Recording pack reference <scope/name1> at path1.
Recording pack reference <scope/name2> at path2.
ql1
ql2
ql3

Is there some packages/cli to get metadata of a query?

codeql resolve metadata --format=json -- <ql> does not output anything. The codeql version is CodeQL command-line toolchain release 2.25.6.

[jketema]

Hi @Lslightly

Thank you for your question. What are you actually trying to achieve? Digging into the contents of the database directory is probably not what you want to do, as the directory structure is not guaranteed to stay the same.

[Lslightly]

I want to decode bqrs results of run-queries and store the decoded csv there and I'm writing a wrapper tool to call codeql.

The queries come from different pack, and I observe that queries in different pack will lead to different directory, so I'm asking how to get the pack a query belongs to.

database run-queries does not provide an option to specify the output directory while query run does. But query run does not allow run queries parallely in one database at the same time as I know in version v2.21.3. A lock will be hold when run one query in query run. So I choose run-queries for efficiency. But I have to know the structure of results directory now.

[jketema]

If you want to know if a query occurs in a certain pack, then codeql resolve queries is indeed the command you need.

[Lslightly]

Thanks!