Lines Matching refs:zSql
172 const char *zSql; /* Text of the SQL statement */ member
566 Tcl_Free((char *)pStmt->zSql); in dbFreeStmt()
709 static void DbTraceHandler(void *cd, const char *zSql){ in DbTraceHandler() argument
715 Tcl_DStringAppendElement(&str, zSql); in DbTraceHandler()
741 char *zSql = (char *)xd; in DbTraceV2Handler() local
748 Tcl_NewStringObj(zSql, -1)); in DbTraceV2Handler()
804 static void DbProfileHandler(void *cd, const char *zSql, sqlite_uint64 tm){ in DbProfileHandler() argument
812 Tcl_DStringAppendElement(&str, zSql); in DbProfileHandler()
1349 const char *zSql, /* SQL to compile */ in dbPrepare() argument
1356 return sqlite3_prepare(pDb->db, zSql, -1, ppStmt, pzOut); in dbPrepare()
1364 return sqlite3_prepare_v3(pDb->db, zSql, -1, prepFlags, ppStmt, pzOut); in dbPrepare()
1388 const char *zSql = zIn; /* Pointer to first SQL statement in zIn */ in dbPrepareAndBind() local
1403 while( (c = zSql[0])==' ' || c=='\t' || c=='\r' || c=='\n' ){ zSql++; } in dbPrepareAndBind()
1404 nSql = strlen30(zSql); in dbPrepareAndBind()
1409 && memcmp(pPreStmt->zSql, zSql, n)==0 in dbPrepareAndBind()
1410 && (zSql[n]==0 || zSql[n-1]==';') in dbPrepareAndBind()
1413 *pzOut = &zSql[pPreStmt->nSql]; in dbPrepareAndBind()
1440 if( SQLITE_OK!=dbPrepare(pDb, zSql, &pStmt, pzOut) ){ in dbPrepareAndBind()
1464 pPreStmt->nSql = (int)(*pzOut - zSql); in dbPrepareAndBind()
1465 pPreStmt->zSql = sqlite3_sql(pStmt); in dbPrepareAndBind()
1468 if( pPreStmt->zSql==0 ){ in dbPrepareAndBind()
1470 memcpy(zCopy, zSql, pPreStmt->nSql); in dbPrepareAndBind()
1472 pPreStmt->zSql = zCopy; in dbPrepareAndBind()
1477 assert( strlen30(pPreStmt->zSql)==pPreStmt->nSql ); in dbPrepareAndBind()
1478 assert( 0==memcmp(pPreStmt->zSql, zSql, pPreStmt->nSql) ); in dbPrepareAndBind()
1620 const char *zSql; /* Remaining SQL to execute */ member
1667 p->zSql = Tcl_GetString(pSql); in dbEvalInit()
1743 while( p->zSql[0] || p->pPreStmt ){ in dbEvalStep()
1746 zPrevSql = (p->zSql==zPrevSql ? 0 : p->zSql); in dbEvalStep()
1747 rc = dbPrepareAndBind(p->pDb, p->zSql, &p->zSql, &p->pPreStmt); in dbEvalStep()
1782 p->zSql = zPrevSql; in dbEvalStep()
2528 char *zSql; /* An SQL statement */ in DbObjCmd() local
2575 zSql = sqlite3_mprintf("SELECT * FROM '%q'", zTable); in DbObjCmd()
2576 if( zSql==0 ){ in DbObjCmd()
2580 nByte = strlen30(zSql); in DbObjCmd()
2581 rc = sqlite3_prepare(pDb->db, zSql, -1, &pStmt, 0); in DbObjCmd()
2582 sqlite3_free(zSql); in DbObjCmd()
2593 zSql = malloc( nByte + 50 + nCol*2 ); in DbObjCmd()
2594 if( zSql==0 ) { in DbObjCmd()
2598 sqlite3_snprintf(nByte+50, zSql, "INSERT OR %q INTO '%q' VALUES(?", in DbObjCmd()
2600 j = strlen30(zSql); in DbObjCmd()
2602 zSql[j++] = ','; in DbObjCmd()
2603 zSql[j++] = '?'; in DbObjCmd()
2605 zSql[j++] = ')'; in DbObjCmd()
2606 zSql[j] = 0; in DbObjCmd()
2607 rc = sqlite3_prepare(pDb->db, zSql, -1, &pStmt, 0); in DbObjCmd()
2608 free(zSql); in DbObjCmd()