Re: pkg_info -Q not finding all entries?

2023-02-01 Thread David Demelier
On Mon, 2023-01-30 at 11:26 +, Stuart Henderson wrote:
> On 2023-01-30, David Demelier  wrote:
> > While searching for sqlite3 I've realized that pkg_info -Q sqlite3
> > finds some php packages but not everything available in the remote
> > repository:
> 
> This is a consequence of the "first repository of the package search
> path" limitation of -Q and how -stable packages are handled.
> It only displays packages for which a -stable update is available.
> 
> Workaround:
> 
> PKG_PATH=http://cdn.openbsd.org/pub/OpenBSD/%v/packages/%a/ pkg_info
> -Q sqlite
> 

Hi,

Thank you for your both answers, I'll keep that around :)

-- 
David



Re: pkg_info -Q not finding all entries?

2023-01-30 Thread Stuart Henderson
On 2023-01-30, David Demelier  wrote:
> While searching for sqlite3 I've realized that pkg_info -Q sqlite3
> finds some php packages but not everything available in the remote
> repository:

This is a consequence of the "first repository of the package search
path" limitation of -Q and how -stable packages are handled.
It only displays packages for which a -stable update is available.

Workaround:

PKG_PATH=http://cdn.openbsd.org/pub/OpenBSD/%v/packages/%a/ pkg_info -Q sqlite

though this won't show updates from the packages-stable directory.
(Or run -current :-)

Another sort-of alternative is to use pkglocate (install the pkglocatedb
package, and for some things postprocessing with | cut -d: -f1 | sort -u
helps).




Re: pkg_info -Q not finding all entries?

2023-01-30 Thread Matthias Schmidt
Hi,

* David Demelier wrote:
> Hello,
> 
> While searching for sqlite3 I've realized that pkg_info -Q sqlite3
> finds some php packages but not everything available in the remote
> repository:
> 
> # cat /etc/installurl 
> https://ftp.fr.openbsd.org/pub/OpenBSD/
> # pkg_info -Q sqlite3
> debug-php-sqlite3-7.4.32p0
> debug-php-sqlite3-7.4.33
> debug-php-sqlite3-8.0.24p0
> debug-php-sqlite3-8.0.25
> debug-php-sqlite3-8.0.26
> debug-php-sqlite3-8.0.27
> debug-php-sqlite3-8.1.11p0
> debug-php-sqlite3-8.1.12
> debug-php-sqlite3-8.1.13
> debug-php-sqlite3-8.1.14
> php-sqlite3-7.4.32p0
> php-sqlite3-7.4.33
> php-sqlite3-8.0.24p0
> php-sqlite3-8.0.25
> php-sqlite3-8.0.26
> php-sqlite3-8.0.27
> php-sqlite3-8.1.11p0
> php-sqlite3-8.1.12
> php-sqlite3-8.1.13
> php-sqlite3-8.1.14

What you see above are the sqlite3 packages from the 7.2
packages-stable/ directory.  When you do the same on a -current you get
much more results and presumably what you expected.

$ pkg_info -Q sqlite3 | wc -l
 20

I assume pkg_info looks only in the stable directory and not in both to
builds a set between updated and not updates packages...

Cheers

Matthias



pkg_info -Q not finding all entries?

2023-01-30 Thread David Demelier
Hello,

While searching for sqlite3 I've realized that pkg_info -Q sqlite3
finds some php packages but not everything available in the remote
repository:

# cat /etc/installurl 
https://ftp.fr.openbsd.org/pub/OpenBSD/
# pkg_info -Q sqlite3
debug-php-sqlite3-7.4.32p0
debug-php-sqlite3-7.4.33
debug-php-sqlite3-8.0.24p0
debug-php-sqlite3-8.0.25
debug-php-sqlite3-8.0.26
debug-php-sqlite3-8.0.27
debug-php-sqlite3-8.1.11p0
debug-php-sqlite3-8.1.12
debug-php-sqlite3-8.1.13
debug-php-sqlite3-8.1.14
php-sqlite3-7.4.32p0
php-sqlite3-7.4.33
php-sqlite3-8.0.24p0
php-sqlite3-8.0.25
php-sqlite3-8.0.26
php-sqlite3-8.0.27
php-sqlite3-8.1.11p0
php-sqlite3-8.1.12
php-sqlite3-8.1.13
php-sqlite3-8.1.14
#

It also does not list the installed package of the exact name 'sqlite3'
(which is installed).

# pkg_info sqlite3
Information for inst:sqlite3-3.39.3

Comment:
embedded SQL implementation

Required by:
python-3.9.16

Description:
SQLite is a C library that implements an embeddable SQL database
engine.
Programs that link with the SQLite library can have SQL database access
without running a separate RDBMS process. The distribution comes with a
standalone command-line access program (sqlite3) that can be used to
administer an SQLite database and which serves as an example of how to
use the SQLite library.

Maintainer: The OpenBSD ports mailing-list 

WWW: https://www.sqlite.org/


Do I miss something (or misunderstood the -Q option)? This is 7.2 on
amd64.

Regards,

-- 
David