trace1.html

sqlite的帮助文档

</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">H10200</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#ifdef SQLITE_INT64_TYPE
  typedef SQLITE_INT64_TYPE sqlite_int64;
  typedef unsigned SQLITE_INT64_TYPE sqlite_uint64;
#elif defined(_MSC_VER) || defined(__BORLANDC__)
  typedef __int64 sqlite_int64;
  typedef unsigned __int64 sqlite_uint64;
#else
  typedef long long int sqlite_int64;
  typedef unsigned long long int sqlite_uint64;
#endif
typedef sqlite_int64 sqlite3_int64;
typedef sqlite_uint64 sqlite3_uint64;

</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></ol></td></tr><tr><td valign="top">H10201</td><td valign="top">The <a href="c3ref/int64.html">sqlite_int64</a> and <a href="c3ref/int64.html">sqlite3_int64</a> type shall specify
a 64-bit signed integer. <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></ol></td></tr><tr><td valign="top">H10202</td><td valign="top">The <a href="c3ref/int64.html">sqlite_uint64</a> and <a href="c3ref/int64.html">sqlite3_uint64</a> type shall specify
a 64-bit unsigned integer. <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></ol></td></tr><tr><td valign="top">H10210</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_OK           0   /* Successful result */
/* beginning-of-error-codes */
#define SQLITE_ERROR        1   /* SQL error or missing database */
#define SQLITE_INTERNAL     2   /* Internal logic error in SQLite */
#define SQLITE_PERM         3   /* Access permission denied */
#define SQLITE_ABORT        4   /* Callback routine requested an abort */
#define SQLITE_BUSY         5   /* The database file is locked */
#define SQLITE_LOCKED       6   /* A table in the database is locked */
#define SQLITE_NOMEM        7   /* A malloc() failed */
#define SQLITE_READONLY     8   /* Attempt to write a readonly database */
#define SQLITE_INTERRUPT    9   /* Operation terminated by sqlite3_interrupt()*/
#define SQLITE_IOERR       10   /* Some kind of disk I/O error occurred */
#define SQLITE_CORRUPT     11   /* The database disk image is malformed */
#define SQLITE_NOTFOUND    12   /* NOT USED. Table or record not found */
#define SQLITE_FULL        13   /* Insertion failed because database is full */
#define SQLITE_CANTOPEN    14   /* Unable to open the database file */
#define SQLITE_PROTOCOL    15   /* NOT USED. Database lock protocol error */
#define SQLITE_EMPTY       16   /* Database is empty */
#define SQLITE_SCHEMA      17   /* The database schema changed */
#define SQLITE_TOOBIG      18   /* String or BLOB exceeds size limit */
#define SQLITE_CONSTRAINT  19   /* Abort due to constraint violation */
#define SQLITE_MISMATCH    20   /* Data type mismatch */
#define SQLITE_MISUSE      21   /* Library used incorrectly */
#define SQLITE_NOLFS       22   /* Uses OS features not supported on host */
#define SQLITE_AUTH        23   /* Authorization denied */
#define SQLITE_FORMAT      24   /* Auxiliary database format error */
#define SQLITE_RANGE       25   /* 2nd parameter to sqlite3_bind out of range */
#define SQLITE_NOTADB      26   /* File opened that is not a database file */
#define SQLITE_ROW         100  /* sqlite3_step() has another row ready */
#define SQLITE_DONE        101  /* sqlite3_step() has finished executing */
/* end-of-error-codes */

