struct pkgdb_it *
pkgdb_repo_origins(sqlite3 *sqlite)
{
sqlite3_stmt *stmt = NULL;
int ret;
static struct pkgdb repodb;
const char query_sql[] = ""
"SELECT id, origin, name, version, comment, "
"prefix, desc, arch, maintainer, www, "
"licenselogic, flatsize, pkgsize, "
"cksum, path AS repopath, manifestdigest "
"FROM packages "
"ORDER BY origin;";
ret = sqlite3_prepare_v2(sqlite, query_sql, -1,
&stmt, NULL);
if (ret != SQLITE_OK) {
ERROR_SQLITE(sqlite);
return (NULL);
}
repodb.sqlite = sqlite;
repodb.type = PKGDB_REMOTE;
return pkgdb_it_new(&repodb, stmt, PKG_REMOTE, PKGDB_IT_FLAG_ONCE);
}
struct pkgdb_it *
pkgdb_rquery_provide(struct pkgdb *db, const char *provide, const char *repo)
{
sqlite3_stmt *stmt;
struct sbuf *sql = NULL;
const char *reponame = NULL;
int ret;
const char basesql[] = ""
"SELECT p.id, p.origin, p.name, p.version, p.comment, "
"p.name || '~' || p.origin as uniqueid, "
"p.prefix, p.desc, p.arch, p.maintainer, p.www, "
"p.licenselogic, p.flatsize, p.pkgsize, "
"p.cksum, p.manifestdigest, p.path AS repopath, '%1$s' AS dbname "
"FROM '%1$s'.packages AS p, '%1$s'.pkg_provides AS pp, "
"'%1$s'.provides AS pr "
"WHERE p.id = pp.package_id "
"AND pp.provide_id = pr.id "
"AND pr.name = ?1;";
assert(db != NULL);
reponame = pkgdb_get_reponame(db, repo);
sql = sbuf_new_auto();
/*
* Working on multiple remote repositories
*/
if (reponame == NULL) {
/* duplicate the query via UNION for all the attached
* databases */
ret = pkgdb_sql_all_attached(db->sqlite, sql,
basesql, " UNION ALL ");
if (ret != EPKG_OK) {
sbuf_delete(sql);
return (NULL);
}
} else
sbuf_printf(sql, basesql, reponame);
sbuf_finish(sql);
pkg_debug(4, "Pkgdb: running '%s'", sbuf_get(sql));
ret = sqlite3_prepare_v2(db->sqlite, sbuf_get(sql), -1, &stmt, NULL);
if (ret != SQLITE_OK) {
ERROR_SQLITE(db->sqlite, sbuf_get(sql));
sbuf_delete(sql);
return (NULL);
}
sbuf_delete(sql);
sqlite3_bind_text(stmt, 1, provide, -1, SQLITE_TRANSIENT);
return (pkgdb_it_new(db, stmt, PKG_REMOTE, PKGDB_IT_FLAG_ONCE));
}
struct pkgdb_it *
pkgdb_query_which(struct pkgdb *db, const char *path)
{
sqlite3_stmt *stmt;
const char sql[] = ""
"SELECT p.rowid, p.origin, p.name, p.version, p.comment, p.desc, "
"p.message, p.arch, p.osversion, p.maintainer, p.www, "
"p.prefix, p.flatsize "
"FROM packages AS p, files AS f "
"WHERE p.rowid = f.package_id "
"AND f.path = ?1;";
if (sqlite3_prepare_v2(db->sqlite, sql, -1, &stmt, NULL) != SQLITE_OK) {
ERROR_SQLITE(db->sqlite);
return (NULL);
}
sqlite3_bind_text(stmt, 1, path, -1, SQLITE_TRANSIENT);
return (pkgdb_it_new(db, stmt, IT_LOCAL));
}
struct pkgdb_it *
pkgdb_query_upgrades(struct pkgdb *db)
{
if (db->remote != PKGDB_REMOTE)
return (NULL);
sqlite3_stmt *stmt;
const char sql[] = ""
"SELECT l.id, l.origin, l.name, l.version, l.comment, l.desc, "
"l.message, l.arch, l.osversion, l.maintainer, "
"l.www, l.prefix, l.flatsize, r.version, r.flatsize, r.pkgsize, r.path "
"FROM main.packages AS l, "
"remote.packages AS r "
"WHERE l.origin = r.origin "
"AND PKGLT(l.version, r.version)";
if (sqlite3_prepare_v2(db->sqlite, sql, -1, &stmt, NULL) != SQLITE_OK)
return (NULL);
return (pkgdb_it_new(db, stmt, IT_UPGRADE));
}
struct pkgdb_it *
pkgdb_rquery(struct pkgdb *db, const char *pattern, match_t match,
const char *repo)
{
sqlite3_stmt *stmt = NULL;
struct sbuf *sql = NULL;
const char *reponame = NULL;
const char *comp = NULL;
int ret;
char basesql[BUFSIZ] = ""
"SELECT id, origin, name, version, comment, "
"prefix, desc, arch, maintainer, www, "
"licenselogic, flatsize, pkgsize, "
"cksum, manifestdigest, path AS repopath, '%1$s' AS dbname "
"FROM '%1$s'.packages p";
assert(db != NULL);
assert(match == MATCH_ALL || (pattern != NULL && pattern[0] != '\0'));
/*
* If we have no remote repos loaded, we just return nothing instead of failing
* an assert deep inside pkgdb_get_reponame
*/
if (db->type != PKGDB_REMOTE)
return (NULL);
reponame = pkgdb_get_reponame(db, repo);
sql = sbuf_new_auto();
comp = pkgdb_get_pattern_query(pattern, match);
if (comp && comp[0])
strlcat(basesql, comp, sizeof(basesql));
/*
* Working on multiple remote repositories
*/
if (reponame == NULL) {
/* duplicate the query via UNION for all the attached
* databases */
ret = pkgdb_sql_all_attached(db->sqlite, sql,
basesql, " UNION ALL ");
if (ret != EPKG_OK) {
sbuf_delete(sql);
return (NULL);
}
} else
sbuf_printf(sql, basesql, reponame, reponame);
sbuf_cat(sql, " ORDER BY name;");
sbuf_finish(sql);
pkg_debug(4, "Pkgdb: running '%s'", sbuf_get(sql));
ret = sqlite3_prepare_v2(db->sqlite, sbuf_get(sql), sbuf_size(sql), &stmt, NULL);
if (ret != SQLITE_OK) {
ERROR_SQLITE(db->sqlite);
sbuf_delete(sql);
return (NULL);
}
sbuf_delete(sql);
if (match != MATCH_ALL && match != MATCH_CONDITION)
sqlite3_bind_text(stmt, 1, pattern, -1, SQLITE_TRANSIENT);
return (pkgdb_it_new(db, stmt, PKG_REMOTE, PKGDB_IT_FLAG_ONCE));
}
struct pkgdb_it *
pkgdb_query(struct pkgdb *db, const char *pattern, match_t match)
{
char sql[BUFSIZ];
sqlite3_stmt *stmt;
const char *comp = NULL;
char *checkorigin = NULL;
if (match != MATCH_ALL && pattern == NULL) {
ERROR_BAD_ARG("pattern");
return (NULL);
}
if (pattern != NULL)
checkorigin = strchr(pattern, '/');
switch (match) {
case MATCH_ALL:
comp = "";
break;
case MATCH_EXACT:
if (checkorigin == NULL)
comp = " WHERE p.name = ?1";
else
comp = " WHERE p.origin = ?1";
break;
case MATCH_GLOB:
if (checkorigin == NULL)
comp = " WHERE p.name GLOB ?1";
else
comp = " WHERE p.origin GLOB ?1";
break;
case MATCH_REGEX:
if (checkorigin == NULL)
comp = " WHERE p.name REGEXP ?1";
else
comp = " WHERE p.origin REGEXP ?1";
break;
case MATCH_EREGEX:
if (checkorigin == NULL)
comp = " WHERE EREGEXP(?1, p.name)";
else
comp = " WHERE EREGEXP(?1, p.origin)";
break;
}
snprintf(sql, sizeof(sql),
"SELECT p.rowid, p.origin, p.name, p.version, p.comment, p.desc, "
"p.message, p.arch, p.osversion, p.maintainer, p.www, "
"p.prefix, p.flatsize "
"FROM packages AS p%s "
"ORDER BY p.name;", comp);
if (sqlite3_prepare_v2(db->sqlite, sql, -1, &stmt, NULL) != SQLITE_OK) {
ERROR_SQLITE(db->sqlite);
return (NULL);
}
if (match != MATCH_ALL)
sqlite3_bind_text(stmt, 1, pattern, -1, SQLITE_TRANSIENT);
return (pkgdb_it_new(db, stmt, IT_LOCAL));
}
