Debian Codegraph @

ext/session/changeset.c

raw
1 /*
2 ** 2014-08-18
3 **
4 ** The author disclaims copyright to this source code. In place of
5 ** a legal notice, here is a blessing:
6 **
7 ** May you do good and not evil.
8 ** May you find forgiveness for yourself and forgive others.
9 ** May you share freely, never taking more than you give.
10 **
11 *************************************************************************
12 ** This file contains code to implement the "changeset" command line
13 ** utility for displaying and transforming changesets generated by
14 ** the Sessions extension.
15 */
16 #include "sqlite3.h"
17 #include <stdio.h>
18 #include <stdlib.h>
19 #include <string.h>
20 #include <assert.h>
21 #include <ctype.h>
22
23
24 /*
25 ** Show a usage message on stderr then quit.
26 */
27 static void usage(const char *argv0){
28 fprintf(stderr, "Usage: %s FILENAME COMMAND ...\n", argv0);
29 fprintf(stderr,
30 "COMMANDs:\n"
31 " apply DB [OPTIONS] Apply the changeset to database file DB. OPTIONS:\n"
32 " -n|--dryrun Test run. Don't apply changes\n"
33 " --enablefk Enable FOREIGN KEY support\n"
34 " --nosavepoint \\\n"
35 " --invert \\___ Flags passed into\n"
36 " --ignorenoop / changeset_apply_v2()\n"
37 " --fknoaction /\n"
38 " concat FILE2 OUT Concatenate FILENAME and FILE2 into OUT\n"
39 " dump Show the complete content of the changeset\n"
40 " invert OUT Write an inverted changeset into file OUT\n"
41 " sql Give a pseudo-SQL rendering of the changeset\n"
42 );
43 exit(1);
44 }
45
46 /*
47 ** Read the content of a disk file into an in-memory buffer
48 */
49 static void readFile(const char *zFilename, int *pSz, void **ppBuf){
50 FILE *f;
51 sqlite3_int64 sz;
52 void *pBuf;
53 f = fopen(zFilename, "rb");
54 if( f==0 ){
55 fprintf(stderr, "cannot open \"%s\" for reading\n", zFilename);
56 exit(1);
57 }
58 fseek(f, 0, SEEK_END);
59 sz = ftell(f);
60 rewind(f);
61 pBuf = sqlite3_malloc64( sz ? sz : 1 );
62 if( pBuf==0 ){
63 fprintf(stderr, "cannot allocate %d to hold content of \"%s\"\n",
64 (int)sz, zFilename);
65 exit(1);
66 }
67 if( sz>0 ){
68 if( fread(pBuf, (size_t)sz, 1, f)!=1 ){
69 fprintf(stderr, "cannot read all %d bytes of \"%s\"\n",
70 (int)sz, zFilename);
71 exit(1);
72 }
73 fclose(f);
74 }
75 *pSz = (int)sz;
76 *ppBuf = pBuf;
77 }
78
79 /* Array for converting from half-bytes (nybbles) into ASCII hex
80 ** digits. */
81 static const char hexdigits[] = {
82 '0', '1', '2', '3', '4', '5', '6', '7',
83 '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'
84 };
85
86 /*
87 ** Render an sqlite3_value as an SQL string.
88 */
89 static void renderValue(sqlite3_value *pVal){
90 switch( sqlite3_value_type(pVal) ){
91 case SQLITE_FLOAT: {
92 double r1;
93 char zBuf[50];
94 r1 = sqlite3_value_double(pVal);
95 sqlite3_snprintf(sizeof(zBuf), zBuf, "%!.15g", r1);
96 printf("%s", zBuf);
97 break;
98 }
99 case SQLITE_INTEGER: {
100 printf("%lld", sqlite3_value_int64(pVal));
101 break;
102 }
103 case SQLITE_BLOB: {
104 char const *zBlob = sqlite3_value_blob(pVal);
105 int nBlob = sqlite3_value_bytes(pVal);
106 int i;
107 printf("x'");
108 for(i=0; i<nBlob; i++){
109 putchar(hexdigits[(zBlob[i]>>4)&0x0F]);
110 putchar(hexdigits[(zBlob[i])&0x0F]);
111 }
112 putchar('\'');
113 break;
114 }
115 case SQLITE_TEXT: {
116 const unsigned char *zArg = sqlite3_value_text(pVal);
117 putchar('\'');
118 while( zArg[0] ){
119 putchar(zArg[0]);
120 if( zArg[0]=='\'' ) putchar(zArg[0]);
121 zArg++;
122 }
123 putchar('\'');
124 break;
125 }
126 default: {
127 assert( sqlite3_value_type(pVal)==SQLITE_NULL );
128 printf("NULL");
129 break;
130 }
131 }
132 }
133
134 /*
135 ** Number of conflicts seen
136 */
137 static int nConflict = 0;
138
139 /*
140 ** The conflict callback
141 */
142 static int conflictCallback(
143 void *pCtx,
144 int eConflict,
145 sqlite3_changeset_iter *pIter
146 ){
147 int op, bIndirect, nCol, i;
148 const char *zTab;
149 unsigned char *abPK;
150 const char *zType = "";
151 const char *zOp = "";
152 const char *zSep = " ";
153
154 nConflict++;
155 sqlite3changeset_op(pIter, &zTab, &nCol, &op, &bIndirect);
156 sqlite3changeset_pk(pIter, &abPK, 0);
157 switch( eConflict ){
158 case SQLITE_CHANGESET_DATA: zType = "DATA"; break;
159 case SQLITE_CHANGESET_NOTFOUND: zType = "NOTFOUND"; break;
160 case SQLITE_CHANGESET_CONFLICT: zType = "PRIMARY KEY"; break;
161 case SQLITE_CHANGESET_FOREIGN_KEY: zType = "FOREIGN KEY"; break;
162 case SQLITE_CHANGESET_CONSTRAINT: zType = "CONSTRAINT"; break;
163 }
164 switch( op ){
165 case SQLITE_UPDATE: zOp = "UPDATE of"; break;
166 case SQLITE_INSERT: zOp = "INSERT into"; break;
167 case SQLITE_DELETE: zOp = "DELETE from"; break;
168 }
169 printf("%s conflict on %s table %s with primary key", zType, zOp, zTab);
170 for(i=0; i<nCol && abPK; i++){
171 sqlite3_value *pVal;
172 if( abPK[i]==0 ) continue;
173 printf("%s", zSep);
174 if( op==SQLITE_INSERT ){
175 sqlite3changeset_new(pIter, i, &pVal);
176 }else{
177 sqlite3changeset_old(pIter, i, &pVal);
178 }
179 renderValue(pVal);
180 zSep = ",";
181 }
182 printf("\n");
183 return SQLITE_CHANGESET_OMIT;
184 }
185
186 int main(int argc, char **argv){
187 int sz, rc;
188 void *pBuf = 0;
189 if( argc<3 ) usage(argv[0]);
190 readFile(argv[1], &sz, &pBuf);
191
192 /* changeset FILENAME apply DB
193 ** Apply the changeset in FILENAME to the database file DB
194 */
195 if( strcmp(argv[2],"apply")==0 ){
196 sqlite3 *db;
197 int bDryRun = 0;
198 int bEnableFK = 0;
199 const char *zDb = 0;
200 int i;
201 int applyFlags = 0;
202 for(i=3; i<argc; i++){
203 const char *zArg = argv[i];
204 if( zArg[0]=='-' ){
205 if( zArg[1]=='-' && zArg[2]!=0 ) zArg++;
206 if( strcmp(zArg, "-n")==0 || strcmp(zArg,"-dryrun")==0 ){
207 bDryRun = 1;
208 continue;
209 }
210 if( strcmp(zArg, "-nosavepoint")==0 ){
211 applyFlags |= SQLITE_CHANGESETAPPLY_NOSAVEPOINT;
212 continue;
213 }
214 if( strcmp(zArg, "-invert")==0 ){
215 applyFlags |= SQLITE_CHANGESETAPPLY_INVERT;
216 continue;
217 }
218 if( strcmp(zArg, "-ignorenoop")==0 ){
219 applyFlags |= SQLITE_CHANGESETAPPLY_IGNORENOOP;
220 continue;
221 }
222 if( strcmp(zArg, "-fknoaction")==0 ){
223 applyFlags |= SQLITE_CHANGESETAPPLY_FKNOACTION;
224 continue;
225 }
226 if( strcmp(zArg, "-enablefk")==0 ){
227 bEnableFK = 1;
228 continue;
229 }
230 fprintf(stderr, "unknown option: \"%s\"\n", argv[i]);
231 exit(1);
232 }else if( zDb ){
233 fprintf(stderr, "unknown argument: \"%s\"\n", argv[i]);
234 exit(1);
235 }else{
236 zDb = zArg;
237 }
238 }
239 rc = sqlite3_open(zDb, &db);
240 if( rc!=SQLITE_OK ){
241 fprintf(stderr, "unable to open database file \"%s\": %s\n",
242 zDb, sqlite3_errmsg(db));
243 sqlite3_close(db);
244 exit(1);
245 }
246 if( bEnableFK ){
247 sqlite3_exec(db, "PRAGMA foreign_keys=1;", 0, 0, 0);
248 }
249 sqlite3_exec(db, "BEGIN", 0, 0, 0);
250 nConflict = 0;
251 if( applyFlags ){
252 rc = sqlite3changeset_apply_v2(db, sz, pBuf, 0, conflictCallback, 0,
253 0, 0, applyFlags);
254 }else{
255 rc = sqlite3changeset_apply(db, sz, pBuf, 0, conflictCallback, 0);
256 }
257 if( rc ){
258 fprintf(stderr, "sqlite3changeset_apply() returned %d\n", rc);
259 }
260 if( nConflict || bDryRun ){
261 fprintf(stderr, "%d conflicts - no changes applied\n", nConflict);
262 sqlite3_exec(db, "ROLLBACK", 0, 0, 0);
263 }else if( rc ){
264 fprintf(stderr, "sqlite3changeset_apply() returns %d "
265 "- no changes applied\n", rc);
266 sqlite3_exec(db, "ROLLBACK", 0, 0, 0);
267 }else{
268 sqlite3_exec(db, "COMMIT", 0, 0, 0);
269 }
270 sqlite3_close(db);
271 }else
272
273 /* changeset FILENAME concat FILE2 OUT
274 ** Add changeset FILE2 onto the end of the changeset in FILENAME
275 ** and write the result into OUT.
276 */
277 if( strcmp(argv[2],"concat")==0 ){
278 int szB;
279 void *pB;
280 int szOut;
281 void *pOutBuf;
282 FILE *out;
283 const char *zOut = argv[4];
284 if( argc!=5 ) usage(argv[0]);
285 out = fopen(zOut, "wb");
286 if( out==0 ){
287 fprintf(stderr, "cannot open \"%s\" for writing\n", zOut);
288 exit(1);
289 }
290 readFile(argv[3], &szB, &pB);
291 rc = sqlite3changeset_concat(sz, pBuf, szB, pB, &szOut, &pOutBuf);
292 if( rc!=SQLITE_OK ){
293 fprintf(stderr, "sqlite3changeset_concat() returns %d\n", rc);
294 }else if( szOut>0 && fwrite(pOutBuf, szOut, 1, out)!=1 ){
295 fprintf(stderr, "unable to write all %d bytes of output to \"%s\"\n",
296 szOut, zOut);
297 }
298 fclose(out);
299 sqlite3_free(pOutBuf);
300 sqlite3_free(pB);
301 }else
302
303 /* changeset FILENAME dump
304 ** Show the complete content of the changeset in FILENAME
305 */
306 if( strcmp(argv[2],"dump")==0 ){
307 int cnt = 0;
308 int i;
309 sqlite3_changeset_iter *pIter;
310 rc = sqlite3changeset_start(&pIter, sz, pBuf);
311 if( rc!=SQLITE_OK ){
312 fprintf(stderr, "sqlite3changeset_start() returns %d\n", rc);
313 exit(1);
314 }
315 while( sqlite3changeset_next(pIter)==SQLITE_ROW ){
316 int op, bIndirect, nCol;
317 const char *zTab;
318 unsigned char *abPK;
319 sqlite3changeset_op(pIter, &zTab, &nCol, &op, &bIndirect);
320 cnt++;
321 printf("%d: %s table=[%s] indirect=%d nColumn=%d\n",
322 cnt, op==SQLITE_INSERT ? "INSERT" :
323 op==SQLITE_UPDATE ? "UPDATE" : "DELETE",
324 zTab, bIndirect, nCol);
325 sqlite3changeset_pk(pIter, &abPK, 0);
326 for(i=0; i<nCol; i++){
327 sqlite3_value *pVal;
328 pVal = 0;
329 sqlite3changeset_old(pIter, i, &pVal);
330 if( pVal ){
331 printf(" old[%d]%s = ", i, abPK[i] ? "pk" : " ");
332 renderValue(pVal);
333 printf("\n");
334 }
335 pVal = 0;
336 sqlite3changeset_new(pIter, i, &pVal);
337 if( pVal ){
338 printf(" new[%d]%s = ", i, abPK[i] ? "pk" : " ");
339 renderValue(pVal);
340 printf("\n");
341 }
342 }
343 }
344 sqlite3changeset_finalize(pIter);
345 }else
346
347 /* changeset FILENAME invert OUT
348 ** Invert the changes in FILENAME and writes the result on OUT
349 */
350 if( strcmp(argv[2],"invert")==0 ){
351 FILE *out;
352 int szOut = 0;
353 void *pOutBuf = 0;
354 const char *zOut = argv[3];
355 if( argc!=4 ) usage(argv[0]);
356 out = fopen(zOut, "wb");
357 if( out==0 ){
358 fprintf(stderr, "cannot open \"%s\" for writing\n", zOut);
359 exit(1);
360 }
361 rc = sqlite3changeset_invert(sz, pBuf, &szOut, &pOutBuf);
362 if( rc!=SQLITE_OK ){
363 fprintf(stderr, "sqlite3changeset_invert() returns %d\n", rc);
364 }else if( szOut>0 && fwrite(pOutBuf, szOut, 1, out)!=1 ){
365 fprintf(stderr, "unable to write all %d bytes of output to \"%s\"\n",
366 szOut, zOut);
367 }
368 fclose(out);
369 sqlite3_free(pOutBuf);
370 }else
371
372 /* changeset FILE sql
373 ** Show the content of the changeset as pseudo-SQL
374 */
375 if( strcmp(argv[2],"sql")==0 ){
376 int cnt = 0;
377 char *zPrevTab = 0;
378 char *zSQLTabName = 0;
379 sqlite3_changeset_iter *pIter = 0;
380 rc = sqlite3changeset_start(&pIter, sz, pBuf);
381 if( rc!=SQLITE_OK ){
382 fprintf(stderr, "sqlite3changeset_start() returns %d\n", rc);
383 exit(1);
384 }
385 printf("BEGIN;\n");
386 while( sqlite3changeset_next(pIter)==SQLITE_ROW ){
387 int op, bIndirect, nCol;
388 const char *zTab;
389 sqlite3changeset_op(pIter, &zTab, &nCol, &op, &bIndirect);
390 cnt++;
391 if( zPrevTab==0 || strcmp(zPrevTab,zTab)!=0 ){
392 sqlite3_free(zPrevTab);
393 sqlite3_free(zSQLTabName);
394 zPrevTab = sqlite3_mprintf("%s", zTab);
395 if( !isalnum(zTab[0]) || sqlite3_strglob("*[^a-zA-Z0-9]*",zTab)==0 ){
396 zSQLTabName = sqlite3_mprintf("\"%w\"", zTab);
397 }else{
398 zSQLTabName = sqlite3_mprintf("%s", zTab);
399 }
400 printf("/****** Changes for table %s ***************/\n", zSQLTabName);
401 }
402 switch( op ){
403 case SQLITE_DELETE: {
404 unsigned char *abPK;
405 int i;
406 const char *zSep = " ";
407 sqlite3changeset_pk(pIter, &abPK, 0);
408 printf("/* %d */ DELETE FROM %s WHERE", cnt, zSQLTabName);
409 for(i=0; i<nCol; i++){
410 sqlite3_value *pVal;
411 if( abPK[i]==0 ) continue;
412 printf("%sc%d=", zSep, i+1);
413 zSep = " AND ";
414 sqlite3changeset_old(pIter, i, &pVal);
415 renderValue(pVal);
416 }
417 printf(";\n");
418 break;
419 }
420 case SQLITE_UPDATE: {
421 unsigned char *abPK;
422 int i;
423 const char *zSep = " ";
424 sqlite3changeset_pk(pIter, &abPK, 0);
425 printf("/* %d */ UPDATE %s SET", cnt, zSQLTabName);
426 for(i=0; i<nCol; i++){
427 sqlite3_value *pVal = 0;
428 sqlite3changeset_new(pIter, i, &pVal);
429 if( pVal ){
430 printf("%sc%d=", zSep, i+1);
431 zSep = ", ";
432 renderValue(pVal);
433 }
434 }
435 printf(" WHERE");
436 zSep = " ";
437 for(i=0; i<nCol; i++){
438 sqlite3_value *pVal;
439 if( abPK[i]==0 ) continue;
440 printf("%sc%d=", zSep, i+1);
441 zSep = " AND ";
442 sqlite3changeset_old(pIter, i, &pVal);
443 renderValue(pVal);
444 }
445 printf(";\n");
446 break;
447 }
448 case SQLITE_INSERT: {
449 int i;
450 printf("/* %d */ INSERT INTO %s VALUES", cnt, zSQLTabName);
451 for(i=0; i<nCol; i++){
452 sqlite3_value *pVal;
453 printf("%c", i==0 ? '(' : ',');
454 sqlite3changeset_new(pIter, i, &pVal);
455 renderValue(pVal);
456 }
457 printf(");\n");
458 break;
459 }
460 }
461 }
462 printf("COMMIT;\n");
463 sqlite3changeset_finalize(pIter);
464 sqlite3_free(zPrevTab);
465 sqlite3_free(zSQLTabName);
466 }else
467
468 /* If nothing else matches, show the usage comment */
469 usage(argv[0]);
470 sqlite3_free(pBuf);
471 return 0;
472 }