/*

** 2001 September 15

**

** The author disclaims copyright to this source code.  In place of

** a legal notice, here is a blessing:

**

**    May you do good and not evil.

**    May you find forgiveness for yourself and forgive others.

**    May you share freely, never taking more than you give.

**

*************************************************************************

** This header file defines the interface that the SQLite library

** presents to client programs.  If a C-function, structure, datatype,

** or constant definition does not appear in this file, then it is

** not a published API of SQLite, is subject to change without

** notice, and should not be referenced by programs that use SQLite.

**

** Some of the definitions that are in this file are marked as

** "experimental".  Experimental interfaces are normally new

** features recently added to SQLite.  We do not anticipate changes

** to experimental interfaces but reserve to make minor changes if

** experience from use "in the wild" suggest such changes are prudent.

**

** The official C-language API documentation for SQLite is derived

** from comments in this file.  This file is the authoritative source

** on how SQLite interfaces are suppose to operate.

**

** The name of this file under configuration management is "sqlite.h.in".

** The makefile makes some minor changes to this file (such as inserting

** the version number) and changes its name to "sqlite3.h" as

** part of the build process.

**

** @(#) $Id: sqlite.h.in,v 1.387 2008/08/05 17:53:23 drh Exp $

*/

#ifndef _SQLITE3_H_

#define _SQLITE3_H_

#include <stdarg.h>     /* Needed for the definition of va_list */

/*

** Make sure we can call this stuff from C++.

*/

#ifdef __cplusplus

