tracker-sql - Use SQL to query the Tracker databases.
tracker sql -q <sql> | -f <file>
tracker-sql(1) User Commands tracker-sql(1) NAME tracker-sql - Use SQL to query the Tracker databases. SYNOPSIS tracker sql -q <sql> | -f <file> DESCRIPTION This command allows probing of the current database. When using com- mands like tracker sparql, the SPARQL used is translated into SQL before being run on the database. This allows direct use of the data- base using SQL avoiding the SPARQL engine entirely. The caller can run a query two ways, either by providing a file with the query or by providing a string with the sql query. The file argument can be either a local path or a URI. It also does not have to be an absolute path. OPTIONS -f, --file=<file> Use a file with SPARQL content to query. Don't forget to end all queries with a semicolon (;) and also to use quotes around table names. The quotes are important because most tables are named after ontology classes like "nfo:Document" and queries will fail without the quotes. -q, --query=<sql> Use a sql string to query the database with. EXAMPLES Show first 10 "nfo:Document" entries where the TOC is not NULL: $ tracker sql -q 'SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;' ATTRIBUTES See attributes(7) for descriptions of the following attributes: +---------------+--------------------------------+ |ATTRIBUTE TYPE | ATTRIBUTE VALUE | +---------------+--------------------------------+ |Availability | library/desktop/search/tracker | +---------------+--------------------------------+ |Stability | Pass-through volatile | +---------------+--------------------------------+ SEE ALSO tracker-sparql(1), tracker-store(1), tracker-info(1). http://en.wikipedia.org/wiki/SQL NOTES Source code for open source software components in Oracle Solaris can be found at https://www.oracle.com/downloads/opensource/solaris-source- code-downloads.html. This software was built from source available at https://github.com/oracle/solaris-userland. The original community source was downloaded from https://down- load.gnome.org/sources/tracker/2.3/tracker-2.3.6.tar.xz. Further information about this software can be found on the open source community website at https://www.gnome.org/. GNU October 2014 tracker-sql(1)