Sqlite参考手册

C Interface: Session Module

Add A Changeset To A Changegroup

int sqlite3changegroup_add(sqlite3_changegroup*, int nData, void *pData);

Add all changes within the changeset (or patchset) in buffer pData (size nData bytes) to the changegroup.

If the buffer contains a patchset, then all prior calls to this function on the same changegroup object must also have specified patchsets. Or, if the buffer contains a changeset, so must have the earlier calls to this function. Otherwise, SQLITE_ERROR is returned and no changes are added to the changegroup.

Rows within the changeset and changegroup are identified by the values in their PRIMARY KEY columns. A change in the changeset is considered to apply to the same row as a change already present in the changegroup if the two rows have the same primary key.

Changes to rows that do not already appear in the changegroup are simply copied into it. Or, if both the new changeset and the changegroup contain changes that apply to a single row, the final contents of the changegroup depends on the type of each change, as follows:

Existing Change	New Change	Output Change
INSERT	INSERT	The new change is ignored. This case does not occur if the new changeset was recorded immediately after the changesets already added to the changegroup.
INSERT	UPDATE	The INSERT change remains in the changegroup. The values in the INSERT change are modified as if the row was inserted by the existing change and then updated according to the new change.
INSERT	DELETE	The existing INSERT is removed from the changegroup. The DELETE is not added.
UPDATE	INSERT	The new change is ignored. This case does not occur if the new changeset was recorded immediately after the changesets already added to the changegroup.
UPDATE	UPDATE	The existing UPDATE remains within the changegroup. It is amended so that the accompanying values are as if the row was updated once by the existing change and then again by the new change.
UPDATE	DELETE	The existing UPDATE is replaced by the new DELETE within the changegroup.
DELETE	INSERT	If one or more of the column values in the row inserted by the new change differ from those in the row deleted by the existing change, the existing DELETE is replaced by an UPDATE within the changegroup. Otherwise, if the inserted row is exactly the same as the deleted row, the existing DELETE is simply discarded.
DELETE	UPDATE	The new change is ignored. This case does not occur if the new changeset was recorded immediately after the changesets already added to the changegroup.
DELETE	DELETE	The new change is ignored. This case does not occur if the new changeset was recorded immediately after the changesets already added to the changegroup.

If the new changeset contains changes to a table that is already present in the changegroup, then the number of columns and the position of the primary key columns for the table must be consistent. If this is not the case, this function fails with SQLITE_SCHEMA. If the input changeset appears to be corrupt and the corruption is detected, SQLITE_CORRUPT is returned. Or, if an out-of-memory condition occurs during processing, this function returns SQLITE_NOMEM. In all cases, if an error occurs the final contents of the changegroup is undefined.

If no error occurs, SQLITE_OK is returned.

See also lists of Objects, Constants, and Functions.

 SQLite is in the Public Domain.

https://sqlite.org/session/sqlite3changegroup_add.html

C Interface: Session Module相关

1.Advance A Changeset Iterator
2.Apply A Changeset To A Database
3.Attach A Table To A Session Object
4.Changegroup Handle
5.Changeset Iterator Handle
6.Concatenate Two Changeset Objects
7.Constants Passed To The Conflict Handler
8.Constants Returned By The Conflict Handler
9.Create A New Changegroup Object
10.Create A New Session Object
11.Create An Iterator To Traverse A Changeset
12.Delete A Changegroup Object
13.Delete A Session Object
14.Determine The Number Of Foreign Key Constraint Violations
15.Enable Or Disable A Session Object
16.Finalize A Changeset Iterator
17.Generate A Changeset From A Session Object
18.Generate A Patchset From A Session Object
19.Invert A Changeset
20.Load The Difference Between Tables Into A Session
21.Obtain A Composite Changeset From A Changegroup
22.Obtain Conflicting Row Values From A Changeset Iterator
23.Obtain new.* Values From A Changeset Iterator
24.Obtain old.* Values From A Changeset Iterator
25.Obtain The Current Operation From A Changeset Iterator
26.Obtain The Primary Key Definition Of A Table
27.Session Object Handle
28.Set a table filter on a Session Object
29.Set Or Clear the Indirect Change Flag
30.SQLite Session Module C/C++ Interface
31.Streaming Versions of API functions
32.Test if a changeset has recorded any changes
33.The Session Extension

Sqlite

