Login
Changes To DbFunctions
Login

Changes to "DbFunctions" between 2014-10-17 11:28:03 and 2014-10-17 11:28:38

9
10
11
12
13
14
15
16

17
18
19
20
21
22
23
9
10
11
12
13
14
15

16
17
18
19
20
21
22
23







-
+







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

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

<h3>FSL_CKOUT_DIR()</h3>

<tt>FSL_CKOUT_DIR([INTEGER=0])</tt> returns the path to the current checkout directory, or NULL if no checkout is opened. If passed no argument or passed a truthy value, the trailing slash is included in the returned value. If passed a falsy argument, the slash is not included.
<tt>FSL_CKOUT_DIR(<nowiki>[INTEGER=0]</nowiki>)</tt> returns the path to the current checkout directory, or NULL if no checkout is opened. If passed no argument or passed a truthy value, the trailing slash is included in the returned value. If passed a falsy argument, the slash is not included.


<h3>FSL_CI_MTIME()</h3>

<tt>FSL_CI_MTIME(INT,INT)</tt> takes two RIDs as arguments: the manifest (checkin) version RID and the blob.rid value of a file which part of the first RID's checkin.

It behaves like <tt>fsl_mtime_of_manifest_file()</tt>, returning the calculated (and highly synthetic!) mtime as an SQL integer (Unix epoch timestamp). This is primarily