Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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  be-
       fore  being run on the database.	This allows direct use of the database
       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;'

SEE ALSO
       tracker-sparql(1), tracker-store(1), tracker-info(1).

       http://en.wikipedia.org/wiki/SQL

GNU				 October 2014			tracker-sql(1)

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | EXAMPLES | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=tracker-sql&sektion=1&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help