extern "C" {

#endif

/*

** Add the ability to override 'extern'

*/

#ifndef SQLITE_EXTERN

# define SQLITE_EXTERN extern

#endif

/*

** Ensure these symbols were not defined by some previous header file.

*/

#ifdef SQLITE_VERSION

# undef SQLITE_VERSION

#endif

#ifdef SQLITE_VERSION_NUMBER

# undef SQLITE_VERSION_NUMBER

#endif

/*

** CAPI3REF: Compile-Time Library Version Numbers {H10010} <S60100>

**

** The SQLITE_VERSION and SQLITE_VERSION_NUMBER #defines in

** the sqlite3.h file specify the version of SQLite with which

** that header file is associated.

**

** The "version" of SQLite is a string of the form "X.Y.Z".

** The phrase "alpha" or "beta" might be appended after the Z.

** The X value is major version number always 3 in SQLite3.

** The X value only changes when backwards compatibility is

** broken and we intend to never break backwards compatibility.

** The Y value is the minor version number and only changes when

** there are major feature enhancements that are forwards compatible

** but not backwards compatible.

** The Z value is the release number and is incremented with

** each release but resets back to 0 whenever Y is incremented.

**

** See also: [sqlite3_libversion()] and [sqlite3_libversion_number()].

**

** INVARIANTS:

**

** {H10011} The SQLITE_VERSION #define in the sqlite3.h header file shall

**          evaluate to a string literal that is the SQLite version

**          with which the header file is associated.

**

** {H10014} The SQLITE_VERSION_NUMBER #define shall resolve to an integer

**          with the value (X*1000000 + Y*1000 + Z) where X, Y, and Z

**          are the major version, minor version, and release number.

*/

#define SQLITE_VERSION         "3.6.1"

#define SQLITE_VERSION_NUMBER  3006001

/*

** CAPI3REF: Run-Time Library Version Numbers {H10020} <S60100>

** KEYWORDS: sqlite3_version

**

** These features provide the same information as the [SQLITE_VERSION]

** and [SQLITE_VERSION_NUMBER] #defines in the header, but are associated

** with the library instead of the header file.  Cautious programmers might

** include a check in their application to verify that

** sqlite3_libversion_number() always returns the value

** [SQLITE_VERSION_NUMBER].

**

** The sqlite3_libversion() function returns the same information as is

** in the sqlite3_version[] string constant.  The function is provided

** for use in DLLs since DLL users usually do not have direct access to string

** constants within the DLL.

**

** INVARIANTS:

**

** {H10021} The [sqlite3_libversion_number()] interface shall return

**          an integer equal to [SQLITE_VERSION_NUMBER].

**

** {H10022} The [sqlite3_version] string constant shall contain

**          the text of the [SQLITE_VERSION] string.

**

** {H10023} The [sqlite3_libversion()] function shall return

**          a pointer to the [sqlite3_version] string constant.

*/

SQLITE_EXTERN const char sqlite3_version[];

const char *sqlite3_libversion(void);

int sqlite3_libversion_number(void);

/*

** CAPI3REF: Test To See If The Library Is Threadsafe {H10100} <S60100>

**

** SQLite can be compiled with or without mutexes.  When

** the [SQLITE_THREADSAFE] C preprocessor macro is true, mutexes

** are enabled and SQLite is threadsafe.  When that macro is false,

** the mutexes are omitted.  Without the mutexes, it is not safe

** to use SQLite concurrently from more than one thread.

**

** Enabling mutexes incurs a measurable performance penalty.

** So if speed is of utmost importance, it makes sense to disable

** the mutexes.  But for maximum safety, mutexes should be enabled.

** The default behavior is for mutexes to be enabled.

**

** This interface can be used by a program to make sure that the

** version of SQLite that it is linking against was compiled with

** the desired setting of the [SQLITE_THREADSAFE] macro.

**

** This interface only reports on the compile-time mutex setting

** of the [SQLITE_THREADSAFE] flag.  If SQLite is compiled with

** SQLITE_THREADSAFE=1 then mutexes are enabled by default but

** can be fully or partially disabled using a call to [sqlite3_config()]

** with the verbs [SQLITE_CONFIG_SINGLETHREAD], [SQLITE_CONFIG_MULTITHREAD],

** or [SQLITE_CONFIG_MUTEX].  The return value of this function shows

** only the default compile-time setting, not any run-time changes

** to that setting.

**

** INVARIANTS:

**

** {H10101} The [sqlite3_threadsafe()] function shall return nonzero if

**          SQLite was compiled with the its mutexes enabled by default

**          or zero if SQLite was compiled such that mutexes are

**          permanently disabled.

**

** {H10102} The value returned by the [sqlite3_threadsafe()] function

**          shall not change when mutex setting are modified at

**          runtime using the [sqlite3_config()] interface and 

**          especially the [SQLITE_CONFIG_SINGLETHREAD],

**          [SQLITE_CONFIG_MULTITHREAD], [SQLITE_CONFIG_SERIALIZED],

**          and [SQLITE_CONFIG_MUTEX] verbs.

*/

int sqlite3_threadsafe(void);

/*

** CAPI3REF: Database Connection Handle {H12000} <S40200>

** KEYWORDS: {database connection} {database connections}

**

** Each open SQLite database is represented by a pointer to an instance of

** the opaque structure named "sqlite3".  It is useful to think of an sqlite3

** pointer as an object.  The [sqlite3_open()], [sqlite3_open16()], and

** [sqlite3_open_v2()] interfaces are its constructors, and [sqlite3_close()]

** is its destructor.  There are many other interfaces (such as

** [sqlite3_prepare_v2()], [sqlite3_create_function()], and

** [sqlite3_busy_timeout()] to name but three) that are methods on an

** sqlite3 object.

*/

typedef struct sqlite3 sqlite3;

/*

** CAPI3REF: 64-Bit Integer Types {H10200} <S10110>

** KEYWORDS: sqlite_int64 sqlite_uint64

**

** Because there is no cross-platform way to specify 64-bit integer types

** SQLite includes typedefs for 64-bit signed and unsigned integers.

**

** The sqlite3_int64 and sqlite3_uint64 are the preferred type definitions.

** The sqlite_int64 and sqlite_uint64 types are supported for backwards

** compatibility only.

**

** INVARIANTS:

**

** {H10201} The [sqlite_int64] and [sqlite3_int64] type shall specify

**          a 64-bit signed integer.

**

** {H10202} The [sqlite_uint64] and [sqlite3_uint64] type shall specify

**          a 64-bit unsigned integer.

*/

#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;

/*

** If compiling for a processor that lacks floating point support,

** substitute integer for floating-point.

*/

#ifdef SQLITE_OMIT_FLOATING_POINT

# define double sqlite3_int64

#endif

/*

** CAPI3REF: Closing A Database Connection {H12010} <S30100><S40200>

**

** This routine is the destructor for the [sqlite3] object.

**

** Applications should [sqlite3_finalize | finalize] all [prepared statements]

** and [sqlite3_blob_close | close] all [BLOB handles] associated with

** the [sqlite3] object prior to attempting to close the object.

** The [sqlite3_next_stmt()] interface can be used to locate all

** [prepared statements] associated with a [database connection] if desired.

** Typical code might look like this:

**

** <blockquote><pre>

** sqlite3_stmt *pStmt;

** while( (pStmt = sqlite3_next_stmt(db, 0))!=0 ){

**     sqlite3_finalize(pStmt);

** }

** </pre></blockquote>

**

** If [sqlite3_close()] is invoked while a transaction is open,

** the transaction is automatically rolled back.

**

** INVARIANTS:

**

** {H12011} A successful call to [sqlite3_close(C)] shall destroy the

**          [database connection] object C.

**

** {H12012} A successful call to [sqlite3_close(C)] shall return SQLITE_OK.

**

** {H12013} A successful call to [sqlite3_close(C)] shall release all

**          memory and system resources associated with [database connection]

**          C.

**

** {H12014} A call to [sqlite3_close(C)] on a [database connection] C that

**          has one or more open [prepared statements] shall fail with

**          an [SQLITE_BUSY] error code.

**

** {H12015} A call to [sqlite3_close(C)] where C is a NULL pointer shall

**          return SQLITE_OK.

**

** {H12019} When [sqlite3_close(C)] is invoked on a [database connection] C

**          that has a pending transaction, the transaction shall be

**          rolled back.

**

** ASSUMPTIONS:

**

** {A12016} The C parameter to [sqlite3_close(C)] must be either a NULL

**          pointer or an [sqlite3] object pointer obtained

**          from [sqlite3_open()], [sqlite3_open16()], or

**          [sqlite3_open_v2()], and not previously closed.

*/

int sqlite3_close(sqlite3 *);

/*

** The type for a callback function.

** This is legacy and deprecated.  It is included for historical

** compatibility and is not documented.

*/

typedef int (*sqlite3_callback)(void*,int,char**, char**);

/*

** CAPI3REF: One-Step Query Execution Interface {H12100} <S10000>

**

** The sqlite3_exec() interface is a convenient way of running one or more

** SQL statements without having to write a lot of C code.  The UTF-8 encoded

** SQL statements are passed in as the second parameter to sqlite3_exec().

** The statements are evaluated one by one until either an error or

** an interrupt is encountered, or until they are all done.  The 3rd parameter

** is an optional callback that is invoked once for each row of any query

** results produced by the SQL statements.  The 5th parameter tells where

** to write any error messages.

**

** The error message passed back through the 5th parameter is held

** in memory obtained from [sqlite3_malloc()].  To avoid a memory leak,

** the calling application should call [sqlite3_free()] on any error

** message returned through the 5th parameter when it has finished using

** the error message.

**

** If the SQL statement in the 2nd parameter is NULL or an empty string

** or a string containing only whitespace and comments, then no SQL

** statements are evaluated and the database is not changed.

**

** The sqlite3_exec() interface is implemented in terms of

** [sqlite3_prepare_v2()], [sqlite3_step()], and [sqlite3_finalize()].

** The sqlite3_exec() routine does nothing to the database that cannot be done

** by [sqlite3_prepare_v2()], [sqlite3_step()], and [sqlite3_finalize()].

**

** INVARIANTS:

**

** {H12101} A successful invocation of [sqlite3_exec(D,S,C,A,E)]

**          shall sequentially evaluate all of the UTF-8 encoded,

**          semicolon-separated SQL statements in the zero-terminated

**          string S within the context of the [database connection] D.

**

** {H12102} If the S parameter to [sqlite3_exec(D,S,C,A,E)] is NULL then

**          the actions of the interface shall be the same as if the

**          S parameter were an empty string.

**

** {H12104} The return value of [sqlite3_exec()] shall be [SQLITE_OK] if all

**          SQL statements run successfully and to completion.

**

** {H12105} The return value of [sqlite3_exec()] shall be an appropriate

**          non-zero [error code] if any SQL statement fails.

**

** {H12107} If one or more of the SQL statements handed to [sqlite3_exec()]

**          return results and the 3rd parameter is not NULL, then

**          the callback function specified by the 3rd parameter shall be

**          invoked once for each row of result.

**

** {H12110} If the callback returns a non-zero value then [sqlite3_exec()]

**          shall abort the SQL statement it is currently evaluating,

**          skip all subsequent SQL statements, and return [SQLITE_ABORT].

**

** {H12113} The [sqlite3_exec()] routine shall pass its 4th parameter through

**          as the 1st parameter of the callback.

**

** {H12116} The [sqlite3_exec()] routine shall set the 2nd parameter of its

**          callback to be the number of columns in the current row of

**          result.

**

** {H12119} The [sqlite3_exec()] routine shall set the 3rd parameter of its

**          callback to be an array of pointers to strings holding the

**          values for each column in the current result set row as

**          obtained from [sqlite3_column_text()].

**

** {H12122} The [sqlite3_exec()] routine shall set the 4th parameter of its

**          callback to be an array of pointers to strings holding the

**          names of result columns as obtained from [sqlite3_column_name()].

**

** {H12125} If the 3rd parameter to [sqlite3_exec()] is NULL then

**          [sqlite3_exec()] shall silently discard query results.

**

** {H12131} If an error occurs while parsing or evaluating any of the SQL

**          statements in the S parameter of [sqlite3_exec(D,S,C,A,E)] and if

**          the E parameter is not NULL, then [sqlite3_exec()] shall store

**          in *E an appropriate error message written into memory obtained

**          from [sqlite3_malloc()].

**

** {H12134} The [sqlite3_exec(D,S,C,A,E)] routine shall set the value of

**          *E to NULL if E is not NULL and there are no errors.

**

** {H12137} The [sqlite3_exec(D,S,C,A,E)] function shall set the [error code]

**          and message accessible via [sqlite3_errcode()],

**          [sqlite3_errmsg()], and [sqlite3_errmsg16()].

**

** {H12138} If the S parameter to [sqlite3_exec(D,S,C,A,E)] is NULL or an

**          empty string or contains nothing other than whitespace, comments,

**          and/or semicolons, then results of [sqlite3_errcode()],

**          [sqlite3_errmsg()], and [sqlite3_errmsg16()]

**          shall reset to indicate no errors.

**

** ASSUMPTIONS:

**

** {A12141} The first parameter to [sqlite3_exec()] must be an valid and open

**          [database connection].

**

** {A12142} The database connection must not be closed while

**          [sqlite3_exec()] is running.

**

** {A12143} The calling function should use [sqlite3_free()] to free

**          the memory that *errmsg is left pointing at once the error

**          message is no longer needed.

**

** {A12145} The SQL statement text in the 2nd parameter to [sqlite3_exec()]

**          must remain unchanged while [sqlite3_exec()] is running.

*/

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 */

);

