Cross Reference: /external/sqlite/dist/shell.c

Lines Matching refs:zSql
1212   const char *zSql;               /* The text of the SQL statement */
1225   zSql = sqlite3_sql(pSql);
1226   if( zSql==0 ) return;
1227   for(z=zSql; *z==' ' || *z=='\t' || *z=='\n' || *z=='\f' || *z=='\r'; z++);
1289   const char *zSql,                           /* SQL to be evaluated */
1304   while( zSql[0] && (SQLITE_OK == rc) ){
1305     rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
1313         zSql = zLeftover;
1314         while( IsSpace(zSql[0]) ) zSql++;
1327         fprintf(pArg->out, "%s\n", zStmtSql ? zStmtSql : zSql);
1427       ** copy of the error message. Otherwise, set zSql to point to the
1432         zSql = zLeftover;
1433         while( IsSpace(zSql[0]) ) zSql++;
1459   const char *zSql;
1467   zSql = azArg[2];
1475   }else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
1484        zTable, zTable, zSql);
1489     fprintf(p->out, "%s;\n", zSql);
2159   const unsigned char *zSql;
2173     zSql = sqlite3_column_text(pQuery, 1);
2175     sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
2177       fprintf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
2200       zSql = sqlite3_column_text(pQuery, 1);
2202       sqlite3_exec(newDb, (const char*)zSql, 0, 0, &zErrMsg);
2204         fprintf(stderr, "Error: %s\nSQL: [%s]\n", zErrMsg, zSql);
2586     char *zSql;                 /* An SQL statement */
2624     zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
2625     if( zSql==0 ){
2630     nByte = strlen30(zSql);
2631     rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2658       rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2660     sqlite3_free(zSql);
2671     zSql = sqlite3_malloc( nByte*2 + 20 + nCol*2 );
2672     if( zSql==0 ){
2677     sqlite3_snprintf(nByte+20, zSql, "INSERT INTO \"%w\" VALUES(?", zTable);
2678     j = strlen30(zSql);
2680       zSql[j++] = ',';
2681       zSql[j++] = '?';
2683     zSql[j++] = ')';
2684     zSql[j] = 0;
2685     rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
2686     sqlite3_free(zSql);
3205     char *zSql = 0;
3210     zSql = sqlite3_mprintf(
3219         zSql = sqlite3_mprintf(
3224                  "   AND name LIKE ?1", zSql);
3226         zSql = sqlite3_mprintf(
3231                  "   AND name LIKE ?1", zSql, zDbName, zDbName);
3235     zSql = sqlite3_mprintf("%z ORDER BY 1", zSql);
3236     rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
3237     sqlite3_free(zSql);
3541 ** Return true if zSql is a complete SQL statement.  Return false if it
3544 static int line_is_complete(char *zSql, int nSql){
3546   if( zSql==0 ) return 1;
3547   zSql[nSql] = ';';
3548   zSql[nSql+1] = 0;
3549   rc = sqlite3_complete(zSql);
3550   zSql[nSql] = 0;
3565   char *zSql = 0;           /* Accumulated SQL text */
3567   int nSql = 0;             /* Bytes of zSql[] used */
3568   int nAlloc = 0;           /* Allocated zSql[] space */
3569   int nSqlPrior = 0;        /* Bytes of zSql[] used by prior line */
3603     if( line_is_command_terminator(zLine) && line_is_complete(zSql, nSql) ){
3609       zSql = realloc(zSql, nAlloc);
3610       if( zSql==0 ){
3619       assert( nAlloc>0 && zSql!=0 );
3620       memcpy(zSql, zLine+i, nLine+1-i);
3624       zSql[nSql++] = '\n';
3625       memcpy(zSql+nSql, zLine, nLine+1);
3628     if( nSql && line_contains_semicolon(&zSql[nSqlPrior], nSql-nSqlPrior)
3629                 && sqlite3_complete(zSql) ){
3633       rc = shell_exec(p->db, zSql, shell_callback, p, &zErrMsg);
3657     }else if( nSql && _all_whitespace(zSql) ){
3658       if( p->echoOn ) printf("%s\n", zSql);
3663     if( !_all_whitespace(zSql) ){
3664       fprintf(stderr, "Error: incomplete SQL: %s\n", zSql);
3666     free(zSql);