自学教程：C++ sqlite3FixExpr函数代码示例

int sqlite3FixExpr(  DbFixer *pFix,     /* Context of the fixation */  Expr *pExpr        /* The expression to be fixed to one database */){  while( pExpr ){    if( pExpr->op==TK_VARIABLE ){      if( pFix->pParse->db->init.busy ){        pExpr->op = TK_NULL;      }else{        sqlite3ErrorMsg(pFix->pParse, "%s cannot use variables", pFix->zType);        return 1;      }    }    if( ExprHasProperty(pExpr, EP_TokenOnly) ) break;    if( ExprHasProperty(pExpr, EP_xIsSelect) ){      if( sqlite3FixSelect(pFix, pExpr->x.pSelect) ) return 1;    }else{      if( sqlite3FixExprList(pFix, pExpr->x.pList) ) return 1;    }    if( sqlite3FixExpr(pFix, pExpr->pRight) ){      return 1;    }    pExpr = pExpr->pLeft;  }  return 0;}

int sqlite3FixSrcList(  DbFixer *pFix,         SrcList *pList       ){  int i;  const char *zDb;  struct SrcList_item *pItem;  if( NEVER(pList==0) ) return 0;  zDb = pFix->zDb;  for(i=0, pItem=pList->a; i<pList->nSrc; i++, pItem++){    if( pItem->zDatabase==0 ){      pItem->zDatabase = sqlite3DbStrDup(pFix->pParse->db, zDb);    }else if( sqlite3StrICmp(pItem->zDatabase,zDb)!=0 ){      sqlite3ErrorMsg(pFix->pParse,         "%s %T cannot reference objects in database %s",         pFix->zType, pFix->pName, pItem->zDatabase);      return 1;    }#if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_TRIGGER)    if( sqlite3FixSelect(pFix, pItem->pSelect) ) return 1;    if( sqlite3FixExpr(pFix, pItem->pOn) ) return 1;#endif  }  return 0;}

/*** The following set of routines walk through the parse tree and assign** a specific database to all table references where the database name** was left unspecified in the original SQL statement.  The pFix structure** must have been initialized by a prior call to sqlite3FixInit().**** These routines are used to make sure that an index, trigger, or** view in one database does not refer to objects in a different database.** (Exception: indices, triggers, and views in the TEMP database are** allowed to refer to anything.)  If a reference is explicitly made** to an object in a different database, an error message is added to** pParse->zErrMsg and these routines return non-zero.  If everything** checks out, these routines return 0.*/int sqlite3FixSrcList(  DbFixer *pFix,       /* Context of the fixation */  SrcList *pList       /* The Source list to check and modify */){  int i;  const char *zDb;  struct SrcList_item *pItem;  if( NEVER(pList==0) ) return 0;  zDb = pFix->zDb;  for(i=0, pItem=pList->a; i<pList->nSrc; i++, pItem++){    if( pFix->bVarOnly==0 ){      if( pItem->zDatabase && sqlite3StrICmp(pItem->zDatabase, zDb) ){        sqlite3ErrorMsg(pFix->pParse,            "%s %T cannot reference objects in database %s",            pFix->zType, pFix->pName, pItem->zDatabase);        return 1;      }      sqlite3DbFree(pFix->pParse->db, pItem->zDatabase);      pItem->zDatabase = 0;      pItem->pSchema = pFix->pSchema;    }#if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_TRIGGER)    if( sqlite3FixSelect(pFix, pItem->pSelect) ) return 1;    if( sqlite3FixExpr(pFix, pItem->pOn) ) return 1;#endif  }  return 0;}

int sqlite3FixSelect(  DbFixer *pFix,       /* Context of the fixation */  Select *pSelect      /* The SELECT statement to be fixed to one database */){  while( pSelect ){    if( sqlite3FixExprList(pFix, pSelect->pEList) ){      return 1;    }    if( sqlite3FixSrcList(pFix, pSelect->pSrc) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pWhere) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pHaving) ){      return 1;    }    pSelect = pSelect->pPrior;  }  return 0;}

int sqlite3FixSelect(  DbFixer *pFix,         Select *pSelect      ){  while( pSelect ){    if( sqlite3FixExprList(pFix, pSelect->pEList) ){      return 1;    }    if( sqlite3FixSrcList(pFix, pSelect->pSrc) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pWhere) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pHaving) ){      return 1;    }    pSelect = pSelect->pPrior;  }  return 0;}