/*

** CAPI3REF: Result Codes {H10210} <S10700>

** KEYWORDS: SQLITE_OK {error code} {error codes}

** KEYWORDS: {result code} {result codes}

**

** Many SQLite functions return an integer result code from the set shown

** here in order to indicates success or failure.

**

** New error codes may be added in future versions of SQLite.

**

** See also: [SQLITE_IOERR_READ | extended result codes]

*/

#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 */

/*

** CAPI3REF: Extended Result Codes {H10220} <S10700>

** KEYWORDS: {extended error code} {extended error codes}

** KEYWORDS: {extended result code} {extended result codes}

**

** In its default configuration, SQLite API routines return one of 26 integer

** [SQLITE_OK | result codes].  However, experience has shown that many of

** these result codes are too coarse-grained.  They do not provide as

** much information about problems as programmers might like.  In an effort to

** address this, newer versions of SQLite (version 3.3.8 and later) include

** support for additional result codes that provide more detailed information

** about errors. The extended result codes are enabled or disabled

** on a per database connection basis using the

** [sqlite3_extended_result_codes()] API.

**

** Some of the available extended result codes are listed here.

** One may expect the number of extended result codes will be expand

** over time.  Software that uses extended result codes should expect

** to see new result codes in future releases of SQLite.

**

** The SQLITE_OK result code will never be extended.  It will always

** be exactly zero.

**

** INVARIANTS:

**

** {H10223} The symbolic name for an extended result code shall contains

**          a related primary result code as a prefix.

**

** {H10224} Primary result code names shall contain a single "_" character.

**

** {H10225} Extended result code names shall contain two or more "_" characters.

**

** {H10226} 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.

*/

