Lines Matching defs:zSql
1998 char *zSql;
2004 zSql = sqlite3_mprintf("PRAGMA \"%w\".table_info=%Q;",
2006 shell_check_oom(zSql);
2007 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
2008 sqlite3_free(zSql);
3421 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
3441 if( zSql==0 ) return;
3443 while( zSql[0] ){
3444 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zSql);
3447 zSql, sqlite3_errmsg(db));
8416 char *zSql = 0;
8421 zSql = sqlite3_mprintf(
8424 zSql, zSep, zDb
8426 if( zSql==0 ) return SQLITE_NOMEM;
8430 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0);
8431 sqlite3_free(zSql);
8440 char *zSql = 0;
8445 zSql = sqlite3_mprintf(
8450 zSql, zSep, zDb, zDb
8452 if( zSql==0 ) return SQLITE_NOMEM;
8456 sqlite3_prepare_v2(pCur->db, zSql, -1, &pCur->pStmt, 0);
8457 sqlite3_free(zSql);
11810 ** Buffer zSql must contain zero or more complete SQL statements. This
11830 const char *zSql, /* SQL statement(s) to add */
12036 char *zSql; /* SQL statement */
12244 const char *zSql /* SQL statement to compile */
12246 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0);
12266 char *zSql;
12268 zSql = sqlite3_vmprintf(zFmt, ap);
12269 if( zSql==0 ){
12272 rc = idxPrepareStmt(db, ppStmt, pzErrmsg, zSql);
12273 sqlite3_free(zSql);
13119 "EXPLAIN QUERY PLAN %s", pStmt->zSql
13142 const char *zSql;
13147 zSql = idxHashSearch(&p->hIdx, zIdx, nIdx);
13148 if( zSql ){
13149 idxHashAdd(&rc, &hIdx, zSql, 0);
13220 const char *zSql =
13229 rc = idxPrintfPrepareStmt(p->db, &pSelect, pzErr, zSql, zTab, zTab);
13333 const char *zSql = (const char*)sqlite3_column_text(pSchema, 2);
13337 if( zSql ) rc = sqlite3_exec(p->dbv, zSql, 0, 0, pzErrmsg);
13620 char *zSql;
13625 zSql = sqlite3_mprintf(
13628 if( zSql==0 ) return SQLITE_NOMEM;
13629 rc = sqlite3_exec(p->dbv, zSql, 0, 0, 0);
13630 sqlite3_free(zSql);
13874 const char *zSql = (const char*)sqlite3_column_text(pSql, 0);
13875 if( zSql ) rc = sqlite3_exec(pNew->dbm, zSql, 0, 0, pzErrmsg);
13928 const char *zSql, /* SQL statement to add */
13934 const char *zStmt = zSql;
13952 pNew->zSql = (char*)&pNew[1];
13953 memcpy(pNew->zSql, z, n+1);
14037 if( pStmt ) zRet = pStmt->zSql;
14320 ** Otherwise, this function attempts to prepare SQL statement zSql and
14323 static sqlite3_stmt *intckPrepare(sqlite3_intck *p, const char *zSql){
14326 p->rc = sqlite3_prepare_v2(p->db, zSql, -1, &pRet, 0);
14348 char *zSql = 0;
14350 zSql = sqlite3_vmprintf(zFmt, ap);
14351 if( p->rc==SQLITE_OK && zSql==0 ){
14354 pRet = intckPrepare(p, zSql);
14355 sqlite3_free(zSql);
14382 ** Execute SQL statement zSql. There is no way to obtain any results
14386 static void intckExec(sqlite3_intck *p, const char *zSql){
14388 pStmt = intckPrepare(p, zSql);
14420 char *zSql = 0;
14443 zSql = intckMprintf(p, "%z%squote(?)", zSql, zSep);
14446 zSql = intckMprintf(p, "%z || ')'", zSql);
14485 zSql = intckMprintf(p, "%z%s(quote( %z ) )",
14486 zSql,
14487 (zSql==0 ? "VALUES" : ",\n "),
14491 zSql = intckMprintf(p,
14494 , zSql
14498 pStmt = intckPrepare(p, zSql);
14509 sqlite3_free(zSql);
14700 const char *zSql = (const char*)sqlite3_value_text(apVal[0]);
14706 if( zSql ){
14707 zRes = intckParseCreateIndex(zSql, idx, &nRes);
15094 char *zSql = 0;
15095 zSql = intckCheckObjectSql(p, p->zObj, p->zKey, &p->nKeyVal);
15096 p->pCheck = intckPrepare(p, zSql);
15097 sqlite3_free(zSql);
16244 char *zSql = 0;
16250 zSql = sqlite3_mprintf("SELECT %.*s(0)", nFunc, zSchema);
16252 zSql = sqlite3_mprintf("PRAGMA %Q.page_count", zSchema);
16254 if( zSql==0 ) return SQLITE_NOMEM;
16256 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0);
16257 sqlite3_free(zSql);
16318 char *zSql = sqlite3_mprintf("SELECT %.*s(?2)", nFunc, zSchema);
16319 if( zSql==0 ){
16322 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0);
16323 sqlite3_free(zSql);
16911 ** Otherwise, it attempts to prepare the SQL statement in zSql against
16919 const char *zSql
16923 if( sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) ){
16999 ** Otherwise, execute SQL script zSql. If successful, return SQLITE_OK.
17003 static int recoverExec(sqlite3_recover *p, sqlite3 *db, const char *zSql){
17005 int rc = sqlite3_exec(db, zSql, 0, 0, 0);
17344 ** zSql as the parameter.
17349 static void recoverSqlCallback(sqlite3_recover *p, const char *zSql){
17351 int res = p->xSql(p->pSqlCtx, zSql);
17485 char *zSql = recoverMPrintf(p, "ATTACH %Q AS recovery;", p->zStateDb);
17486 recoverExec(p, p->dbOut, zSql);
17492 sqlite3_free(zSql);
17648 const char *zSql = (const char*)sqlite3_column_text(pSelect, 4);
17653 zSql = (const char*)(zFree = recoverMPrintf(p,
17655 zName, zName, zSql
17658 rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0);
17660 recoverSqlCallback(p, zSql);
17707 const char *zSql = (const char*)sqlite3_column_text(pSelect, 1);
17708 int rc = sqlite3_exec(p->dbOut, zSql, 0, 0, 0);
17710 recoverSqlCallback(p, zSql);
17764 char *zSql = 0;
17774 zSql = recoverMPrintf(p, "INSERT OR IGNORE INTO %Q(", pTab->zTab);
17778 zSql = recoverMPrintf(p, "%z_rowid_", zSql);
17794 zSql = recoverMPrintf(p, "%z%s%Q", zSql, zSep, pTab->aCol[ii].zCol);
17810 zSql, zBind
17813 zFinal = recoverMPrintf(p, "%s) VALUES (%s)", zSql, zBind);
17817 sqlite3_free(zSql);
17883 char *zSql = 0;
17891 zSql = recoverMPrintf(p, "CREATE TABLE %s(%s)", zTbl, zField);
17894 recoverExec(p, p->dbOut, zSql);
17895 recoverSqlCallback(p, zSql);
17896 sqlite3_free(zSql);
20999 static char *shell_error_context(const char *zSql, sqlite3 *db){
21006 || zSql==0
21008 || iOffset>=(int)strlen(zSql)
21014 zSql++;
21015 while( (zSql[0]&0xc0)==0x80 ){ zSql++; iOffset--; }
21017 len = strlen(zSql);
21020 while( len>0 && (zSql[len]&0xc0)==0x80 ) len--;
21022 zCode = sqlite3_mprintf("%.*s", len, zSql);
21024 for(i=0; zCode[i]; i++){ if( IsSpace(zSql[i]) ) zCode[i] = ' '; }
21094 const char *zSql /* SQL string, or NULL */
21103 zContext = shell_error_context(zSql, db);
21538 const char *zSql =
21545 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
22177 const char *zSql,
22182 return sqlite3_expert_sql(pState->expert.pExpert, zSql, pzErr);
22218 const char *zSql = sqlite3_expert_report(p, i, EXPERT_REPORT_SQL);
22224 oputf("%s\n\n", zSql);
22306 const char *zSql, /* SQL to be evaluated */
22321 rc = expertHandleSQL(pArg, zSql, pzErrMsg);
22326 while( zSql[0] && (SQLITE_OK == rc) ){
22328 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
22331 *pzErrMsg = save_err_msg(db, "in prepare", rc, zSql);
22336 zSql = zLeftover;
22337 while( IsSpace(zSql[0]) ) zSql++;
22428 ** copy of the error message. Otherwise, set zSql to point to the
22433 zSql = zLeftover;
22434 while( IsSpace(zSql[0]) ) zSql++;
22477 char *zSql;
22485 zSql = sqlite3_mprintf("PRAGMA table_info=%Q", zTab);
22486 shell_check_oom(zSql);
22487 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
22488 sqlite3_free(zSql);
22529 zSql = sqlite3_mprintf("SELECT 1 FROM pragma_index_list(%Q)"
22531 shell_check_oom(zSql);
22532 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
22533 sqlite3_free(zSql);
22592 const char *zSql;
22601 zSql = azArg[2];
22615 }else if( cli_strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
22624 zTable, zTable, zSql);
22630 printSchemaLine(zSql, ";\n");
23540 char *zSql = sqlite3_mprintf(
23542 shell_check_oom(zSql);
23543 sqlite3_exec(p->db, zSql, 0, 0, 0);
23544 sqlite3_free(zSql);
23600 char *zSql;
23602 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase"
23604 shell_check_oom(zSql);
23605 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0);
23606 sqlite3_free(zSql);
23633 char *zSql;
23642 zSql = sqlite3_mprintf("SELECT DISTINCT candidate COLLATE nocase"
23645 shell_check_oom(zSql);
23646 sqlite3_prepare_v2(globalDb, zSql, -1, &pStmt, 0);
23647 sqlite3_free(zSql);
23805 const char *zSql;
23813 zSql = (const char*)pX;
23818 zSql = sqlite3_expanded_sql(pStmt);
23823 zSql = sqlite3_normalized_sql(pStmt);
23828 zSql = sqlite3_sql(pStmt);
23833 if( zSql==0 ) return 0;
23834 nSql = strlen(zSql);
23836 while( nSql>0 && zSql[nSql-1]==';' ){ nSql--; }
23840 sputf(p->traceOut, "%.*s;\n", (int)nSql, zSql);
23845 sputf(p->traceOut, "%.*s; -- %lld ns\n", (int)nSql, zSql, nNanosec);
24154 const unsigned char *zSql;
24168 zSql = sqlite3_column_text(pQuery, 1);
24169 if( zName==0 || zSql==0 ) continue;
24172 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
24174 eputf("Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
24198 zSql = sqlite3_column_text(pQuery, 1);
24199 if( zName==0 || zSql==0 ) continue;
24202 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
24204 eputf("Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
24309 static int db_int(sqlite3 *db, const char *zSql){
24312 sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
24351 static const struct { const char *zName; const char *zSql; } aQuery[] = {
24419 char *zSql = sqlite3_mprintf(aQuery[i].zSql, zSchemaTab);
24420 int val = db_int(p->db, zSql);
24421 sqlite3_free(zSql);
24713 const char *zSql =
24764 rc = sqlite3_prepare_v2(db, zSql, -1, &pSql, 0);
24858 const char *zSql,
24863 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0);
25285 const char *zSql = "SELECT %s FROM %s WHERE %s";
25298 shellPreparePrintf(pAr->db, &rc, &pSql, zSql, azCols[pAr->bVerbose],
25323 char *zSql = 0;
25333 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;",
25336 oputf("%s\n", zSql);
25341 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr);
25355 sqlite3_free(zSql);
25432 ** Run the SQL statement in zSql. Or if doing a --dryrun, merely print it out.
25434 static int arExecSql(ArCommand *pAr, const char *zSql){
25437 oputf("%s\n", zSql);
25441 rc = sqlite3_exec(pAr->db, zSql, 0, 0, &zErr);
25509 char *zSql;
25524 zSql = sqlite3_mprintf(
25528 rc = arExecSql(pAr, zSql);
25529 sqlite3_free(zSql);
25566 zSql = sqlite3_mprintf("DROP TABLE %s", zTemp);
25567 arExecSql(pAr, zSql);
25568 sqlite3_free(zSql);
25693 static int recoverSqlCb(void *pCtx, const char *zSql){
25695 sputf(pState->out, "%s;\n", zSql);
26480 char *zSql;
26558 zSql = sqlite3_mprintf(
26565 run_schema_dump_query(p,zSql);
26566 sqlite3_free(zSql);
26568 zSql = sqlite3_mprintf(
26575 run_table_dump_query(p, zSql);
26576 sqlite3_free(zSql);
26903 char *zSql = 0; /* An SQL statement */
27081 zSql = sqlite3_mprintf("SELECT count(*) FROM pragma_table_info(%Q,%Q);",
27083 if( zSql==0 ){
27087 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
27088 sqlite3_free(zSql);
27089 zSql = 0;
27110 zSql = sqlite3_malloc64( nByte );
27111 if( zSql==0 ){
27116 sqlite3_snprintf(nByte, zSql, "INSERT INTO \"%w\".\"%w\" VALUES(?",
27119 sqlite3_snprintf(nByte, zSql, "INSERT INTO \"%w\" VALUES(?", zTable);
27121 j = strlen30(zSql);
27123 zSql[j++] = ',';
27124 zSql[j++] = '?';
27126 zSql[j++] = ')';
27127 zSql[j] = 0;
27130 oputf("Insert using: %s\n", zSql);
27132 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
27133 sqlite3_free(zSql);
27134 zSql = 0;
27209 char *zSql;
27240 zSql = sqlite3_mprintf(
27249 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
27250 sqlite3_free(zSql);
27256 zSql = sqlite3_mprintf("PRAGMA index_xinfo='%q'", azArg[1]);
27257 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
27258 sqlite3_free(zSql);
27289 zSql = sqlite3_mprintf(
27295 rc = sqlite3_exec(p->db, zSql, 0, 0, 0);
27298 eputf("Error in [%s]: %s\n", zSql, sqlite3_errmsg(p->db));
27300 sputf(stdout, "%s;\n", zSql);
27308 sqlite3_free(zSql);
27868 char *zSql;
27873 zSql = sqlite3_mprintf(
27876 shell_check_oom(zSql);
27878 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
27879 sqlite3_free(zSql);
27883 zSql = sqlite3_mprintf(
27886 shell_check_oom(zSql);
27887 rx = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
27888 sqlite3_free(zSql);
27905 char *zSql = sqlite3_mprintf(
27907 shell_check_oom(zSql);
27908 sqlite3_exec(p->db, zSql, 0, 0, 0);
27909 sqlite3_free(zSql);
28532 const char *zSql = (const char*)sqlite3_column_text(pStmt, 2);
28536 if( zSql==0 ) continue;
28540 sputf(stdout, "%d: %s %s\n", tno, zOp, zSql);
28543 oputf("%s\n", zSql);
28549 rc = sqlite3_exec(p->db, zSql, captureOutputCallback, &str, &zErrMsg);
28601 char *zSql; /* SQL to be run */
28639 zSql = "SELECT lower(name) as tname FROM sqlite_schema"
28644 zSql = "SELECT lower(name) as tname FROM sqlite_schema"
28649 sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
28685 zSql = sqlite3_mprintf(
28691 zSql = sqlite3_mprintf(
28697 shell_check_oom(zSql);
28701 oputf("%s\n", zSql);
28703 shell_exec(p, zSql, 0);
28765 sqlite3_free(zSql);
29696 ** Return true if zSql is a complete SQL statement. Return false if it
29699 static int line_is_complete(char *zSql, int nSql){
29701 if( zSql==0 ) return 1;
29702 zSql[nSql] = ';';
29703 zSql[nSql+1] = 0;
29704 rc = sqlite3_complete(zSql);
29705 zSql[nSql] = 0;
29727 static int doAutoDetectRestore(ShellState *p, const char *zSql){
29735 if( p->bSafeMode==0 && memcmp(zSql, zExpect, 25)==0 ){
29747 if( memcmp(zSql, zExpect, 19)==0 ){
29794 static int runOneSqlLine(ShellState *p, char *zSql, FILE *in, int startline){
29799 if( ShellHasFlag(p,SHFLG_Backslash) ) resolve_backslashes(zSql);
29802 rc = shell_exec(p, zSql, &zErrMsg);
29839 if( doAutoDetectRestore(p, zSql) ) return 1;
29891 char *zSql = 0; /* Accumulated SQL text */
29893 i64 nSql = 0; /* Bytes of zSql[] used */
29894 i64 nAlloc = 0; /* Allocated zSql[] space */
29924 && line_is_complete(zSql, nSql) ){
29953 zSql = realloc(zSql, nAlloc);
29954 shell_check_oom(zSql);
29959 assert( nAlloc>0 && zSql!=0 );
29960 memcpy(zSql, zLine+i, nLine+1-i);
29964 zSql[nSql++] = '\n';
29965 memcpy(zSql+nSql, zLine, nLine+1);
29968 if( nSql && QSS_SEMITERM(qss) && sqlite3_complete(zSql) ){
29969 echo_group_input(p, zSql);
29970 errCnt += runOneSqlLine(p, zSql, p->in, startline);
29982 echo_group_input(p, zSql);
29989 echo_group_input(p, zSql);
29990 errCnt += runOneSqlLine(p, zSql, p->in, startline);
29993 free(zSql);
31085 ** Trivial exportable function for emscripten. It processes zSql as if
31090 void fiddle_exec(const char * zSql){
31091 if(zSql && *zSql){
31092 if('.'==*zSql) puts(zSql);
31093 shellState.wasm.zInput = zSql;
31094 shellState.wasm.zPos = zSql;