[arch-projects] [AUR] Querying package ID from main repo

tardo tardo at nagi-fanboi.net
Thu Oct 25 02:53:15 EDT 2007

I'd really like to be able to pull package ID numbers from the main site 
DB and put that in the AUR. From what I see, it seems like a simple 
SELECT statement (prefixed by a db_connect() or select_db() if on the 
same host). It's pretty trivial, and since handing out dumps of the main 
repo db just seems to be a no-no, how about someone look through the 
main site's code and finding that statement and throwing it in?

For the record, I don't care about searching for packages on the search 
page, just being able to pull the ID of the package so I can provide a 
good link to the dependencies is enough (current method just searches, 
seems kinda half-assed).

If I had a db dump/site code, here's sort of what I'd implement:

db_connect( ... );
$q = "SELECT ID FROM Packages WHERE Name = 'pkgname'"; // table/columns 
may differ

that should give a numerical result which I can link directly to on the 
package page, eg http://archlinux.org/packages/13418
If anyone can pull out the package ID, i can show what to change in the 
AUR (trivial really).

- tardo

More information about the arch-projects mailing list