►Toolbox:   Miscellaneous Utilities
▼7 Database
On this page:
sqlite3-stmt-scanstatus-enabled?
sqlite3-keywords
boolean->integer
integer->boolean
->posix/  integer
->jd/  double
    contents    up   

7.4 SQLite🔗

 (require toolbox/db/sqlite3) package: toolbox-db-lib

procedure

(sqlite3-stmt-scanstatus-enabled?) → boolean?

Returns #t if the loaded SQLite library was compiled with SQLITE_ENABLE_STMT_SCANSTATUS, which is required if query profiling is enabled in query via the #:analyze? option. Otherwise, returns #f.

procedure

(sqlite3-keywords) → (listof string?)

Returns the list of reserved keywords returned by the loaded SQLite library. If using SQLite, current-sql-keywords can be set to (sqlite3-keywords) to disable unnecessary quoting of non-keyword identifiers.

Added in version 1.1 of package toolbox-db-lib.

procedure

(boolean->integer v) → (or/c 0 1)

  v : any/c
If v is #f, returns 0, otherwise returns 1.

procedure

(integer->boolean v) → boolean?

  v : (or/c 0 1)
If v is 0, returns #f, otherwise returns #t.

procedure

(->posix/integer v) → exact-integer?

  v : datetime-provider?
Equivalent to (floor (->posix v)).

procedure

(->jd/double v) → (and/c rational? flonum?)

  v : datetime-provider?
Equivalent to (real->double-flonum (->jd v)).

    contents    up