SQLite-PPL/src/sqlite.h.in at master · FlashSQL/SQLite-PPL · GitHub

History

8207 lines (8006 loc) · 383 KB

Raw

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

622

623

624

625

626

627

628

629

630

631

632

633

634

635

636

637

638

639

640

641

642

643

644

645

646

647

648

649

650

651

652

653

654

655

656

657

658

659

660

661

662

663

664

665

666

667

668

669

670

671

672

673

674

675

676

677

678

679

680

681

682

683

684

685

686

687

688

689

690

691

692

693

694

695

696

697

698

699

700

701

702

703

704

705

706

707

708

709

710

711

712

713

714

715

716

717

718

719

720

721

722

723

724

725

726

727

728

729

730

731

732

733

734

735

736

737

738

739

740

741

742

743

744

745

746

747

748

749

750

751

752

753

754

755

756

757

758

759

760

761

762

763

764

765

766

767

768

769

770

771

772

773

774

775

776

777

778

779

780

781

782

783

784

785

786

787

788

789

790

791

792

793

794

795

796

797

798

799

800

801

802

803

804

805

806

807

808

809

810

811

812

813

814

815

816

817

818

819

820

821

822

823

824

825

826

827

828

829

830

831

832

833

834

835

836

837

838

839

840

841

842

843

844

845

846

847

848

849

850

851

852

853

854

855

856

857

858

859

860

861

862

863

864

865

866

867

868

869

870

871

872

873

874

875

876

877

878

879

880

881

882

883

884

885

886

887

888

889

890

891

892

893

894

895

896

897

898

899

900

901

902

903

904

905

906

907

908

909

910

911

912

913

914

915

916

917

918

919

920

921

922

923

924

925

926

927

928

929

930

931

932

933

934

935

936

937

938

939

940

941

942

943

944

945

946

947

948

949

950

951

952

953

954

955

956

957

958

959

960

961

962

963

964

965

966

967

968

969

970

971

972

973

974

975

976

977

978

979

980

981

982

983

984

985

986

987

988

989

990

991

992

993

994

995

996

997

998

999

1000

** 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 the right 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 supposed 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.

#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

** Provide the ability to override linkage features of the interface.

#ifndef SQLITE_EXTERN

# define SQLITE_EXTERN extern

#endif

#ifndef SQLITE_API

# define SQLITE_API

#endif

#ifndef SQLITE_CDECL

# define SQLITE_CDECL

#endif

#ifndef SQLITE_STDCALL

# define SQLITE_STDCALL

#endif

** These no-op macros are used in front of interfaces to mark those

** interfaces as either deprecated or experimental. New applications

** should not use deprecated interfaces - they are supported for backwards

** compatibility only. Application writers should be aware that

** experimental interfaces are subject to change in point releases.

** These macros used to resolve to various kinds of compiler magic that

** would generate warning messages when they were used. But that

** compiler magic ended up generating such a flurry of bug reports

** that we have taken it all out and gone back to using simple

** noop macros.

#define SQLITE_DEPRECATED

#define SQLITE_EXPERIMENTAL

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

** ^(The [SQLITE_VERSION] C preprocessor macro in the sqlite3.h header

** evaluates to a string literal that is the SQLite version in the

** format "X.Y.Z" where X is the major version number (always 3 for

** SQLite3) and Y is the minor version number and Z is the release number.)^

** ^(The [SQLITE_VERSION_NUMBER] C preprocessor macro resolves to an integer

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

** numbers used in [SQLITE_VERSION].)^

** The SQLITE_VERSION_NUMBER for any given release of SQLite will also

** be larger than the release from which it is derived. Either Y will

** be held constant and Z will be incremented or else Y will be incremented

** and Z will be reset to zero.

** Since version 3.6.18, SQLite source code has been stored in the

** <a href="http://www.fossil-scm.org/">Fossil configuration management

** system</a>. ^The SQLITE_SOURCE_ID macro evaluates to

** a string which identifies a particular check-in of SQLite

** within its configuration management system. ^The SQLITE_SOURCE_ID

** string contains the date and time of the check-in (UTC) and an SHA1

** hash of the entire source tree.

** See also: [sqlite3_libversion()],

** [sqlite3_libversion_number()], [sqlite3_sourceid()],

** [sqlite_version()] and [sqlite_source_id()].

#define SQLITE_VERSION "--VERS--"

#define SQLITE_VERSION_NUMBER --VERSION-NUMBER--

#define SQLITE_SOURCE_ID "--SOURCE-ID--"

** CAPI3REF: Run-Time Library Version Numbers

** KEYWORDS: sqlite3_version, sqlite3_sourceid

