Login
Changes To DbFunctions
Login

Changes to "DbFunctions" between 2014-02-02 18:19:33 and 2014-02-02 18:20:45

1
2
3
4
5
6
7
8
9
10
11

12
13
14


15
16
17
18
19
20
21
1
2
3
4
5
6
7
8
9
10

11
12


13
14
15
16
17
18
19
20
21










-
+

-
-
+
+







<h1>Fossil DB User-defined Functions</h1>

The Fossil DB schemas can be perused, in the form of
commented SQL, in [http://fossil.wanderinghorse.net/repos/libfossil/doxygen/|the API docs].

A fossil-bound DB handle gets a few extra SQL-callable functions, as
listed below in alphabetical order...

<h3>FSL_CI_MTIME()</h3>

<tt>FSL_CI_MTIME(INT,INT)</tt> is for internal use only. It takes a
<tt>FSL_CI_MTIME(INT,INT)</tt> takes a
manifest RID and a filename FNID as arguments and behaves like
<tt>fsl_mtime_of_manifest_file()</tt>, returning the calculates mtime
as an SQL integer (Unix epoch timestamp).
<tt>fsl_mtime_of_manifest_file()</tt>, returning the calculated (and highly synthetic!) mtime as an SQL integer (Unix epoch timestamp). This is primarily
for internal use.


<h3>FSL_CONTENT()</h3>

<tt>FSL_CONTENT(INTEGER|STRING)</tt> returns the undeltified,
uncompressed content for the blob record with the given RID (if
the argument is an integer) or symbolic name (as per