int sqlite3FixSelect(  DbFixer *pFix,       /* Context of the fixation */  Select *pSelect      /* The SELECT statement to be fixed to one database */){  while( pSelect ){    if( sqlite3FixExprList(pFix, pSelect->pEList) ){      return 1;    }    if( sqlite3FixSrcList(pFix, pSelect->pSrc) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pWhere) ){      return 1;    }    if( sqlite3FixExprList(pFix, pSelect->pGroupBy) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pHaving) ){      return 1;    }    if( sqlite3FixExprList(pFix, pSelect->pOrderBy) ){      return 1;    }    if( sqlite3FixExpr(pFix, pSelect->pLimit) ){      return 1;    }    if( pSelect->pWith ){      int i;      for(i=0; i<pSelect->pWith->nCte; i++){        if( sqlite3FixSelect(pFix, pSelect->pWith->a[i].pSelect) ){          return 1;        }      }    }    pSelect = pSelect->pPrior;  }  return 0;}

int sqlite3FixExprList(  DbFixer *pFix,     /* Context of the fixation */  ExprList *pList    /* The expression to be fixed to one database */){  int i;  struct ExprList_item *pItem;  if( pList==0 ) return 0;  for(i=0, pItem=pList->a; i<pList->nExpr; i++, pItem++){    if( sqlite3FixExpr(pFix, pItem->pExpr) ){      return 1;    }  }  return 0;}

int sqlite3FixExprList(  DbFixer *pFix,       ExprList *pList    ){  int i;  struct ExprList_item *pItem;  if( pList==0 ) return 0;  for(i=0, pItem=pList->a; i<pList->nExpr; i++, pItem++){    if( sqlite3FixExpr(pFix, pItem->pExpr) ){      return 1;    }  }  return 0;}

int sqlite3FixTriggerStep(  DbFixer *pFix,     /* Context of the fixation */  TriggerStep *pStep /* The trigger step be fixed to one database */){  while( pStep ){    if( sqlite3FixSelect(pFix, pStep->pSelect) ){      return 1;    }    if( sqlite3FixExpr(pFix, pStep->pWhere) ){      return 1;    }    if( sqlite3FixExprList(pFix, pStep->pExprList) ){      return 1;    }    pStep = pStep->pNext;  }  return 0;}

int sqlite3FixExpr(  DbFixer *pFix,     /* Context of the fixation */  Expr *pExpr        /* The expression to be fixed to one database */){  while( pExpr ){    if( ExprHasAnyProperty(pExpr, EP_TokenOnly) ) break;    if( ExprHasProperty(pExpr, EP_xIsSelect) ){      if( sqlite3FixSelect(pFix, pExpr->x.pSelect) ) return 1;    }else{      if( sqlite3FixExprList(pFix, pExpr->x.pList) ) return 1;    }    if( sqlite3FixExpr(pFix, pExpr->pRight) ){      return 1;    }    pExpr = pExpr->pLeft;  }  return 0;}

int sqlite3FixExpr(  DbFixer *pFix,     /* Context of the fixation */  Expr *pExpr        /* The expression to be fixed to one database */){  while( pExpr ){    if( sqlite3FixSelect(pFix, pExpr->pSelect) ){      return 1;    }    if( sqlite3FixExprList(pFix, pExpr->pList) ){      return 1;    }    if( sqlite3FixExpr(pFix, pExpr->pRight) ){      return 1;    }    pExpr = pExpr->pLeft;  }  return 0;}

int sqlite3FixTriggerStep(  DbFixer *pFix,       TriggerStep *pStep ){  while( pStep ){    if( sqlite3FixSelect(pFix, pStep->pSelect) ){      return 1;    }    if( sqlite3FixExpr(pFix, pStep->pWhere) ){      return 1;    }    if( sqlite3FixExprList(pFix, pStep->pExprList) ){      return 1;    }    pStep = pStep->pNext;  }  return 0;}

int sqlite3FixExpr(  DbFixer *pFix,       Expr *pExpr        ){  while( pExpr ){    if( ExprHasAnyProperty(pExpr, EP_TokenOnly) ) break;    if( ExprHasProperty(pExpr, EP_xIsSelect) ){      if( sqlite3FixSelect(pFix, pExpr->x.pSelect) ) return 1;    }else{      if( sqlite3FixExprList(pFix, pExpr->x.pList) ) return 1;    }    if( sqlite3FixExpr(pFix, pExpr->pRight) ){      return 1;    }    pExpr = pExpr->pLeft;  }  return 0;}

