+ /* if it's in needed, we've already looked at this one */
+ if (list && !jsw_afind(list, soname)) {
+ jsw_ainsert(list, soname);
+ }
+ }
+
+ sqlite3_finalize(st);
+ return count;
+}
+
+char *zpm_findpkg(struct zpm *zpm, char *pkgstr, char *where) {
+ char *select = "select pkgid, package, version, release from packages_pkgid";
+#if 0
+ char *group = "group by package having max( version||'-'||release collate vercmp) order by length(package), package, version||'-'||release collate vercmp";
+#else
+ char *group = "order by package, version collate vercmp desc, cast(release as integer)";
+ //group = "order by package, version , cast(release as integer)";
+#endif
+ sqlite3_str *sql;
+ char *query, *pkgid = 0;
+
+ /* null pkgstr find "best" package
+ * best is shortest complete package if any are complete
+ * shortest incomplete if any are incomplete
+ * where more than one version is in those sets, best is
+ * latest as determined by vercmp
+ */