1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
tracker3-sql(1)
===============
== NAME
tracker3-sql - Use SQL to query the Tracker databases.
== SYNOPSIS
....
tracker3 sql -q <sql> | -f <file>
....
== DESCRIPTION
This command allows probing of the current database. When using commands
like *tracker3 sparql*, the SPARQL used is translated into SQL before
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::
+
----
$ tracker3 sql -q 'SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;'
----
== SEE ALSO
*tracker3-sparql*(1), *tracker3-info*(1).
*http://en.wikipedia.org/wiki/SQL*
|