/*** The following set of routines walk through the parse tree and assign** a specific database to all table references where the database name** was left unspecified in the original SQL statement.  The pFix structure** must have been initialized by a prior call to sqlite3FixInit().**** These routines are used to make sure that an index, trigger, or** view in one database does not refer to objects in a different database.** (Exception: indices, triggers, and views in the TEMP database are** allowed to refer to anything.)  If a reference is explicitly made** to an object in a different database, an error message is added to** pParse->zErrMsg and these routines return non-zero.  If everything** checks out, these routines return 0.*/int sqlite3FixSrcList(  DbFixer *pFix,       /* Context of the fixation */  SrcList *pList       /* The Source list to check and modify */){  int i;  const char *zDb;  struct SrcList_item *pItem;  if( pList==0 ) return 0;  zDb = pFix->zDb;  for(i=0, pItem=pList->a; i<pList->nSrc; i++, pItem++){    if( pItem->zDatabase==0 ){      pItem->zDatabase = sqliteStrDup(zDb);    }else if( sqlite3StrICmp(pItem->zDatabase,zDb)!=0 ){      sqlite3ErrorMsg(pFix->pParse,         "%s %T cannot reference objects in database %s",         pFix->zType, pFix->pName, pItem->zDatabase);      return 1;    }    if( sqlite3FixSelect(pFix, pItem->pSelect) ) return 1;    if( sqlite3FixExpr(pFix, pItem->pOn) ) return 1;  }  return 0;}

/* ** This routine is called after all of the trigger actions have been parsed ** in order to complete the process of building the trigger. */SQLITE_PRIVATE void sqlite3FinishTrigger(                                         Parse *pParse,          /* Parser context */                                         TriggerStep *pStepList, /* The triggered program */                                         Token *pAll             /* Token that describes the complete CREATE TRIGGER */){    Trigger *pTrig = pParse->pNewTrigger;   /* Trigger being finished */    char *zName;                            /* Name of trigger */    sqlite3 *db = pParse->db;               /* The database */    DbFixer sFix;                           /* Fixer object */    int iDb;                                /* Database containing the trigger */    Token nameToken;                        /* Trigger name for error reporting */        pParse->pNewTrigger = 0;    if( NEVER(pParse->nErr) || !pTrig ) goto triggerfinish_cleanup;    zName = pTrig->zName;    iDb = sqlite3SchemaToIndex(pParse->db, pTrig->pSchema);    pTrig->step_list = pStepList;    while( pStepList ){        pStepList->pTrig = pTrig;        pStepList = pStepList->pNext;    }    nameToken.z = pTrig->zName;    nameToken.n = sqlite3Strlen30(nameToken.z);    sqlite3FixInit(&sFix, pParse, iDb, "trigger", &nameToken);    if( sqlite3FixTriggerStep(&sFix, pTrig->step_list)       || sqlite3FixExpr(&sFix, pTrig->pWhen)       ){        goto triggerfinish_cleanup;    }        /* if we are not initializing,     ** build the sqlite_master entry     */    if( !db->init.busy ){        Vdbe *v;        char *z;                /* Make an entry in the sqlite_master table */        v = sqlite3GetVdbe(pParse);        if( v==0 ) goto triggerfinish_cleanup;        sqlite3BeginWriteOperation(pParse, 0, iDb);        z = sqlite3DbStrNDup(db, (char*)pAll->z, pAll->n);        sqlite3NestedParse(pParse,                           "INSERT INTO %Q.%s VALUES('trigger',%Q,%Q,0,'CREATE TRIGGER %q')",                           db->aDb[iDb].zName, SCHEMA_TABLE(iDb), zName,                           pTrig->table, z);        sqlite3DbFree(db, z);        sqlite3ChangeCookie(pParse, iDb);        sqlite3VdbeAddParseSchemaOp(v, iDb,                                    sqlite3MPrintf(db, "type='trigger' AND name='%q'", zName));    }        if( db->init.busy ){        Trigger *pLink = pTrig;        Hash *pHash = &db->aDb[iDb].pSchema->trigHash;        assert( sqlite3SchemaMutexHeld(db, iDb, 0) );        pTrig = sqlite3HashInsert(pHash, zName, sqlite3Strlen30(zName), pTrig);        if( pTrig ){            db->mallocFailed = 1;        }else if( pLink->pSchema==pLink->pTabSchema ){            Table *pTab;            int n = sqlite3Strlen30(pLink->table);            pTab = sqlite3HashFind(&pLink->pTabSchema->tblHash, pLink->table, n);            assert( pTab!=0 );            pLink->pNext = pTab->pTrigger;            pTab->pTrigger = pLink;        }    }    triggerfinish_cleanup:    sqlite3DeleteTrigger(db, pTrig);    assert( !pParse->pNewTrigger );    sqlite3DeleteTriggerStep(db, pStepList);}