Lines Matching refs:out
374 static void printQuoted(FILE *out, sqlite3_value *X){ in printQuoted() argument
381 fprintf(out, "%s", zBuf); in printQuoted()
385 fprintf(out, "%lld", sqlite3_value_int64(X)); in printQuoted()
393 fprintf(out, "x'"); in printQuoted()
395 fprintf(out, "%02x", zBlob[i]); in printQuoted()
397 fprintf(out, "'"); in printQuoted()
400 fprintf(out, "X''"); in printQuoted()
408 fprintf(out, "NULL"); in printQuoted()
412 fprintf(out, "'"); in printQuoted()
418 fprintf(out, "%.*s'||X'%02x", i-j, &zArg[j], c); in printQuoted()
421 fprintf(out, "%02x", c); in printQuoted()
426 fprintf(out, "'\n||'"); in printQuoted()
429 fprintf(out, "%.*s'", i-j+1, &zArg[j]); in printQuoted()
434 fprintf(out, "%s'", &zArg[j]); in printQuoted()
439 fprintf(out, "NULL"); in printQuoted()
448 static void dump_table(const char *zTab, FILE *out){ in dump_table() argument
460 fprintf(out, "%s;\n", sqlite3_column_text(pStmt,0)); in dump_table()
496 fprintf(out, "%s",ins.z); in dump_table()
499 fprintf(out, "%s",zSep); in dump_table()
500 printQuoted(out, sqlite3_column_value(pStmt,i)); in dump_table()
503 fprintf(out, ");\n"); in dump_table()
512 fprintf(out, "%s;\n", sqlite3_column_text(pStmt,0)); in dump_table()
523 static void diff_one_table(const char *zTab, FILE *out){ in diff_one_table() argument
563 fprintf(out, "-- 2nd DB has no %s table\n", zTab); in diff_one_table()
565 fprintf(out, "DROP TABLE %s;\n", zId); in diff_one_table()
573 fprintf(out, "-- 1st DB has no %s table\n", zTab); in diff_one_table()
575 dump_table(zTab, out); in diff_one_table()
592 fprintf(out, "%sDROP TABLE %s; -- due to schema mismatch\n", zLead, zId); in diff_one_table()
593 dump_table(zTab, out); in diff_one_table()
599 fprintf(out, "ALTER TABLE %s ADD COLUMN %s;\n", zId, safeId(az2[n2])); in diff_one_table()
699 fprintf(out, "DROP INDEX %s;\n", z); in diff_one_table()
711 fprintf(out, "%sUPDATE %s", zLead, zId); in diff_one_table()
715 fprintf(out, "%s %s=", zSep, az2[(i+nPk-1)/2]); in diff_one_table()
717 printQuoted(out, sqlite3_column_value(pStmt,i+1)); in diff_one_table()
720 fprintf(out, "%sDELETE FROM %s", zLead, zId); in diff_one_table()
724 fprintf(out, "%s %s=", zSep, az2[i]); in diff_one_table()
725 printQuoted(out, sqlite3_column_value(pStmt,i)); in diff_one_table()
728 fprintf(out, ";\n"); in diff_one_table()
730 fprintf(out, "%sINSERT INTO %s(%s", zLead, zId, az2[0]); in diff_one_table()
731 for(i=1; az2[i]; i++) fprintf(out, ",%s", az2[i]); in diff_one_table()
732 fprintf(out, ") VALUES"); in diff_one_table()
735 fprintf(out, "%s", zSep); in diff_one_table()
737 printQuoted(out, sqlite3_column_value(pStmt,i)); in diff_one_table()
740 fprintf(out, ","); in diff_one_table()
741 printQuoted(out, sqlite3_column_value(pStmt,i)); in diff_one_table()
743 fprintf(out, ");\n"); in diff_one_table()
759 fprintf(out, "%s;\n", sqlite3_column_text(pStmt,0)); in diff_one_table()
1259 static void rbudiff_one_table(const char *zTab, FILE *out){ in rbudiff_one_table() argument
1309 fprintf(out, "%s\n", ct.z); in rbudiff_one_table()
1314 fprintf(out, "%s", insert.z); in rbudiff_one_table()
1319 if( i>0 ) fprintf(out, ", "); in rbudiff_one_table()
1320 printQuoted(out, sqlite3_column_value(pStmt, i)); in rbudiff_one_table()
1346 fprintf(out, "x'"); in rbudiff_one_table()
1347 for(j=0; j<nDelta; j++) fprintf(out, "%02x", (u8)aDelta[j]); in rbudiff_one_table()
1348 fprintf(out, "'"); in rbudiff_one_table()
1356 printQuoted(out, sqlite3_column_value(pStmt, i)); in rbudiff_one_table()
1358 fprintf(out, ", "); in rbudiff_one_table()
1360 fprintf(out, "'%s'", zOtaControl); in rbudiff_one_table()
1365 fprintf(out, ");\n"); in rbudiff_one_table()
1372 fprintf(out, "%s\n", cnt.z); in rbudiff_one_table()
1390 static void summarize_one_table(const char *zTab, FILE *out){ in summarize_one_table() argument
1411 fprintf(out, "%s: missing from second database\n", zTab); in summarize_one_table()
1418 fprintf(out, "%s: missing from first database\n", zTab); in summarize_one_table()
1435 fprintf(out, "%s: incompatible schema\n", zTab); in summarize_one_table()
1505 fprintf(out, "%s: %lld changes, %lld inserts, %lld deletes, %lld unchanged\n", in summarize_one_table()
1519 static void putsVarint(FILE *out, sqlite3_uint64 v){ in putsVarint() argument
1529 fwrite(p, 8, 1, out); in putsVarint()
1537 fwrite(p+n+1, 9-n, 1, out); in putsVarint()
1544 static void putValue(FILE *out, sqlite3_stmt *pStmt, int k){ in putValue() argument
1551 putc(iDType, out); in putValue()
1556 for(j=56; j>=0; j-=8) putc((uX>>j)&0xff, out); in putValue()
1561 for(j=56; j>=0; j-=8) putc((uX>>j)&0xff, out); in putValue()
1565 putsVarint(out, (sqlite3_uint64)iX); in putValue()
1566 fwrite(sqlite3_column_text(pStmt, k),1,(size_t)iX,out); in putValue()
1570 putsVarint(out, (sqlite3_uint64)iX); in putValue()
1571 fwrite(sqlite3_column_blob(pStmt, k),1,(size_t)iX,out); in putValue()
1581 static void changeset_one_table(const char *zTab, FILE *out){ in changeset_one_table() argument
1686 putc('T', out); in changeset_one_table()
1687 putsVarint(out, (sqlite3_uint64)nCol); in changeset_one_table()
1688 for(i=0; i<nCol; i++) putc(aiFlg[i], out); in changeset_one_table()
1689 fwrite(zTab, 1, strlen(zTab), out); in changeset_one_table()
1690 putc(0, out); in changeset_one_table()
1695 putc(iType, out); in changeset_one_table()
1696 putc(0, out); in changeset_one_table()
1701 putValue(out, pStmt, k); in changeset_one_table()
1704 putValue(out, pStmt, k+1); in changeset_one_table()
1707 putc(0, out); in changeset_one_table()
1713 putc(0, out); in changeset_one_table()
1716 putValue(out, pStmt, k+2); in changeset_one_table()
1719 putc(0, out); in changeset_one_table()
1728 putValue(out, pStmt, k); in changeset_one_table()
1731 putValue(out, pStmt, k+2); in changeset_one_table()
1740 putValue(out, pStmt, k); in changeset_one_table()
1743 putValue(out, pStmt, k+1); in changeset_one_table()
1938 FILE *out = stdout; in main() local
1956 out = fopen(argv[++i], "wb"); in main()
1957 if( out==0 ) cmdlineError("cannot open: %s", argv[i]); in main()
2050 if( useTransaction ) fprintf(out, "BEGIN TRANSACTION;\n"); in main()
2052 fprintf(out, "CREATE TABLE IF NOT EXISTS rbu_count" in main()
2058 xDiff(zTab, out); in main()
2063 xDiff((const char*)sqlite3_column_text(pStmt,0), out); in main()