Debian Codegraph @

www/session/c_changesetapply_fknoaction.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>Flags for sqlite3changeset_apply_v2</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <a href="../session/intro.html"><h2>Session Module C Interface</h2></a><h2>Flags for sqlite3changeset_apply_v2</h2><blockquote><pre>#define SQLITE_CHANGESETAPPLY_NOSAVEPOINT 0x0001
119 #define SQLITE_CHANGESETAPPLY_INVERT 0x0002
120 #define SQLITE_CHANGESETAPPLY_IGNORENOOP 0x0004
121 #define SQLITE_CHANGESETAPPLY_FKNOACTION 0x0008
122 #define SQLITE_CHANGESETAPPLY_NOUPDATELOOP 0x0010
123 </pre></blockquote><p>
124 The following flags may passed via the 9th parameter to
125 <a href="../session/sqlite3changeset_apply.html">sqlite3changeset_apply_v2</a> and <a href="../session/sqlite3changegroup_add_strm.html">sqlite3changeset_apply_v2_strm</a>:</p>
126
127 <p><dl>
128 <dt>SQLITE_CHANGESETAPPLY_NOSAVEPOINT <dd>
129 Usually, the sessions module encloses all operations performed by
130 a single call to apply_v2() or apply_v2_strm() in a <a href="../lang_savepoint.html">SAVEPOINT</a>. The
131 SAVEPOINT is committed if the changeset or patchset is successfully
132 applied, or rolled back if an error occurs. Specifying this flag
133 causes the sessions module to omit this savepoint. In this case, if the
134 caller has an open transaction or savepoint when apply_v2() is called,
135 it may revert the partially applied changeset by rolling it back.</p>
136
137 <p><dt>SQLITE_CHANGESETAPPLY_INVERT <dd>
138 Invert the changeset before applying it. This is equivalent to inverting
139 a changeset using sqlite3changeset_invert() before applying it. It is
140 an error to specify this flag with a patchset.</p>
141
142 <p><dt>SQLITE_CHANGESETAPPLY_IGNORENOOP <dd>
143 Do not invoke the conflict handler callback for any changes that
144 would not actually modify the database even if they were applied.
145 Specifically, this means that the conflict handler is not invoked
146 for:
147 <ul>
148 <li>a delete change if the row being deleted cannot be found,
149 <li>an update change if the modified fields are already set to
150 their new values in the conflicting row, or
151 <li>an insert change if all fields of the conflicting row match
152 the row being inserted.
153 </ul></p>
154
155 <p><dt>SQLITE_CHANGESETAPPLY_FKNOACTION <dd>
156 If this flag it set, then all foreign key constraints in the target
157 database behave as if they were declared with "ON UPDATE NO ACTION ON
158 DELETE NO ACTION", even if they are actually CASCADE, RESTRICT, SET NULL
159 or SET DEFAULT.</p>
160
161 <p><dt>SQLITE_CHANGESETAPPLY_NOUPDATELOOP <dd>
162 Sometimes, a changeset contains two or more update statements such that
163 although after applying all updates the database will contain no
164 constraint violations, no single update can be applied before the others.
165 The simplest example of this is a pair of UPDATEs that have "swapped"
166 two column values with a UNIQUE constraint.
167 <p>
168 Usually, sqlite3changeset_apply() and similar functions work hard to try
169 to find a way to apply such a changeset. However, if this flag is set,
170 then all such updates are considered CONSTRAINT conflicts.
171 </p><p>See also lists of
172 <a href="../session/objlist.html">Objects</a>,
173 <a href="../session/constlist.html">Constants</a>, and
174 <a href="../session/funclist.html">Functions</a>.</p>
175