trace1.html

sqlite的帮助文档

  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></li><li value="2"><p>S20110
  The SQLite library shall provide interfaces that permit the application
  to override the interfaces used to read and write persistent storage.
</p></li><li value="3"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="4"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H10250</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_LOCK_NONE          0
#define SQLITE_LOCK_SHARED        1
#define SQLITE_LOCK_RESERVED      2
#define SQLITE_LOCK_PENDING       3
#define SQLITE_LOCK_EXCLUSIVE     4

</pre></blockquote><ol><li value="1"><p>H11120The 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></li><li value="2"><p>S20110
  The SQLite library shall provide interfaces that permit the application
  to override the interfaces used to read and write persistent storage.
</p></li><li value="3"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="4"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li><li value="1"><p>H11310The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_FCNTL_LOCKSTATE        1

</pre></blockquote></p></li><li value="2"><p>S30800
  SQLite shall provide the interfaces that support testing and
  validation of the library code in an as-delivered configuration.
</p></li><li value="3"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10260</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_SYNC_NORMAL        0x00002
#define SQLITE_SYNC_FULL          0x00003
#define SQLITE_SYNC_DATAONLY      0x00010

</pre></blockquote><ol><li value="1"><p>H11120The 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></li><li value="2"><p>S20110
  The SQLite library shall provide interfaces that permit the application
  to override the interfaces used to read and write persistent storage.
</p></li><li value="3"><p>S20100
  The SQLite library shall provide interfaces that permit the application
  to override interfaces to the platform on which the application is running.
</p></li><li value="4"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H10265</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_INTEGER  1
#define SQLITE_FLOAT    2
#define SQLITE_BLOB     4
#define SQLITE_NULL     5
#ifdef SQLITE_TEXT
# undef SQLITE_TEXT
#else
# define SQLITE_TEXT     3
#endif
#define SQLITE3_TEXT     3

</pre></blockquote><ol><li value="1"><p>S10110
  The SQLite library shall support BLOB, CLOB, integer, and floating-point
  datatypes.
</p></li><li value="2"><p>S10100
  The SQLite library shall accepts a well-defined dialect of SQL
  that conforms to published SQL standards.
</p></li><li value="3"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li><li value="1"><p>S10120
  The SQLite library shall implement the standard SQL interpretation
  of NULL values.
</p></li><li value="2"><p>S10100
  The SQLite library shall accepts a well-defined dialect of SQL
  that conforms to published SQL standards.
</p></li><li value="3"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></td></tr><tr><td valign="top">H10267</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_UTF8           1
#define SQLITE_UTF16LE        2
#define SQLITE_UTF16BE        3
#define SQLITE_UTF16          4    /* Use native byte order */
#define SQLITE_ANY            5    /* sqlite3_create_function only */
#define SQLITE_UTF16_ALIGNED  8    /* sqlite3_create_collation only */

</pre></blockquote><ol><li value="1"><p>H16100The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_create_function(
  sqlite3 *db,
  const char *zFunctionName,
  int nArg,
  int eTextRep,
  void *pApp,
  void (*xFunc)(sqlite3_context*,int,sqlite3_value**),
  void (*xStep)(sqlite3_context*,int,sqlite3_value**),
  void (*xFinal)(sqlite3_context*)
);
int sqlite3_create_function16(
  sqlite3 *db,
  const void *zFunctionName,
  int nArg,
  int eTextRep,
  void *pApp,
  void (*xFunc)(sqlite3_context*,int,sqlite3_value**),
  void (*xStep)(sqlite3_context*,int,sqlite3_value**),
  void (*xFinal)(sqlite3_context*)
);

</pre></blockquote></p></li><li value="2"><p>S20200
  The SQLite library shall provide interfaces that permit the application
  to create new SQL functions.
</p></li><li value="3"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li><li value="1"><p>S50200
  The SQLite library shall support text encoded as UTF-8,
  UTF-16le, or UTF-16be.
</p></li><li value="2"><p>S50000
  The SQLite library shall be cross-platform.
</p></li></ol></td></tr><tr><td valign="top">H10280</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
typedef void (*sqlite3_destructor_type)(void*);
#define SQLITE_STATIC      ((sqlite3_destructor_type)0)
#define SQLITE_TRANSIENT   ((sqlite3_destructor_type)-1)

</pre></blockquote><ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10310</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
SQLITE_EXTERN char *sqlite3_temp_directory;

</pre></blockquote><ol><li value="1"><p>S20000
  The SQLite library shall be extensible and configurable.
</p></li></ol></td></tr><tr><td valign="top">H10330</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_enable_shared_cache(int);

</pre></blockquote><ol><li value="1"><p>S30900
  SQLite shall provide the ability for separate database connections
  within the same process to share resources.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10331</td><td valign="top">A successful invocation of <a href="c3ref/enable_shared_cache.html">sqlite3_enable_shared_cache(B)</a>
will enable or disable shared cache mode for any subsequently
created <a href="c3ref/sqlite3.html">database connection</a> in the same process. <ol><li value="1"><p>S30900
  SQLite shall provide the ability for separate database connections
  within the same process to share resources.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10336</td><td valign="top">When shared cache is enabled, the <a href="c3ref/create_module.html">sqlite3_create_module()</a>
interface will always return an error. <ol><li value="1"><p>S30900
  SQLite shall provide the ability for separate database connections
  within the same process to share resources.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10337</td><td valign="top">The <a href="c3ref/enable_shared_cache.html">sqlite3_enable_shared_cache(B)</a> interface returns
<a href="c3ref/c_abort.html">SQLITE_OK</a> if shared cache was enabled or disabled successfully. <ol><li value="1"><p>S30900
  SQLite shall provide the ability for separate database connections
  within the same process to share resources.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10339</td><td valign="top">Shared cache is disabled by default. <ol><li value="1"><p>S30900
  SQLite shall provide the ability for separate database connections
  within the same process to share resources.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H10510</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_complete(const char *sql);
int sqlite3_complete16(const void *sql);