</pre></blockquote><ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><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">H10220</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_IOERR_READ              (SQLITE_IOERR | (1&lt;&lt;8))
#define SQLITE_IOERR_SHORT_READ        (SQLITE_IOERR | (2&lt;&lt;8))
#define SQLITE_IOERR_WRITE             (SQLITE_IOERR | (3&lt;&lt;8))
#define SQLITE_IOERR_FSYNC             (SQLITE_IOERR | (4&lt;&lt;8))
#define SQLITE_IOERR_DIR_FSYNC         (SQLITE_IOERR | (5&lt;&lt;8))
#define SQLITE_IOERR_TRUNCATE          (SQLITE_IOERR | (6&lt;&lt;8))
#define SQLITE_IOERR_FSTAT             (SQLITE_IOERR | (7&lt;&lt;8))
#define SQLITE_IOERR_UNLOCK            (SQLITE_IOERR | (8&lt;&lt;8))
#define SQLITE_IOERR_RDLOCK            (SQLITE_IOERR | (9&lt;&lt;8))
#define SQLITE_IOERR_DELETE            (SQLITE_IOERR | (10&lt;&lt;8))
#define SQLITE_IOERR_BLOCKED           (SQLITE_IOERR | (11&lt;&lt;8))
#define SQLITE_IOERR_NOMEM             (SQLITE_IOERR | (12&lt;&lt;8))
#define SQLITE_IOERR_ACCESS            (SQLITE_IOERR | (13&lt;&lt;8))
#define SQLITE_IOERR_CHECKRESERVEDLOCK (SQLITE_IOERR | (14&lt;&lt;8))
#define SQLITE_IOERR_LOCK              (SQLITE_IOERR | (15&lt;&lt;8))

</pre></blockquote><ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><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">H10223</td><td valign="top">The symbolic name for an extended result code shall contains
a related primary result code as a prefix. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><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">H10224</td><td valign="top">Primary result code names shall contain a single "_" character. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><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">H10225</td><td valign="top">Extended result code names shall contain two or more "_" characters. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><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">H10226</td><td valign="top">The numeric value of an extended result code shall contain the
numeric value of its corresponding primary result code in
its least significant 8 bits. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><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">H10230</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_OPEN_READONLY         0x00000001
#define SQLITE_OPEN_READWRITE        0x00000002
#define SQLITE_OPEN_CREATE           0x00000004
#define SQLITE_OPEN_DELETEONCLOSE    0x00000008
#define SQLITE_OPEN_EXCLUSIVE        0x00000010
#define SQLITE_OPEN_MAIN_DB          0x00000100
#define SQLITE_OPEN_TEMP_DB          0x00000200
#define SQLITE_OPEN_TRANSIENT_DB     0x00000400
#define SQLITE_OPEN_MAIN_JOURNAL     0x00000800
#define SQLITE_OPEN_TEMP_JOURNAL     0x00001000
#define SQLITE_OPEN_SUBJOURNAL       0x00002000
#define SQLITE_OPEN_MASTER_JOURNAL   0x00004000
#define SQLITE_OPEN_NOMUTEX          0x00008000
#define SQLITE_OPEN_FULLMUTEX        0x00010000

</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>H12700The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_open(
  const char *filename,   /* Database filename (UTF-8) */
  sqlite3 **ppDb          /* OUT: SQLite db handle */
);
int sqlite3_open16(
  const void *filename,   /* Database filename (UTF-16) */
  sqlite3 **ppDb          /* OUT: SQLite db handle */
);
int sqlite3_open_v2(
  const char *filename,   /* Database filename (UTF-8) */
  sqlite3 **ppDb,         /* OUT: SQLite db handle */
  int flags,              /* Flags */
  const char *zVfs        /* Name of VFS module to use */
);

</pre></blockquote></p></li><li value="2"><p>S40200
  The SQLite library shall support multiple independent database
  connections per thread and per process.
</p></li><li value="3"><p>S40000
  The SQLite library shall be safe for use in applications that
  make concurrent access to the underlying database from different
  threads and/or processes.
</p></li></ol></td></tr><tr><td valign="top">H10240</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_IOCAP_ATOMIC          0x00000001
#define SQLITE_IOCAP_ATOMIC512       0x00000002
#define SQLITE_IOCAP_ATOMIC1K        0x00000004
#define SQLITE_IOCAP_ATOMIC2K        0x00000008
#define SQLITE_IOCAP_ATOMIC4K        0x00000010
#define SQLITE_IOCAP_ATOMIC8K        0x00000020
#define SQLITE_IOCAP_ATOMIC16K       0x00000040
#define SQLITE_IOCAP_ATOMIC32K       0x00000080
#define SQLITE_IOCAP_ATOMIC64K       0x00000100
#define SQLITE_IOCAP_SAFE_APPEND     0x00000200
#define SQLITE_IOCAP_SEQUENTIAL      0x00000400

</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);