#define SQLITE_IOERR_READ              (SQLITE_IOERR | (1<<8))

#define SQLITE_IOERR_SHORT_READ        (SQLITE_IOERR | (2<<8))

#define SQLITE_IOERR_WRITE             (SQLITE_IOERR | (3<<8))

#define SQLITE_IOERR_FSYNC             (SQLITE_IOERR | (4<<8))

#define SQLITE_IOERR_DIR_FSYNC         (SQLITE_IOERR | (5<<8))

#define SQLITE_IOERR_TRUNCATE          (SQLITE_IOERR | (6<<8))

#define SQLITE_IOERR_FSTAT             (SQLITE_IOERR | (7<<8))

#define SQLITE_IOERR_UNLOCK            (SQLITE_IOERR | (8<<8))

#define SQLITE_IOERR_RDLOCK            (SQLITE_IOERR | (9<<8))

#define SQLITE_IOERR_DELETE            (SQLITE_IOERR | (10<<8))

#define SQLITE_IOERR_BLOCKED           (SQLITE_IOERR | (11<<8))

#define SQLITE_IOERR_NOMEM             (SQLITE_IOERR | (12<<8))

#define SQLITE_IOERR_ACCESS            (SQLITE_IOERR | (13<<8))

#define SQLITE_IOERR_CHECKRESERVEDLOCK (SQLITE_IOERR | (14<<8))

/*

** CAPI3REF: Flags For File Open Operations {H10230} <H11120> <H12700>

**

** These bit values are intended for use in the

** 3rd parameter to the [sqlite3_open_v2()] interface and

** in the 4th parameter to the xOpen method of the

** [sqlite3_vfs] object.

*/

#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

/*

** CAPI3REF: Device Characteristics {H10240} <H11120>

**

** The xDeviceCapabilities method of the [sqlite3_io_methods]

** object returns an integer which is a vector of the these

** bit values expressing I/O characteristics of the mass storage

** device that holds the file that the [sqlite3_io_methods]

** refers to.

**

** The SQLITE_IOCAP_ATOMIC property means that all writes of

** any size are atomic.  The SQLITE_IOCAP_ATOMICnnn values

** mean that writes of blocks that are nnn bytes in size and

** are aligned to an address which is an integer multiple of

** nnn are atomic.  The SQLITE_IOCAP_SAFE_APPEND value means

** that when data is appended to a file, the data is appended

** first then the size of the file is extended, never the other

** way around.  The SQLITE_IOCAP_SEQUENTIAL property means that

** information is written to disk in the same order as calls

** to xWrite().

*/

