reqmatrix.html

sqlite3源码,适合作为嵌入式（embedded）

<tr>
<td valign="top"><a name="H10530">H10530</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_sleep(int);
</pre></blockquote>
<p>Parents: <a href="#S40410">S40410</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H10533">H10533</a></td>
<td valign="top">
The <a href="c3ref/sleep.html">sqlite3_sleep(M)</a> interface invokes the xSleep
method of the default <a href="c3ref/vfs.html">VFS</a> in order to
suspend execution of the current thread for at least
M milliseconds.
<p>Parents: <a href="#S40410">S40410</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H10536">H10536</a></td>
<td valign="top">
The <a href="c3ref/sleep.html">sqlite3_sleep(M)</a> interface returns the number of
milliseconds of sleep actually requested of the operating
system, which might be larger than the parameter M.
<p>Parents: <a href="#S40410">S40410</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11110">H11110</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3_file sqlite3_file;
struct sqlite3_file {
const struct sqlite3_io_methods *pMethods;  /* Methods for an open file */
};
</pre></blockquote>
<p>Parents: <a href="#S20110">S20110</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11120">H11120</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3_io_methods sqlite3_io_methods;
struct sqlite3_io_methods {
int iVersion;
int (*xClose)(sqlite3_file*);
int (*xRead)(sqlite3_file*, void*, int iAmt, sqlite3_int64 iOfst);
int (*xWrite)(sqlite3_file*, const void*, int iAmt, sqlite3_int64 iOfst);
int (*xTruncate)(sqlite3_file*, sqlite3_int64 size);
int (*xSync)(sqlite3_file*, int flags);
int (*xFileSize)(sqlite3_file*, sqlite3_int64 *pSize);
int (*xLock)(sqlite3_file*, int);
int (*xUnlock)(sqlite3_file*, int);
int (*xCheckReservedLock)(sqlite3_file*, int *pResOut);
int (*xFileControl)(sqlite3_file*, int op, void *pArg);
int (*xSectorSize)(sqlite3_file*);
int (*xDeviceCharacteristics)(sqlite3_file*);
/* Additional methods may be added in future releases */
};
</pre></blockquote>
<p>Parents: <a href="#S20110">S20110</a>
</p>
<p>Children: <a href="#H10230">H10230</a>
 <a href="#H10240">H10240</a>
 <a href="#H10250">H10250</a>
 <a href="#H10260">H10260</a>
</p>
</td></tr>

<tr>
<td valign="top"><a name="H11140">H11140</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3_vfs sqlite3_vfs;
struct sqlite3_vfs {
int iVersion;            /* Structure version number */
int szOsFile;            /* Size of subclassed sqlite3_file */
int mxPathname;          /* Maximum file pathname length */
sqlite3_vfs *pNext;      /* Next registered VFS */
const char *zName;       /* Name of this virtual file system */
void *pAppData;          /* Pointer to application-specific data */
int (*xOpen)(sqlite3_vfs*, const char *zName, sqlite3_file*,
int flags, int *pOutFlags);
int (*xDelete)(sqlite3_vfs*, const char *zName, int syncDir);
int (*xAccess)(sqlite3_vfs*, const char *zName, int flags, int *pResOut);
int (*xFullPathname)(sqlite3_vfs*, const char *zName, int nOut, char *zOut);
void *(*xDlOpen)(sqlite3_vfs*, const char *zFilename);
void (*xDlError)(sqlite3_vfs*, int nByte, char *zErrMsg);
void (*(*xDlSym)(sqlite3_vfs*,void*, const char *zSymbol))(void);
void (*xDlClose)(sqlite3_vfs*, void*);
int (*xRandomness)(sqlite3_vfs*, int nByte, char *zOut);
int (*xSleep)(sqlite3_vfs*, int microseconds);
int (*xCurrentTime)(sqlite3_vfs*, double*);
int (*xGetLastError)(sqlite3_vfs*, int, char *);
/* New fields may be appended in figure versions.  The iVersion
** value will increment whenever this happens. */
};
</pre></blockquote>
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p>Children: <a href="#H11190">H11190</a>
</p>
</td></tr>

