C API: String LIKE Matching
(c3ref/strlike.html)
sqlite3_strlike()
The sqlite3_strlike(P,X,E) interface returns zero if and only if
string X matches the LIKE pattern P with escape character E.
The definition of LIKE pattern matching used in
sqlite3_strlike(P,X,E) is the same as for ...
|
C API: String Globbing
(c3ref/strglob.html)
sqlite3_strglob()
The sqlite3_strglob(P,X) interface returns zero if and only if
string X matches the GLOB pattern P.
The definition of GLOB pattern matching used in
sqlite3_strglob(P,X) is the same as for the "X GLOB P" operator in ...
|
C API: Finalize A Dynamic String
(c3ref/str_finish.html)
sqlite3_str_finish()
The sqlite3_str_finish(X) interface destroys the sqlite3_str object X
and returns a pointer to a memory buffer obtained from sqlite3_malloc64()
that contains the constructed string. The calling application should
pass the returned value to sqlite3_free() to avoid a memory leak ...
|
C API: SQL Trace Event Codes
(c3ref/c_trace.html)
SQLITE_TRACE_STMT, SQLITE_TRACE_PROFILE, SQLITE_TRACE_ROW, SQLITE_TRACE_CLOSE
... xCallback(T,C,P,X).
The T argument is one of the integer type codes above.
The C argument is a copy of the context pointer passed in as the
fourth argument to sqlite3_trace_v2().
The P and X arguments are ...
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... If sqlite3_value object V was initialized
using sqlite3_bind_pointer(S,I,P,X,D) or sqlite3_result_pointer(C,P,X,D)
and if X and Y are strings that compare equal according to strcmp(X,Y),
then sqlite3_value_pointer(V,Y) will return ...
|
JSON Functions And Operators
(json1.html)
4.19. The json_type() function
The json_type(X) function returns the "type" of the outermost element
of X. The json_type(X,P) function returns the "type" of the element
in X that is selected by path P. The "type" returned by json_type() is
one of ...
|
C API: Find all elements on the right-hand side of an IN constraint.
(c3ref/vtab_in_first.html)
sqlite3_vtab_in_first(), sqlite3_vtab_in_next()
... The X parameter in a call to sqlite3_vtab_in_first(X,P) or
sqlite3_vtab_in_next(X,P) should be one of the parameters to the
xFilter method which invokes these routines, and specifically
a parameter that was previously selected for all-at-once ...
|
C API: Checkpoint a database
(c3ref/wal_checkpoint.html)
sqlite3_wal_checkpoint()
The sqlite3_wal_checkpoint(D,X) is equivalent to
sqlite3_wal_checkpoint_v2(D,X,SQLITE_CHECKPOINT_PASSIVE,0,0).
In brief, sqlite3_wal_checkpoint(D,X) causes the content in the
write-ahead log for database X on database connection D to be
transferred into the database file ...
|
C API: Function Auxiliary Data
(c3ref/get_auxdata.html)
sqlite3_get_auxdata(), sqlite3_set_auxdata()
... After each call to sqlite3_set_auxdata(C,N,P,X) where X is not NULL,
SQLite will invoke the destructor function X with parameter P exactly
once, when the auxiliary data is discarded.
SQLite is free to discard the auxiliary data ...
|
C API: Prepared Statement Scan Status Opcodes
(c3ref/c_scanstat_est.html)
SQLITE_SCANSTAT_NLOOP, SQLITE_SCANSTAT_NVISIT, SQLITE_SCANSTAT_EST, SQLITE_SCANSTAT_NAME, SQLITE_SCANSTAT_EXPLAIN, SQLITE_SCANSTAT_SELECTID ...
The following constants can be used for the T parameter to the
sqlite3_stmt_scanstatus(S,X,T,V) interface. Each constant designates a
different metric for sqlite3_stmt_scanstatus() to return.
When the value returned to V is a string, space to hold ...
|
Page generated by FTS5 in about 78.45 ms.