Lines Matching refs:zSql
1984 char *zSql; in shellFakeSchema() local
1990 zSql = sqlite3_mprintf("PRAGMA \"%w\".table_info=%Q;", in shellFakeSchema()
1992 shell_check_oom(zSql); in shellFakeSchema()
1993 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in shellFakeSchema()
1994 sqlite3_free(zSql); in shellFakeSchema()
3407 const char *zSql = (const char*)sqlite3_value_text(argv[0]); in sha3QueryFunc() local
3427 if( zSql==0 ) return; in sha3QueryFunc()
3429 while( zSql[0] ){ in sha3QueryFunc()
3430 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql); in sha3QueryFunc()
3433 zSql, sqlite3_errmsg(db)); in sha3QueryFunc()
8338 char *zSql = 0; in completionNext() local
8343 zSql = sqlite3_mprintf( in completionNext()
8346 zSql, zSep, zDb in completionNext()
8348 if( zSql==0 ) return SQLITE_NOMEM; in completionNext()
8352 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
8353 sqlite3_free(zSql); in completionNext()
8362 char *zSql = 0; in completionNext() local
8367 zSql = sqlite3_mprintf( in completionNext()
8372 zSql, zSep, zDb, zDb in completionNext()
8374 if( zSql==0 ) return SQLITE_NOMEM; in completionNext()
8378 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
8379 sqlite3_free(zSql); in completionNext()
11751 const char *zSql, /* SQL statement(s) to add */
11957 char *zSql; /* SQL statement */ member
12165 const char *zSql /* SQL statement to compile */ in idxPrepareStmt() argument
12167 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0); in idxPrepareStmt()
12187 char *zSql; in idxPrintfPrepareStmt() local
12189 zSql = sqlite3_vmprintf(zFmt, ap); in idxPrintfPrepareStmt()
12190 if( zSql==0 ){ in idxPrintfPrepareStmt()
12193 rc = idxPrepareStmt(db, ppStmt, pzErrmsg, zSql); in idxPrintfPrepareStmt()
12194 sqlite3_free(zSql); in idxPrintfPrepareStmt()
13040 "EXPLAIN QUERY PLAN %s", pStmt->zSql in idxFindIndexes()
13063 const char *zSql; in idxFindIndexes() local
13068 zSql = idxHashSearch(&p->hIdx, zIdx, nIdx); in idxFindIndexes()
13069 if( zSql ){ in idxFindIndexes()
13070 idxHashAdd(&rc, &hIdx, zSql, 0); in idxFindIndexes()
13141 const char *zSql = in idxProcessOneTrigger() local
13150 rc = idxPrintfPrepareStmt(p->db, &pSelect, pzErr, zSql, zTab, zTab); in idxProcessOneTrigger()
13254 const char *zSql = (const char*)sqlite3_column_text(pSchema, 2); in idxCreateVtabSchema() local
13258 if( zSql ) rc = sqlite3_exec(p->dbv, zSql, 0, 0, pzErrmsg); in idxCreateVtabSchema()
13540 char *zSql; in idxBuildSampleTable() local
13545 zSql = sqlite3_mprintf( in idxBuildSampleTable()
13548 if( zSql==0 ) return SQLITE_NOMEM; in idxBuildSampleTable()
13549 rc = sqlite3_exec(p->dbv, zSql, 0, 0, 0); in idxBuildSampleTable()
13550 sqlite3_free(zSql); in idxBuildSampleTable()
13791 const char *zSql = (const char*)sqlite3_column_text(pSql, 0); in sqlite3_expert_new() local
13792 if( zSql ) rc = sqlite3_exec(pNew->dbm, zSql, 0, 0, pzErrmsg); in sqlite3_expert_new()
13845 const char *zSql, /* SQL statement to add */ in sqlite3_expert_sql() argument
13851 const char *zStmt = zSql; in sqlite3_expert_sql()
13869 pNew->zSql = (char*)&pNew[1]; in sqlite3_expert_sql()
13870 memcpy(pNew->zSql, z, n+1); in sqlite3_expert_sql()
13954 if( pStmt ) zRet = pStmt->zSql; in sqlite3_expert_report()
14981 char *zSql = 0; in dbdataDbsize() local
14987 zSql = sqlite3_mprintf("SELECT %.*s(0)", nFunc, zSchema); in dbdataDbsize()
14989 zSql = sqlite3_mprintf("PRAGMA %Q.page_count", zSchema); in dbdataDbsize()
14991 if( zSql==0 ) return SQLITE_NOMEM; in dbdataDbsize()
14993 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0); in dbdataDbsize()
14994 sqlite3_free(zSql); in dbdataDbsize()
15055 char *zSql = sqlite3_mprintf("SELECT %.*s(?2)", nFunc, zSchema); in dbdataFilter() local
15056 if( zSql==0 ){ in dbdataFilter()
15059 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0); in dbdataFilter()
15060 sqlite3_free(zSql); in dbdataFilter()
15656 const char *zSql in recoverPrepare() argument
15660 if( sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) ){ in recoverPrepare()
15740 static int recoverExec(sqlite3_recover *p, sqlite3 *db, const char *zSql){ in recoverExec() argument
15742 int rc = sqlite3_exec(db, zSql, 0, 0, 0); in recoverExec()
16086 static void recoverSqlCallback(sqlite3_recover *p, const char *zSql){ in recoverSqlCallback() argument
16088 int res = p->xSql(p->pSqlCtx, zSql); in recoverSqlCallback()
16222 char *zSql = recoverMPrintf(p, "ATTACH %Q AS recovery;", p->zStateDb); in recoverOpenRecovery() local
16223 recoverExec(p, p->dbOut, zSql); in recoverOpenRecovery()
16229 sqlite3_free(zSql); in recoverOpenRecovery()
16385 const char *zSql = (const char*)sqlite3_column_text(pSelect, 4); in recoverWriteSchema1() local
16390 zSql = (const char*)(zFree = recoverMPrintf(p, in recoverWriteSchema1()
16392 zName, zName, zSql in recoverWriteSchema1()
16395 rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0); in recoverWriteSchema1()
16397 recoverSqlCallback(p, zSql); in recoverWriteSchema1()
16444 const char *zSql = (const char*)sqlite3_column_text(pSelect, 1); in recoverWriteSchema2() local
16445 int rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0); in recoverWriteSchema2()
16447 recoverSqlCallback(p, zSql); in recoverWriteSchema2()
16501 char *zSql = 0; in recoverInsertStmt() local
16511 zSql = recoverMPrintf(p, "INSERT OR IGNORE INTO %Q(", pTab->zTab); in recoverInsertStmt()
16515 zSql = recoverMPrintf(p, "%z_rowid_", zSql); in recoverInsertStmt()
16531 zSql = recoverMPrintf(p, "%z%s%Q", zSql, zSep, pTab->aCol[ii].zCol); in recoverInsertStmt()
16547 zSql, zBind in recoverInsertStmt()
16550 zFinal = recoverMPrintf(p, "%s) VALUES (%s)", zSql, zBind); in recoverInsertStmt()
16554 sqlite3_free(zSql); in recoverInsertStmt()
16620 char *zSql = 0; in recoverLostAndFoundCreate() local
16628 zSql = recoverMPrintf(p, "CREATE TABLE %s(%s)", zTbl, zField); in recoverLostAndFoundCreate()
16631 recoverExec(p, p->dbOut, zSql); in recoverLostAndFoundCreate()
16632 recoverSqlCallback(p, zSql); in recoverLostAndFoundCreate()
16633 sqlite3_free(zSql); in recoverLostAndFoundCreate()
19736 static char *shell_error_context(const char *zSql, sqlite3 *db){ in shell_error_context() argument
19743 || zSql==0 in shell_error_context()
19745 || iOffset>=(int)strlen(zSql) in shell_error_context()
19751 zSql++; in shell_error_context()
19752 while( (zSql[0]&0xc0)==0x80 ){ zSql++; iOffset--; } in shell_error_context()
19754 len = strlen(zSql); in shell_error_context()
19757 while( len>0 && (zSql[len]&0xc0)==0x80 ) len--; in shell_error_context()
19759 zCode = sqlite3_mprintf("%.*s", len, zSql); in shell_error_context()
19761 for(i=0; zCode[i]; i++){ if( IsSpace(zSql[i]) ) zCode[i] = ' '; } in shell_error_context()
19831 const char *zSql /* SQL string, or NULL */ in save_err_msg() argument
19840 zContext = shell_error_context(zSql, db); in save_err_msg()
20275 const char *zSql = in display_scanstats()
20282 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in display_scanstats()
20914 const char *zSql, in expertHandleSQL() argument
20919 return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr); in expertHandleSQL()
20955 const char *zSql = sqlite3_expert_report(p, i, EXPERT_REPORT_SQL); in expertFinish() local
20961 oputf("%s\n\n", zSql); in expertFinish()
21043 const char *zSql, /* SQL to be evaluated */ in shell_exec() argument
21058 rc = expertHandleSQL(pArg, zSql, pzErrMsg); in shell_exec()
21063 while( zSql[0] && (SQLITE_OK == rc) ){ in shell_exec()
21065 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover); in shell_exec()
21068 *pzErrMsg = save_err_msg(db, "in prepare", rc, zSql); in shell_exec()
21073 zSql = zLeftover; in shell_exec()
21074 while( IsSpace(zSql[0]) ) zSql++; in shell_exec()
21170 zSql = zLeftover; in shell_exec()
21171 while( IsSpace(zSql[0]) ) zSql++; in shell_exec()
21214 char *zSql; in tableColumnList() local
21222 zSql = sqlite3_mprintf("PRAGMA table_info=%Q", zTab); in tableColumnList()
21223 shell_check_oom(zSql); in tableColumnList()
21224 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
21225 sqlite3_free(zSql); in tableColumnList()
21266 zSql = sqlite3_mprintf("SELECT 1 FROM pragma_index_list(%Q)" in tableColumnList()
21268 shell_check_oom(zSql); in tableColumnList()
21269 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
21270 sqlite3_free(zSql); in tableColumnList()
21329 const char *zSql; in dump_callback() local
21338 zSql = azArg[2]; in dump_callback()
21352 }else if( cli_strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){ in dump_callback()
21361 zTable, zTable, zSql); in dump_callback()
21367 printSchemaLine(zSql, ";\n"); in dump_callback()
22276 char *zSql = sqlite3_mprintf( in open_db() local
22278 shell_check_oom(zSql); in open_db()
22279 sqlite3_exec(p->db, zSql, 0, 0, 0); in open_db()
22280 sqlite3_free(zSql); in open_db()
22336 char *zSql; in readline_completion_generator() local
22338 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase" in readline_completion_generator()
22340 shell_check_oom(zSql); in readline_completion_generator()
22341 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in readline_completion_generator()
22342 sqlite3_free(zSql); in readline_completion_generator()
22369 char *zSql; in linenoise_completion() local
22378 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase" in linenoise_completion()
22381 shell_check_oom(zSql); in linenoise_completion()
22382 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in linenoise_completion()
22383 sqlite3_free(zSql); in linenoise_completion()
22541 const char *zSql; in sql_trace_callback() local
22549 zSql = (const char*)pX; in sql_trace_callback()
22554 zSql = sqlite3_expanded_sql(pStmt); in sql_trace_callback()
22559 zSql = sqlite3_normalized_sql(pStmt); in sql_trace_callback()
22564 zSql = sqlite3_sql(pStmt); in sql_trace_callback()
22569 if( zSql==0 ) return 0; in sql_trace_callback()
22570 nSql = strlen(zSql); in sql_trace_callback()
22572 while( nSql>0 && zSql[nSql-1]==';' ){ nSql--; } in sql_trace_callback()
22576 sputf(p->traceOut, "%.*s;\n", (int)nSql, zSql); in sql_trace_callback()
22581 sputf(p->traceOut, "%.*s; -- %lld ns\n", (int)nSql, zSql, nNanosec); in sql_trace_callback()
22890 const unsigned char *zSql; in tryToCloneSchema() local
22904 zSql = sqlite3_column_text(pQuery, 1); in tryToCloneSchema()
22905 if( zName==0 || zSql==0 ) continue; in tryToCloneSchema()
22908 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg); in tryToCloneSchema()
22910 eputf("Error: %s\nSQL: [%s]\n", zErrMsg, zSql); in tryToCloneSchema()
22934 zSql = sqlite3_column_text(pQuery, 1); in tryToCloneSchema()
22935 if( zName==0 || zSql==0 ) continue; in tryToCloneSchema()
22938 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg); in tryToCloneSchema()
22940 eputf("Error: %s\nSQL: [%s]\n", zErrMsg, zSql); in tryToCloneSchema()
23045 static int db_int(sqlite3 *db, const char *zSql){ in db_int() argument
23048 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in db_int()
23087 static const struct { const char *zName; const char *zSql; } aQuery[] = { in shell_dbinfo_command() member
23155 char *zSql = sqlite3_mprintf(aQuery[i].zSql, zSchemaTab); in shell_dbinfo_command() local
23156 int val = db_int(p->db, zSql); in shell_dbinfo_command()
23157 sqlite3_free(zSql); in shell_dbinfo_command()
23449 const char *zSql = in lintFkeyIndexes() local
23500 rc = sqlite3_prepare_v2(db, zSql, -1, &pSql, 0); in lintFkeyIndexes()
23594 const char *zSql, in shellPrepare() argument
23599 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0); in shellPrepare()
24021 const char *zSql = "SELECT %s FROM %s WHERE %s"; in arListCommand() local
24034 shellPreparePrintf(pAr->db, &rc, &pSql, zSql, azCols[pAr->bVerbose], in arListCommand()
24059 char *zSql = 0; in arRemoveCommand() local
24069 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;", in arRemoveCommand()
24072 oputf("%s\n", zSql); in arRemoveCommand()
24077 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr); in arRemoveCommand()
24091 sqlite3_free(zSql); in arRemoveCommand()
24170 static int arExecSql(ArCommand *pAr, const char *zSql){ in arExecSql() argument
24173 oputf("%s\n", zSql); in arExecSql()
24177 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr); in arExecSql()
24245 char *zSql; in arCreateOrUpdateCommand() local
24260 zSql = sqlite3_mprintf( in arCreateOrUpdateCommand()
24264 rc = arExecSql(pAr, zSql); in arCreateOrUpdateCommand()
24265 sqlite3_free(zSql); in arCreateOrUpdateCommand()
24302 zSql = sqlite3_mprintf("DROP TABLE %s", zTemp); in arCreateOrUpdateCommand()
24303 arExecSql(pAr, zSql); in arCreateOrUpdateCommand()
24304 sqlite3_free(zSql); in arCreateOrUpdateCommand()
24429 static int recoverSqlCb(void *pCtx, const char *zSql){ in recoverSqlCb() argument
24431 sputf(pState->out, "%s;\n", zSql); in recoverSqlCb()
25143 char *zSql; in do_meta_command() local
25221 zSql = sqlite3_mprintf( in do_meta_command()
25228 run_schema_dump_query(p,zSql); in do_meta_command()
25229 sqlite3_free(zSql); in do_meta_command()
25231 zSql = sqlite3_mprintf( in do_meta_command()
25237 run_table_dump_query(p, zSql); in do_meta_command()
25238 sqlite3_free(zSql); in do_meta_command()
25565 char *zSql; /* An SQL statement */ in do_meta_command() local
25705 zSql = sqlite3_mprintf("SELECT * FROM %s", zFullTabName); in do_meta_command()
25706 if( zSql==0 || zFullTabName==0 ){ in do_meta_command()
25710 nByte = strlen30(zSql); in do_meta_command()
25711 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25734 sqlite3_free(zSql); in do_meta_command()
25751 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25758 sqlite3_free(zSql); in do_meta_command()
25763 zSql = sqlite3_malloc64( nByte*2 + 20 + nCol*2 ); in do_meta_command()
25764 if( zSql==0 ){ in do_meta_command()
25768 sqlite3_snprintf(nByte+20, zSql, "INSERT INTO %s VALUES(?", zFullTabName); in do_meta_command()
25769 j = strlen30(zSql); in do_meta_command()
25771 zSql[j++] = ','; in do_meta_command()
25772 zSql[j++] = '?'; in do_meta_command()
25774 zSql[j++] = ')'; in do_meta_command()
25775 zSql[j] = 0; in do_meta_command()
25777 oputf("Insert using: %s\n", zSql); in do_meta_command()
25779 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25785 sqlite3_free(zSql); in do_meta_command()
25854 char *zSql; in do_meta_command() local
25885 zSql = sqlite3_mprintf( in do_meta_command()
25894 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25895 sqlite3_free(zSql); in do_meta_command()
25901 zSql = sqlite3_mprintf("PRAGMA index_xinfo='%q'", azArg[1]); in do_meta_command()
25902 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25903 sqlite3_free(zSql); in do_meta_command()
25934 zSql = sqlite3_mprintf( in do_meta_command()
25940 rc = sqlite3_exec(p->db, zSql, 0, 0, 0); in do_meta_command()
25943 eputf("Error in [%s]: %s\n", zSql, sqlite3_errmsg(p->db)); in do_meta_command()
25945 sputf(stdout, "%s;\n", zSql); in do_meta_command()
25953 sqlite3_free(zSql); in do_meta_command()
26498 char *zSql; in do_meta_command() local
26503 zSql = sqlite3_mprintf( in do_meta_command()
26506 shell_check_oom(zSql); in do_meta_command()
26508 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
26509 sqlite3_free(zSql); in do_meta_command()
26513 zSql = sqlite3_mprintf( in do_meta_command()
26516 shell_check_oom(zSql); in do_meta_command()
26517 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
26518 sqlite3_free(zSql); in do_meta_command()
26535 char *zSql = sqlite3_mprintf( in do_meta_command() local
26537 shell_check_oom(zSql); in do_meta_command()
26538 sqlite3_exec(p->db, zSql, 0, 0, 0); in do_meta_command()
26539 sqlite3_free(zSql); in do_meta_command()
27162 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2); in do_meta_command() local
27166 if( zSql==0 ) continue; in do_meta_command()
27170 sputf(stdout, "%d: %s %s\n", tno, zOp, zSql); in do_meta_command()
27173 oputf("%s\n", zSql); in do_meta_command()
27179 rc = sqlite3_exec(p->db, zSql, captureOutputCallback, &str, &zErrMsg); in do_meta_command()
27231 char *zSql; /* SQL to be run */ in do_meta_command() local
27269 zSql = "SELECT lower(name) as tname FROM sqlite_schema" in do_meta_command()
27274 zSql = "SELECT lower(name) as tname FROM sqlite_schema" in do_meta_command()
27279 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
27315 zSql = sqlite3_mprintf( in do_meta_command()
27321 zSql = sqlite3_mprintf( in do_meta_command()
27327 shell_check_oom(zSql); in do_meta_command()
27331 oputf("%s\n", zSql); in do_meta_command()
27333 shell_exec(p, zSql, 0); in do_meta_command()
27395 sqlite3_free(zSql); in do_meta_command()
28259 static int line_is_complete(char *zSql, int nSql){ in line_is_complete() argument
28261 if( zSql==0 ) return 1; in line_is_complete()
28262 zSql[nSql] = ';'; in line_is_complete()
28263 zSql[nSql+1] = 0; in line_is_complete()
28264 rc = sqlite3_complete(zSql); in line_is_complete()
28265 zSql[nSql] = 0; in line_is_complete()
28287 static int doAutoDetectRestore(ShellState *p, const char *zSql){ in doAutoDetectRestore() argument
28295 if( p->bSafeMode==0 && memcmp(zSql, zExpect, 25)==0 ){ in doAutoDetectRestore()
28307 if( memcmp(zSql, zExpect, 19)==0 ){ in doAutoDetectRestore()
28354 static int runOneSqlLine(ShellState *p, char *zSql, FILE *in, int startline){ in runOneSqlLine() argument
28359 if( ShellHasFlag(p,SHFLG_Backslash) ) resolve_backslashes(zSql); in runOneSqlLine()
28362 rc = shell_exec(p, zSql, &zErrMsg); in runOneSqlLine()
28399 if( doAutoDetectRestore(p, zSql) ) return 1; in runOneSqlLine()
28451 char *zSql = 0; /* Accumulated SQL text */ in process_input() local
28484 && line_is_complete(zSql, nSql) ){ in process_input()
28513 zSql = realloc(zSql, nAlloc); in process_input()
28514 shell_check_oom(zSql); in process_input()
28519 assert( nAlloc>0 && zSql!=0 ); in process_input()
28520 memcpy(zSql, zLine+i, nLine+1-i); in process_input()
28524 zSql[nSql++] = '\n'; in process_input()
28525 memcpy(zSql+nSql, zLine, nLine+1); in process_input()
28528 if( nSql && QSS_SEMITERM(qss) && sqlite3_complete(zSql) ){ in process_input()
28529 echo_group_input(p, zSql); in process_input()
28530 errCnt += runOneSqlLine(p, zSql, p->in, startline); in process_input()
28542 echo_group_input(p, zSql); in process_input()
28549 echo_group_input(p, zSql); in process_input()
28550 errCnt += runOneSqlLine(p, zSql, p->in, startline); in process_input()
28553 free(zSql); in process_input()
29628 void fiddle_exec(const char * zSql){ argument
29629 if(zSql && *zSql){
29630 if('.'==*zSql) puts(zSql);
29631 shellState.wasm.zInput = zSql;
29632 shellState.wasm.zPos = zSql;