#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

/*

** CAPI3REF: File Locking Levels {H10250} <H11120> <H11310>

**

** SQLite uses one of these integer values as the second

** argument to calls it makes to the xLock() and xUnlock() methods

** of an [sqlite3_io_methods] object.

*/

#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

/*

** CAPI3REF: Synchronization Type Flags {H10260} <H11120>

**

** When SQLite invokes the xSync() method of an

** [sqlite3_io_methods] object it uses a combination of

** these integer values as the second argument.

**

** When the SQLITE_SYNC_DATAONLY flag is used, it means that the

** sync operation only needs to flush data to mass storage.  Inode

** information need not be flushed. The SQLITE_SYNC_NORMAL flag means

** to use normal fsync() semantics. The SQLITE_SYNC_FULL flag means

** to use Mac OS-X style fullsync instead of fsync().

*/

#define SQLITE_SYNC_NORMAL        0x00002

#define SQLITE_SYNC_FULL          0x00003

#define SQLITE_SYNC_DATAONLY      0x00010

/*

** CAPI3REF: OS Interface Open File Handle {H11110} <S20110>

**

** An [sqlite3_file] object represents an open file in the OS

** interface layer.  Individual OS interface implementations will

** want to subclass this object by appending additional fields

** for their own use.  The pMethods entry is a pointer to an

** [sqlite3_io_methods] object that defines methods for performing

** I/O operations on the open file.

*/

typedef struct sqlite3_file sqlite3_file;

struct sqlite3_file {

  const struct sqlite3_io_methods *pMethods;  /* Methods for an open file */

};

/*

** CAPI3REF: OS Interface File Virtual Methods Object {H11120} <S20110>

**

** Every file opened by the [sqlite3_vfs] xOpen method populates an

** [sqlite3_file] object (or, more commonly, a subclass of the

** [sqlite3_file] object) with a pointer to an instance of this object.

** This object defines the methods used to perform various operations

** against the open file represented by the [sqlite3_file] object.

**

** The flags argument to xSync may be one of [SQLITE_SYNC_NORMAL] or

** [SQLITE_SYNC_FULL].  The first choice is the normal fsync().

** The second choice is a Mac OS-X style fullsync.  The [SQLITE_SYNC_DATAONLY]

** flag may be ORed in to indicate that only the data of the file

** and not its inode needs to be synced.

**

** The integer values to xLock() and xUnlock() are one of

** <ul>

** <li> [SQLITE_LOCK_NONE],

** <li> [SQLITE_LOCK_SHARED],

** <li> [SQLITE_LOCK_RESERVED],

** <li> [SQLITE_LOCK_PENDING], or

** <li> [SQLITE_LOCK_EXCLUSIVE].

** </ul>

** xLock() increases the lock. xUnlock() decreases the lock.

** The xCheckReservedLock() method checks whether any database connection,

** either in this process or in some other process, is holding a RESERVED,

** PENDING, or EXCLUSIVE lock on the file.  It returns true

** if such a lock exists and false otherwise.

**

** The xFileControl() method is a generic interface that allows custom

** VFS implementations to directly control an open file using the

** [sqlite3_file_control()] interface.  The second "op" argument is an

** integer opcode.  The third argument is a generic pointer intended to

** point to a structure that may contain arguments or space in which to

** write return values.  Potential uses for xFileControl() might be

** functions to enable blocking locks with timeouts, to change the

** locking strategy (for example to use dot-file locks), to inquire

** about the status of a lock, or to break stale locks.  The SQLite

** core reserves all opcodes less than 100 for its own use.

** A [SQLITE_FCNTL_LOCKSTATE | list of opcodes] less than 100 is available.

** Applications that define a custom xFileControl method should use opcodes

** greater than 100 to avoid conflicts.

**

** The xSectorSize() method returns the sector size of the

** device that underlies the file.  The sector size is the

** minimum write that can be performed without disturbing

** other bytes in the file.  The xDeviceCharacteristics()

** method returns a bit vector describing behaviors of the

** underlying device:

**

** <ul>

** <li> [SQLITE_IOCAP_ATOMIC]

** <li> [SQLITE_IOCAP_ATOMIC512]

** <li> [SQLITE_IOCAP_ATOMIC1K]

** <li> [SQLITE_IOCAP_ATOMIC2K]

** <li> [SQLITE_IOCAP_ATOMIC4K]

** <li> [SQLITE_IOCAP_ATOMIC8K]

** <li> [SQLITE_IOCAP_ATOMIC16K]

** <li> [SQLITE_IOCAP_ATOMIC32K]

** <li> [SQLITE_IOCAP_ATOMIC64K]

** <li> [SQLITE_IOCAP_SAFE_APPEND]

** <li> [SQLITE_IOCAP_SEQUENTIAL]

** </ul>

**

** The SQLITE_IOCAP_ATOMIC property means that all writes of

** any size are atomic.  The SQLITE_IOCAP_ATOMICnnn values

** mean that writes of blocks that are nnn bytes in size and

** are aligned to an address which is an integer multiple of

** nnn are atomic.  The SQLITE_IOCAP_SAFE_APPEND value means

** that when data is appended to a file, the data is appended

** first then the size of the file is extended, never the other

** way around.  The SQLITE_IOCAP_SEQUENTIAL property means that

** information is written to disk in the same order as calls

** to xWrite().

*/

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 */

};

