Lines Matching defs:zSql
914 char *zSql;
920 zSql = sqlite3_mprintf("PRAGMA \"%w\".table_info=%Q;",
922 shell_check_oom(zSql);
923 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
924 sqlite3_free(zSql);
2114 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
2134 if( zSql==0 ) return;
2136 while( zSql[0] ){
2137 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql);
2140 zSql, sqlite3_errmsg(db));
5884 char *zSql = 0;
5889 zSql = sqlite3_mprintf(
5892 zSql, zSep, zDb
5894 if( zSql==0 ) return SQLITE_NOMEM;
5898 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0);
5899 sqlite3_free(zSql);
5908 char *zSql = 0;
5913 zSql = sqlite3_mprintf(
5918 zSql, zSep, zDb, zDb
5920 if( zSql==0 ) return SQLITE_NOMEM;
5924 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0);
5925 sqlite3_free(zSql);
9251 ** Buffer zSql must contain zero or more complete SQL statements. This
9271 const char *zSql, /* SQL statement(s) to add */
9477 char *zSql; /* SQL statement */
9685 const char *zSql /* SQL statement to compile */
9687 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0);
9707 char *zSql;
9709 zSql = sqlite3_vmprintf(zFmt, ap);
9710 if( zSql==0 ){
9713 rc = idxPrepareStmt(db, ppStmt, pzErrmsg, zSql);
9714 sqlite3_free(zSql);
10559 "EXPLAIN QUERY PLAN %s", pStmt->zSql
10582 const char *zSql;
10587 zSql = idxHashSearch(&p->hIdx, zIdx, nIdx);
10588 if( zSql ){
10589 idxHashAdd(&rc, &hIdx, zSql, 0);
10660 const char *zSql =
10669 rc = idxPrintfPrepareStmt(p->db, &pSelect, pzErr, zSql, zTab, zTab);
10773 const char *zSql = (const char*)sqlite3_column_text(pSchema, 2);
10777 if( zSql ) rc = sqlite3_exec(p->dbv, zSql, 0, 0, pzErrmsg);
11059 char *zSql;
11064 zSql = sqlite3_mprintf(
11067 if( zSql==0 ) return SQLITE_NOMEM;
11068 rc = sqlite3_exec(p->dbv, zSql, 0, 0, 0);
11069 sqlite3_free(zSql);
11214 const char *zSql = (const char*)sqlite3_column_text(pSql, 0);
11215 if( zSql ) rc = sqlite3_exec(pNew->dbm, zSql, 0, 0, pzErrmsg);
11268 const char *zSql, /* SQL statement to add */
11274 const char *zStmt = zSql;
11288 pNew->zSql = (char*)&pNew[1];
11289 memcpy(pNew->zSql, z, n+1);
11373 if( pStmt ) zRet = pStmt->zSql;
12133 char *zSql = 0;
12139 zSql = sqlite3_mprintf("SELECT %.*s(0)", nFunc, zSchema);
12141 zSql = sqlite3_mprintf("PRAGMA %Q.page_count", zSchema);
12143 if( zSql==0 ) return SQLITE_NOMEM;
12145 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0);
12146 sqlite3_free(zSql);
12206 char *zSql = sqlite3_mprintf("SELECT %.*s(?2)", nFunc, zSchema);
12207 if( zSql==0 ){
12210 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0);
12211 sqlite3_free(zSql);
13051 ** Otherwise, it attempts to prepare the SQL statement in zSql against
13059 const char *zSql
13063 if( sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) ){
13139 ** Otherwise, execute SQL script zSql. If successful, return SQLITE_OK.
13143 static int recoverExec(sqlite3_recover *p, sqlite3 *db, const char *zSql){
13145 int rc = sqlite3_exec(db, zSql, 0, 0, 0);
13483 ** zSql as the parameter.
13488 static void recoverSqlCallback(sqlite3_recover *p, const char *zSql){
13490 int res = p->xSql(p->pSqlCtx, zSql);
13622 char *zSql = recoverMPrintf(p, "ATTACH %Q AS recovery;", p->zStateDb);
13623 recoverExec(p, p->dbOut, zSql);
13629 sqlite3_free(zSql);
13785 const char *zSql = (const char*)sqlite3_column_text(pSelect, 4);
13790 zSql = (const char*)(zFree = recoverMPrintf(p,
13792 zName, zName, zSql
13795 rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0);
13797 recoverSqlCallback(p, zSql);
13844 const char *zSql = (const char*)sqlite3_column_text(pSelect, 1);
13845 int rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0);
13847 recoverSqlCallback(p, zSql);
13901 char *zSql = 0;
13911 zSql = recoverMPrintf(p, "INSERT OR IGNORE INTO %Q(", pTab->zTab);
13915 zSql = recoverMPrintf(p, "%z_rowid_", zSql);
13931 zSql = recoverMPrintf(p, "%z%s%Q", zSql, zSep, pTab->aCol[ii].zCol);
13947 zSql, zBind
13950 zFinal = recoverMPrintf(p, "%s) VALUES (%s)", zSql, zBind);
13954 sqlite3_free(zSql);
14020 char *zSql = 0;
14028 zSql = recoverMPrintf(p, "CREATE TABLE %s(%s)", zTbl, zField);
14031 recoverExec(p, p->dbOut, zSql);
14032 recoverSqlCallback(p, zSql);
14033 sqlite3_free(zSql);
17050 static char *shell_error_context(const char *zSql, sqlite3 *db){
17057 || zSql==0
17064 zSql++;
17065 while( (zSql[0]&0xc0)==0x80 ){ zSql++; iOffset--; }
17067 len = strlen(zSql);
17070 while( (zSql[len]&0xc0)==0x80 ) len--;
17072 zCode = sqlite3_mprintf("%.*s", len, zSql);
17074 for(i=0; zCode[i]; i++){ if( IsSpace(zSql[i]) ) zCode[i] = ' '; }
17145 const char *zSql /* SQL string, or NULL */
17154 zContext = shell_error_context(zSql, db);
17456 const char *zSql; /* The text of the SQL statement */
17474 zSql = sqlite3_sql(pSql);
17475 if( zSql==0 ) return;
17476 for(z=zSql; *z==' ' || *z=='\t' || *z=='\n' || *z=='\f' || *z=='\r'; z++);
18147 const char *zSql,
18152 return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr);
18189 const char *zSql = sqlite3_expert_report(p, i, EXPERT_REPORT_SQL);
18195 raw_printf(out, "%s\n\n", zSql);
18277 const char *zSql, /* SQL to be evaluated */
18292 rc = expertHandleSQL(pArg, zSql, pzErrMsg);
18297 while( zSql[0] && (SQLITE_OK == rc) ){
18299 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
18302 *pzErrMsg = save_err_msg(db, "in prepare", rc, zSql);
18307 zSql = zLeftover;
18308 while( IsSpace(zSql[0]) ) zSql++;
18365 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
18405 ** copy of the error message. Otherwise, set zSql to point to the
18410 zSql = zLeftover;
18411 while( IsSpace(zSql[0]) ) zSql++;
18454 char *zSql;
18462 zSql = sqlite3_mprintf("PRAGMA table_info=%Q", zTab);
18463 shell_check_oom(zSql);
18464 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
18465 sqlite3_free(zSql);
18506 zSql = sqlite3_mprintf("SELECT 1 FROM pragma_index_list(%Q)"
18508 shell_check_oom(zSql);
18509 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
18510 sqlite3_free(zSql);
18569 const char *zSql;
18578 zSql = azArg[2];
18592 }else if( cli_strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
18601 zTable, zTable, zSql);
18607 printSchemaLine(p->out, zSql, ";\n");
19565 char *zSql = sqlite3_mprintf(
19567 shell_check_oom(zSql);
19568 sqlite3_exec(p->db, zSql, 0, 0, 0);
19569 sqlite3_free(zSql);
19621 char *zSql;
19623 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase"
19625 shell_check_oom(zSql);
19626 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0);
19627 sqlite3_free(zSql);
19652 char *zSql;
19661 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase"
19664 shell_check_oom(zSql);
19665 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0);
19666 sqlite3_free(zSql);
19815 const char *zSql;
19823 zSql = (const char*)pX;
19828 zSql = sqlite3_expanded_sql(pStmt);
19833 zSql = sqlite3_normalized_sql(pStmt);
19838 zSql = sqlite3_sql(pStmt);
19843 if( zSql==0 ) return 0;
19844 nSql = strlen(zSql);
19846 while( nSql>0 && zSql[nSql-1]==';' ){ nSql--; }
19850 utf8_printf(p->traceOut, "%.*s;\n", (int)nSql, zSql);
19855 utf8_printf(p->traceOut, "%.*s; -- %lld ns\n", (int)nSql, zSql, nNanosec);
20164 const unsigned char *zSql;
20179 zSql = sqlite3_column_text(pQuery, 1);
20180 if( zName==0 || zSql==0 ) continue;
20182 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
20184 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
20208 zSql = sqlite3_column_text(pQuery, 1);
20209 if( zName==0 || zSql==0 ) continue;
20211 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
20213 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
20302 static int db_int(sqlite3 *db, const char *zSql){
20305 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
20344 static const struct { const char *zName; const char *zSql; } aQuery[] = {
20410 char *zSql = sqlite3_mprintf(aQuery[i].zSql, zSchemaTab);
20411 int val = db_int(p->db, zSql);
20412 sqlite3_free(zSql);
20705 const char *zSql =
20758 rc = sqlite3_prepare_v2(db, zSql, -1, &pSql, 0);
20853 const char *zSql,
20858 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0);
21285 const char *zSql = "SELECT %s FROM %s WHERE %s";
21298 shellPreparePrintf(pAr->db, &rc, &pSql, zSql, azCols[pAr->bVerbose],
21327 char *zSql = 0;
21337 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;",
21340 utf8_printf(pAr->p->out, "%s\n", zSql);
21345 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr);
21359 sqlite3_free(zSql);
21436 ** Run the SQL statement in zSql. Or if doing a --dryrun, merely print it out.
21438 static int arExecSql(ArCommand *pAr, const char *zSql){
21441 utf8_printf(pAr->p->out, "%s\n", zSql);
21445 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr);
21513 char *zSql;
21528 zSql = sqlite3_mprintf(
21532 rc = arExecSql(pAr, zSql);
21533 sqlite3_free(zSql);
21570 zSql = sqlite3_mprintf("DROP TABLE %s", zTemp);
21571 arExecSql(pAr, zSql);
21572 sqlite3_free(zSql);
21699 static int recoverSqlCb(void *pCtx, const char *zSql){
21701 utf8_printf(pState->out, "%s;\n", zSql);
22373 char *zSql;
22450 zSql = sqlite3_mprintf(
22457 run_schema_dump_query(p,zSql);
22458 sqlite3_free(zSql);
22460 zSql = sqlite3_mprintf(
22466 run_table_dump_query(p, zSql);
22467 sqlite3_free(zSql);
22794 char *zSql; /* An SQL statement */
22937 zSql = sqlite3_mprintf("SELECT * FROM %s", zFullTabName);
22938 if( zSql==0 || zFullTabName==0 ){
22942 nByte = strlen30(zSql);
22943 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
22966 sqlite3_free(zSql);
22983 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
22990 sqlite3_free(zSql);
22995 zSql = sqlite3_malloc64( nByte*2 + 20 + nCol*2 );
22996 if( zSql==0 ){
23000 sqlite3_snprintf(nByte+20, zSql, "INSERT INTO %s VALUES(?", zFullTabName);
23001 j = strlen30(zSql);
23003 zSql[j++] = ',';
23004 zSql[j++] = '?';
23006 zSql[j++] = ')';
23007 zSql[j] = 0;
23009 utf8_printf(p->out, "Insert using: %s\n", zSql);
23011 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
23017 sqlite3_free(zSql);
23080 char *zSql;
23105 zSql = sqlite3_mprintf(
23114 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
23115 sqlite3_free(zSql);
23121 zSql = sqlite3_mprintf("PRAGMA index_xinfo='%q'", azArg[1]);
23122 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
23123 sqlite3_free(zSql);
23154 zSql = sqlite3_mprintf(
23160 rc = sqlite3_exec(p->db, zSql, 0, 0, 0);
23163 utf8_printf(stderr, "Error in [%s]: %s\n", zSql, sqlite3_errmsg(p->db));
23165 utf8_printf(stdout, "%s;\n", zSql);
23175 sqlite3_free(zSql);
23720 char *zSql;
23725 zSql = sqlite3_mprintf(
23728 shell_check_oom(zSql);
23730 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
23731 sqlite3_free(zSql);
23735 zSql = sqlite3_mprintf(
23738 shell_check_oom(zSql);
23739 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
23740 sqlite3_free(zSql);
23757 char *zSql = sqlite3_mprintf(
23759 shell_check_oom(zSql);
23760 sqlite3_exec(p->db, zSql, 0, 0, 0);
23761 sqlite3_free(zSql);
24377 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2);
24381 if( zSql==0 ) continue;
24385 printf("%d: %s %s\n", tno, zOp, zSql);
24388 utf8_printf(p->out, "%s\n", zSql);
24394 rc = sqlite3_exec(p->db, zSql, captureOutputCallback, &str, &zErrMsg);
24447 char *zSql; /* SQL to be run */
24486 zSql = "SELECT lower(name) FROM sqlite_schema"
24491 zSql = "SELECT lower(name) FROM sqlite_schema"
24496 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
24532 zSql = sqlite3_mprintf(
24538 zSql = sqlite3_mprintf(
24544 shell_check_oom(zSql);
24548 utf8_printf(p->out, "%s\n", zSql);
24550 shell_exec(p, zSql, 0);
24552 sqlite3_free(zSql);
25376 ** Return true if zSql is a complete SQL statement. Return false if it
25379 static int line_is_complete(char *zSql, int nSql){
25381 if( zSql==0 ) return 1;
25382 zSql[nSql] = ';';
25383 zSql[nSql+1] = 0;
25384 rc = sqlite3_complete(zSql);
25385 zSql[nSql] = 0;
25392 static int runOneSqlLine(ShellState *p, char *zSql, FILE *in, int startline){
25397 if( ShellHasFlag(p,SHFLG_Backslash) ) resolve_backslashes(zSql);
25400 rc = shell_exec(p, zSql, &zErrMsg);
25487 char *zSql = 0; /* Accumulated SQL text */
25489 i64 nSql = 0; /* Bytes of zSql[] used */
25490 i64 nAlloc = 0; /* Allocated zSql[] space */
25519 && line_is_complete(zSql, nSql) ){
25547 zSql = realloc(zSql, nAlloc);
25548 shell_check_oom(zSql);
25553 assert( nAlloc>0 && zSql!=0 );
25554 memcpy(zSql, zLine+i, nLine+1-i);
25558 zSql[nSql++] = '\n';
25559 memcpy(zSql+nSql, zLine, nLine+1);
25562 if( nSql && QSS_SEMITERM(qss) && sqlite3_complete(zSql) ){
25563 echo_group_input(p, zSql);
25564 errCnt += runOneSqlLine(p, zSql, p->in, startline);
25575 echo_group_input(p, zSql);
25582 echo_group_input(p, zSql);
25583 errCnt += runOneSqlLine(p, zSql, p->in, startline);
25585 free(zSql);
26570 ** Trivial exportable function for emscripten. It processes zSql as if
26575 void fiddle_exec(const char * zSql){
26576 if(zSql && *zSql){
26577 if('.'==*zSql) puts(zSql);
26578 shellState.wasm.zInput = zSql;
26579 shellState.wasm.zPos = zSql;