SQLite，是一款轻型的数据库，是遵守ACID的关系型数据库管理系统，它包含在一个相对小的C库中。它是D.RichardHipp建立的公有领域项目。它的设计目标是嵌入式的，而且目前已经在很多嵌入式产品中使用了它，它占用资源非常的低，在嵌入式设备中，可能只需要几百K的内存就够了。它能够支持Windows/Linux/Unix等等主流的操作系统，同时能够跟很多程序语言相结合，比如 Tcl、C#、PHP、Java等，还有ODBC接口，同样比起Mysql、PostgreSQL这两款开源的世界著名数据库管理系统来

主页	https://sqlite.org/
源码	https://www.sqlite.org/src/
发布版本	3.21.0

Sqlite目录

1.C界面 \| C Interface
2.C Interface: Session Module
3.CLI
4.数据库文件表 \| Database File Format
5.数据类 \| Datatypes
6.动态内存分配 \| Dynamic Memory Allocation
7.外键约束 \| Foreign Key Constraints
8.全文索引 \| Full-Text Search
9.损坏方式 \| How To Corrupt
10.JSON
11.语言 \| Language
12.局限性 \| Limits
13.锁定和并发 \| Locking and Concurrency
14.其他 \| Miscellaneous
15.PRAGMA Statements
16.查询计划程序 \| Query Planner
17.R*Tree Module
18.RBU Extension
19.语法图 \| Syntax Diagrams
20.Tcl Interface
21.虚拟表机制 \| Virtual Table Mechanism
22.预写日志 \| Write-Ahead Logging
23.SQL 教程
24.SQL 简介
25.SQL 语法
26.SQL DELETE 语句
27.SQL UPDATE 语句
28.SQL NOT NULL 约束
29.SQL 约束
30.SQL CREATE TABLE 语句
31.SQL CREATE DATABASE 语句
32.SQL INSERT INTO SELECT 语句
33.SQL SELECT INTO 语句
34.SQL CREATE VIEW、REPLACE VIEW、 DROP VIEW 语句
35.SQL AUTO INCREMENT 字段
36.SQL ALTER TABLE 语句
37.SQL 撤销索引、表以及数据库
38.SQL CREATE INDEX 语句
39.SQL DEFAULT 约束
40.SQL CHECK 约束
41.SQL FOREIGN KEY 约束
42.SQL PRIMARY KEY 约束
43.SQL UNIQUE 约束
44.SQL 通用数据类型
45.SQL ISNULL()、NVL()、IFNULL() 和 COALESCE() 函数
46.SQL NULL 值 – IS NULL 和 IS NOT NULL
47.SQL Server 和 MySQL 中的 Date 函数
48.SQL MS Access、MySQL 和 SQL Server 数据类型
49.SQL 函数
50.SQL 总结
51.SQL 主机
52.SQL 快速参考
53.SQL ROUND() 函数
54.SQL Server GETDATE() 函数
55.MySQL DATE_FORMAT() 函数
56.MySQL DATEDIFF() 函数
57.MySQL DATE_SUB() 函数
58.MySQL DATE_ADD() 函数
59.MySQL EXTRACT() 函数
60.MySQL DATE() 函数
61.MySQL CURTIME() 函数
62.MySQL CURDATE() 函数
63.MySQL NOW() 函数
64.SQL Server CONVERT() 函数
65.SQL Server DATEDIFF() 函数
66.SQL Server DATEADD() 函数
67.SQL Server DATEPART() 函数
68.SQLite 命令
69.SQLite 安装
70.SQLite 简介
71.SQLite 运算符
72.SQLite Select 语句
73.SQLite 删除表
74.SQLite 创建表
75.SQLite Insert 语句
76.SQLite 分离数据库
77.SQLite 附加数据库
78.SQLite 创建数据库
79.SQLite 数据类型
80.SQLite 语法
81.SQLite Order By
82.SQLite Limit 子句
83.SQLite Glob 子句
84.SQLite Like 子句
85.SQLite Delete 语句
86.SQLite Update 语句
87.SQLite AND/OR 运算符
88.SQLite Where 子句
89.SQLite 表达式
90.SQLite Distinct 关键字
91.SQLite Having 子句
92.SQLite Group By
93.SQLite Join
94.SQLite 约束
95.SQLite PRAGMA
96.SQLite 事务
97.SQLite 视图
98.SQLite Truncate Table
99.SQLite Alter 命令
100.SQLite Indexed By