Lines Matching refs:zSql
1207 const char *zSql; /* The text of the SQL statement */
1220 zSql = sqlite3_sql(pSql);
1221 if( zSql==0 ) return;
1222 for(z=zSql; *z==' ' || *z=='\t' || *z=='\n' || *z=='\f' || *z=='\r'; z++);
1284 const char *zSql, /* SQL to be evaluated */
1299 while( zSql[0] && (SQLITE_OK == rc) ){
1300 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1308 zSql = zLeftover;
1309 while( IsSpace(zSql[0]) ) zSql++;
1322 fprintf(pArg->out, "%s\n", zStmtSql ? zStmtSql : zSql);
1422 ** copy of the error message. Otherwise, set zSql to point to the
1427 zSql = zLeftover;
1428 while( IsSpace(zSql[0]) ) zSql++;
1454 const char *zSql;
1462 zSql = azArg[2];
1470 }else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
1479 zTable, zTable, zSql);
1484 fprintf(p->out, "%s;\n", zSql);
2139 const unsigned char *zSql;
2153 zSql = sqlite3_column_text(pQuery, 1);
2155 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
2157 fprintf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
2180 zSql = sqlite3_column_text(pQuery, 1);
2182 sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
2184 fprintf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
2566 char *zSql; /* An SQL statement */
2604 zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
2605 if( zSql==0 ){
2610 nByte = strlen30(zSql);
2611 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2638 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2640 sqlite3_free(zSql);
2651 zSql = sqlite3_malloc( nByte*2 + 20 + nCol*2 );
2652 if( zSql==0 ){
2657 sqlite3_snprintf(nByte+20, zSql, "INSERT INTO \"%w\" VALUES(?", zTable);
2658 j = strlen30(zSql);
2660 zSql[j++] = ',';
2661 zSql[j++] = '?';
2663 zSql[j++] = ')';
2664 zSql[j] = 0;
2665 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2666 sqlite3_free(zSql);
3185 char *zSql = 0;
3190 zSql = sqlite3_mprintf(
3199 zSql = sqlite3_mprintf(
3204 " AND name LIKE ?1", zSql);
3206 zSql = sqlite3_mprintf(
3211 " AND name LIKE ?1", zSql, zDbName, zDbName);
3215 zSql = sqlite3_mprintf("%z ORDER BY 1", zSql);
3216 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3217 sqlite3_free(zSql);
3521 ** Return true if zSql is a complete SQL statement. Return false if it
3524 static int line_is_complete(char *zSql, int nSql){
3526 if( zSql==0 ) return 1;
3527 zSql[nSql] = ';';
3528 zSql[nSql+1] = 0;
3529 rc = sqlite3_complete(zSql);
3530 zSql[nSql] = 0;
3545 char *zSql = 0; /* Accumulated SQL text */
3547 int nSql = 0; /* Bytes of zSql[] used */
3548 int nAlloc = 0; /* Allocated zSql[] space */
3549 int nSqlPrior = 0; /* Bytes of zSql[] used by prior line */
3583 if( line_is_command_terminator(zLine) && line_is_complete(zSql, nSql) ){
3589 zSql = realloc(zSql, nAlloc);
3590 if( zSql==0 ){
3599 assert( nAlloc>0 && zSql!=0 );
3600 memcpy(zSql, zLine+i, nLine+1-i);
3604 zSql[nSql++] = '\n';
3605 memcpy(zSql+nSql, zLine, nLine+1);
3608 if( nSql && line_contains_semicolon(&zSql[nSqlPrior], nSql-nSqlPrior)
3609 && sqlite3_complete(zSql) ){
3613 rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
3637 }else if( nSql && _all_whitespace(zSql) ){
3638 if( p->echoOn ) printf("%s\n", zSql);
3643 if( !_all_whitespace(zSql) ){
3644 fprintf(stderr, "Error: incomplete SQL: %s\n", zSql);
3646 free(zSql);