Lines Matching refs:n
231 /* On Windows, we normally run with output mode of TEXT so that \n characters
232 ** are automatically translated into \r\n. However, this behavior needs
234 ** rendering quoted strings that contain \n characters). The following
260 static int cli_strncmp(const char *a, const char *b, size_t n){ argument
263 return strncmp(a,b,n);
323 printf("Run Time: real %.3f user %f sys %f\n",
402 printf("Run Time: real %.3f user %f sys %f\n",
507 raw_printf(stderr,"Error: out of memory\n");
552 int n; local
555 for(i=n=0; zUtf[i]; i++){
557 n++;
558 if( n==aw ){
564 if( n>=aw ){
567 utf8_printf(pOut, "%*s%s", aw-n, "", zUtf);
569 utf8_printf(pOut, "%s%*s", zUtf, aw-n, "");
616 int n = 0; local
618 if( (0xc0&*(z++))!=0x80 ) n++;
620 return n;
668 int n = 0; local
671 if( n+100>nLine ){
676 if( fgets(&zLine[n], nLine - n, in)==0 ){
677 if( n==0 ){
681 zLine[n] = 0;
684 while( zLine[n] ) n++;
685 if( n>0 && zLine[n-1]=='\n' ){
686 n--;
687 if( n>0 && zLine[n-1]=='\r' ) n--;
688 zLine[n] = 0;
810 int n; member
838 len = nAppend+p->n+1;
846 if( p->z==0 || p->n+len>=p->nAlloc ){
853 char *zCsr = p->z+p->n;
860 p->n = (int)(zCsr - p->z);
863 memcpy(p->z+p->n, zAppend, nAppend);
864 p->n += nAppend;
865 p->z[p->n] = '\0';
997 int n = strlen30(aPrefix[i]); local
998 if( cli_strncmp(zIn+7, aPrefix[i], n)==0 && zIn[n+7]==' ' ){
1004 z = sqlite3_mprintf("%.*s \"%w\".%s", n+7, zIn, zSchema, zIn+n+8);
1006 z = sqlite3_mprintf("%.*s %s.%s", n+7, zIn, zSchema, zIn+n+8);
1014 z = sqlite3_mprintf("%s\n/* %s */", zIn, zFake);
1016 z = sqlite3_mprintf("%z\n/* %s */", z, zFake);
1308 #define SEP_Row "\n"
1312 #define SEP_CrLf "\r\n"
1328 utf8_printf(p->pLog, "(%d) %s\n", iErrCode, zMsg);
1345 utf8_printf(p->out, "%s\n", sqlite3_value_text(apVal[0]));
1365 utf8_printf(stderr, "%s\n", zMsg);
1430 /* When writing the file to be edited, do \n to \r\n conversions on systems
1431 ** that want \r\n line endings */
1442 /* Remember whether or not the value originally contained \r\n */
1443 if( z && strstr(z,"\r\n")!=0 ) hasCRNL = 1;
1489 /* If the original contains \r\n then do no conversions back to \n */
1491 /* If the file did not originally contain \r\n then convert any new
1492 ** \r\n back into \n */
1494 if( p[i]=='\r' && p[i+1]=='\n' ) i++;
1611 ** Additionallly , escape the "\n" and "\r" characters so that they do not
1615 ** This is like output_quoted_string() but with the addition of the \r\n
1622 for(i=0; (c = z[i])!=0 && c!='\'' && c!='\n' && c!='\r'; i++){}
1632 if( z[i]=='\n' ) nNL++;
1637 zNL = unused_string(z, "\\n", "\\012", zBuf1);
1645 for(i=0; (c = z[i])!=0 && c!='\n' && c!='\r' && c!='\''; i++){}
1659 if( c=='\n' ){
1692 }else if( c=='\n' ){
1694 fputc('n', out);
1710 static void output_json_string(FILE *out, const char *z, i64 n){ argument
1712 if( n<0 ) n = strlen(z);
1714 while( n-- ){
1725 }else if( c=='\n' ){
1726 fputc('n', out);
1945 raw_printf(p->out, "\n");
1967 static const char *azTerm[] = { "", "*/", "\n" };
1972 size_t n = strlen(zNew); local
1973 zNew[n-1] = 0;
1988 static void printSchemaLineN(FILE *out, char *z, int n, const char *zTail){ argument
1989 char c = z[n];
1990 z[n] = 0;
1992 z[n] = c;
2002 if( z[i]=='\n' ) return 1;
2019 utf8_printf(p->out, "%d,%d,%s\n", iEqpId, p2, zText);
2062 i64 n = strlen(p->sGraph.zPrefix); local
2067 utf8_printf(p->out, "%s%s%s\n", p->sGraph.zPrefix,
2069 if( n<(i64)sizeof(p->sGraph.zPrefix)-7 ){
2070 memcpy(&p->sGraph.zPrefix[n], pNext ? "| " : " ", 4);
2072 p->sGraph.zPrefix[n] = 0;
2088 utf8_printf(p->out, "%s\n", pRow->zText+3);
2092 utf8_printf(p->out, "QUERY PLAN\n");
2108 raw_printf(p->out, "Progress limit reached (%u)\n", p->nProgress);
2114 raw_printf(p->out, "Progress %u\n", p->nProgress);
2151 fputs("\n", p->out);
2197 fputs(i==nArg-1 ? "\n" : " ", p->out);
2202 fputs(i==nArg-1 ? "\n" : " ", p->out);
2219 fputs(i==nArg-1 ? "\n" : " ", p->out);
2224 printSchemaLine(p->out, azArg[0], ";\n");
2239 utf8_printf(p->out, "%s;\n", azArg[0]);
2248 if( z[j-1]=='\r' ) z[j-1] = '\n';
2266 cEnd = '\n';
2272 printSchemaLineN(p->out, z, j, "\n");
2278 && (c=='(' || c=='\n' || (c==',' && !wsToEol(z+i+1)))
2280 if( c=='\n' ) j--;
2281 printSchemaLineN(p->out, z, j, "\n ");
2289 printSchemaLine(p->out, z, ";\n");
2319 raw_printf(p->out,"</TH>\n");
2321 raw_printf(p->out,"</TR>\n");
2328 raw_printf(p->out,"</TD>\n");
2330 raw_printf(p->out,"</TR>\n");
2427 raw_printf(p->out,");\n");
2435 fputs(",\n{", p->out);
2550 if( p->n ) appendText(p, "|", 0);
2564 "SAVEPOINT selftest_init;\n"
2565 "CREATE TABLE IF NOT EXISTS selftest(\n"
2566 " tno INTEGER PRIMARY KEY,\n" /* Test number */
2567 " op TEXT,\n" /* Operator: memo run */
2568 " cmd TEXT,\n" /* Command text */
2569 " ans TEXT\n" /* Desired answer */
2571 "CREATE TEMP TABLE [_shell$self](op,cmd,ans);\n"
2572 "INSERT INTO [_shell$self](rowid,op,cmd)\n"
2573 " VALUES(coalesce((SELECT (max(tno)+100)/10 FROM selftest),10),\n"
2574 " 'memo','Tests generated by --init');\n"
2575 "INSERT INTO [_shell$self]\n"
2576 " SELECT 'run',\n"
2578 "FROM sqlite_schema ORDER BY 2'',224))',\n"
2580 "FROM sqlite_schema ORDER BY 2',224));\n"
2581 "INSERT INTO [_shell$self]\n"
2584 " printf('%w',name) || '\" NOT INDEXED'',224))',\n"
2585 " hex(sha3_query(printf('SELECT * FROM \"%w\" NOT INDEXED',name),224))\n"
2586 " FROM (\n"
2587 " SELECT name FROM sqlite_schema\n"
2588 " WHERE type='table'\n"
2589 " AND name<>'selftest'\n"
2590 " AND coalesce(rootpage,0)>0\n"
2591 " )\n"
2592 " ORDER BY name;\n"
2593 "INSERT INTO [_shell$self]\n"
2594 " VALUES('run','PRAGMA integrity_check','ok');\n"
2596 " SELECT rowid*10,op,cmd,ans FROM [_shell$self];\n"
2600 utf8_printf(stderr, "SELFTEST initialization failure: %s\n", zErrMsg);
2613 int i, n; local
2623 n = strlen30(zName);
2624 if( cQuote ) n += n+2;
2625 z = p->zDestTable = malloc( n+1 );
2627 n = 0;
2628 if( cQuote ) z[n++] = cQuote;
2630 z[n++] = zName[i];
2631 if( zName[i]==cQuote ) z[n++] = cQuote;
2633 if( cQuote ) z[n++] = cQuote;
2634 z[n] = 0;
2672 zMsg = sqlite3_mprintf("\n %z\n %*s^--- error here", zCode, iOffset, "");
2674 zMsg = sqlite3_mprintf("\n %z\n %*serror here ---^", zCode, iOffset-14, "");
2702 utf8_printf(p->out, "/**** ERROR: (%d) %s *****/\n%s", rc,
2719 raw_printf(p->out, "\n;\n");
2721 raw_printf(p->out, ";\n");
2727 utf8_printf(p->out, "/**** ERROR: (%d) %s *****/\n", rc,
2785 int n = strlen30(aTrans[i].zPattern); local
2786 if( cli_strncmp(aTrans[i].zPattern, z, n)==0 ){
2787 utf8_printf(out, "%-36s %s", aTrans[i].zDesc, &z[n]);
2819 raw_printf(p->out, "%-36s %s\n", zLabel, zLine);
2841 raw_printf(out, "%-36s %d\n", "Number of output columns:", nCol);
2844 utf8_printf(out, "%-36s %s\n", z, sqlite3_column_name(pStmt,i));
2847 utf8_printf(out, "%-36s %s\n", z, sqlite3_column_decltype(pStmt, i));
2851 utf8_printf(out, "%-36s %s\n", z, sqlite3_column_database_name(pStmt,i));
2853 utf8_printf(out, "%-36s %s\n", z, sqlite3_column_table_name(pStmt,i));
2855 utf8_printf(out, "%-36s %s\n", z, sqlite3_column_origin_name(pStmt,i));
2863 raw_printf(pArg->out, "VM-steps: %d\n", iCur);
2893 "Lookaside Slots Used: %d (max %d)\n",
2897 raw_printf(pArg->out, "Successful lookaside attempts: %d\n",
2901 raw_printf(pArg->out, "Lookaside failures due to size: %d\n",
2905 raw_printf(pArg->out, "Lookaside failures due to OOM: %d\n",
2910 raw_printf(pArg->out, "Pager Heap Usage: %d bytes\n",
2914 raw_printf(pArg->out, "Page cache hits: %d\n", iCur);
2917 raw_printf(pArg->out, "Page cache misses: %d\n", iCur);
2920 raw_printf(pArg->out, "Page cache writes: %d\n", iCur);
2923 raw_printf(pArg->out, "Page cache spills: %d\n", iCur);
2926 raw_printf(pArg->out, "Schema Heap Usage: %d bytes\n",
2930 raw_printf(pArg->out, "Statement Heap/Lookaside Usage: %d bytes\n",
2938 raw_printf(pArg->out, "Fullscan Steps: %d\n", iCur);
2940 raw_printf(pArg->out, "Sort Operations: %d\n", iCur);
2942 raw_printf(pArg->out, "Autoindex Inserts: %d\n", iCur);
2946 raw_printf(pArg->out, "Bloom filter bypass taken: %d/%d\n",
2950 raw_printf(pArg->out, "Virtual Machine Steps: %d\n", iCur);
2952 raw_printf(pArg->out, "Reprepare operations: %d\n", iCur);
2954 raw_printf(pArg->out, "Number of times run: %d\n", iCur);
2956 raw_printf(pArg->out, "Memory used by prepared stmt: %d\n", iCur);
2979 int i, k, n, mx;
2980 raw_printf(pArg->out, "-------- scanstats --------\n");
2984 for(i=n=0; 1; i++){
2996 if( n==0 ){
2998 if( k>0 ) raw_printf(pArg->out, "-------- subquery %d -------\n", k);
3000 n++;
3004 utf8_printf(pArg->out, "Loop %2d: %s\n", n, zExplain);
3007 " nLoop=%-8lld nRow=%-8lld estRow=%-8lld estRow/Loop=%-8g\n",
3012 raw_printf(pArg->out, "---------------------------\n");
3072 for(z=zSql; *z==' ' || *z=='\t' || *z=='\n' || *z=='\f' || *z=='\r'; z++);
3168 "CREATE TABLE IF NOT EXISTS temp.sqlite_parameters(\n"
3169 " key TEXT PRIMARY KEY,\n"
3170 " value\n"
3284 fputs("\n", p->out);
3290 ** as \n, \t, \f, or \r.
3293 ** first \r, \n, or \f. Expand \t into spaces. Return a copy (obtained
3307 int n; /* Output column number */ local
3316 i = j = n = 0;
3317 while( n<mxWidth ){
3319 n++;
3325 n++;
3327 }while( (n&7)!=0 && n<mxWidth );
3333 if( n>=mxWidth && bWordWrap ){
3352 if( n>=mxWidth && z[i]>=' ' ){
3354 }else if( z[i]=='\r' && z[i+1]=='\n' ){
3363 i = j = n = 0;
3366 n++;
3372 n++;
3374 }while( (n&7)!=0 && n<mxWidth );
3404 int n = sqlite3_column_bytes(pStmt,i); local
3406 for(j=0; j<n; j++){
3440 int j, nTotal, w, n; local
3532 n = strlenChar(z);
3534 if( n>p->actualWidth[j] ) p->actualWidth[j] = n;
3541 rowSep = "\n";
3547 fputs(i==nColumn-1?"\n":" ", p->out);
3551 fputs(i==nColumn-1?"\n":" ", p->out);
3558 rowSep = " |\n";
3563 n = strlenChar(azData[i]);
3564 utf8_printf(p->out, "%*s%s%*s", (w-n)/2, "", azData[i], (w-n+1)/2, "");
3565 fputs(i==nColumn-1?" |\n":" | ", p->out);
3572 rowSep = " |\n";
3576 n = strlenChar(azData[i]);
3577 utf8_printf(p->out, "%*s%s%*s", (w-n)/2, "", azData[i], (w-n+1)/2, "");
3578 fputs(i==nColumn-1?" |\n":" | ", p->out);
3585 rowSep = " " BOX_13 "\n";
3590 n = strlenChar(azData[i]);
3592 (w-n)/2, "", azData[i], (w-n+1)/2, "",
3593 i==nColumn-1?" "BOX_13"\n":" "BOX_13" ");
3616 raw_printf(p->out, "\n");
3632 utf8_printf(p->out, "Interrupt\n");
3719 fputs("]\n", pArg->out);
3722 sqlite3_snprintf(sizeof(zBuf), zBuf, "%llu row%s\n",
3781 raw_printf(out, "-- Candidates -----------------------------\n");
3782 raw_printf(out, "%s\n", zCand);
3788 if( zIdx==0 ) zIdx = "(no new indexes)\n";
3790 raw_printf(out, "-- Query %d --------------------------------\n",i+1);
3791 raw_printf(out, "%s\n\n", zSql);
3793 raw_printf(out, "%s\n", zIdx);
3794 raw_printf(out, "%s\n", zEQP);
3821 int n; local
3823 n = strlen30(z);
3824 if( n>=2 && 0==cli_strncmp(z, "-verbose", n) ){
3827 else if( n>=2 && 0==cli_strncmp(z, "-sample", n) ){
3829 raw_printf(stderr, "option requires an argument: %s\n", z);
3834 raw_printf(stderr, "value out of range: %s\n", azArg[i]);
3840 raw_printf(stderr, "unknown option: %s\n", z);
3848 raw_printf(stderr, "sqlite3_expert_new: %s\n", zErr ? zErr : "out of memory");
4181 if( !dataOnly ) raw_printf(p->out, "DELETE FROM sqlite_sequence;\n");
4183 if( !dataOnly ) raw_printf(p->out, "ANALYZE sqlite_schema;\n");
4191 raw_printf(p->out, "PRAGMA writable_schema=ON;\n");
4199 utf8_printf(p->out, "%s\n", zIns);
4203 printSchemaLine(p->out, zSql, ";\n");
4261 raw_printf(p->out, "/****** CORRUPTION ERROR *******/\n");
4292 raw_printf(p->out, "/****** CORRUPTION ERROR *******/\n");
4294 utf8_printf(p->out, "/****** %s ******/\n", zErr);
4303 utf8_printf(p->out, "/****** ERROR: %s ******/\n", zErr);
4339 " -n, --dryrun Show the SQL that would have occurred",
4407 " --csv Use , and \\n as column and row separators",
4620 int n = 0; local
4632 utf8_printf(out, "%s\n", azHelp[i]);
4633 n++;
4642 utf8_printf(out, "%s\n", azHelp[i]);
4644 n++;
4648 if( n ){
4649 if( n==1 ){
4653 utf8_printf(out, "%s\n", azHelp[j]);
4657 return n;
4666 utf8_printf(out, "%s\n", azHelp[j]);
4669 utf8_printf(out, "%s\n", azHelp[j]);
4672 n++;
4677 return n;
4779 size_t n; local
4789 n = fread(zBuf, 16, 1, f);
4790 if( n==1 && memcmp(zBuf, "SQLite format 3", 16)==0 ){
4795 n = fread(zBuf, 25, 1, f);
4796 if( n==1 && memcmp(zBuf, "Start-Of-SQLite3-", 17)==0 ){
4800 n = fread(zBuf, 22, 1, f);
4801 if( n==1 && zBuf[0]==0x50 && zBuf[1]==0x4b && zBuf[2]==0x05
4804 }else if( n==0 && dfltZip && sqlite3_strlike("%.zip",zName,0)==0 ){
4821 int n = 0; local
4833 utf8_printf(stderr, "cannot open \"%s\" for reading\n", zDbFilename);
4845 rc = sscanf(zLine, "| size %d pagesize %d", &n, &pgsz);
4847 if( n<0 ) goto readHexDb_error;
4849 n = (n+pgsz-1)&~(pgsz-1); /* Round n up to the next multiple of pgsz */
4850 a = sqlite3_malloc( n ? n : 1 );
4852 memset(a, 0, n);
4854 utf8_printf(stderr, "invalid pagesize\n");
4871 if( k+16<=n && k>=0 ){
4877 *pnData = n;
4896 utf8_printf(stderr,"Error on line %d of --hexdb input\n", nLine);
4967 ** then this function searches the input for "\n" and "\r" characters
4970 ** replace(replace(<input>, '\n', char(10), '\r', char(13));
4993 if( zNL==0 && zText[i]=='\n' ){
4994 zNL = unused_string(zText, "\\n", "\\012", zBuf1);
5021 if( zText[i]=='\n' ){
5110 utf8_printf(stderr,"Error: unable to open database \"%s\": %s\n",
5185 utf8_printf(stderr, "Error: sqlite3_deserialize() returns %d\n", rc);
5204 utf8_printf(stderr, "Error: sqlite3_close() returns %d: %s\n",
5282 ** \n -> newline
5305 }else if( c=='n' ){
5306 c = '\n';
5354 utf8_printf(stderr, "ERROR: Not a boolean value: \"%s\". Assuming \"no\".\n",
5393 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zFile);
5415 utf8_printf(p->traceOut, "-- closing database connection\n");
5446 utf8_printf(p->traceOut, "%.*s;\n", (int)nSql, zSql);
5451 utf8_printf(p->traceOut, "%.*s; -- %lld ns\n", (int)nSql, zSql, nNanosec);
5477 int n; /* Number of bytes in z */ member
5485 int cRowSep; /* The row separator character. (Usually "\n") */
5500 if( p->n+1>=p->nAlloc ){
5505 p->z[p->n++] = (char)c;
5512 ** + Store results in p->z of length p->n. Space to hold p->z comes
5515 ** + Use p->rSep as the row separator. The default is "\n".
5525 p->n = 0;
5550 do{ p->n--; }while( p->z[p->n]!=cQuote );
5555 utf8_printf(stderr, "%s:%d: unescaped %c character\n",
5559 utf8_printf(stderr, "%s:%d: unterminated %c-quoted field\n",
5579 p->n = 0;
5590 if( p->n>0 && p->z[p->n-1]=='\r' ) p->n--;
5594 if( p->z ) p->z[p->n] = 0;
5602 ** + Store results in p->z of length p->n. Space to hold p->z comes
5615 p->n = 0;
5629 if( p->z ) p->z[p->n] = 0;
5648 int i, j, n; local
5658 utf8_printf(stderr, "Error %d: %s on [%s]\n",
5663 n = sqlite3_column_count(pQuery);
5664 zInsert = sqlite3_malloc64(200 + nTable + n*3);
5669 for(j=1; j<n; j++){
5676 utf8_printf(stderr, "Error %d: %s on [%s]\n",
5683 for(i=0; i<n; i++){
5713 utf8_printf(stderr, "Error %d: %s\n", sqlite3_extended_errcode(newDb),
5768 utf8_printf(stderr, "Error: (%d) %s on [%s]\n",
5780 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
5787 printf("done\n");
5797 utf8_printf(stderr, "Error: (%d) %s on [%s]\n",
5809 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
5816 printf("done\n");
5833 utf8_printf(stderr, "File \"%s\" already exists.\n", zNewDb);
5838 utf8_printf(stderr, "Cannot create output database: %s\n",
5878 utf8_printf(stderr, "Failed: [%s]\n", zCmd);
5964 utf8_printf(stderr, "error: %s\n", sqlite3_errmsg(p->db));
5975 raw_printf(stderr, "unable to read database header\n");
5981 utf8_printf(p->out, "%-20s %d\n", "database page size:", i);
5982 utf8_printf(p->out, "%-20s %d\n", "write format:", aHdr[18]);
5983 utf8_printf(p->out, "%-20s %d\n", "read format:", aHdr[19]);
5984 utf8_printf(p->out, "%-20s %d\n", "reserved bytes:", aHdr[20]);
5996 raw_printf(p->out, "\n");
6009 utf8_printf(p->out, "%-20s %d\n", aQuery[i].zName, val);
6013 utf8_printf(p->out, "%-20s %u\n", "data version", iDataVersion);
6023 utf8_printf(stderr, "Error: %s\n", zErr);
6331 int n = strlen30(azArg[i]); local
6332 if( n>1 && sqlite3_strnicmp("-verbose", azArg[i], n)==0 ){
6335 else if( n>1 && sqlite3_strnicmp("-groupbyparent", azArg[i], n)==0 ){
6340 raw_printf(stderr, "Usage: %s %s ?-verbose? ?-groupbyparent?\n",
6393 raw_printf(out, "-- Parent table %s\n", zParent);
6399 raw_printf(out, "%s%s --> %s\n", zIndent, zCI, zTarget);
6401 raw_printf(out, "%s/* no extra indexes required for %s -> %s */\n",
6410 raw_printf(stderr, "%s\n", sqlite3_errmsg(db));
6416 raw_printf(stderr, "%s\n", sqlite3_errmsg(db));
6419 raw_printf(stderr, "%s\n", sqlite3_errmsg(db));
6433 int n; local
6434 n = (nArg>=2 ? strlen30(azArg[1]) : 0);
6435 if( n<1 || sqlite3_strnicmp(azArg[1], "fkey-indexes", n) ) goto usage;
6439 raw_printf(stderr, "Usage %s sub-command ?switches...?\n", azArg[0]);
6440 raw_printf(stderr, "Where sub-commands are:\n");
6441 raw_printf(stderr, " fkey-indexes\n");
6456 raw_printf(stderr, "sql error: %s (%d)\n",
6509 raw_printf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
6530 raw_printf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
6580 utf8_printf(stderr, "Error: %s\n", z);
6582 utf8_printf(stderr, "Use \"-A\" for more help\n");
6584 utf8_printf(stderr, "Use \".archive --help\" for more help\n");
6677 { "dryrun", 'n', AR_SWITCH_DRYRUN, 0 },
6684 utf8_printf(stderr, "Wrong number of arguments. Usage:\n");
6717 int n; local
6725 n = strlen30(z);
6730 for(i=1; i<n; i++){
6740 if( i<(n-1) ){
6742 i = n;
6766 if( (n-2)<=strlen30(zLong) && 0==memcmp(&z[2], zLong, n-2) ){
6820 int n = strlen30(z); local
6822 while( n>0 && z[n-1]=='/' ) n--;
6823 z[n] = '\0';
6830 utf8_printf(stderr, "not found in archive: %s\n", z);
6897 utf8_printf(pAr->p->out, "%s\n", sqlite3_sql(pSql));
6901 utf8_printf(pAr->p->out, "%s % 10d %s %s\n",
6908 utf8_printf(pAr->p->out, "%s\n", sqlite3_column_text(pSql, 0));
6936 utf8_printf(pAr->p->out, "%s\n", zSql);
6949 utf8_printf(stdout, "ERROR: %s\n", zErr);
7013 utf8_printf(pAr->p->out, "%s\n", sqlite3_sql(pSql));
7017 utf8_printf(pAr->p->out, "%s\n", sqlite3_column_text(pSql, 0));
7037 utf8_printf(pAr->p->out, "%s\n", zSql);
7043 utf8_printf(stdout, "ERROR: %s\n", zErr);
7075 "CREATE TABLE IF NOT EXISTS sqlar(\n"
7076 " name TEXT PRIMARY KEY, -- name of the file\n"
7077 " mode INT, -- access permissions\n"
7078 " mtime INT, -- last modification time\n"
7079 " sz INT, -- original file size\n"
7080 " data BLOB -- compressed content\n"
7084 "REPLACE INTO %s(name,mode,mtime,sz,data)\n"
7085 " SELECT\n"
7086 " %s,\n"
7087 " mode,\n"
7088 " mtime,\n"
7089 " CASE substr(lsmode(mode),1,1)\n"
7090 " WHEN '-' THEN length(data)\n"
7091 " WHEN 'd' THEN 0\n"
7092 " ELSE -1 END,\n"
7093 " sqlar_compress(data)\n"
7094 " FROM fsdir(%Q,%Q) AS disk\n"
7097 "REPLACE INTO %s(name,mode,mtime,data)\n"
7098 " SELECT\n"
7099 " %s,\n"
7100 " mode,\n"
7101 " mtime,\n"
7102 " data\n"
7103 " FROM fsdir(%Q,%Q) AS disk\n"
7218 utf8_printf(pState->out, "-- open database '%s'%s\n", cmd.zFile,
7224 utf8_printf(stderr, "cannot open file: %s (%s)\n",
7239 utf8_printf(stderr, "database does not contain an 'sqlar' table\n");
7297 utf8_printf(pState->out, "%s;\n", zSql);
7317 int n; local
7319 n = strlen30(z);
7320 if( n<=17 && memcmp("-ignore-freelist", z, n)==0 ){
7323 if( n<=12 && memcmp("-recovery-db", z, n)==0 && i<(nArg-1) ){
7332 if( n<=15 && memcmp("-lost-and-found", z, n)==0 && i<(nArg-1) ){
7336 if( n<=10 && memcmp("-no-rowids", z, n)==0 ){
7340 utf8_printf(stderr, "unexpected option: %s\n", azArg[i]);
7359 raw_printf(stderr, "sql error: %s (%d)\n", zErr, errCode);
7384 fprintf(stderr,"E:%d\n",rc), assert(0)
7593 int n, c; local
7631 n = strlen30(azArg[0]);
7636 if( c=='a' && cli_strncmp(azArg[0], "auth", n)==0 ){
7638 raw_printf(stderr, "Usage: .auth ON|OFF\n");
7655 if( c=='a' && cli_strncmp(azArg[0], "archive", n)==0 ){
7663 if( (c=='b' && n>=3 && cli_strncmp(azArg[0], "backup", n)==0)
7664 || (c=='s' && n>=3 && cli_strncmp(azArg[0], "save", n)==0)
7685 utf8_printf(stderr, "unknown option: %s\n", azArg[j]);
7694 raw_printf(stderr, "Usage: .backup ?DB? ?OPTIONS? FILENAME\n");
7699 raw_printf(stderr, "missing FILENAME argument on .backup\n");
7706 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zDestFile);
7717 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(pDest));
7726 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(pDest));
7733 if( c=='b' && n>=3 && cli_strncmp(azArg[0], "bail", n)==0 ){
7737 raw_printf(stderr, "Usage: .bail on|off\n");
7742 if( c=='b' && n>=3 && cli_strncmp(azArg[0], "binary", n)==0 ){
7750 raw_printf(stderr, "Usage: .binary on|off\n");
7758 if( c=='b' && n>=3 && cli_strncmp(azArg[0], "breakpoint", n)==0 ){
7774 utf8_printf(stderr, "Cannot change to directory \"%s\"\n", azArg[1]);
7778 raw_printf(stderr, "Usage: .cd DIRECTORY\n");
7784 if( c=='c' && n>=3 && cli_strncmp(azArg[0], "changes", n)==0 ){
7788 raw_printf(stderr, "Usage: .changes on|off\n");
7798 if( c=='c' && n>=3 && cli_strncmp(azArg[0], "check", n)==0 ){
7802 raw_printf(stderr, "Usage: .check GLOB-PATTERN\n");
7805 raw_printf(stderr, "Error: cannot read 'testcase-out.txt'\n");
7809 "testcase-%s FAILED\n Expected: [%s]\n Got: [%s]\n",
7813 utf8_printf(stdout, "testcase-%s ok\n", p->zTestcase);
7821 if( c=='c' && cli_strncmp(azArg[0], "clone", n)==0 ){
7826 raw_printf(stderr, "Usage: .clone FILENAME\n");
7832 if( c=='c' && cli_strncmp(azArg[0], "connection", n)==0 ){
7846 utf8_printf(stdout, "ACTIVE %d: %s\n", i, zFile);
7848 utf8_printf(stdout, " %d: %s\n", i, zFile);
7865 raw_printf(stderr, "cannot close the active database connection\n");
7873 raw_printf(stderr, "Usage: .connection [close] [CONNECTION-NUMBER]\n");
7878 if( c=='d' && n>1 && cli_strncmp(azArg[0], "databases", n)==0 ){
7886 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
7905 utf8_printf(p->out, "%s: %s %s%s\n",
7917 if( c=='d' && n>=3 && cli_strncmp(azArg[0], "dbconfig", n)==0 ){
7947 utf8_printf(p->out, "%19s %s\n", aDbConfig[ii].zName, v ? "on" : "off");
7951 utf8_printf(stderr, "Error: unknown dbconfig \"%s\"\n", azArg[1]);
7952 utf8_printf(stderr, "Enter \".dbconfig\" with no arguments for a list\n");
7957 if( c=='d' && n>=3 && cli_strncmp(azArg[0], "dbinfo", n)==0 ){
7961 if( c=='r' && cli_strncmp(azArg[0], "recover", n)==0 ){
7967 if( c=='d' && cli_strncmp(azArg[0], "dump", n)==0 ){
7983 " with SQLITE_OMIT_VIRTUALTABLE\n");
8001 raw_printf(stderr, "Unknown option \"%s\" on \".dump\"\n", azArg[i]);
8035 raw_printf(p->out, "PRAGMA foreign_keys=OFF;\n");
8036 raw_printf(p->out, "BEGIN TRANSACTION;\n");
8067 raw_printf(p->out, "PRAGMA writable_schema=OFF;\n");
8073 raw_printf(p->out, p->nErr?"ROLLBACK; -- due to errors\n":"COMMIT;\n");
8079 if( c=='e' && cli_strncmp(azArg[0], "echo", n)==0 ){
8083 raw_printf(stderr, "Usage: .echo on|off\n");
8088 if( c=='e' && cli_strncmp(azArg[0], "eqp", n)==0 ){
8114 raw_printf(stderr, "Usage: .eqp off|on|trace|trigger|full\n");
8120 if( c=='e' && cli_strncmp(azArg[0], "exit", n)==0 ){
8128 if( c=='e' && cli_strncmp(azArg[0], "explain", n)==0 ){
8151 if( c=='e' && cli_strncmp(azArg[0], "expert", n)==0 ){
8154 "Cannot run experimental commands such as \"%s\" in safe mode\n",
8164 if( c=='f' && cli_strncmp(azArg[0], "filectrl", n)==0 ){
8211 utf8_printf(p->out, "Available file-controls:\n");
8213 utf8_printf(p->out, " .filectrl %s %s\n",
8229 utf8_printf(stderr, "Error: ambiguous file-control: \"%s\"\n"
8230 "Use \".filectrl --help\" for help\n", zCmd);
8237 utf8_printf(stderr,"Error: unknown file-control: %s\n"
8238 "Use \".filectrl --help\" for help\n", zCmd);
8281 utf8_printf(p->out, "%s\n", z);
8295 utf8_printf(p->out,"%d\n", x);
8302 utf8_printf(p->out, "Usage: .filectrl %s %s\n", zCmd,aCtrl[iCtrl].zUsage);
8307 raw_printf(p->out, "%s\n", zBuf);
8311 if( c=='f' && cli_strncmp(azArg[0], "fullschema", n)==0 ){
8322 raw_printf(stderr, "Usage: .fullschema ?--indent?\n");
8346 raw_printf(p->out, "/* No STAT tables available */\n");
8348 raw_printf(p->out, "ANALYZE sqlite_schema;\n");
8354 raw_printf(p->out, "ANALYZE sqlite_schema;\n");
8358 if( c=='h' && cli_strncmp(azArg[0], "headers", n)==0 ){
8363 raw_printf(stderr, "Usage: .headers on|off\n");
8368 if( c=='h' && cli_strncmp(azArg[0], "help", n)==0 ){
8370 n = showHelp(p->out, azArg[1]);
8371 if( n==0 ){
8372 utf8_printf(p->out, "Nothing matches '%s'\n", azArg[1]);
8380 if( c=='i' && cli_strncmp(azArg[0], "import", n)==0 ){
8416 utf8_printf(p->out, "ERROR: extra argument: \"%s\". Usage:\n", z);
8433 sCtx.cRowSep = '\n';
8437 utf8_printf(p->out, "ERROR: unknown option: \"%s\". Usage:\n", z);
8443 utf8_printf(p->out, "ERROR: missing %s argument. Usage:\n",
8456 "Error: non-null column separator required for import\n");
8462 " for import\n");
8468 "Error: non-null row separator required for import\n");
8483 " for import\n");
8493 raw_printf(stderr, "Error: pipes are not supported in this OS\n");
8505 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zFile);
8517 utf8_printf(p->out, "\n");
8553 "Columns renamed during .import %s due to duplicates:\n"
8554 "%s\n", sCtx.zFile, zRenames);
8559 utf8_printf(stderr,"%s: empty file\n", sCtx.zFile);
8568 zCreate = sqlite3_mprintf("%z%z\n", zCreate, zColDefs);
8570 utf8_printf(p->out, "%s\n", zCreate);
8574 utf8_printf(stderr, "%s failed:\n%s\n", zCreate, sqlite3_errmsg(p->db));
8583 utf8_printf(stderr,"Error: %s\n", sqlite3_errmsg(p->db));
8605 utf8_printf(p->out, "Insert using: %s\n", zSql);
8609 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
8635 "filling the rest with NULL\n",
8647 "extras ignored\n",
8654 utf8_printf(stderr, "%s:%d: INSERT failed: %s\n", sCtx.zFile,
8668 "Added %d rows with %d errors using %d lines of input\n",
8675 if( c=='i' && cli_strncmp(azArg[0], "imposter", n)==0 ){
8684 utf8_printf(stderr, "Usage: .imposter INDEX IMPOSTER\n"
8685 " .imposter off\n");
8744 utf8_printf(stderr, "no such index: \"%s\"\n", azArg[1]);
8759 utf8_printf(stderr, "Error in [%s]: %s\n", zSql, sqlite3_errmsg(p->db));
8761 utf8_printf(stdout, "%s;\n", zSql);
8763 "WARNING: writing to an imposter table will corrupt the \"%s\" %s!\n",
8768 raw_printf(stderr, "SQLITE_TESTCTRL_IMPOSTER returns %d\n", rc);
8776 if( c=='i' && cli_strncmp(azArg[0], "iotrace", n)==0 ){
8788 utf8_printf(stderr, "Error: cannot open \"%s\"\n", azArg[1]);
8798 if( c=='l' && n>=5 && cli_strncmp(azArg[0], "limits", n)==0 ){
8820 printf("%20s %d\n", aLimit[i].zLimitName,
8824 raw_printf(stderr, "Usage: .limit NAME ?NEW-VALUE?\n");
8835 utf8_printf(stderr, "ambiguous limit: \"%s\"\n", azArg[1]);
8842 utf8_printf(stderr, "unknown limit: \"%s\"\n"
8843 "enter \".limits\" with no arguments for a list.\n",
8852 printf("%20s %d\n", aLimit[iLimit].zLimitName,
8857 if( c=='l' && n>2 && cli_strncmp(azArg[0], "lint", n)==0 ){
8863 if( c=='l' && cli_strncmp(azArg[0], "load", n)==0 ){
8868 raw_printf(stderr, "Usage: .load FILE ?ENTRYPOINT?\n");
8877 utf8_printf(stderr, "Error: %s\n", zErrMsg);
8885 if( c=='l' && cli_strncmp(azArg[0], "log", n)==0 ){
8888 raw_printf(stderr, "Usage: .log FILENAME\n");
8898 if( c=='m' && cli_strncmp(azArg[0], "mode", n)==0 ){
8928 utf8_printf(stderr, "unknown option: %s\n", z);
8929 utf8_printf(stderr, "options:\n"
8930 " --noquote\n"
8931 " --quote\n"
8932 " --wordwrap on/off\n"
8933 " --wrap N\n"
8934 " --ww\n");
8938 utf8_printf(stderr, "extra argument: \"%s\"\n", z);
8949 "current output mode: %s --wrap %d --wordwrap %s --%squote\n",
8954 raw_printf(p->out, "current output mode: %s\n", modeDescr[p->mode]);
9015 "qbox quote table tabs tcl\n");
9022 if( c=='n' && cli_strcmp(azArg[0], "nonce")==0 ){
9024 raw_printf(stderr, "Usage: .nonce NONCE\n");
9027 raw_printf(stderr, "line %d: incorrect nonce: \"%s\"\n",
9038 if( c=='n' && cli_strncmp(azArg[0], "nullvalue", n)==0 ){
9043 raw_printf(stderr, "Usage: .nullvalue STRING\n");
9048 if( c=='o' && cli_strncmp(azArg[0], "open", n)==0 && n>=2 ){
9082 utf8_printf(stderr, "unknown option: %s\n", z);
9086 utf8_printf(stderr, "extra argument: \"%s\"\n", z);
9128 utf8_printf(stderr, "Error: cannot open '%s'\n", zNewFilename);
9143 && (cli_strncmp(azArg[0], "output", n)==0
9144 || cli_strncmp(azArg[0], "once", n)==0))
9145 || (c=='e' && n==5 && cli_strcmp(azArg[0],"excel")==0)
9159 }else if( cli_strncmp(azArg[0],"once",n)==0 ){
9176 utf8_printf(p->out, "ERROR: unknown option: \"%s\". Usage:\n",
9189 utf8_printf(p->out,"ERROR: extra parameter: \"%s\". Usage:\n",
9229 raw_printf(stderr, "Error: pipes are not supported in this OS\n");
9235 utf8_printf(stderr,"Error: cannot open pipe \"%s\"\n", zFile + 1);
9247 utf8_printf(stderr,"Error: cannot write to \"%s\"\n", zFile);
9260 if( c=='p' && n>=3 && cli_strncmp(azArg[0], "parameter", n)==0 ){
9293 utf8_printf(p->out, "%-*s %s\n", len, sqlite3_column_text(pStmt,0),
9338 utf8_printf(p->out, "Error: %s\n", sqlite3_errmsg(p->db));
9364 if( c=='p' && n>=3 && cli_strncmp(azArg[0], "print", n)==0 ){
9370 raw_printf(p->out, "\n");
9374 if( c=='p' && n>=3 && cli_strncmp(azArg[0], "progress", n)==0 ){
9399 utf8_printf(stderr, "Error: missing argument on --limit\n");
9407 utf8_printf(stderr, "Error: unknown option: \"%s\"\n", azArg[i]);
9419 if( c=='p' && cli_strncmp(azArg[0], "prompt", n)==0 ){
9429 if( c=='q' && cli_strncmp(azArg[0], "quit", n)==0 ){
9435 if( c=='r' && n>=3 && cli_strncmp(azArg[0], "read", n)==0 ){
9440 raw_printf(stderr, "Usage: .read FILE\n");
9446 raw_printf(stderr, "Error: pipes are not supported in this OS\n");
9452 utf8_printf(stderr, "Error: cannot open \"%s\"\n", azArg[1]);
9460 utf8_printf(stderr,"Error: cannot open \"%s\"\n", azArg[1]);
9472 if( c=='r' && n>=3 && cli_strncmp(azArg[0], "restore", n)==0 ){
9487 raw_printf(stderr, "Usage: .restore ?DB? FILE\n");
9493 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zSrcFile);
9500 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
9515 raw_printf(stderr, "Error: source database is busy\n");
9518 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
9525 if( c=='s' && cli_strncmp(azArg[0], "scanstats", n)==0 ){
9529 raw_printf(stderr, "Warning: .scanstats not available in this build.\n");
9532 raw_printf(stderr, "Usage: .scanstats on|off\n");
9537 if( c=='s' && cli_strncmp(azArg[0], "schema", n)==0 ){
9561 utf8_printf(stderr, "Unknown option: \"%s\"\n", azArg[ii]);
9567 raw_printf(stderr, "Usage: .schema ?--indent? ?--nosys? ?LIKE-PATTERN?\n");
9580 "CREATE TABLE %s (\n"
9581 " type text,\n"
9582 " name text,\n"
9583 " tbl_name text,\n"
9584 " rootpage integer,\n"
9585 " sql text\n"
9600 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
9662 utf8_printf(p->out, "SQL: %s;\n", sSelect.z);
9669 utf8_printf(stderr,"Error: %s\n", zErrMsg);
9673 raw_printf(stderr,"Error: querying schema information\n");
9680 if( (c=='s' && n==11 && cli_strncmp(azArg[0], "selecttrace", n)==0)
9681 || (c=='t' && n==9 && cli_strncmp(azArg[0], "treetrace", n)==0)
9688 if( c=='s' && cli_strncmp(azArg[0],"session",n)==0 && n>=3 ){
9719 raw_printf(stderr, "ERROR: No sessions are open\n");
9723 raw_printf(stderr, "ERROR: sqlite3session_attach() returns %d\n", rc);
9742 utf8_printf(stderr, "ERROR: cannot open \"%s\" for writing\n",
9753 printf("Error: error code %d\n", rc);
9758 raw_printf(stderr, "ERROR: Failed to write entire %d-byte output\n",
9786 utf8_printf(p->out, "session %s enable flag = %d\n",
9805 raw_printf(stderr, "Error: out or memory\n");
9825 utf8_printf(p->out, "session %s indirect flag = %d\n",
9838 utf8_printf(p->out, "session %s isempty flag = %d\n",
9848 utf8_printf(p->out, "%d %s\n", i, pAuxDb->aSession[i].zName);
9863 utf8_printf(stderr, "Session \"%s\" already exists\n", zName);
9868 raw_printf(stderr, "Maximum of %d sessions\n", ArraySize(pAuxDb->aSession));
9874 raw_printf(stderr, "Cannot open session: error code=%d\n", rc);
9893 if( c=='s' && n>=10 && cli_strncmp(azArg[0], "selftest-", 9)==0 ){
9894 if( cli_strncmp(azArg[0]+9, "boolean", n-9)==0 ){
9898 utf8_printf(p->out, "%s: %d 0x%x\n", azArg[i], v, v);
9901 if( cli_strncmp(azArg[0]+9, "integer", n-9)==0 ){
9906 sqlite3_snprintf(sizeof(zBuf),zBuf,"%s: %lld 0x%llx\n", azArg[i],v,v);
9913 if( c=='s' && n>=4 && cli_strncmp(azArg[0],"selftest",n)==0 ){
9934 utf8_printf(stderr, "Unknown option \"%s\" on \"%s\"\n",
9936 raw_printf(stderr, "Should be one of: --init -v\n");
9965 raw_printf(stderr, "Error querying the selftest table\n");
9981 printf("%d: %s %s\n", tno, zOp, zSql);
9984 utf8_printf(p->out, "%s\n", zSql);
9988 str.n = 0;
9993 utf8_printf(p->out, "Result: %s\n", str.z);
9998 utf8_printf(p->out, "%d: error-code-%d: %s\n", tno, rc, zErrMsg);
10003 utf8_printf(p->out, "%d: Expected: [%s]\n", tno, zAns);
10004 utf8_printf(p->out, "%d: Got: [%s]\n", tno, str.z);
10009 "Unknown operation \"%s\" on selftest line %d\n", zOp, tno);
10017 utf8_printf(p->out, "%d errors out of %d tests\n", nErr, nTest);
10020 if( c=='s' && cli_strncmp(azArg[0], "separator", n)==0 ){
10022 raw_printf(stderr, "Usage: .separator COL ?ROW?\n");
10035 if( c=='s' && n>=4 && cli_strncmp(azArg[0],"sha3sum",n)==0 ){
10065 utf8_printf(stderr, "Unknown option \"%s\" on \"%s\"\n",
10072 raw_printf(stderr, "Usage: .sha3sum ?OPTIONS? ?LIKE-PATTERN?\n");
10117 appendText(&sQuery, " ORDER BY tbl, idx, rowid;\n", 0);
10121 sQuery.n = 0;
10144 utf8_printf(p->out, "%s\n", zSql);
10153 && (cli_strncmp(azArg[0], "shell", n)==0
10154 || cli_strncmp(azArg[0],"system",n)==0)
10160 raw_printf(stderr, "Usage: .system COMMAND\n");
10171 if( x ) raw_printf(stderr, "System command returns %d\n", x);
10175 if( c=='s' && cli_strncmp(azArg[0], "show", n)==0 ){
10180 raw_printf(stderr, "Usage: .show\n");
10184 utf8_printf(p->out, "%12.12s: %s\n","echo",
10186 utf8_printf(p->out, "%12.12s: %s\n","eqp", azBool[p->autoEQP&3]);
10187 utf8_printf(p->out, "%12.12s: %s\n","explain",
10189 utf8_printf(p->out,"%12.12s: %s\n","headers", azBool[p->showHeader!=0]);
10194 (p->out, "%12.12s: %s --wrap %d --wordwrap %s --%squote\n", "mode",
10199 utf8_printf(p->out, "%12.12s: %s\n","mode", modeDescr[p->mode]);
10203 raw_printf(p->out, "\n");
10204 utf8_printf(p->out,"%12.12s: %s\n","output",
10208 raw_printf(p->out, "\n");
10211 raw_printf(p->out, "\n");
10218 utf8_printf(p->out, "%12.12s: %s\n","stats", zOut);
10223 raw_printf(p->out, "\n");
10224 utf8_printf(p->out, "%12.12s: %s\n", "filename",
10228 if( c=='s' && cli_strncmp(azArg[0], "stats", n)==0 ){
10240 raw_printf(stderr, "Usage: .stats ?on|off|stmt|vmstep?\n");
10245 if( (c=='t' && n>1 && cli_strncmp(azArg[0], "tables", n)==0)
10246 || (c=='i' && (cli_strncmp(azArg[0], "indices", n)==0
10247 || cli_strncmp(azArg[0], "indexes", n)==0) )
10266 raw_printf(stderr, "Usage: .indexes ?LIKE-PATTERN?\n");
10345 raw_printf(p->out, "\n");
10359 raw_printf(stderr, "Error: cannot open 'testcase-out.txt'\n");
10370 if( c=='t' && n>=8 && cli_strncmp(azArg[0], "testctrl", n)==0 ){
10418 utf8_printf(p->out, "Available test-controls:\n");
10420 utf8_printf(p->out, " .testctrl %s %s\n",
10436 utf8_printf(stderr, "Error: ambiguous test-control: \"%s\"\n"
10437 "Use \".testctrl --help\" for help\n", zCmd);
10444 utf8_printf(stderr,"Error: unknown test-control: %s\n"
10445 "Use \".testctrl --help\" for help\n", zCmd);
10448 "line %d: \".testctrl %s\" may not be used in safe mode\n",
10489 printf("-- random seed: %d\n", ii);
10542 utf8_printf(p->out, "%llu\n", x);
10577 if( id>1 ) utf8_printf(p->out, "\n");
10593 utf8_printf(p->out, "Usage: .testctrl %s %s\n", zCmd,aCtrl[iCtrl].zUsage);
10596 raw_printf(p->out, "%d\n", rc2);
10598 raw_printf(p->out, "0x%08x\n", rc2);
10603 if( c=='t' && n>4 && cli_strncmp(azArg[0], "timeout", n)==0 ){
10608 if( c=='t' && n>=5 && cli_strncmp(azArg[0], "timer", n)==0 ){
10612 raw_printf(stderr, "Error: timer not available on this system.\n");
10616 raw_printf(stderr, "Usage: .timer on|off\n");
10622 if( c=='t' && cli_strncmp(azArg[0], "trace", n)==0 ){
10653 raw_printf(stderr, "Unknown option \"%s\" on \".trace\"\n", z);
10672 if( c=='u' && cli_strncmp(azArg[0], "unmodule", n)==0 ){
10677 raw_printf(stderr, "Usage: .unmodule [--allexcept] NAME ...\n");
10697 if( c=='u' && cli_strncmp(azArg[0], "user", n)==0 ){
10699 raw_printf(stderr, "Usage: .user SUBCOMMAND ...\n");
10706 raw_printf(stderr, "Usage: .user login USER PASSWORD\n");
10713 utf8_printf(stderr, "Authentication failed for user %s\n", azArg[2]);
10718 raw_printf(stderr, "Usage: .user add USER PASSWORD ISADMIN\n");
10725 raw_printf(stderr, "User-Add failed: %d\n", rc);
10730 raw_printf(stderr, "Usage: .user edit USER PASSWORD ISADMIN\n");
10737 raw_printf(stderr, "User-Edit failed: %d\n", rc);
10742 raw_printf(stderr, "Usage: .user delete USER\n");
10748 raw_printf(stderr, "User-Delete failed: %d\n", rc);
10752 raw_printf(stderr, "Usage: .user login|add|edit|delete ...\n");
10759 if( c=='v' && cli_strncmp(azArg[0], "version", n)==0 ){
10760 utf8_printf(p->out, "SQLite %s %s\n" /*extra-version-info*/,
10763 utf8_printf(p->out, "zlib version %s\n", zlibVersion());
10770 CTIMEOPT_VAL(__clang_patchlevel__) "\n");
10772 utf8_printf(p->out, "msvc-" CTIMEOPT_VAL(_MSC_VER) "\n");
10774 utf8_printf(p->out, "gcc-" __VERSION__ "\n");
10778 if( c=='v' && cli_strncmp(azArg[0], "vfsinfo", n)==0 ){
10784 utf8_printf(p->out, "vfs.zName = \"%s\"\n", pVfs->zName);
10785 raw_printf(p->out, "vfs.iVersion = %d\n", pVfs->iVersion);
10786 raw_printf(p->out, "vfs.szOsFile = %d\n", pVfs->szOsFile);
10787 raw_printf(p->out, "vfs.mxPathname = %d\n", pVfs->mxPathname);
10792 if( c=='v' && cli_strncmp(azArg[0], "vfslist", n)==0 ){
10799 utf8_printf(p->out, "vfs.zName = \"%s\"%s\n", pVfs->zName,
10801 raw_printf(p->out, "vfs.iVersion = %d\n", pVfs->iVersion);
10802 raw_printf(p->out, "vfs.szOsFile = %d\n", pVfs->szOsFile);
10803 raw_printf(p->out, "vfs.mxPathname = %d\n", pVfs->mxPathname);
10805 raw_printf(p->out, "-----------------------------------\n");
10810 if( c=='v' && cli_strncmp(azArg[0], "vfsname", n)==0 ){
10816 utf8_printf(p->out, "%s\n", zVfsName);
10822 if( c=='w' && cli_strncmp(azArg[0], "wheretrace", n)==0 ){
10827 if( c=='w' && cli_strncmp(azArg[0], "width", n)==0 ){
10841 " \"%s\". Enter \".help\" for help\n", azArg[0]);
10889 if( cin=='\n')
11021 utf8_printf(stderr, "%s %s\n", zPrefix, zErrorTail);
11030 raw_printf(p->out, "%s\n", zLineBuf);
11036 if( ShellHasFlag(p, SHFLG_Echo) ) utf8_printf(p->out, "%s\n", zDo);
11059 for(; *z && '\n'!=*z; ++nZ, ++z){}
11095 " Check recursion.\n", MAX_INPUT_NESTING, p->lineno);
11105 if( p->in==0 && stdin_is_interactive ) printf("\n");
11154 zSql[nSql++] = '\n';
11230 int n; local
11234 n = strlen30(zDrive) + strlen30(zPath) + 1;
11235 home_dir = malloc( n );
11237 sqlite3_snprintf(n, home_dir, "%s%s", zDrive, zPath);
11247 i64 n = strlen(home_dir) + 1; local
11248 char *z = malloc( n );
11249 if( z ) memcpy(z, home_dir, n);
11276 " cannot read ~/.sqliterc\n");
11286 utf8_printf(stderr,"-- Loading resources from %s\n",sqliterc);
11291 utf8_printf(stderr,"cannot open: \"%s\"\n", sqliterc);
11304 " -A ARGS... run \".archive ARGS\" and exit\n"
11306 " -append append the database to the end of the file\n"
11307 " -ascii set output mode to 'ascii'\n"
11308 " -bail stop after hitting an error\n"
11309 " -batch force batch I/O\n"
11310 " -box set output mode to 'box'\n"
11311 " -column set output mode to 'column'\n"
11312 " -cmd COMMAND run \"COMMAND\" before reading stdin\n"
11313 " -csv set output mode to 'csv'\n"
11315 " -deserialize open the database using sqlite3_deserialize()\n"
11317 " -echo print inputs before execution\n"
11318 " -init FILENAME read/process named file\n"
11319 " -[no]header turn headers on or off\n"
11321 " -heap SIZE Size of heap for memsys3 or memsys5\n"
11323 " -help show this message\n"
11324 " -html set output mode to HTML\n"
11325 " -interactive force interactive I/O\n"
11326 " -json set output mode to 'json'\n"
11327 " -line set output mode to 'line'\n"
11328 " -list set output mode to 'list'\n"
11329 " -lookaside SIZE N use N entries of SZ bytes for lookaside memory\n"
11330 " -markdown set output mode to 'markdown'\n"
11332 " -maxsize N maximum size for a --deserialize database\n"
11334 " -memtrace trace all memory allocations and deallocations\n"
11335 " -mmap N default mmap size set to N\n"
11337 " -multiplex enable the multiplexor VFS\n"
11339 " -newline SEP set output row separator. Default: '\\n'\n"
11340 " -nofollow refuse to open symbolic links to database files\n"
11341 " -nonce STRING set the safe-mode escape nonce\n"
11342 " -nullvalue TEXT set text string for NULL values. Default ''\n"
11343 " -pagecache SIZE N use N slots of SZ bytes each for page cache memory\n"
11344 " -quote set output mode to 'quote'\n"
11345 " -readonly open the database read-only\n"
11346 " -safe enable safe-mode\n"
11347 " -separator SEP set output column separator. Default: '|'\n"
11349 " -sorterref SIZE sorter references threshold size\n"
11351 " -stats print memory stats before each finalize\n"
11352 " -table set output mode to 'table'\n"
11353 " -tabs set output mode to 'tabs'\n"
11354 " -version show SQLite version\n"
11355 " -vfs NAME use NAME as the default VFS\n"
11357 " -vfstrace enable tracing of all VFS calls\n"
11360 " -zip open the file as a ZIP Archive\n"
11365 "Usage: %s [OPTIONS] FILENAME [SQL]\n"
11366 "FILENAME is the name of an SQLite database. A new database is created\n"
11367 "if the file does not previously exist.\n", Argv0);
11369 utf8_printf(stderr, "OPTIONS include:\n%s", zOptions);
11371 raw_printf(stderr, "Use the -help option for additional information\n");
11383 " initialization.\n");
11437 utf8_printf(stderr, "%s: Error: missing argument to %s\n",
11500 "attach debugger to process %d and press any key to continue.\n",
11519 utf8_printf(stderr, "SQLite header and source version mismatch\n%s\n%s\n",
11540 i64 n; local
11542 n = strlen(z);
11543 argv[i] = malloc( n+1 );
11545 memcpy(argv[i], z, n+1);
11626 sqlite3_int64 n, sz; local
11630 n = integerValue(cmdline_option_value(argc,argv,++i));
11631 if( sz>0 && n>0 && 0xffffffffffffLL/sz<n ){
11632 n = 0xffffffffffffLL/sz;
11635 (n>0 && sz>0) ? malloc(n*sz) : 0, sz, n);
11638 int n, sz; local
11641 n = (int)integerValue(cmdline_option_value(argc,argv,++i));
11642 if( n<0 ) n = 0;
11643 sqlite3_config(SQLITE_CONFIG_LOOKASIDE, sz, n);
11644 if( sz*n==0 ) data.shellFlgs &= ~SHFLG_Lookaside;
11646 int n; local
11647 n = (int)integerValue(cmdline_option_value(argc,argv,++i));
11648 switch( n ){
11735 utf8_printf(stderr, "no such VFS: \"%s\"\n", argv[i]);
11745 utf8_printf(stderr,"%s: Error: no database filename specified\n", Argv0);
11862 printf("%s %s\n", sqlite3_libversion(), sqlite3_sourceid());
11912 utf8_printf(stderr,"Error: %s\n", zErrMsg);
11915 utf8_printf(stderr,"Error: unable to process SQL \"%s\"\n", z);
11923 " with \"%s\"\n", z);
11939 utf8_printf(stderr,"%s: Error: unknown option: %s\n", Argv0, z);
11940 raw_printf(stderr,"Use -help for a list of options.\n");
11963 utf8_printf(stderr,"Error: %s\n", zErrMsg);
11965 utf8_printf(stderr,"Error: unable to process SQL: %s\n", azCmd[i]);
11981 "SQLite version %s %.19s\n" /*extra-version-info*/
11982 "Enter \".help\" for usage hints.\n",
11989 "persistent database.\n");
12049 utf8_printf(stderr, "Memory leaked: %u bytes\n",
12087 printf("fiddle_db_arg(%p)\n", (const void*)arg);
12126 ** chunk of size n (its 2nd argument) on each call and must return 0
12133 int fiddle_export_db( int (*xCallback)(unsigned const char *zOut, int n) ){ argument