/*

** CAPI3REF: Standard File Control Opcodes {H11310} <S30800>

**

** These integer constants are opcodes for the xFileControl method

** of the [sqlite3_io_methods] object and for the [sqlite3_file_control()]

** interface.

**

** The [SQLITE_FCNTL_LOCKSTATE] opcode is used for debugging.  This

** opcode causes the xFileControl method to write the current state of

** the lock (one of [SQLITE_LOCK_NONE], [SQLITE_LOCK_SHARED],

** [SQLITE_LOCK_RESERVED], [SQLITE_LOCK_PENDING], or [SQLITE_LOCK_EXCLUSIVE])

** into an integer that the pArg argument points to. This capability

** is used during testing and only needs to be supported when SQLITE_TEST

** is defined.

**

*/

#define SQLITE_FCNTL_LOCKSTATE        1

/*

** CAPI3REF: Mutex Handle {H17110} <S20130>

**

** The mutex module within SQLite defines [sqlite3_mutex] to be an

** abstract type for a mutex object.  The SQLite core never looks

** at the internal representation of an [sqlite3_mutex].  It only

** deals with pointers to the [sqlite3_mutex] object.

**

** Mutexes are created using [sqlite3_mutex_alloc()].

*/

typedef struct sqlite3_mutex sqlite3_mutex;