** These interfaces provide the same information as the [SQLITE_VERSION],

** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros

** but are associated with the library instead of the header file. ^(Cautious

** programmers might include assert() statements in their application to

** verify that values returned by these interfaces match the macros in

** the header, and thus ensure that the application is

** compiled with matching library and header files.

** <blockquote><pre>

** assert( sqlite3_libversion_number()==SQLITE_VERSION_NUMBER );

** assert( strcmp(sqlite3_sourceid(),SQLITE_SOURCE_ID)==0 );

** assert( strcmp(sqlite3_libversion(),SQLITE_VERSION)==0 );

** </pre></blockquote>)^

** ^The sqlite3_version[] string constant contains the text of [SQLITE_VERSION]

** macro. ^The sqlite3_libversion() function returns a pointer to the

** to the sqlite3_version[] string constant. The sqlite3_libversion()

** function is provided for use in DLLs since DLL users usually do not have

** direct access to string constants within the DLL. ^The

** sqlite3_libversion_number() function returns an integer equal to

** [SQLITE_VERSION_NUMBER]. ^The sqlite3_sourceid() function returns

** a pointer to a string constant whose value is the same as the

** [SQLITE_SOURCE_ID] C preprocessor macro.

** See also: [sqlite_version()] and [sqlite_source_id()].

SQLITE_EXTERN const char sqlite3_version[];

const char *sqlite3_libversion(void);

const char *sqlite3_sourceid(void);

int sqlite3_libversion_number(void);

** CAPI3REF: Run-Time Library Compilation Options Diagnostics

** ^The sqlite3_compileoption_used() function returns 0 or 1

** indicating whether the specified option was defined at

** compile time. ^The SQLITE_ prefix may be omitted from the

** option name passed to sqlite3_compileoption_used().

** ^The sqlite3_compileoption_get() function allows iterating

** over the list of options that were defined at compile time by

** returning the N-th compile time option string. ^If N is out of range,

** sqlite3_compileoption_get() returns a NULL pointer. ^The SQLITE_

** prefix is omitted from any strings returned by

** sqlite3_compileoption_get().

** ^Support for the diagnostic functions sqlite3_compileoption_used()

** and sqlite3_compileoption_get() may be omitted by specifying the

** [SQLITE_OMIT_COMPILEOPTION_DIAGS] option at compile time.

** See also: SQL functions [sqlite_compileoption_used()] and

** [sqlite_compileoption_get()] and the [compile_options pragma].

#ifndef SQLITE_OMIT_COMPILEOPTION_DIAGS

int sqlite3_compileoption_used(const char *zOptName);

const char *sqlite3_compileoption_get(int N);

#endif

** CAPI3REF: Test To See If The Library Is Threadsafe

** ^The sqlite3_threadsafe() function returns zero if and only if

** SQLite was compiled with mutexing code omitted due to the

** [SQLITE_THREADSAFE] compile-time option being set to 0.

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

** the [SQLITE_THREADSAFE] C preprocessor macro is 1 or 2, mutexes

** are enabled and SQLite is threadsafe. When the

** [SQLITE_THREADSAFE] macro is 0,

** 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 an application 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 or =2 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_SERIALIZED]. ^(The return value of the

** sqlite3_threadsafe() function shows only the compile-time setting of

** thread safety, not any run-time changes to that setting made by

** sqlite3_config(). In other words, the return value from sqlite3_threadsafe()

** is unchanged by calls to sqlite3_config().)^

** See the [threading mode] documentation for additional information.

int sqlite3_threadsafe(void);

** CAPI3REF: Database Connection Handle

** 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()]

** and [sqlite3_close_v2()] are its destructors. 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

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

** ^The sqlite3_int64 and sqlite_int64 types can store integer values

** between -9223372036854775808 and +9223372036854775807 inclusive. ^The

** sqlite3_uint64 and sqlite_uint64 types can store integer values

** between 0 and +18446744073709551615 inclusive.

#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

** DESTRUCTOR: sqlite3

** ^The sqlite3_close() and sqlite3_close_v2() routines are destructors

** for the [sqlite3] object.

** ^Calls to sqlite3_close() and sqlite3_close_v2() return [SQLITE_OK] if

** the [sqlite3] object is successfully destroyed and all associated

** resources are deallocated.

** ^If the database connection is associated with unfinalized prepared

** statements or unfinished sqlite3_backup objects then sqlite3_close()

** will leave the database connection open and return [SQLITE_BUSY].

** ^If sqlite3_close_v2() is called with unfinalized prepared statements

** and/or unfinished sqlite3_backups, then the database connection becomes

** an unusable "zombie" which will automatically be deallocated when the