<tr>
<td valign="top"><a name="H11190">H11190</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_ACCESS_EXISTS    0
#define SQLITE_ACCESS_READWRITE 1
#define SQLITE_ACCESS_READ      2
</pre></blockquote>
<p>Parents: <a href="#H11140">H11140</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11200">H11200</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
sqlite3_vfs *sqlite3_vfs_find(const char *zVfsName);
int sqlite3_vfs_register(sqlite3_vfs*, int makeDflt);
int sqlite3_vfs_unregister(sqlite3_vfs*);
</pre></blockquote>
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11203">H11203</a></td>
<td valign="top">
The <a href="c3ref/vfs_find.html">sqlite3_vfs_find(N)</a> interface returns a pointer to the
registered <a href="c3ref/vfs.html">sqlite3_vfs</a> object whose name exactly matches
the zero-terminated UTF-8 string N, or it returns NULL if
there is no match.
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11206">H11206</a></td>
<td valign="top">
If the N parameter to <a href="c3ref/vfs_find.html">sqlite3_vfs_find(N)</a> is NULL then
the function returns a pointer to the default <a href="c3ref/vfs.html">sqlite3_vfs</a>
object if there is one, or NULL if there is no default
<a href="c3ref/vfs.html">sqlite3_vfs</a> object.
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11209">H11209</a></td>
<td valign="top">
The <a href="c3ref/vfs_find.html">sqlite3_vfs_register(P,F)</a> interface registers the
well-formed <a href="c3ref/vfs.html">sqlite3_vfs</a> object P using the name given
by the zName field of the object.
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11212">H11212</a></td>
<td valign="top">
Using the <a href="c3ref/vfs_find.html">sqlite3_vfs_register(P,F)</a> interface to register
the same <a href="c3ref/vfs.html">sqlite3_vfs</a> object multiple times is a harmless no-op.
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11215">H11215</a></td>
<td valign="top">
The <a href="c3ref/vfs_find.html">sqlite3_vfs_register(P,F)</a> interface makes the <a href="c3ref/vfs.html">sqlite3_vfs</a>
object P the default <a href="c3ref/vfs.html">sqlite3_vfs</a> object if F is non-zero.
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11218">H11218</a></td>
<td valign="top">
The <a href="c3ref/vfs_find.html">sqlite3_vfs_unregister(P)</a> interface unregisters the
<a href="c3ref/vfs.html">sqlite3_vfs</a> object P so that it is no longer returned by
subsequent calls to <a href="c3ref/vfs_find.html">sqlite3_vfs_find()</a>.
<p>Parents: <a href="#S20100">S20100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11300">H11300</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_file_control(sqlite3*, const char *zDbName, int op, void*);
</pre></blockquote>
<p>Parents: <a href="#S30800">S30800</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11302">H11302</a></td>
<td valign="top">
The <a href="c3ref/finalize.html">sqlite3_finalize(S)</a> interface destroys the
<a href="c3ref/stmt.html">prepared statement</a> S and releases all
memory and file resources held by that object.
<p>Parents: <a href="#S70300">S70300</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11304">H11304</a></td>
<td valign="top">
If the most recent call to <a href="c3ref/step.html">sqlite3_step(S)</a> for the
<a href="c3ref/stmt.html">prepared statement</a> S returned an error,
then <a href="c3ref/finalize.html">sqlite3_finalize(S)</a> returns that same error.
<p>Parents: <a href="#S70300">S70300</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H11310">H11310</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_FCNTL_LOCKSTATE        1
#define SQLITE_GET_LOCKPROXYFILE      2
#define SQLITE_SET_LOCKPROXYFILE      3
#define SQLITE_LAST_ERRNO             4
</pre></blockquote>
<p>Parents: <a href="#S30800">S30800</a>
</p>
<p>Children: <a href="#H10250">H10250</a>
</p>
</td></tr>