/*

** CAPI3REF: OS Interface Object {H11140} <S20100>

**

** An instance of the sqlite3_vfs object defines the interface between

** the SQLite core and the underlying operating system.  The "vfs"

** in the name of the object stands for "virtual file system".

**

** The value of the iVersion field is initially 1 but may be larger in

** future versions of SQLite.  Additional fields may be appended to this

** object when the iVersion value is increased.  Note that the structure

** of the sqlite3_vfs object changes in the transaction between

** SQLite version 3.5.9 and 3.6.0 and yet the iVersion field was not

** modified.

**

** The szOsFile field is the size of the subclassed [sqlite3_file]

** structure used by this VFS.  mxPathname is the maximum length of

** a pathname in this VFS.

**

** Registered sqlite3_vfs objects are kept on a linked list formed by

** the pNext pointer.  The [sqlite3_vfs_register()]

** and [sqlite3_vfs_unregister()] interfaces manage this list

** in a thread-safe way.  The [sqlite3_vfs_find()] interface

** searches the list.  Neither the application code nor the VFS

** implementation should use the pNext pointer.

**

** The pNext field is the only field in the sqlite3_vfs

** structure that SQLite will ever modify.  SQLite will only access

** or modify this field while holding a particular static mutex.

** The application should never modify anything within the sqlite3_vfs

** object once the object has been registered.

**

** The zName field holds the name of the VFS module.  The name must

** be unique across all VFS modules.

**

** {H11141} SQLite will guarantee that the zFilename parameter to xOpen

** is either a NULL pointer or string obtained

** from xFullPathname().  SQLite further guarantees that

** the string will be valid and unchanged until xClose() is

** called. {END}  Because of the previous sentense,

** the [sqlite3_file] can safely store a pointer to the

** filename if it needs to remember the filename for some reason.

** If the zFilename parameter is xOpen is a NULL pointer then xOpen

** must invite its own temporary name for the file.  Whenever the 

** xFilename parameter is NULL it will also be the case that the

** flags parameter will include [SQLITE_OPEN_DELETEONCLOSE].

**

** {H11142} The flags argument to xOpen() includes all bits set in

** the flags argument to [sqlite3_open_v2()].  Or if [sqlite3_open()]

** or [sqlite3_open16()] is used, then flags includes at least

** [SQLITE_OPEN_READWRITE] | [SQLITE_OPEN_CREATE]. {END}

** If xOpen() opens a file read-only then it sets *pOutFlags to

** include [SQLITE_OPEN_READONLY].  Other bits in *pOutFlags may be set.

**

** {H11143} SQLite will also add one of the following flags to the xOpen()

** call, depending on the object being opened:

**

** <ul>

** <li>  [SQLITE_OPEN_MAIN_DB]

** <li>  [SQLITE_OPEN_MAIN_JOURNAL]

** <li>  [SQLITE_OPEN_TEMP_DB]

** <li>  [SQLITE_OPEN_TEMP_JOURNAL]

** <li>  [SQLITE_OPEN_TRANSIENT_DB]

** <li>  [SQLITE_OPEN_SUBJOURNAL]

** <li>  [SQLITE_OPEN_MASTER_JOURNAL]

** </ul> {END}

**

** The file I/O implementation can use the object type flags to

** change the way it deals with files.  For example, an application

** that does not care about crash recovery or rollback might make

** the open of a journal file a no-op.  Writes to this journal would

** also be no-ops, and any attempt to read the journal would return

** SQLITE_IOERR.  Or the implementation might recognize that a database

** file will be doing page-aligned sector reads and writes in a random

** order and set up its I/O subsystem accordingly.

**

** SQLite might also add one of the following flags to the xOpen method:

**

** <ul>

** <li> [SQLITE_OPEN_DELETEONCLOSE]

** <li> [SQLITE_OPEN_EXCLUSIVE]

** </ul>

**

** {H11145} The [SQLITE_OPEN_DELETEONCLOSE] flag means the file should be

** deleted when it is closed.  {H11146} The [SQLITE_OPEN_DELETEONCLOSE]

** will be set for TEMP  databases, journals and for subjournals.

**

** {H11147} The [SQLITE_OPEN_EXCLUSIVE] flag means the file should be opened

** for exclusive access.  This flag is set for all files except

** for the main database file.

**

** {H11148} At least szOsFile bytes of memory are allocated by SQLite

** to hold the  [sqlite3_file] structure passed as the third

** argument to xOpen. {END}  The xOpen method does not have to

** allocate the structure; it should just fill it in.

**

** {H11149} The flags argument to xAccess() may be [SQLITE_ACCESS_EXISTS]

** to test for the existence of a file, or [SQLITE_ACCESS_READWRITE] to

** test whether a file is readable and writable, or [SQLITE_ACCESS_READ]

** to test whether a file is at least readable. {END}  The file can be a

** directory.

**

** {H11150} SQLite will always allocate at least mxPathname+1 bytes for the

** output buffer xFullPathname. {H11151} The exact size of the output buffer

** is also passed as a parameter to both  methods. {END}  If the output buffer

** is not large enough, [SQLITE_CANTOPEN] should be returned. Since this is

** handled as a fatal error by SQLite, vfs implementations should endeavor

** to prevent this by setting mxPathname to a sufficiently large value.

**

** The xRandomness(), xSleep(), and xCurrentTime() interfaces

** are not strictly a part of the filesystem, but they are

** included in the VFS structure for completeness.

** The xRandomness() function attempts to return nBytes bytes

** of good-quality randomness into zOut.  The return value is

** the actual number of bytes of randomness obtained.

** The xSleep() method causes the calling thread to sleep for at

** least the number of microseconds given.  The xCurrentTime()

** method returns a Julian Day Number for the current date and time.

*/

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 (*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. */

};

/*

** CAPI3REF: Flags for the xAccess VFS method {H11190} <H11140>

**

** {H11191} These integer constants can be used as the third parameter to

** the xAccess method of an [sqlite3_vfs] object. {END}  They determine

** what kind of permissions the xAccess method is looking for.

** {H11192} With SQLITE_ACCESS_EXISTS, the xAccess method

** simply checks whether the file exists.

** {H11193} With SQLITE_ACCESS_READWRITE, the xAccess method

** checks whether the file is both readable and writable.

** {H11194} With SQLITE_ACCESS_READ, the xAccess method

** checks whether the file is readable.

*/

#define SQLITE_ACCESS_EXISTS    0

#define SQLITE_ACCESS_READWRITE 1

#define SQLITE_ACCESS_READ      2

