Check the status of a submitted package?

[fdcastel]

How can I check the status of a submitted package?

For example, version 5.0.3 of the Firebird package is still under moderation. However, I can't find a way to determine this status through the API. Is there a method to query this information?

Running

choco search firebird --all --exact --ignore-http-cache  

Returns

Chocolatey v2.2.2
firebird 5.0.2 [Approved]
firebird 5.0.1 [Approved]
firebird 5.0.0 [Approved]
firebird 4.0.6 [Approved]
firebird 4.0.5 [Approved]
firebird 4.0.4 [Approved]
firebird 4.0.3 [Approved]
firebird 4.0.2 [Approved]
firebird 4.0.1.1000 [Approved]
firebird 4.0.1 [Approved]
firebird 4.0.0 [Approved]
firebird 3.0.13 [Approved]
firebird 3.0.12 [Approved]
firebird 3.0.11 [Approved]
firebird 3.0.10.1000 [Approved]
firebird 3.0.9 [Approved]
firebird 3.0.8 [Approved]
firebird 3.0.7 [Approved]
firebird 3.0.5 [Approved]
firebird 3.0.4 [Approved]
firebird 3.0.3 [Approved]
firebird 3.0.2 [Approved]
firebird 3.0.1.1000 [Approved] Downloads cached for licensed users
firebird 2.5.9 [Approved]
firebird 2.5.8 [Approved]
firebird 2.5.7.1000 [Approved]
firebird 2.5.6.1000 [Approved]
firebird 2.1.7.1000 [Approved]
28 packages found.

There is a --approved-only switch which seems to do nothing except to add a warning:

Starting vith Chocolatey CLI v2.0.0, changes have been made to the
`choco search` command which means that filtering of packages using the
`--approved-only`, `--download-cache`, and `--not-broken` options are
now performed within Chocolatey CLI. Previously, this filtering would
have been performed on the Chocolatey Community Repository. As a result,
it is possible that incomplete package lists are returned from a command
that uses these options.

Otherwise, the results remain the same.

It seems that Chocolatey v2 has made --approved-only the default behavior. Is there a way to disable this?

[pauby]

Until a package is approved, or exempted, it won't return in a search as it's not "available". There is no supported way to return the status of a package.

--approved-only will only return packages that have been approved, and not those that have been exempted.

[pauby]

Is it an issue to keep resubmitting the packages every 24 hours if they haven’t been approved by moderation yet?

Yes. Each time you submit a package, it goes through the moderation services. By continuously submitting a package it will:

• Go through the package moderation services each time.
• Will never get to a state where it can be reviewed.
• Waste resources, and increase the costs of hosting the package moderation services.

Have you checked out Chocolatey AU as both a project (which on the surface does what you are trying to do) or as to how it detects submitted packages and their status?

[fdcastel]

• Will never get to a state where it can be reviewed.
• Waste resources, and increase the costs of hosting the package moderation services.

I see. Understood.

Have you checked out Chocolatey AU as both a project (which on the surface does what you are trying to do) or as to how it detects submitted packages and their status?

I only took a quick look and didn’t spot anything right away, but I’ll dig in further.

In the meantime, my current approach will be to check the https://community.chocolatey.org/packages/$package/$version URL and skip the push if it does not return an HTTP 404 (Not Found).

Thanks again for the details. Much appreciated.

[corbob]

In the meantime, my current approach will be to check the https://community.chocolatey.org/packages/$package/$version URL and skip the push if it does not return an HTTP 404 (Not Found).

I'd have to double check my update scripts, but I'm pretty sure my scripts detect the latest version (usually from GitHub releases), then they run choco search $package --exact --version $versionFound, and if that returns nothing then it bundles things up to be pushed.

[fdcastel]

It looks like Chocolatey AU already does what I had in mind: checking the gallery URL to determine if the package has been submitted.

[fdcastel]

choco search $package --exact --version $versionFound

Excellent! Thank you @corbob! You are correct:

# Version 5.0.3 is still under moderation at the time of this writing.

# choco search firebird --exact --version 5.0.3        
Chocolatey v2.4.3
firebird 5.0.3
1 packages found.

# choco search firebird --exact
Chocolatey v2.4.3
firebird 5.0.2 [Approved]
1 packages found.

I will proceed with this approach.