Koldom
Help: sql
Not logged in

The "sql" command:

Usage: fossil sql ?OPTIONS?

Run the sqlite3 command-line shell on the Fossil repository identified by the -R option, or on the current repository. See https://www.sqlite.org/cli.html for additional information about the sqlite3 command-line shell.

WARNING: Careless use of this command can corrupt a Fossil repository in ways that are unrecoverable. Be sure you know what you are doing before running any SQL commands that modify the repository database. Use the --readonly option to prevent accidental damage to the repository.

Options:

--no-repository
Skip opening the repository database
--readonly
Open the repository read-only. No changes are allowed. This is a recommended safety precaution to prevent repository damage.
-R REPOSITORY
Use REPOSITORY as the repository database
--test
Enable some testing and analysis features that are normally disabled.

All of the standard sqlite3 command-line shell options should also work.

The following SQL extensions are provided with this Fossil-enhanced version of the sqlite3 command-line shell:

builtin
A virtual table that contains one row for each datafile that is built into the Fossil binary.

checkin_mtime(X,Y)
Return the mtime for the file Y (a BLOB.RID) found in check-in X (another BLOB.RID value).

compress(X)
Compress text X with the same algorithm used to compress artifacts in the BLOB table.

content(X)
Return the content of artifact X. X can be an artifact hash or hash prefix or a tag. Artifacts are stored compressed and deltaed. This function does all necessary decompression and undeltaing.

decompress(X)
Decompress text X. Undoes the work of compress(X).

delta_apply(X,D)
Apply delta D to source blob X and return the result.

delta_create(X,Y)
Create and return a delta that will convert X into Y.

delta_output_size(D)
Return the number of bytes of output to expect when applying delta D

delta_parse(D)
A table-valued function that deconstructs delta D and returns rows for each element of that delta.

files_of_checkin(X)
A table-valued function that returns info on all files contained in check-in X. Example:
SELECT * FROM files_of_checkin('trunk');

helptext
A virtual table with one row for each command, webpage, and setting together with the built-in help text.

now()
Return the number of seconds since 1970.

obscure(T)
Obfuscate the text password T so that its original value is not readily visible. Fossil uses this same algorithm when storing passwords of remote URLs.

regexp
The REGEXP operator works, unlike in standard SQLite.

symbolic_name_to_rid(X)
Return the BLOB.RID corresponding to symbolic name X.