X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=lib%2Ffindpkg.c;h=8dd0ad14b1a4b7f83b96af8410eaaf9ac54ff79b;hp=6d7981a315055bbe50024fe73b3fe6ca34e3a698;hb=b6f9b692cd319ffbe43fbd191b13613532d82e37;hpb=a068919e82f0565035293903b85d58c21d008679

diff --git a/lib/findpkg.c b/lib/findpkg.c
index 6d7981a..8dd0ad1 100644
--- a/lib/findpkg.c
+++ b/lib/findpkg.c
@@ -81,24 +81,39 @@ char *select = "select printf('%%s-%%s-%%s',P.package,P.version,P.release) as pk
 	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\
-			       ";
+int zpm_packages_needed(struct zpm *zpm, char *pkgid, jsw_atree_t *list) {
+	char *pkglibsneeded = "select soname, selfsatisfied from package_libraries_needed where 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);
+		}
+	}
 
+	sqlite3_finalize(st);
+	return count;
+}
+
+
+int zpm_libraries_needed(struct zpm *zpm, char *pkgid, jsw_atree_t *list) {
+	char *pkglibsneeded = "select soname, selfsatisfied from package_libraries_needed where pkgid = %Q";
 	sqlite3_stmt *st;
 	int count = 0;
 	int rv;
@@ -176,6 +191,76 @@ char *zpm_findpkg(struct zpm *zpm, char *pkgstr, char *where) {
 	}
 
 
+	sqlite3_str_appendall(sql, " ");
+	sqlite3_str_appendall(sql, group);
+	sqlite3_str_appendall(sql, " limit 1;");
+
+	if (sqlite3_str_errcode(sql)) {
+		zpm->error = 1;
+		sqlite3_free(sqlite3_str_finish(sql));
+		return 0;
+	}
+
+	query = sqlite3_str_finish(sql);
+
+	pkgid = zpm_db_string(zpm, query);;
+
+	sqlite3_free(query);
+
+	return pkgid;
+}
+
+char *zpm_findpkg_range(struct zpm *zpm, char *minpkg, char *maxpkg, char *where, int wantleast) {
+	int release;
+	char version[32];
+	char package[32];
+
+	char *select = "select pkgid, package, version, release from packages_pkgid";
+	char *last = "order by version collate vercmp desc, cast(release as integer) desc";
+	char *first = "order by version collate vercmp, cast(release as integer)";
+	char *group;
+
+	char *query, *pkgid = 0;
+	sqlite3_str *sql;
+
+	group = wantleast ? first : last;
+	/* 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
+	 */
+
+	sql = sqlite3_str_new(zpm->db);
+
+	sqlite3_str_appendall(sql, select);
+	sqlite3_str_appendall(sql, " where true");
+
+	if (minpkg) {
+		sqlite3_str_appendf(sql, " and pkgid >= %Q collate vercmp",
+				minpkg);
+		zpm_parse_package(minpkg, package, version, &release);
+		if (*package != 0) {
+			sqlite3_str_appendf(sql, " and package = %Q",
+					package);
+		}
+	}
+
+	if (maxpkg) {
+		sqlite3_str_appendf(sql, " and pkgid <= %Q collate vercmp",
+				maxpkg);
+		zpm_parse_package(maxpkg, package, version, &release);
+		if (*package != 0) {
+			sqlite3_str_appendf(sql, " and package = %Q",
+					package);
+		}
+	}
+
+	if (where) {
+		sqlite3_str_appendall(sql, " and ");
+		sqlite3_str_appendall(sql, where);
+	}
+
 	sqlite3_str_appendall(sql, " ");
 	sqlite3_str_appendall(sql, group);
 	sqlite3_str_appendall(sql, " limit 1;");