/*

** CAPI3REF: Initialize The SQLite Library {H10130} <S20000><S30100>

**

** The sqlite3_initialize() routine initializes the

** SQLite library.  The sqlite3_shutdown() routine

** deallocates any resources that were allocated by sqlite3_initialize().

**

** A call to sqlite3_initialize() is an "effective" call if it is

** the first time sqlite3_initialize() is invoked during the lifetime of

** the process, or if it is the first time sqlite3_initialize() is invoked

** following a call to sqlite3_shutdown().  Only an effective call

** of sqlite3_initialize() does any initialization.  All other calls

** are harmless no-ops.

**

** Among other things, sqlite3_initialize() shall invoke

** sqlite3_os_init().  Similarly, sqlite3_shutdown()

** shall invoke sqlite3_os_end().

**

** The sqlite3_initialize() routine returns SQLITE_OK on success.

** If for some reason, sqlite3_initialize() is unable to initialize

** the library (perhaps it is unable to allocate a needed resource such

** as a mutex) it returns an [error code] other than SQLITE_OK.

**

** The sqlite3_initialize() routine is called internally by many other

** SQLite interfaces so that an application usually does not need to

** invoke sqlite3_initialize() directly.  For example, [sqlite3_open()]

** calls sqlite3_initialize() so the SQLite library will be automatically

** initialized when [sqlite3_open()] is called if it has not be initialized

** already.  However, if SQLite is compiled with the SQLITE_OMIT_AUTOINIT

** compile-time option, then the automatic calls to sqlite3_initialize()

** are omitted and the application must call sqlite3_initialize() directly

** prior to using any other SQLite interface.  For maximum portability,

** it is recommended that applications always invoke sqlite3_initialize()

** directly prior to using any other SQLite interface.  Future releases

** of SQLite may require this.  In other words, the behavior exhibited

** when SQLite is compiled with SQLITE_OMIT_AUTOINIT might become the

** default behavior in some future release of SQLite.

**

** The sqlite3_os_init() routine does operating-system specific

** initialization of the SQLite library.  The sqlite3_os_end()

** routine undoes the effect of sqlite3_os_init().  Typical tasks

** performed by these routines include allocation or deallocation

** of static resources, initialization of global variables,

** setting up a default [sqlite3_vfs] module, or setting up

** a default configuration using [sqlite3_config()].

**

** The application should never invoke either sqlite3_os_init()

** or sqlite3_os_end() directly.  The application should only invoke

** sqlite3_initialize() and sqlite3_shutdown().  The sqlite3_os_init()

** interface is called automatically by sqlite3_initialize() and

** sqlite3_os_end() is called by sqlite3_shutdown().  Appropriate

** implementations for sqlite3_os_init() and sqlite3_os_end()

** are built into SQLite when it is compiled for unix, windows, or os/2.

** When built for other platforms (using the SQLITE_OS_OTHER=1 compile-time

** option) the application must supply a suitable implementation for

** sqlite3_os_init() and sqlite3_os_end().  An application-supplied

** implementation of sqlite3_os_init() or sqlite3_os_end()

** must return SQLITE_OK on success and some other [error code] upon

** failure.

*/

int sqlite3_initialize(void);

int sqlite3_shutdown(void);

int sqlite3_os_init(void);

int sqlite3_os_end(void);

/*

** CAPI3REF: Configuring The SQLite Library {H10145} <S20000><S30200>

** EXPERIMENTAL

**

** The sqlite3_config() interface is used to make global configuration

** changes to SQLite in order to tune SQLite to the specific needs of

** the application.  The default configuration is recommended for most

** applications and so this routine is usually not necessary.  It is

** provided to support rare applications with unusual needs.

**

** The sqlite3_config() interface is not threadsafe.  The application

** must insure that no other SQLite interfaces are invoked by other

** threads while sqlite3_config() is running.  Furthermore, sqlite3_config()

** may only be invoked prior to library initialization using

** [sqlite3_initialize()] or after shutdown by [sqlite3_shutdown()].

** Note, however, that sqlite3_config() can be called as part of the

** implementation of an application-defined [sqlite3_os_init()].

**

** The first argument to sqlite3_config() is an integer

** [SQLITE_CONFIG_SINGLETHREAD | configuration option] that determines

** what property of SQLite is to be configured.  Subsequent arguments

** vary depending on the [SQLITE_CONFIG_SINGLETHREAD | configuration option]

** in the first argument.

**

** When a configuration option is set, sqlite3_config() returns SQLITE_OK.

** If the option is unknown or SQLite is unable to set the option

** then this routine returns a non-zero [error code].

*/

int sqlite3_config(int, ...);

/*

** CAPI3REF: Configure database connections  {H10180} <S20000>

** EXPERIMENTAL

**

** The sqlite3_db_config() interface is used to make configuration

** changes to a [database connection].  The interface is similar to

** [sqlite3_config()] except that the changes apply to a single

** [database connection] (specified in the first argument).  The

** sqlite3_db_config() interface can only be used immediately after

** the database connection is created using [sqlite3_open()],

** [sqlite3_open16()], or [sqlite3_open_v2()].  

**

** The second argument to sqlite3_db_config(D,V,...)  is the

** configuration verb - an integer code that indicates what

** aspect of the [database connection] is being configured.

** The only choice for this value is [SQLITE_DBCONFIG_LOOKASIDE].

** New verbs are likely to be added in future releases of SQLite.

** Additional arguments depend on the verb.

*/

int sqlite3_db_config(sqlite3*, int op, ...);

/*

** CAPI3REF: Memory Allocation Routines {H10155} <S20120>