stardog query execute Manual Page

NAME


stardog query execute —Executes a query against a database; prints the query results on STDOUT.

SYNOPSIS


stardog [ --krb5 ] [ --krb5-disable-rdns ]query execute [ {-b | --bind} <variables to bind>... ] [ {-f | --format} <resultFormat> ] [ {-g | --named-graph} <Named graph> ] [ {-l | --limit} <N> ] [ {-o | --offset} <N> ] [ {-p | --passwd} <password> ] [ {-P | --ask-password} ] [ {-r | --reasoning} ] [ --timeout <N[h|m|s]> ] [ --tx <txID> ] [ {-u | --username} <username> ] [ {-v | --verbose} ] [--] <database> <query>...

OPTIONS


-b <variables to bind>, --bind <variables to bind>
Variable bindings. One or more variable bindings to apply before executing query. Each binding is provided as a 'var=value' pair; multiple bindings should be separated with whitespaces. Variables must exist in the query and the value should be a valid RDF term in Turtle syntax. Namespaces stored in the database can be used in the values; e.g. x=ex:name. Quotes areneeded around IRIs to avoid special characters to be evaluated by the shell; e.g. y="<http://example.org/test>". In Turtle syntax literals have quotes which need to be escaped to differentiate them from shell quotes; e.g. z=\"value\". Finally, if a literal contains special characters or a space then additional quotes are needed for the shell; e.g. z="\"another value\"".
-f <resultFormat>, --format <resultFormat>
Result format for RDF [NTRIPLES, RDF/XML, TURTLE, PRETTY_TURTLE, TRIG, TRIX, N3, NQUADS] or SPARQL [SPARQL, JSON, TEXT, TABLE, CSV, TSV, HTML].
-g <Named graph>, --named-graph <Named graph>
Default graph to run the queries against.
--krb5
Use the Kerberos environment.
--krb5-disable-rdns
Disable reverse DNS lookup for Kerberos clients.
-l <N>, --limit <N>
Limit the number of results the query will return. Specifying the limit willoverride any limit specified in the original query string
-o <N>, --offset <N>
Skip the first N results the query will return. Specifying the offset willoverride any offset specified in the original query string
-p <password>, --passwd <password>
Password.
-P, --ask-password
Prompt for password.
-r, --reasoning
Turn reasoning on.
--timeout <N[h|m|s]>
Timeout for the query in ms. An optional time unit can be specified by the suffix 'h' (for hours), 'm' (for minutes), or 's' (for seconds).Timeout value of 0 results in no timeout
--tx <txID>
Transaction ID this query will run against. A read query will see all the changes done in the transaction before they are committed. An update query will run as part of the given transaction.will be needed.
-u <username>, --username <username>
User name.
-v, --verbose
Verbose flag that causes more detailed information to be printed
--
This option can be used to separate command-line options from the list of argument, (useful when arguments might be mistaken for command-line options
<database> <query>
The name of the database or the full connection string of the database to connect to. If only the name is provided, the default server URL will be pre-pended to the name of the database in order to construct the connection string. Connection parameters such as ';reasoning=true' can be included in the provided database name. Connection parameters specified like this can be overridden by specific options on the command. The default server URL will be read from the JVM argument 'stardog.default.cli.server'. If the JVM argument is not set, the default value 'http://localhost:5820' is used. If the server URL has no explicit port value, the default port value '5820' is used. To use a secure connection, you should specify the full connection string and postfix 's' to the protocol, e.g. https. The subsequent argument is the SPARQL query string to execute. This can either be a file name, a SPARQL query string, or astored query name.

EXAMPLES


Basic query execution:

    $ stardog query myDb "select * where { ?s ?p ?o }"

Execute a query with some specified bindings:

    $ stardog query -b s="<http://example.org/test>" p=ex:name o="\"John Doe\"" myDb "select * {?s ?p ?o}"

Execute a query with reasoning:

    $ stardog query myDb --reasoning "select ?type where { <urn:an:individual> rdf:type ?type }"

Execute a query specified in a file:

    $ stardog query myDb query.sparql

Execute a stored query using its name:

    $ stardog query myDb listNamedGraphs