Lines Matching refs:zSql
1260 char *zSql; in shellFakeSchema() local
1266 zSql = sqlite3_mprintf("PRAGMA \"%w\".table_info=%Q;", in shellFakeSchema()
1268 shell_check_oom(zSql); in shellFakeSchema()
1269 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in shellFakeSchema()
1270 sqlite3_free(zSql); in shellFakeSchema()
2683 const char *zSql = (const char*)sqlite3_value_text(argv[0]); in sha3QueryFunc() local
2703 if( zSql==0 ) return; in sha3QueryFunc()
2705 while( zSql[0] ){ in sha3QueryFunc()
2706 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql); in sha3QueryFunc()
2709 zSql, sqlite3_errmsg(db)); in sha3QueryFunc()
7614 char *zSql = 0; in completionNext() local
7619 zSql = sqlite3_mprintf( in completionNext()
7622 zSql, zSep, zDb in completionNext()
7624 if( zSql==0 ) return SQLITE_NOMEM; in completionNext()
7628 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
7629 sqlite3_free(zSql); in completionNext()
7638 char *zSql = 0; in completionNext() local
7643 zSql = sqlite3_mprintf( in completionNext()
7648 zSql, zSep, zDb, zDb in completionNext()
7650 if( zSql==0 ) return SQLITE_NOMEM; in completionNext()
7654 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0); in completionNext()
7655 sqlite3_free(zSql); in completionNext()
11027 const char *zSql, /* SQL statement(s) to add */
11233 char *zSql; /* SQL statement */ member
11441 const char *zSql /* SQL statement to compile */ in idxPrepareStmt() argument
11443 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0); in idxPrepareStmt()
11463 char *zSql; in idxPrintfPrepareStmt() local
11465 zSql = sqlite3_vmprintf(zFmt, ap); in idxPrintfPrepareStmt()
11466 if( zSql==0 ){ in idxPrintfPrepareStmt()
11469 rc = idxPrepareStmt(db, ppStmt, pzErrmsg, zSql); in idxPrintfPrepareStmt()
11470 sqlite3_free(zSql); in idxPrintfPrepareStmt()
12316 "EXPLAIN QUERY PLAN %s", pStmt->zSql in idxFindIndexes()
12339 const char *zSql; in idxFindIndexes() local
12344 zSql = idxHashSearch(&p->hIdx, zIdx, nIdx); in idxFindIndexes()
12345 if( zSql ){ in idxFindIndexes()
12346 idxHashAdd(&rc, &hIdx, zSql, 0); in idxFindIndexes()
12417 const char *zSql = in idxProcessOneTrigger() local
12426 rc = idxPrintfPrepareStmt(p->db, &pSelect, pzErr, zSql, zTab, zTab); in idxProcessOneTrigger()
12530 const char *zSql = (const char*)sqlite3_column_text(pSchema, 2); in idxCreateVtabSchema() local
12534 if( zSql ) rc = sqlite3_exec(p->dbv, zSql, 0, 0, pzErrmsg); in idxCreateVtabSchema()
12816 char *zSql; in idxBuildSampleTable() local
12821 zSql = sqlite3_mprintf( in idxBuildSampleTable()
12824 if( zSql==0 ) return SQLITE_NOMEM; in idxBuildSampleTable()
12825 rc = sqlite3_exec(p->dbv, zSql, 0, 0, 0); in idxBuildSampleTable()
12826 sqlite3_free(zSql); in idxBuildSampleTable()
13067 const char *zSql = (const char*)sqlite3_column_text(pSql, 0); in sqlite3_expert_new() local
13068 if( zSql ) rc = sqlite3_exec(pNew->dbm, zSql, 0, 0, pzErrmsg); in sqlite3_expert_new()
13121 const char *zSql, /* SQL statement to add */ in sqlite3_expert_sql() argument
13127 const char *zStmt = zSql; in sqlite3_expert_sql()
13145 pNew->zSql = (char*)&pNew[1]; in sqlite3_expert_sql()
13146 memcpy(pNew->zSql, z, n+1); in sqlite3_expert_sql()
13230 if( pStmt ) zRet = pStmt->zSql; in sqlite3_expert_report()
14256 char *zSql = 0; in dbdataDbsize() local
14262 zSql = sqlite3_mprintf("SELECT %.*s(0)", nFunc, zSchema); in dbdataDbsize()
14264 zSql = sqlite3_mprintf("PRAGMA %Q.page_count", zSchema); in dbdataDbsize()
14266 if( zSql==0 ) return SQLITE_NOMEM; in dbdataDbsize()
14268 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0); in dbdataDbsize()
14269 sqlite3_free(zSql); in dbdataDbsize()
14330 char *zSql = sqlite3_mprintf("SELECT %.*s(?2)", nFunc, zSchema); in dbdataFilter() local
14331 if( zSql==0 ){ in dbdataFilter()
14334 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0); in dbdataFilter()
14335 sqlite3_free(zSql); in dbdataFilter()
14931 const char *zSql in recoverPrepare() argument
14935 if( sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) ){ in recoverPrepare()
15015 static int recoverExec(sqlite3_recover *p, sqlite3 *db, const char *zSql){ in recoverExec() argument
15017 int rc = sqlite3_exec(db, zSql, 0, 0, 0); in recoverExec()
15361 static void recoverSqlCallback(sqlite3_recover *p, const char *zSql){ in recoverSqlCallback() argument
15363 int res = p->xSql(p->pSqlCtx, zSql); in recoverSqlCallback()
15497 char *zSql = recoverMPrintf(p, "ATTACH %Q AS recovery;", p->zStateDb); in recoverOpenRecovery() local
15498 recoverExec(p, p->dbOut, zSql); in recoverOpenRecovery()
15504 sqlite3_free(zSql); in recoverOpenRecovery()
15660 const char *zSql = (const char*)sqlite3_column_text(pSelect, 4); in recoverWriteSchema1() local
15665 zSql = (const char*)(zFree = recoverMPrintf(p, in recoverWriteSchema1()
15667 zName, zName, zSql in recoverWriteSchema1()
15670 rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0); in recoverWriteSchema1()
15672 recoverSqlCallback(p, zSql); in recoverWriteSchema1()
15719 const char *zSql = (const char*)sqlite3_column_text(pSelect, 1); in recoverWriteSchema2() local
15720 int rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0); in recoverWriteSchema2()
15722 recoverSqlCallback(p, zSql); in recoverWriteSchema2()
15776 char *zSql = 0; in recoverInsertStmt() local
15786 zSql = recoverMPrintf(p, "INSERT OR IGNORE INTO %Q(", pTab->zTab); in recoverInsertStmt()
15790 zSql = recoverMPrintf(p, "%z_rowid_", zSql); in recoverInsertStmt()
15806 zSql = recoverMPrintf(p, "%z%s%Q", zSql, zSep, pTab->aCol[ii].zCol); in recoverInsertStmt()
15822 zSql, zBind in recoverInsertStmt()
15825 zFinal = recoverMPrintf(p, "%s) VALUES (%s)", zSql, zBind); in recoverInsertStmt()
15829 sqlite3_free(zSql); in recoverInsertStmt()
15895 char *zSql = 0; in recoverLostAndFoundCreate() local
15903 zSql = recoverMPrintf(p, "CREATE TABLE %s(%s)", zTbl, zField); in recoverLostAndFoundCreate()
15906 recoverExec(p, p->dbOut, zSql); in recoverLostAndFoundCreate()
15907 recoverSqlCallback(p, zSql); in recoverLostAndFoundCreate()
15908 sqlite3_free(zSql); in recoverLostAndFoundCreate()
18962 static char *shell_error_context(const char *zSql, sqlite3 *db){ in shell_error_context() argument
18969 || zSql==0 in shell_error_context()
18971 || iOffset>=(int)strlen(zSql) in shell_error_context()
18977 zSql++; in shell_error_context()
18978 while( (zSql[0]&0xc0)==0x80 ){ zSql++; iOffset--; } in shell_error_context()
18980 len = strlen(zSql); in shell_error_context()
18983 while( len>0 && (zSql[len]&0xc0)==0x80 ) len--; in shell_error_context()
18985 zCode = sqlite3_mprintf("%.*s", len, zSql); in shell_error_context()
18987 for(i=0; zCode[i]; i++){ if( IsSpace(zSql[i]) ) zCode[i] = ' '; } in shell_error_context()
19058 const char *zSql /* SQL string, or NULL */ in save_err_msg() argument
19067 zContext = shell_error_context(zSql, db); in save_err_msg()
19514 const char *zSql = in display_scanstats()
19521 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in display_scanstats()
20153 const char *zSql, in expertHandleSQL() argument
20158 return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr); in expertHandleSQL()
20195 const char *zSql = sqlite3_expert_report(p, i, EXPERT_REPORT_SQL); in expertFinish() local
20201 raw_printf(out, "%s\n\n", zSql); in expertFinish()
20284 const char *zSql, /* SQL to be evaluated */ in shell_exec() argument
20299 rc = expertHandleSQL(pArg, zSql, pzErrMsg); in shell_exec()
20304 while( zSql[0] && (SQLITE_OK == rc) ){ in shell_exec()
20306 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover); in shell_exec()
20309 *pzErrMsg = save_err_msg(db, "in prepare", rc, zSql); in shell_exec()
20314 zSql = zLeftover; in shell_exec()
20315 while( IsSpace(zSql[0]) ) zSql++; in shell_exec()
20411 zSql = zLeftover; in shell_exec()
20412 while( IsSpace(zSql[0]) ) zSql++; in shell_exec()
20455 char *zSql; in tableColumnList() local
20463 zSql = sqlite3_mprintf("PRAGMA table_info=%Q", zTab); in tableColumnList()
20464 shell_check_oom(zSql); in tableColumnList()
20465 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
20466 sqlite3_free(zSql); in tableColumnList()
20507 zSql = sqlite3_mprintf("SELECT 1 FROM pragma_index_list(%Q)" in tableColumnList()
20509 shell_check_oom(zSql); in tableColumnList()
20510 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in tableColumnList()
20511 sqlite3_free(zSql); in tableColumnList()
20570 const char *zSql; in dump_callback() local
20579 zSql = azArg[2]; in dump_callback()
20593 }else if( cli_strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){ in dump_callback()
20602 zTable, zTable, zSql); in dump_callback()
20608 printSchemaLine(p->out, zSql, ";\n"); in dump_callback()
21520 char *zSql = sqlite3_mprintf( in open_db() local
21522 shell_check_oom(zSql); in open_db()
21523 sqlite3_exec(p->db, zSql, 0, 0, 0); in open_db()
21524 sqlite3_free(zSql); in open_db()
21581 char *zSql; in readline_completion_generator() local
21583 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase" in readline_completion_generator()
21585 shell_check_oom(zSql); in readline_completion_generator()
21586 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in readline_completion_generator()
21587 sqlite3_free(zSql); in readline_completion_generator()
21614 char *zSql; in linenoise_completion() local
21623 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase" in linenoise_completion()
21626 shell_check_oom(zSql); in linenoise_completion()
21627 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0); in linenoise_completion()
21628 sqlite3_free(zSql); in linenoise_completion()
21787 const char *zSql; in sql_trace_callback() local
21795 zSql = (const char*)pX; in sql_trace_callback()
21800 zSql = sqlite3_expanded_sql(pStmt); in sql_trace_callback()
21805 zSql = sqlite3_normalized_sql(pStmt); in sql_trace_callback()
21810 zSql = sqlite3_sql(pStmt); in sql_trace_callback()
21815 if( zSql==0 ) return 0; in sql_trace_callback()
21816 nSql = strlen(zSql); in sql_trace_callback()
21818 while( nSql>0 && zSql[nSql-1]==';' ){ nSql--; } in sql_trace_callback()
21822 utf8_printf(p->traceOut, "%.*s;\n", (int)nSql, zSql); in sql_trace_callback()
21827 utf8_printf(p->traceOut, "%.*s; -- %lld ns\n", (int)nSql, zSql, nNanosec); in sql_trace_callback()
22139 const unsigned char *zSql; in tryToCloneSchema() local
22154 zSql = sqlite3_column_text(pQuery, 1); in tryToCloneSchema()
22155 if( zName==0 || zSql==0 ) continue; in tryToCloneSchema()
22158 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg); in tryToCloneSchema()
22160 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql); in tryToCloneSchema()
22185 zSql = sqlite3_column_text(pQuery, 1); in tryToCloneSchema()
22186 if( zName==0 || zSql==0 ) continue; in tryToCloneSchema()
22189 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg); in tryToCloneSchema()
22191 utf8_printf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql); in tryToCloneSchema()
22280 static int db_int(sqlite3 *db, const char *zSql){ in db_int() argument
22283 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0); in db_int()
22322 static const struct { const char *zName; const char *zSql; } aQuery[] = { in shell_dbinfo_command() member
22390 char *zSql = sqlite3_mprintf(aQuery[i].zSql, zSchemaTab); in shell_dbinfo_command() local
22391 int val = db_int(p->db, zSql); in shell_dbinfo_command()
22392 sqlite3_free(zSql); in shell_dbinfo_command()
22685 const char *zSql = in lintFkeyIndexes() local
22738 rc = sqlite3_prepare_v2(db, zSql, -1, &pSql, 0); in lintFkeyIndexes()
22833 const char *zSql, in shellPrepare() argument
22838 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0); in shellPrepare()
23268 const char *zSql = "SELECT %s FROM %s WHERE %s"; in arListCommand() local
23281 shellPreparePrintf(pAr->db, &rc, &pSql, zSql, azCols[pAr->bVerbose], in arListCommand()
23310 char *zSql = 0; in arRemoveCommand() local
23320 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;", in arRemoveCommand()
23323 utf8_printf(pAr->p->out, "%s\n", zSql); in arRemoveCommand()
23328 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr); in arRemoveCommand()
23342 sqlite3_free(zSql); in arRemoveCommand()
23421 static int arExecSql(ArCommand *pAr, const char *zSql){ in arExecSql() argument
23424 utf8_printf(pAr->p->out, "%s\n", zSql); in arExecSql()
23428 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr); in arExecSql()
23496 char *zSql; in arCreateOrUpdateCommand() local
23511 zSql = sqlite3_mprintf( in arCreateOrUpdateCommand()
23515 rc = arExecSql(pAr, zSql); in arCreateOrUpdateCommand()
23516 sqlite3_free(zSql); in arCreateOrUpdateCommand()
23553 zSql = sqlite3_mprintf("DROP TABLE %s", zTemp); in arCreateOrUpdateCommand()
23554 arExecSql(pAr, zSql); in arCreateOrUpdateCommand()
23555 sqlite3_free(zSql); in arCreateOrUpdateCommand()
23682 static int recoverSqlCb(void *pCtx, const char *zSql){ in recoverSqlCb() argument
23684 utf8_printf(pState->out, "%s;\n", zSql); in recoverSqlCb()
24375 char *zSql; in do_meta_command() local
24452 zSql = sqlite3_mprintf( in do_meta_command()
24459 run_schema_dump_query(p,zSql); in do_meta_command()
24460 sqlite3_free(zSql); in do_meta_command()
24462 zSql = sqlite3_mprintf( in do_meta_command()
24468 run_table_dump_query(p, zSql); in do_meta_command()
24469 sqlite3_free(zSql); in do_meta_command()
24798 char *zSql; /* An SQL statement */ in do_meta_command() local
24941 zSql = sqlite3_mprintf("SELECT * FROM %s", zFullTabName); in do_meta_command()
24942 if( zSql==0 || zFullTabName==0 ){ in do_meta_command()
24946 nByte = strlen30(zSql); in do_meta_command()
24947 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
24970 sqlite3_free(zSql); in do_meta_command()
24987 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
24994 sqlite3_free(zSql); in do_meta_command()
24999 zSql = sqlite3_malloc64( nByte*2 + 20 + nCol*2 ); in do_meta_command()
25000 if( zSql==0 ){ in do_meta_command()
25004 sqlite3_snprintf(nByte+20, zSql, "INSERT INTO %s VALUES(?", zFullTabName); in do_meta_command()
25005 j = strlen30(zSql); in do_meta_command()
25007 zSql[j++] = ','; in do_meta_command()
25008 zSql[j++] = '?'; in do_meta_command()
25010 zSql[j++] = ')'; in do_meta_command()
25011 zSql[j] = 0; in do_meta_command()
25013 utf8_printf(p->out, "Insert using: %s\n", zSql); in do_meta_command()
25015 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25021 sqlite3_free(zSql); in do_meta_command()
25092 char *zSql; in do_meta_command() local
25123 zSql = sqlite3_mprintf( in do_meta_command()
25132 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25133 sqlite3_free(zSql); in do_meta_command()
25139 zSql = sqlite3_mprintf("PRAGMA index_xinfo='%q'", azArg[1]); in do_meta_command()
25140 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25141 sqlite3_free(zSql); in do_meta_command()
25172 zSql = sqlite3_mprintf( in do_meta_command()
25178 rc = sqlite3_exec(p->db, zSql, 0, 0, 0); in do_meta_command()
25181 utf8_printf(stderr, "Error in [%s]: %s\n", zSql, sqlite3_errmsg(p->db)); in do_meta_command()
25183 utf8_printf(stdout, "%s;\n", zSql); in do_meta_command()
25193 sqlite3_free(zSql); in do_meta_command()
25745 char *zSql; in do_meta_command() local
25750 zSql = sqlite3_mprintf( in do_meta_command()
25753 shell_check_oom(zSql); in do_meta_command()
25755 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25756 sqlite3_free(zSql); in do_meta_command()
25760 zSql = sqlite3_mprintf( in do_meta_command()
25763 shell_check_oom(zSql); in do_meta_command()
25764 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
25765 sqlite3_free(zSql); in do_meta_command()
25782 char *zSql = sqlite3_mprintf( in do_meta_command() local
25784 shell_check_oom(zSql); in do_meta_command()
25785 sqlite3_exec(p->db, zSql, 0, 0, 0); in do_meta_command()
25786 sqlite3_free(zSql); in do_meta_command()
26415 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2); in do_meta_command() local
26419 if( zSql==0 ) continue; in do_meta_command()
26423 printf("%d: %s %s\n", tno, zOp, zSql); in do_meta_command()
26426 utf8_printf(p->out, "%s\n", zSql); in do_meta_command()
26432 rc = sqlite3_exec(p->db, zSql, captureOutputCallback, &str, &zErrMsg); in do_meta_command()
26485 char *zSql; /* SQL to be run */ in do_meta_command() local
26524 zSql = "SELECT lower(name) as tname FROM sqlite_schema" in do_meta_command()
26529 zSql = "SELECT lower(name) as tname FROM sqlite_schema" in do_meta_command()
26534 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0); in do_meta_command()
26570 zSql = sqlite3_mprintf( in do_meta_command()
26576 zSql = sqlite3_mprintf( in do_meta_command()
26582 shell_check_oom(zSql); in do_meta_command()
26586 utf8_printf(p->out, "%s\n", zSql); in do_meta_command()
26588 shell_exec(p, zSql, 0); in do_meta_command()
26651 sqlite3_free(zSql); in do_meta_command()
27504 static int line_is_complete(char *zSql, int nSql){ in line_is_complete() argument
27506 if( zSql==0 ) return 1; in line_is_complete()
27507 zSql[nSql] = ';'; in line_is_complete()
27508 zSql[nSql+1] = 0; in line_is_complete()
27509 rc = sqlite3_complete(zSql); in line_is_complete()
27510 zSql[nSql] = 0; in line_is_complete()
27517 static int runOneSqlLine(ShellState *p, char *zSql, FILE *in, int startline){ in runOneSqlLine() argument
27522 if( ShellHasFlag(p,SHFLG_Backslash) ) resolve_backslashes(zSql); in runOneSqlLine()
27525 rc = shell_exec(p, zSql, &zErrMsg); in runOneSqlLine()
27612 char *zSql = 0; /* Accumulated SQL text */ in process_input() local
27645 && line_is_complete(zSql, nSql) ){ in process_input()
27674 zSql = realloc(zSql, nAlloc); in process_input()
27675 shell_check_oom(zSql); in process_input()
27680 assert( nAlloc>0 && zSql!=0 ); in process_input()
27681 memcpy(zSql, zLine+i, nLine+1-i); in process_input()
27685 zSql[nSql++] = '\n'; in process_input()
27686 memcpy(zSql+nSql, zLine, nLine+1); in process_input()
27689 if( nSql && QSS_SEMITERM(qss) && sqlite3_complete(zSql) ){ in process_input()
27690 echo_group_input(p, zSql); in process_input()
27691 errCnt += runOneSqlLine(p, zSql, p->in, startline); in process_input()
27703 echo_group_input(p, zSql); in process_input()
27710 echo_group_input(p, zSql); in process_input()
27711 errCnt += runOneSqlLine(p, zSql, p->in, startline); in process_input()
27714 free(zSql); in process_input()
28822 void fiddle_exec(const char * zSql){ argument
28823 if(zSql && *zSql){
28824 if('.'==*zSql) puts(zSql);
28825 shellState.wasm.zInput = zSql;
28826 shellState.wasm.zPos = zSql;