** last prepared statement is finalized or the last sqlite3_backup is

** finished. The sqlite3_close_v2() interface is intended for use with

** host languages that are garbage collected, and where the order in which

** destructors are called is arbitrary.

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

** [sqlite3_blob_close | close] all [BLOB handles], and

** [sqlite3_backup_finish | finish] all [sqlite3_backup] objects associated

** with the [sqlite3] object prior to attempting to close the object. ^If

** sqlite3_close_v2() is called on a [database connection] that still has

** outstanding [prepared statements], [BLOB handles], and/or

** [sqlite3_backup] objects then it returns [SQLITE_OK] and the deallocation

** of resources is deferred until all [prepared statements], [BLOB handles],

** and [sqlite3_backup] objects are also destroyed.

** ^If an [sqlite3] object is destroyed while a transaction is open,

** the transaction is automatically rolled back.

** The C parameter to [sqlite3_close(C)] and [sqlite3_close_v2(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.

** ^Calling sqlite3_close() or sqlite3_close_v2() with a NULL pointer

** argument is a harmless no-op.

int sqlite3_close(sqlite3*);

int sqlite3_close_v2(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

** METHOD: sqlite3

** The sqlite3_exec() interface is a convenience wrapper around

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

** that allows an application to run multiple statements of SQL

** without having to use a lot of C code.

** ^The sqlite3_exec() interface runs zero or more UTF-8 encoded,

** semicolon-separate SQL statements passed into its 2nd argument,

** in the context of the [database connection] passed in as its 1st

** argument. ^If the callback function of the 3rd argument to

** sqlite3_exec() is not NULL, then it is invoked for each result row

** coming out of the evaluated SQL statements. ^The 4th argument to

** sqlite3_exec() is relayed through to the 1st argument of each

** callback invocation. ^If the callback pointer to sqlite3_exec()

** is NULL, then no callback is ever invoked and result rows are

** ignored.

** ^If an error occurs while evaluating the SQL statements passed into

** sqlite3_exec(), then execution of the current statement stops and

** subsequent statements are skipped. ^If the 5th parameter to sqlite3_exec()

** is not NULL then any error message is written into memory obtained

** from [sqlite3_malloc()] and passed back through the 5th parameter.

** To avoid memory leaks, the application should invoke [sqlite3_free()]

** on error message strings returned through the 5th parameter of

** sqlite3_exec() after the error message string is no longer needed.

** ^If the 5th parameter to sqlite3_exec() is not NULL and no errors

** occur, then sqlite3_exec() sets the pointer in its 5th parameter to

** NULL before returning.

** ^If an sqlite3_exec() callback returns non-zero, the sqlite3_exec()

** routine returns SQLITE_ABORT without invoking the callback again and

** without running any subsequent SQL statements.

** ^The 2nd argument to the sqlite3_exec() callback function is the

** number of columns in the result. ^The 3rd argument to the sqlite3_exec()

** callback is an array of pointers to strings obtained as if from

** [sqlite3_column_text()], one for each column. ^If an element of a

** result row is NULL then the corresponding string pointer for the

** sqlite3_exec() callback is a NULL pointer. ^The 4th argument to the

** sqlite3_exec() callback is an array of pointers to strings where each

** entry represents the name of corresponding result column as obtained

** from [sqlite3_column_name()].

** ^If the 2nd parameter to sqlite3_exec() is a NULL pointer, a pointer

** to an empty string, or a pointer that contains only whitespace and/or

** SQL comments, then no SQL statements are evaluated and the database

** is not changed.

** Restrictions:

** <ul>

** <li> The application must ensure that the 1st parameter to sqlite3_exec()

** is a valid and open [database connection].

** <li> The application must not close the [database connection] specified by

** the 1st parameter to sqlite3_exec() while sqlite3_exec() is running.

** <li> The application must not modify the SQL statement text passed into

** the 2nd parameter of sqlite3_exec() while sqlite3_exec() is running.

** </ul>

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

** KEYWORDS: {result code definitions}

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

** here in order to indicate success or failure.

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

** See also: [extended result code definitions]

#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 /* Unknown opcode in sqlite3_file_control() */

#define SQLITE_FULL 13 /* Insertion failed because database is full */

#define SQLITE_CANTOPEN 14 /* Unable to open the database file */

#define SQLITE_PROTOCOL 15 /* 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_NOTICE 27 /* Notifications from sqlite3_log() */

#define SQLITE_WARNING 28 /* Warnings from sqlite3_log() */

#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

** KEYWORDS: {extended result code definitions}

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

** [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. These [extended result codes] are enabled or disabled

** on a per database connection basis using the

** [sqlite3_extended_result_codes()] API. Or, the extended code for

** the most recent error can be obtained using

** [sqlite3_extended_errcode()].

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

#define SQLITE_IOERR_LOCK (SQLITE_IOERR | (15<<8))

#define SQLITE_IOERR_CLOSE (SQLITE_IOERR | (16<<8))

#define SQLITE_IOERR_DIR_CLOSE (SQLITE_IOERR | (17<<8))

#define SQLITE_IOERR_SHMOPEN (SQLITE_IOERR | (18<<8))

#define SQLITE_IOERR_SHMSIZE (SQLITE_IOERR | (19<<8))

#define SQLITE_IOERR_SHMLOCK (SQLITE_IOERR | (20<<8))

#define SQLITE_IOERR_SHMMAP (SQLITE_IOERR | (21<<8))

#define SQLITE_IOERR_SEEK (SQLITE_IOERR | (22<<8))

#define SQLITE_IOERR_DELETE_NOENT (SQLITE_IOERR | (23<<8))

#define SQLITE_IOERR_MMAP (SQLITE_IOERR | (24<<8))

#define SQLITE_IOERR_GETTEMPPATH (SQLITE_IOERR | (25<<8))

#define SQLITE_IOERR_CONVPATH (SQLITE_IOERR | (26<<8))

#define SQLITE_IOERR_VNODE (SQLITE_IOERR | (27<<8))

#define SQLITE_IOERR_AUTH (SQLITE_IOERR | (28<<8))

#define SQLITE_LOCKED_SHAREDCACHE (SQLITE_LOCKED | (1<<8))

#define SQLITE_BUSY_RECOVERY (SQLITE_BUSY | (1<<8))

#define SQLITE_BUSY_SNAPSHOT (SQLITE_BUSY | (2<<8))

#define SQLITE_CANTOPEN_NOTEMPDIR (SQLITE_CANTOPEN | (1<<8))

#define SQLITE_CANTOPEN_ISDIR (SQLITE_CANTOPEN | (2<<8))

#define SQLITE_CANTOPEN_FULLPATH (SQLITE_CANTOPEN | (3<<8))

#define SQLITE_CANTOPEN_CONVPATH (SQLITE_CANTOPEN | (4<<8))

#define SQLITE_CORRUPT_VTAB (SQLITE_CORRUPT | (1<<8))

#define SQLITE_READONLY_RECOVERY (SQLITE_READONLY | (1<<8))

#define SQLITE_READONLY_CANTLOCK (SQLITE_READONLY | (2<<8))

#define SQLITE_READONLY_ROLLBACK (SQLITE_READONLY | (3<<8))

#define SQLITE_READONLY_DBMOVED (SQLITE_READONLY | (4<<8))

#define SQLITE_ABORT_ROLLBACK (SQLITE_ABORT | (2<<8))

#define SQLITE_CONSTRAINT_CHECK (SQLITE_CONSTRAINT | (1<<8))

#define SQLITE_CONSTRAINT_COMMITHOOK (SQLITE_CONSTRAINT | (2<<8))

#define SQLITE_CONSTRAINT_FOREIGNKEY (SQLITE_CONSTRAINT | (3<<8))

#define SQLITE_CONSTRAINT_FUNCTION (SQLITE_CONSTRAINT | (4<<8))

#define SQLITE_CONSTRAINT_NOTNULL (SQLITE_CONSTRAINT | (5<<8))

#define SQLITE_CONSTRAINT_PRIMARYKEY (SQLITE_CONSTRAINT | (6<<8))

#define SQLITE_CONSTRAINT_TRIGGER (SQLITE_CONSTRAINT | (7<<8))

#define SQLITE_CONSTRAINT_UNIQUE (SQLITE_CONSTRAINT | (8<<8))

#define SQLITE_CONSTRAINT_VTAB (SQLITE_CONSTRAINT | (9<<8))

#define SQLITE_CONSTRAINT_ROWID (SQLITE_CONSTRAINT |(10<<8))

#define SQLITE_NOTICE_RECOVER_WAL (SQLITE_NOTICE | (1<<8))

#define SQLITE_NOTICE_RECOVER_ROLLBACK (SQLITE_NOTICE | (2<<8))

#define SQLITE_WARNING_AUTOINDEX (SQLITE_WARNING | (1<<8))

#define SQLITE_AUTH_USER (SQLITE_AUTH | (1<<8))

** CAPI3REF: Flags For File Open Operations

** These bit values are intended for use in the

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

** in the 4th parameter to the [sqlite3_vfs.xOpen] method.

#define SQLITE_OPEN_READONLY 0x00000001 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_READWRITE 0x00000002 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_CREATE 0x00000004 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_DELETEONCLOSE 0x00000008 /* VFS only */

#define SQLITE_OPEN_EXCLUSIVE 0x00000010 /* VFS only */

#define SQLITE_OPEN_AUTOPROXY 0x00000020 /* VFS only */

#define SQLITE_OPEN_URI 0x00000040 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_MEMORY 0x00000080 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_MAIN_DB 0x00000100 /* VFS only */

#define SQLITE_OPEN_TEMP_DB 0x00000200 /* VFS only */

#define SQLITE_OPEN_TRANSIENT_DB 0x00000400 /* VFS only */

#define SQLITE_OPEN_MAIN_JOURNAL 0x00000800 /* VFS only */

#define SQLITE_OPEN_TEMP_JOURNAL 0x00001000 /* VFS only */

#define SQLITE_OPEN_SUBJOURNAL 0x00002000 /* VFS only */

#define SQLITE_OPEN_MASTER_JOURNAL 0x00004000 /* VFS only */

#define SQLITE_OPEN_NOMUTEX 0x00008000 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_FULLMUTEX 0x00010000 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_SHAREDCACHE 0x00020000 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_PRIVATECACHE 0x00040000 /* Ok for sqlite3_open_v2() */

#define SQLITE_OPEN_WAL 0x00080000 /* VFS only */

/* Reserved: 0x00F00000 */

** CAPI3REF: Device Characteristics

** The xDeviceCharacteristics method of the [sqlite3_io_methods]

** object returns an integer which is a vector of 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(). The SQLITE_IOCAP_POWERSAFE_OVERWRITE property means that

** after reboot following a crash or power loss, the only bytes in a

** file that were written at the application level might have changed

** and that adjacent bytes, even bytes within the same sector are

** guaranteed to be unchanged. The SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN

** flag indicate that a file cannot be deleted when open. The

** SQLITE_IOCAP_IMMUTABLE flag indicates that the file is on

** read-only media and cannot be changed even by processes with

** elevated privileges.

#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

#define SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN 0x00000800

#define SQLITE_IOCAP_POWERSAFE_OVERWRITE 0x00001000

#define SQLITE_IOCAP_IMMUTABLE 0x00002000

** CAPI3REF: File Locking Levels

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

** 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. If the lower four bits of the flag

** equal SQLITE_SYNC_NORMAL, that means to use normal fsync() semantics.

** If the lower four bits equal SQLITE_SYNC_FULL, that means

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

** Do not confuse the SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags

** with the [PRAGMA synchronous]=NORMAL and [PRAGMA synchronous]=FULL

** settings. The [synchronous pragma] determines when calls to the

** xSync VFS method occur and applies uniformly across all platforms.

** The SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags determine how

** energetic or rigorous or forceful the sync operations are and

** only make a difference on Mac OSX for the default SQLite code.

** (Third-party VFS implementations might also make the distinction

** between SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL, but among the

** operating systems natively supported by SQLite, only Mac OSX

** cares about the difference.)

#define SQLITE_SYNC_NORMAL 0x00002

#define SQLITE_SYNC_FULL 0x00003

#define SQLITE_SYNC_DATAONLY 0x00010

** CAPI3REF: OS Interface Open File Handle

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

** [sqlite3_vfs | 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

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

** If the [sqlite3_vfs.xOpen] method sets the sqlite3_file.pMethods element

** to a non-NULL pointer, then the sqlite3_io_methods.xClose method

** may be invoked even if the [sqlite3_vfs.xOpen] reported that it failed. The

** only way to prevent a call to xClose following a failed [sqlite3_vfs.xOpen]

** is for the [sqlite3_vfs.xOpen] to set the sqlite3_file.pMethods element

** to NULL.

** 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 [file control opcodes | list of opcodes] less than 100 is available.

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

** greater than 100 to avoid conflicts. VFS implementations should

** return [SQLITE_NOTFOUND] for file control opcodes that they do not

** recognize.

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

** If xRead() returns SQLITE_IOERR_SHORT_READ it must also fill

** in the unread portions of the buffer with zeros. A VFS that

** fails to zero-fill short reads might seem to work. However,

** failure to zero-fill short reads will eventually lead to

** database corruption.

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

/* Methods above are valid for version 1 */

int (*xShmMap)(sqlite3_file*, int iPg, int pgsz, int, void volatile**);

int (*xShmLock)(sqlite3_file*, int offset, int n, int flags);

void (*xShmBarrier)(sqlite3_file*);

int (*xShmUnmap)(sqlite3_file*, int deleteFlag);

/* Methods above are valid for version 2 */

int (*xFetch)(sqlite3_file*, sqlite3_int64 iOfst, int iAmt, void **pp);

int (*xUnfetch)(sqlite3_file*, sqlite3_int64 iOfst, void *p);

/* Methods above are valid for version 3 */

/* Additional methods may be added in future releases */

};

** CAPI3REF: Standard File Control Opcodes

** KEYWORDS: {file control opcodes} {file control opcode}

** These integer constants are opcodes for the xFileControl method

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

** interface.

** <ul>

** <li>[[SQLITE_FCNTL_LOCKSTATE]]

** 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 is only available when the SQLITE_TEST

** compile-time option is used.

** <li>[[SQLITE_FCNTL_SIZE_HINT]]

** The [SQLITE_FCNTL_SIZE_HINT] opcode is used by SQLite to give the VFS

** layer a hint of how large the database file will grow to be during the

** current transaction. This hint is not guaranteed to be accurate but it

** is often close. The underlying VFS might choose to preallocate database

** file space based on this hint in order to help writes to the database

** file run faster.

** <li>[[SQLITE_FCNTL_CHUNK_SIZE]]

** The [SQLITE_FCNTL_CHUNK_SIZE] opcode is used to request that the VFS

** extends and truncates the database file in chunks of a size specified

** by the user. The fourth argument to [sqlite3_file_control()] should

** point to an integer (type int) containing the new chunk-size to use

** for the nominated database. Allocating database file space in large

** chunks (say 1MB at a time), may reduce file-system fragmentation and

** improve performance on some systems.

** <li>[[SQLITE_FCNTL_FILE_POINTER]]

** The [SQLITE_FCNTL_FILE_POINTER] opcode is used to obtain a pointer

** to the [sqlite3_file] object associated with a particular database

** connection. See also [SQLITE_FCNTL_JOURNAL_POINTER].

** <li>[[SQLITE_FCNTL_JOURNAL_POINTER]]

** The [SQLITE_FCNTL_JOURNAL_POINTER] opcode is used to obtain a pointer

** to the [sqlite3_file] object associated with the journal file (either

** the [rollback journal] or the [write-ahead log]) for a particular database

** connection. See also [SQLITE_FCNTL_FILE_POINTER].

** <li>[[SQLITE_FCNTL_SYNC_OMITTED]]

** No longer in use.

** <li>[[SQLITE_FCNTL_SYNC]]

** The [SQLITE_FCNTL_SYNC] opcode is generated internally by SQLite and

** sent to the VFS immediately before the xSync method is invoked on a

** database file descriptor. Or, if the xSync method is not invoked

** because the user has configured SQLite with

** [PRAGMA synchronous | PRAGMA synchronous=OFF] it is invoked in place

** of the xSync method. In most cases, the pointer argument passed with

** this file-control is NULL. However, if the database file is being synced

** as part of a multi-database commit, the argument points to a nul-terminated

** string containing the transactions master-journal file name. VFSes that

** do not need this signal should silently ignore this opcode. Applications

** should not call [sqlite3_file_control()] with this opcode as doing so may

** disrupt the operation of the specialized VFSes that do require it.

** <li>[[SQLITE_FCNTL_COMMIT_PHASETWO]]

** The [SQLITE_FCNTL_COMMIT_PHASETWO] opcode is generated internally by SQLite

** and sent to the VFS after a transaction has been committed immediately

** but before the database is unlocked. VFSes that do not need this signal

** should silently ignore this opcode. Applications should not call

** [sqlite3_file_control()] with this opcode as doing so may disrupt the

** operation of the specialized VFSes that do require it.

** <li>[[SQLITE_FCNTL_WIN32_AV_RETRY]]

** ^The [SQLITE_FCNTL_WIN32_AV_RETRY] opcode is used to configure automatic

** retry counts and intervals for certain disk I/O operations for the

** windows [VFS] in order to provide robustness in the presence of

** anti-virus programs. By default, the windows VFS will retry file read,

** file write, and file delete operations up to 10 times, with a delay

** of 25 milliseconds before the first retry and with the delay increasing

** by an additional 25 milliseconds with each subsequent retry. This

** opcode allows these two values (10 retries and 25 milliseconds of delay)

** to be adjusted. The values are changed for all database connections

** within the same process. The argument is a pointer to an array of two

** integers where the first integer i the new retry count and the second

** integer is the delay. If either integer is negative, then the setting

** is not changed but instead the prior value of that setting is written

** into the array entry, allowing the current retry settings to be

** interrogated. The zDbName parameter is ignored.

** <li>[[SQLITE_FCNTL_PERSIST_WAL]]

** ^The [SQLITE_FCNTL_PERSIST_WAL] opcode is used to set or query the

** persistent [WAL | Write Ahead Log] setting. By default, the auxiliary

** write ahead log and shared memory files used for transaction control

** are automatically deleted when the latest connection to the database

** closes. Setting persistent WAL mode causes those files to persist after

** close. Persisting the files is useful when other processes that do not

** have write permission on the directory containing the database file want

** to read the database file, as the WAL and shared memory files must exist

** in order for the database to be readable. The fourth parameter to

** [sqlite3_file_control()] for this opcode should be a pointer to an integer.

** That integer is 0 to disable persistent WAL mode or 1 to enable persistent

** WAL mode. If the integer is -1, then it is overwritten with the current

** WAL persistence setting.

** <li>[[SQLITE_FCNTL_POWERSAFE_OVERWRITE]]

** ^The [SQLITE_FCNTL_POWERSAFE_OVERWRITE] opcode is used to set or query the

** persistent "powersafe-overwrite" or "PSOW" setting. The PSOW setting

** determines the [SQLITE_IOCAP_POWERSAFE_OVERWRITE] bit of the

** xDeviceCharacteristics methods. The fourth parameter to

** [sqlite3_file_control()] for this opcode should be a pointer to an integer.

** That integer is 0 to disable zero-damage mode or 1 to enable zero-damage

** mode. If the integer is -1, then it is overwritten with the current

** zero-damage mode setting.

** <li>[[SQLITE_FCNTL_OVERWRITE]]

** ^The [SQLITE_FCNTL_OVERWRITE] opcode is invoked by SQLite after opening

** a write transaction to indicate that, unless it is rolled back for some

** reason, the entire database file will be overwritten by the current

** transaction. This is used by VACUUM operations.

** <li>[[SQLITE_FCNTL_VFSNAME]]

** ^The [SQLITE_FCNTL_VFSNAME] opcode can be used to obtain the names of

** all [VFSes] in the VFS stack. The names are of all VFS shims and the

** final bottom-level VFS are written into memory obtained from

** [sqlite3_malloc()] and the result is stored in the char* variable

** that the fourth parameter of [sqlite3_file_control()] points to.

** The caller is responsible for freeing the memory when done. As with

** all file-control actions, there is no guarantee that this will actually

** do anything. Callers should initialize the char* variable to a NULL

** pointer in case this file-control is not implemented. This file-control

** is intended for diagnostic use only.

** <li>[[SQLITE_FCNTL_VFS_POINTER]]

** ^The [SQLITE_FCNTL_VFS_POINTER] opcode finds a pointer to the top-level

** [VFSes] currently in use. ^(The argument X in

** sqlite3_file_control(db,SQLITE_FCNTL_VFS_POINTER,X) must be

** of type "[sqlite3_vfs] **". This opcodes will set *X

** to a pointer to the top-level VFS.)^

** ^When there are multiple VFS shims in the stack, this opcode finds the

** upper-most shim only.

** <li>[[SQLITE_FCNTL_PRAGMA]]

** ^Whenever a [PRAGMA] statement is parsed, an [SQLITE_FCNTL_PRAGMA]

** file control is sent to the open [sqlite3_file] object corresponding

** to the database file to which the pragma statement refers. ^The argument

** to the [SQLITE_FCNTL_PRAGMA] file control is an array of

** pointers to strings (char**) in which the second element of the array

** is the name of the pragma and the third element is the argument to the

** pragma or NULL if the pragma has no argument. ^The handler for an

** [SQLITE_FCNTL_PRAGMA] file control can optionally make the first element

** of the char** argument point to a string obtained from [sqlite3_mprintf()]

** or the equivalent and that string will become the result of the pragma or

** the error message if the pragma fails. ^If the

** [SQLITE_FCNTL_PRAGMA] file control returns [SQLITE_NOTFOUND], then normal

** [PRAGMA] processing continues. ^If the [SQLITE_FCNTL_PRAGMA]

** file control returns [SQLITE_OK], then the parser assumes that the

** VFS has handled the PRAGMA itself and the parser generates a no-op

** prepared statement if result string is NULL, or that returns a copy

** of the result string if the string is non-NULL.

** ^If the [SQLITE_FCNTL_PRAGMA] file control returns

** any result code other than [SQLITE_OK] or [SQLITE_NOTFOUND], that means

** that the VFS encountered an error while handling the [PRAGMA] and the

** compilation of the PRAGMA fails with an error. ^The [SQLITE_FCNTL_PRAGMA]

** file control occurs at the beginning of pragma statement analysis and so

** it is able to override built-in [PRAGMA] statements.

** <li>[[SQLITE_FCNTL_BUSYHANDLER]]

** ^The [SQLITE_FCNTL_BUSYHANDLER]

** file-control may be invoked by SQLite on the database file handle

** shortly after it is opened in order to provide a custom VFS with access

** to the connections busy-handler callback. The argument is of type (void **)

** - an array of two (void *) values. The first (void *) actually points

** to a function of type (int (*)(void *)). In order to invoke the connections

** busy-handler, this function should be invoked with the second (void *) in

** the array as the only argument. If it returns non-zero, then the operation

** should be retried. If it returns zero, the custom VFS should abandon the

** current operation.

** <li>[[SQLITE_FCNTL_TEMPFILENAME]]

** ^Application can invoke the [SQLITE_FCNTL_TEMPFILENAME] file-control

** to have SQLite generate a

** temporary filename using the same algorithm that is followed to generate

** temporary filenames for TEMP tables and other internal uses. The

** argument should be a char** which will be filled with the filename

** written into memory obtained from [sqlite3_malloc()]. The caller should

** invoke [sqlite3_free()] on the result to avoid a memory leak.

** <li>[[SQLITE_FCNTL_MMAP_SIZE]]

** The [SQLITE_FCNTL_MMAP_SIZE] file control is used to query or set the

** maximum number of bytes that will be used for memory-mapped I/O.

** The argument is a pointer to a value of type sqlite3_int64 that

** is an advisory maximum number of bytes in the file to memory map. The

** pointer is overwritten with the old value. The limit is not changed if

** the value originally pointed to is negative, and so the current limit

** can be queried by passing in a pointer to a negative number. This

** file-control is used internally to implement [PRAGMA mmap_size].

** <li>[[SQLITE_FCNTL_TRACE]]

** The [SQLITE_FCNTL_TRACE] file control provides advisory information

** to the VFS about what the higher layers of the SQLite stack are doing.

** This file control is used by some VFS activity tracing [shims].

** The argument is a zero-terminated string. Higher layers in the

** SQLite stack may generate instances of this file control if

** the [SQLITE_USE_FCNTL_TRACE] compile-time option is enabled.

** <li>[[SQLITE_FCNTL_HAS_MOVED]]

** The [SQLITE_FCNTL_HAS_MOVED] file control interprets its argument as a

** pointer to an integer and it writes a boolean into that integer depending

** on whether or not the file has been renamed, moved, or deleted since it

** was first opened.

** <li>[[SQLITE_FCNTL_WIN32_SET_HANDLE]]

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

** opcode causes the xFileControl method to swap the file handle with the one

** pointed to by the pArg argument. This capability is used during testing

** and only needs to be supported when SQLITE_TEST is defined.

** <li>[[SQLITE_FCNTL_WAL_BLOCK]]

** The [SQLITE_FCNTL_WAL_BLOCK] is a signal to the VFS layer that it might

** be advantageous to block on the next WAL lock if the lock is not immediately

** available. The WAL subsystem issues this signal during rare

** circumstances in order to fix a problem with priority inversion.

** Applications should <em>not</em> use this file-control.

** <li>[[SQLITE_FCNTL_ZIPVFS]]

** The [SQLITE_FCNTL_ZIPVFS] opcode is implemented by zipvfs only. All other

** VFS should return SQLITE_NOTFOUND for this opcode.

** <li>[[SQLITE_FCNTL_RBU]]

** The [SQLITE_FCNTL_RBU] opcode is implemented by the special VFS used by

** the RBU extension only. All other VFS should return SQLITE_NOTFOUND for

** this opcode.

** </ul>

#define SQLITE_FCNTL_LOCKSTATE 1

#define SQLITE_FCNTL_GET_LOCKPROXYFILE 2

#define SQLITE_FCNTL_SET_LOCKPROXYFILE 3

#define SQLITE_FCNTL_LAST_ERRNO 4

#define SQLITE_FCNTL_SIZE_HINT 5

#define SQLITE_FCNTL_CHUNK_SIZE 6

#define SQLITE_FCNTL_FILE_POINTER 7

#define SQLITE_FCNTL_SYNC_OMITTED 8

#define SQLITE_FCNTL_WIN32_AV_RETRY 9

View remainder of file in raw view

SQLite-PPL/src/sqlite.h.in at master · FlashSQL/SQLite-PPL · GitHub

Navigation Menu

Uh oh!

SQLite-PPL/src/sqlite.h.in at master · FlashSQL/SQLite-PPL · GitHub

Navigation Menu

Uh oh!

Expand file tree

Breadcrumbs

sqlite.h.in

Latest commit

History

Breadcrumbs

sqlite.h.in

File metadata and controls

Footer

Footer navigation