<tr>
<td valign="top"><a name="H11400">H11400</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_test_control(int op, ...);
</pre></blockquote>
<p>Parents: <a href="#S30800">S30800</a>
</p>
<p>Children: <a href="#H11410">H11410</a>
</p>
</td></tr>

<tr>
<td valign="top"><a name="H11410">H11410</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_TESTCTRL_PRNG_SAVE                5
#define SQLITE_TESTCTRL_PRNG_RESTORE             6
#define SQLITE_TESTCTRL_PRNG_RESET               7
#define SQLITE_TESTCTRL_BITVEC_TEST              8
#define SQLITE_TESTCTRL_FAULT_INSTALL            9
#define SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS     10
</pre></blockquote>
<p>Parents: <a href="#H11400">H11400</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12000">H12000</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef struct sqlite3 sqlite3;
</pre></blockquote>
<p>Parents: <a href="#S40200">S40200</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12010">H12010</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_close(sqlite3 *);
</pre></blockquote>
<p>Parents: <a href="#S30100">S30100</a>
 <a href="#S40200">S40200</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12011">H12011</a></td>
<td valign="top">
A successful call to <a href="c3ref/close.html">sqlite3_close(C)</a> shall destroy the
<a href="c3ref/sqlite3.html">database connection</a> object C.
<p>Parents: <a href="#S30100">S30100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12012">H12012</a></td>
<td valign="top">
A successful call to <a href="c3ref/close.html">sqlite3_close(C)</a> shall return SQLITE_OK.
<p>Parents: <a href="#S30100">S30100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12013">H12013</a></td>
<td valign="top">
A successful call to <a href="c3ref/close.html">sqlite3_close(C)</a> shall release all
memory and system resources associated with <a href="c3ref/sqlite3.html">database connection</a>
C.
<p>Parents: <a href="#S30100">S30100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12014">H12014</a></td>
<td valign="top">
A call to <a href="c3ref/close.html">sqlite3_close(C)</a> on a <a href="c3ref/sqlite3.html">database connection</a> C that
has one or more open <a href="c3ref/stmt.html">prepared statements</a> shall fail with
an <a href="c3ref/c_abort.html">SQLITE_BUSY</a> error code.
<p>Parents: <a href="#S30100">S30100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12015">H12015</a></td>
<td valign="top">
A call to <a href="c3ref/close.html">sqlite3_close(C)</a> where C is a NULL pointer shall
be a harmless no-op returning SQLITE_OK.
<p>Parents: <a href="#S30100">S30100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12019">H12019</a></td>
<td valign="top">
When <a href="c3ref/close.html">sqlite3_close(C)</a> is invoked on a <a href="c3ref/sqlite3.html">database connection</a> C
that has a pending transaction, the transaction shall be
rolled back.
<p>Parents: <a href="#S30100">S30100</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12100">H12100</a></td>
<td valign="top">
The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_exec(
sqlite3*,                                  /* An open database */
const char *sql,                           /* SQL to be evaluated */
int (*callback)(void*,int,char**,char**),  /* Callback function */
void *,                                    /* 1st argument to callback */
char **errmsg                              /* Error msg written here */
);
</pre></blockquote>
<p>Parents: <a href="#S10000">S10000</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12101">H12101</a></td>
<td valign="top">
A successful invocation of <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a>
shall sequentially evaluate all of the UTF-8 encoded,
semicolon-separated SQL statements in the zero-terminated
string S within the context of the <a href="c3ref/sqlite3.html">database connection</a> D.
<p>Parents: <a href="#S10000">S10000</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name="H12102">H12102</a></td>
<td valign="top">
If the S parameter to <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a> is NULL then
the actions of the interface shall be the same as if the
S parameter were an empty string.
<p>Parents: <a href="#S10000">S10000</a>
</p>
<p><i>No children</i></p>
</td></tr>

<tr>
<td valign="top"><a name=