Lines Matching refs:s
499 ** includes string formatting (e.g. "%s").
539 utf8_printf(iotrace, "%s", z);
547 ** in bytes. This is different from the %*.*s specification in printf
548 ** since with %*.*s the width is measured in bytes, not characters.
565 utf8_printf(pOut, "%.*s", i, zUtf);
567 utf8_printf(pOut, "%*s%s", aw-n, "", zUtf);
569 utf8_printf(pOut, "%s%*s", zUtf, aw-n, "");
734 printf("%s", zPrompt);
897 ShellText s; local
907 initText(&s);
911 appendText(&s, zSchema, cQuote);
912 appendText(&s, ".", 0);
915 appendText(&s, zName, cQuote);
919 appendText(&s, zDiv, 0);
923 appendText(&s, zCol, cQuote);
925 appendText(&s, ")", 0);
928 freeText(&s);
929 s.z = 0;
931 return s.z;
951 sqlite3_result_text(pCtx, sqlite3_mprintf("/* %s */", zFake),
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);
1318 ** It's not too expensive, so a generous allowance can be made.
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);
1452 zCmd = sqlite3_mprintf("%s \"%s\"", zEditor, zTempFile);
1549 raw_printf(out,"X'%s'", zStr);
1569 sqlite3_snprintf(20,zBuf,"(%s%u)", zA, i++);
1585 utf8_printf(out,"'%s'",z);
1592 utf8_printf(out, "%.*s", i, z);
1624 utf8_printf(out,"'%s'",z);
1648 utf8_printf(out, "%.*s", i, z);
1660 raw_printf(out, "%s", zNL);
1663 raw_printf(out, "%s", zCR);
1667 raw_printf(out, ",'%s',char(13))", zCR);
1670 raw_printf(out, ",'%s',char(10))", zNL);
1757 utf8_printf(out,"%.*s",i,z);
1808 utf8_printf(out,"%s",p->nullValue);
1820 utf8_printf(out, "%s", zQuoted);
1823 utf8_printf(out, "%s", z);
1827 utf8_printf(p->out, "%s", p->colSeparator);
1885 ** there's no harm in using ATTACH. */
1894 failIfSafeMode(p, "cannot use the %s() function in safe mode",
1936 utf8_printf(p->out, "authorizer: %s", azAction[op]);
1970 char *zNew = sqlite3_mprintf("%s%s;", zOrig, azTerm[i]);
1982 utf8_printf(out, "CREATE TABLE IF NOT EXISTS %s%s", z+13, zTail);
1984 utf8_printf(out, "%s%s", z, zTail);
2019 utf8_printf(p->out, "%d,%d,%s\n", iEqpId, p2, zText);
2067 utf8_printf(p->out, "%s%s%s\n", p->sGraph.zPrefix,
2088 utf8_printf(p->out, "%s\n", pRow->zText+3);
2130 raw_printf(out, "%.*s", N, zDash);
2181 if( p->cnt++>0 ) utf8_printf(p->out, "%s", p->rowSeparator);
2183 utf8_printf(p->out,"%*s = %s%s", w, azCol[i],
2214 utf8_printf(p->out, "%*.s", p->aiIndent[p->iIndent], "");
2239 utf8_printf(p->out, "%s;\n", azArg[0]);
2242 z = sqlite3_mprintf("%s", azArg[0]);
2296 utf8_printf(p->out,"%s%s",azCol[i],
2304 utf8_printf(p->out, "%s", z);
2306 utf8_printf(p->out, "%s", p->colSeparator);
2308 utf8_printf(p->out, "%s", p->rowSeparator);
2337 if(i<nArg-1) utf8_printf(p->out, "%s", p->colSeparator);
2339 utf8_printf(p->out, "%s", p->rowSeparator);
2344 if(i<nArg-1) utf8_printf(p->out, "%s", p->colSeparator);
2346 utf8_printf(p->out, "%s", p->rowSeparator);
2355 utf8_printf(p->out, "%s", p->rowSeparator);
2361 utf8_printf(p->out, "%s", p->rowSeparator);
2368 utf8_printf(p->out,"INSERT INTO %s",p->zDestTable);
2376 utf8_printf(p->out, "%s", z);
2379 raw_printf(p->out, "%s", azCol[i]);
2396 utf8_printf(p->out,"%s", azArg[i]);
2413 raw_printf(p->out, "%s", z);
2420 utf8_printf(p->out,"%s", azArg[i]);
2454 raw_printf(p->out, "%s", z);
2463 utf8_printf(p->out,"%s", azArg[i]);
2489 utf8_printf(p->out,"%s", azArg[i]);
2494 raw_printf(p->out, "%s", z);
2500 utf8_printf(p->out,"%s", azArg[i]);
2511 if( i>0 ) utf8_printf(p->out, "%s", p->colSeparator);
2512 utf8_printf(p->out,"%s",azCol[i] ? azCol[i] : "");
2514 utf8_printf(p->out, "%s", p->rowSeparator);
2518 if( i>0 ) utf8_printf(p->out, "%s", p->colSeparator);
2519 utf8_printf(p->out,"%s",azArg[i] ? azArg[i] : p->nullValue);
2521 utf8_printf(p->out, "%s", p->rowSeparator);
2600 utf8_printf(stderr, "SELFTEST initialization failure: %s\n", zErrMsg);
2668 zCode = sqlite3_mprintf("%.*s", len, zSql);
2672 zMsg = sqlite3_mprintf("\n %z\n %*s^--- error here", zCode, iOffset, "");
2702 utf8_printf(p->out, "/**** ERROR: (%d) %s *****/\n%s", rc,
2712 utf8_printf(p->out, "%s", z);
2714 utf8_printf(p->out, ",%s", sqlite3_column_text(pSelect, i));
2727 utf8_printf(p->out, "/**** ERROR: (%d) %s *****/\n", rc,
2746 sqlite3_str_appendf(pStr, "%s, %s", zPhase, sqlite3_errmsg(db));
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));
3004 utf8_printf(pArg->out, "Loop %2d: %s\n", n, zExplain);
3261 utf8_printf(out, "%.*s", N, zDash);
3276 utf8_printf(p->out, "%s", zSep1);
3279 utf8_printf(p->out, "%s", zSep2);
3282 utf8_printf(p->out, "%s", zSep3);
3395 return sqlite3_mprintf("%s",sqlite3_column_text(pStmt,i));
3564 utf8_printf(p->out, "%*s%s%*s", (w-n)/2, "", azData[i], (w-n+1)/2, "");
3577 utf8_printf(p->out, "%*s%s%*s", (w-n)/2, "", azData[i], (w-n+1)/2, "");
3591 utf8_printf(p->out, "%*s%s%*s%s",
3601 utf8_printf(p->out, "%s", p->cMode==MODE_Box?BOX_13" ":"| ");
3609 utf8_printf(p->out, "%s", rowSep);
3622 utf8_printf(p->out, "%s", colSep);
3722 sqlite3_snprintf(sizeof(zBuf), zBuf, "%llu row%s\n",
3723 nRow, nRow!=1 ? "s" : "");
3724 printf("%s", zBuf);
3782 raw_printf(out, "%s\n", zCand);
3791 raw_printf(out, "%s\n\n", zSql);
3793 raw_printf(out, "%s\n", zIdx);
3794 raw_printf(out, "%s\n", zEQP);
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");
3867 ** This is very similar to SQLite's built-in sqlite3_exec()
3927 zEQP = sqlite3_mprintf("EXPLAIN QUERY PLAN %s", zStmtSql);
3945 zEQP = sqlite3_mprintf("EXPLAIN %s", zStmtSql);
4069 azCol[++nCol] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 1));
4199 utf8_printf(p->out, "%s\n", zIns);
4294 utf8_printf(p->out, "/****** %s ******/\n", zErr);
4300 sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
4303 utf8_printf(p->out, "/****** ERROR: %s ******/\n", zErr);
4632 utf8_printf(out, "%s\n", azHelp[i]);
4638 zPat = sqlite3_mprintf(".%s*", zPattern);
4642 utf8_printf(out, "%s\n", azHelp[i]);
4653 utf8_printf(out, "%s\n", azHelp[j]);
4661 zPat = sqlite3_mprintf("%%%s%%", zPattern);
4666 utf8_printf(out, "%s\n", azHelp[j]);
4669 utf8_printf(out, "%s\n", azHelp[j]);
4833 utf8_printf(stderr, "cannot open \"%s\" for reading\n", zDbFilename);
5110 utf8_printf(stderr,"Error: unable to open database \"%s\": %s\n",
5204 utf8_printf(stderr, "Error: sqlite3_close() returns %d: %s\n",
5286 ** \s -> space
5354 utf8_printf(stderr, "ERROR: Not a boolean value: \"%s\". Assuming \"no\".\n",
5393 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zFile);
5446 utf8_printf(p->traceOut, "%.*s;\n", (int)nSql, zSql);
5451 utf8_printf(p->traceOut, "%.*s; -- %lld ns\n", (int)nSql, zSql, nNanosec);
5555 utf8_printf(stderr, "%s:%d: unescaped %c character\n",
5559 utf8_printf(stderr, "%s:%d: unterminated %c-quoted field\n",
5658 utf8_printf(stderr, "Error %d: %s on [%s]\n",
5667 "INSERT OR IGNORE INTO \"%s\" VALUES(?", zTable);
5676 utf8_printf(stderr, "Error %d: %s on [%s]\n",
5713 utf8_printf(stderr, "Error %d: %s\n", sqlite3_extended_errcode(newDb),
5731 utf8_printf(stderr, "Warning: cannot step \"%s\" backwards", zTable);
5764 " WHERE %s", zWhere);
5768 utf8_printf(stderr, "Error: (%d) %s on [%s]\n",
5777 printf("%s... ", zName); fflush(stdout);
5780 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
5793 " WHERE %s ORDER BY rowid DESC", zWhere);
5797 utf8_printf(stderr, "Error: (%d) %s on [%s]\n",
5806 printf("%s... ", zName); fflush(stdout);
5809 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
5833 utf8_printf(stderr, "File \"%s\" already exists.\n", zNewDb);
5838 utf8_printf(stderr, "Cannot create output database: %s\n",
5876 zCmd = sqlite3_mprintf("%s %s", zXdgOpenCmd, p->zTempFile);
5878 utf8_printf(stderr, "Failed: [%s]\n", zCmd);
5942 "SELECT count(*) FROM %s WHERE type='table'" },
5944 "SELECT count(*) FROM %s WHERE type='index'" },
5946 "SELECT count(*) FROM %s WHERE type='trigger'" },
5948 "SELECT count(*) FROM %s WHERE type='view'" },
5950 "SELECT total(length(sql)) FROM %s" },
5964 utf8_printf(stderr, "error: %s\n", sqlite3_errmsg(p->db));
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]);
5988 utf8_printf(p->out, "%-20s %u", aField[i].zName, val);
6001 zSchemaTab = sqlite3_mprintf("%s", "sqlite_temp_schema");
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);
6188 p->zTempFile = sqlite3_mprintf("%s/temp%llx.%s", zTemp, r, zSuffix);
6190 p->zTempFile = sqlite3_mprintf("%z.%s", p->zTempFile, zSuffix);
6242 char *z = sqlite3_mprintf(" COLLATE %s", zParentSeq);
6303 " 'EXPLAIN QUERY PLAN SELECT 1 FROM ' || quote(s.name) || ' WHERE '"
6304 " || group_concat(quote(s.name) || '.' || quote(f.[from]) || '=?' "
6306 " f.[table], COALESCE(f.[to], p.[name]), s.name, f.[from]),' AND ')"
6308 " 'SEARCH ' || s.name || ' USING COVERING INDEX*('"
6311 " s.name || '(' || group_concat(f.[from], ', ') || ')'"
6315 " 'CREATE INDEX ' || quote(s.name ||'_'|| group_concat(f.[from], '_'))"
6316 " || ' ON ' || quote(s.name) || '('"
6319 " f.[table], COALESCE(f.[to], p.[name]), s.name, f.[from]), ', ')"
6323 "FROM sqlite_schema AS s, pragma_foreign_key_list(s.name) AS f "
6325 "GROUP BY s.name, f.id "
6326 "ORDER BY (CASE WHEN ? THEN f.[table] ELSE s.name END)"
6340 raw_printf(stderr, "Usage: %s %s ?-verbose? ?-groupbyparent?\n",
6393 raw_printf(out, "-- Parent table %s\n", zParent);
6395 zPrev = sqlite3_mprintf("%s", 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));
6439 raw_printf(stderr, "Usage %s sub-command ?switches...?\n", azArg[0]);
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);
6768 return arErrorMsg(pAr, "ambiguous option: %s",z);
6776 return arErrorMsg(pAr, "unrecognized option: %s", z);
6780 return arErrorMsg(pAr, "option requires an argument: %s", z);
6813 ? "SELECT name FROM %s WHERE glob($name,name)"
6814 : "SELECT name FROM %s WHERE name=$name";
6830 utf8_printf(stderr, "not found in archive: %s\n", z);
6863 "%z%s name %s '%q' OR substr(name,1,%d) %s '%q/'",
6881 const char *zSql = "SELECT %s FROM %s WHERE %s";
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));
6933 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;",
6936 utf8_printf(pAr->p->out, "%s\n", zSql);
6949 utf8_printf(stdout, "ERROR: %s\n", zErr);
6966 " writefile(($dir || name), %s, mode, mtime) "
6967 "FROM %s WHERE (%s) AND (data IS NULL OR $dirOnly = 0)"
6989 zDir = sqlite3_mprintf("%s/", pAr->zDir);
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);
7084 "REPLACE INTO %s(name,mode,mtime,sz,data)\n"
7086 " %s,\n"
7095 " WHERE lsmode(mode) NOT LIKE '?%%'%s;"
7097 "REPLACE INTO %s(name,mode,mtime,data)\n"
7099 " %s,\n"
7104 " WHERE lsmode(mode) NOT LIKE '?%%'%s;"
7125 "CREATE VIRTUAL TABLE temp.%s USING zipfile(%Q)",
7145 "SELECT 1 FROM %s AS mem"
7166 zSql = sqlite3_mprintf("DROP TABLE %s", zTemp);
7218 utf8_printf(pState->out, "-- open database '%s'%s\n", cmd.zFile,
7224 utf8_printf(stderr, "cannot open file: %s (%s)\n",
7297 utf8_printf(pState->out, "%s;\n", zSql);
7340 utf8_printf(stderr, "unexpected option: %s\n", azArg[i]);
7359 raw_printf(stderr, "sql error: %s (%d)\n", zErr, errCode);
7463 "WITH Lzn(nlz) AS (" /* Find minimum extraneous leading 0's for uniqueness */
7472 " printf('%s"AUTOCOLUMN_SEP"%s',"
7478 " printf('%s"AUTOCOLUMN_SEP"%s',"
7489 " printf('"AUTOCOLUMN_SEP"%s', substring("
7503 SELECT cpos, printf('\"%w\"',printf('%!.*s%s', nlen-chop,name,suff)) AS cname \
7508 " printf('\"%w\" to \"%w\"',name,printf('%!.*s%s', nlen-chop, name, suff)),"
7562 zColsSpec = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0));
7572 *pzRenamed = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0));
7664 || (c=='s' && n>=3 && cli_strncmp(azArg[0], "save", n)==0)
7673 failIfSafeMode(p, "cannot run .%s in safe mode", azArg[0]);
7685 utf8_printf(stderr, "unknown option: %s\n", azArg[j]);
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));
7774 utf8_printf(stderr, "Cannot change to directory \"%s\"\n", azArg[1]);
7809 "testcase-%s FAILED\n Expected: [%s]\n Got: [%s]\n",
7813 utf8_printf(stdout, "testcase-%s ok\n", p->zTestcase);
7846 utf8_printf(stdout, "ACTIVE %d: %s\n", i, zFile);
7848 utf8_printf(stdout, " %d: %s\n", i, zFile);
7886 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
7905 utf8_printf(p->out, "%s: %s %s%s\n",
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]);
8001 raw_printf(stderr, "Unknown option \"%s\" on \".dump\"\n", azArg[i]);
8048 "WHERE (%s) AND type=='table'"
8058 "WHERE (%s) AND sql NOT NULL"
8154 "Cannot run experimental commands such as \"%s\" in safe mode\n",
8213 utf8_printf(p->out, " .filectrl %s %s\n",
8229 utf8_printf(stderr, "Error: ambiguous file-control: \"%s\"\n"
8237 utf8_printf(stderr,"Error: unknown file-control: %s\n"
8281 utf8_printf(p->out, "%s\n", z);
8302 utf8_printf(p->out, "Usage: .filectrl %s %s\n", zCmd,aCtrl[iCtrl].zUsage);
8307 raw_printf(p->out, "%s\n", zBuf);
8372 utf8_printf(p->out, "Nothing matches '%s'\n", azArg[1]);
8416 utf8_printf(p->out, "ERROR: extra argument: \"%s\". Usage:\n", z);
8437 utf8_printf(p->out, "ERROR: unknown option: \"%s\". Usage:\n", z);
8443 utf8_printf(p->out, "ERROR: missing %s argument. Usage:\n",
8505 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zFile);
8533 zSql = sqlite3_mprintf("SELECT * FROM %s", zFullTabName);
8545 zCreate = sqlite3_mprintf("CREATE TABLE %s", zFullTabName);
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);
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));
8596 sqlite3_snprintf(nByte+20, zSql, "INSERT INTO %s VALUES(?", zFullTabName);
8605 utf8_printf(p->out, "Insert using: %s\n", zSql);
8609 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
8634 utf8_printf(stderr, "%s:%d: expected %d columns but found %d - "
8646 utf8_printf(stderr, "%s:%d: expected %d columns but found %d - "
8654 utf8_printf(stderr, "%s:%d: INSERT failed: %s\n", sCtx.zFile,
8744 utf8_printf(stderr, "no such index: \"%s\"\n", azArg[1]);
8751 "CREATE TABLE \"%w\"(%s,PRIMARY KEY(%.*s))WITHOUT ROWID",
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",
8788 utf8_printf(stderr, "Error: cannot open \"%s\"\n", azArg[1]);
8820 printf("%20s %d\n", aLimit[i].zLimitName,
8835 utf8_printf(stderr, "ambiguous limit: \"%s\"\n", azArg[1]);
8842 utf8_printf(stderr, "unknown limit: \"%s\"\n"
8852 printf("%20s %d\n", aLimit[iLimit].zLimitName,
8877 utf8_printf(stderr, "Error: %s\n", zErrMsg);
8928 utf8_printf(stderr, "unknown option: %s\n", z);
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]);
9027 raw_printf(stderr, "line %d: incorrect nonce: \"%s\"\n",
9041 "%.*s", (int)ArraySize(p->nullValue)-1, azArg[1]);
9082 utf8_printf(stderr, "unknown option: %s\n", z);
9086 utf8_printf(stderr, "extra argument: \"%s\"\n", z);
9120 zNewFilename = sqlite3_mprintf("%s", zFN);
9128 utf8_printf(stderr, "Error: cannot open '%s'\n", zNewFilename);
9155 failIfSafeMode(p, "cannot run .%s in safe mode", azArg[0]);
9176 utf8_printf(p->out, "ERROR: unknown option: \"%s\". Usage:\n",
9183 zFile = sqlite3_mprintf("%s", z);
9185 while( i+1<nArg ) zFile = sqlite3_mprintf("%z %s", zFile, azArg[++i]);
9189 utf8_printf(p->out,"ERROR: extra parameter: \"%s\". Usage:\n",
9223 zFile = sqlite3_mprintf("%s", p->zTempFile);
9235 utf8_printf(stderr,"Error: cannot open pipe \"%s\"\n", zFile + 1);
9240 sqlite3_snprintf(sizeof(p->outfile), p->outfile, "%s", zFile);
9247 utf8_printf(stderr,"Error: cannot write to \"%s\"\n", zFile);
9253 sqlite3_snprintf(sizeof(p->outfile), p->outfile, "%s", zFile);
9293 utf8_printf(p->out, "%-*s %s\n", len, sqlite3_column_text(pStmt,0),
9323 "VALUES(%Q,%s);", zKey, zValue);
9338 utf8_printf(p->out, "Error: %s\n", sqlite3_errmsg(p->db));
9368 utf8_printf(p->out, "%s", azArg[i]);
9407 utf8_printf(stderr, "Error: unknown option: \"%s\"\n", azArg[i]);
9452 utf8_printf(stderr, "Error: cannot open \"%s\"\n", azArg[1]);
9460 utf8_printf(stderr,"Error: cannot open \"%s\"\n", azArg[1]);
9493 utf8_printf(stderr, "Error: cannot open \"%s\"\n", zSrcFile);
9500 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
9518 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
9525 if( c=='s' && cli_strncmp(azArg[0], "scanstats", n)==0 ){
9537 if( c=='s' && cli_strncmp(azArg[0], "schema", n)==0 ){
9561 utf8_printf(stderr, "Unknown option: \"%s\"\n", azArg[ii]);
9580 "CREATE TABLE %s (\n"
9600 utf8_printf(stderr, "Error: %s\n", sqlite3_errmsg(p->db));
9644 appendText(&sSelect, "lower(printf('%s.%s',sname,tbl_name))", 0);
9662 utf8_printf(p->out, "SQL: %s;\n", sSelect.z);
9669 utf8_printf(stderr,"Error: %s\n", zErrMsg);
9680 if( (c=='s' && n==11 && cli_strncmp(azArg[0], "selecttrace", n)==0)
9688 if( c=='s' && cli_strncmp(azArg[0],"session",n)==0 && n>=3 ){
9737 failIfSafeMode(p, "cannot run \".session %s\" in safe mode", azCmd[0]);
9742 utf8_printf(stderr, "ERROR: cannot open \"%s\" for writing\n",
9786 utf8_printf(p->out, "session %s enable flag = %d\n",
9809 char *x = pSession->azFilter[ii-1] = sqlite3_mprintf("%s", azCmd[ii]);
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);
9881 pSession->zName = sqlite3_mprintf("%s", zName);
9893 if( c=='s' && n>=10 && cli_strncmp(azArg[0], "selftest-", 9)==0 ){
9898 utf8_printf(p->out, "%s: %d 0x%x\n", azArg[i], v, v);
9906 sqlite3_snprintf(sizeof(zBuf),zBuf,"%s: %lld 0x%llx\n", azArg[i],v,v);
9907 utf8_printf(p->out, "%s", zBuf);
9913 if( c=='s' && n>=4 && cli_strncmp(azArg[0],"selftest",n)==0 ){
9934 utf8_printf(stderr, "Unknown option \"%s\" on \"%s\"\n",
9981 printf("%d: %s %s\n", tno, zOp, zSql);
9984 utf8_printf(p->out, "%s\n", zSql);
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);
10020 if( c=='s' && cli_strncmp(azArg[0], "separator", n)==0 ){
10027 "%.*s", (int)ArraySize(p->colSeparator)-1, azArg[1]);
10031 "%.*s", (int)ArraySize(p->rowSeparator)-1, azArg[2]);
10035 if( c=='s' && n>=4 && cli_strncmp(azArg[0],"sha3sum",n)==0 ){
10065 utf8_printf(stderr, "Unknown option \"%s\" on \"%s\"\n",
10129 "%s))"
10135 "%s))"
10144 utf8_printf(p->out, "%s\n", zSql);
10152 if( c=='s'
10158 failIfSafeMode(p, "cannot run .%s in safe mode", azArg[0]);
10164 zCmd = sqlite3_mprintf(strchr(azArg[1],' ')==0?"%s":"\"%s\"", azArg[1]);
10166 zCmd = sqlite3_mprintf(strchr(azArg[i],' ')==0?"%z %s":"%z \"%s\"",
10175 if( c=='s' && cli_strncmp(azArg[0], "show", n)==0 ){
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]);
10201 utf8_printf(p->out, "%12.12s: ", "nullvalue");
10204 utf8_printf(p->out,"%12.12s: %s\n","output",
10206 utf8_printf(p->out,"%12.12s: ", "colseparator");
10209 utf8_printf(p->out,"%12.12s: ", "rowseparator");
10218 utf8_printf(p->out, "%12.12s: %s\n","stats", zOut);
10219 utf8_printf(p->out, "%12.12s: ", "width");
10224 utf8_printf(p->out, "%12.12s: %s\n", "filename",
10228 if( c=='s' && cli_strncmp(azArg[0], "stats", n)==0 ){
10253 ShellText s; local
10254 initText(&s);
10274 if( s.z && s.z[0] ) appendText(&s, " UNION ALL ", 0);
10276 appendText(&s, "SELECT name FROM ", 0);
10278 appendText(&s, "SELECT ", 0);
10279 appendText(&s, zDbName, '\'');
10280 appendText(&s, "||'.'||name FROM ", 0);
10282 appendText(&s, zDbName, '"');
10283 appendText(&s, ".sqlite_schema ", 0);
10285 appendText(&s," WHERE type IN ('table','view')"
10289 appendText(&s," WHERE type='index'"
10295 appendText(&s, " ORDER BY 1", 0);
10296 rc = sqlite3_prepare_v2(p->db, s.z, -1, &pStmt, 0);
10298 freeText(&s);
10319 azResult[nRow] = sqlite3_mprintf("%s", sqlite3_column_text(pStmt, 0));
10342 utf8_printf(p->out, "%s%-*s", zSp, maxlen,
10362 sqlite3_snprintf(sizeof(p->zTestcase), p->zTestcase, "%s", azArg[1]);
10420 utf8_printf(p->out, " .testctrl %s %s\n",
10436 utf8_printf(stderr, "Error: ambiguous test-control: \"%s\"\n"
10444 utf8_printf(stderr,"Error: unknown test-control: %s\n"
10448 "line %d: \".testctrl %s\" may not be used in safe mode\n",
10593 utf8_printf(p->out, "Usage: .testctrl %s %s\n", zCmd,aCtrl[iCtrl].zUsage);
10653 raw_printf(stderr, "Unknown option \"%s\" on \".trace\"\n", z);
10713 utf8_printf(stderr, "Authentication failed for user %s\n", azArg[2]);
10760 utf8_printf(p->out, "SQLite %s %s\n" /*extra-version-info*/,
10763 utf8_printf(p->out, "zlib version %s\n", zlibVersion());
10784 utf8_printf(p->out, "vfs.zName = \"%s\"\n", pVfs->zName);
10799 utf8_printf(p->out, "vfs.zName = \"%s\"%s\n", pVfs->zName,
10816 utf8_printf(p->out, "%s\n", zVfsName);
10841 " \"%s\". Enter \".help\" for help\n", azArg[0]);
10871 ** Scan line for classification to guide shell's handling.
11017 "%s near line %d:", zErrorType, startline);
11019 sqlite3_snprintf(sizeof(zPrefix), zPrefix, "%s:", zErrorType);
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);
11138 /* No single-line dispositions remain; accumulate line(s). */
11188 ** Return a pathname which is the user's home directory. A
11237 sqlite3_snprintf(n, home_dir, "%s%s", zDrive, zPath);
11279 zBuf = sqlite3_mprintf("%s/.sqliterc",home_dir);
11286 utf8_printf(stderr,"-- Loading resources from %s\n",sqliterc);
11291 utf8_printf(stderr,"cannot open: \"%s\"\n", sqliterc);
11365 "Usage: %s [OPTIONS] FILENAME [SQL]\n"
11369 utf8_printf(stderr, "OPTIONS include:\n%s", zOptions);
11420 printf("%s", zText);
11427 printf("\033[1m%s\033[0m", zText);
11437 utf8_printf(stderr, "%s: Error: missing argument to %s\n",
11519 utf8_printf(stderr, "SQLite header and source version mismatch\n%s\n%s\n",
11735 utf8_printf(stderr, "no such VFS: \"%s\"\n", argv[i]);
11745 utf8_printf(stderr,"%s: Error: no database filename specified\n", Argv0);
11829 "%s",cmdline_option_value(argc,argv,++i));
11832 "%s",cmdline_option_value(argc,argv,++i));
11835 "%s",cmdline_option_value(argc,argv,++i));
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);
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*/
11997 sqlite3_snprintf(nHistory, zHistory,"%s/.sqlite_history", zHome);
12072 ** Returns a pointer to the given DB name's VFS. If zDbName is 0 then
12124 ** Uses the current database's VFS xRead to stream the db file's