+ sqlite3_free(query);
+
+ return pkgid;
+}
+
+int zpm_libraries_needed(struct zpm *zpm, char *pkgid, jsw_atree_t *list) {
+ char *pkglibsneeded = "\
+ with pkglibs as (\
+ select distinct EN.needed as soname, PF.pkgid\
+ from elfneeded EN\
+ join packagefiles_pkgid PF on PF.hash = EN.file\
+ ),\
+ pkgprovides as (\
+ select distinct EL.soname, PF.pkgid\
+ from elflibraries EL\
+ join packagefiles_pkgid PF on PF.hash = EL.file\
+ )\
+ select distinct PL.soname, PP.soname is not null as selfsatisfied\
+ from pkglibs PL\
+ left join pkgprovides PP on PL.pkgid = PP.pkgid and PL.soname = PP.soname\
+ where PL.pkgid = %Q\
+ ";
+
+ sqlite3_stmt *st;
+ int count = 0;
+ int rv;
+
+ st = zpm_dbquery(zpm, pkglibsneeded, pkgid);
+
+ while ((rv = sqlite3_step(st)) == SQLITE_ROW) {
+ char *soname;
+ int self;
+
+ soname = (char *)sqlite3_column_text(st, 0);
+ /* TODO check and skip self sats */
+ self = sqlite3_column_int(st,1);
+ if (self) {
+ continue;
+ }
+ count++;
+
+ /* if it's in needed, we've already looked at this one */
+ if (list && !jsw_afind(list, soname)) {
+ jsw_ainsert(list, soname);
+ }
+ }