Lines Matching refs:pTrigger
17221 Trigger *pTrigger; /* List of triggers on this object */ member
18409 Trigger *pTrigger; /* Trigger this program was coded from */ member
109371 static void renameWalkTrigger(Walker *pWalker, Trigger *pTrigger){
109375 sqlite3WalkExpr(pWalker, pTrigger->pWhen);
109378 for(pStep=pTrigger->step_list; pStep; pStep=pStep->pNext){
109761 Trigger *pTrigger = sParse.pNewTrigger;
109764 && sCtx.pTab->pSchema==pTrigger->pTabSchema
109772 renameWalkTrigger(&sWalker, pTrigger);
109773 for(pStep=pTrigger->step_list; pStep; pStep=pStep->pNext){
116373 Trigger *pTrigger;
116390 pTrigger = sqlite3TriggerList(pParse, pTab);
116391 while( pTrigger ){
116392 assert( pTrigger->pSchema==pTab->pSchema ||
116393 pTrigger->pSchema==db->aDb[1].pSchema );
116394 sqlite3DropTriggerPtr(pParse, pTrigger);
116395 pTrigger = pTrigger->pNext;
119485 Trigger *pTrigger; /* List of table triggers, if required */
119508 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_DELETE, 0, 0);
119511 # define pTrigger 0
119514 bComplex = pTrigger || sqlite3FkRequired(pParse, pTab, 0, 0);
119536 if( sqlite3IsReadOnly(pParse, pTab, (pTrigger?1:0)) ){
119547 assert(!isView || pTrigger);
119796 sqlite3GenerateRowDelete(pParse, pTab, pTrigger, iDataCur, iIdxCur,
119848 #ifdef pTrigger
119849 #undef pTrigger
119896 Trigger *pTrigger, /* List of triggers to (potentially) fire */
119929 if( sqlite3FkRequired(pParse, pTab, 0, 0) || pTrigger ){
119937 pParse, pTrigger, 0, 0, TRIGGER_BEFORE|TRIGGER_AFTER, pTab, onconf
119957 sqlite3CodeRowTrigger(pParse, pTrigger,
120016 sqlite3CodeRowTrigger(pParse, pTrigger,
123405 Trigger *p = pTop->pTriggerPrg->pTrigger;
123764 Trigger *pTrigger; /* Trigger definition to return */
123771 pTrigger = pFKey->apTrigger[iAction];
123773 if( action!=OE_None && !pTrigger ){
123888 pTrigger = (Trigger *)sqlite3DbMallocZero(db,
123893 if( pTrigger ){
123894 pStep = pTrigger->step_list = (TriggerStep *)&pTrigger[1];
123903 pTrigger->pWhen = sqlite3ExprDup(db, pWhen, EXPRDUP_REDUCE);
123915 fkTriggerDelete(db, pTrigger);
123919 assert( pTrigger!=0 );
123934 pStep->pTrig = pTrigger;
123935 pTrigger->pSchema = pTab->pSchema;
123936 pTrigger->pTabSchema = pTab->pSchema;
123937 pFKey->apTrigger[iAction] = pTrigger;
123938 pTrigger->op = (pChanges ? TK_UPDATE : TK_DELETE);
123941 return pTrigger;
124733 Trigger *pTrigger; /* List of triggers on pTab, if required */
124773 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_INSERT, 0, &tmask);
124776 # define pTrigger 0
124784 assert( (pTrigger && tmask) || (pTrigger==0 && tmask==0) );
124804 sqlite3BeginWriteOperation(pParse, pSelect || pTrigger, iDb);
124817 assert( !pTrigger );
124931 if( pTrigger || readsTable(pParse, iDb, pTab) ){
125253 sqlite3CodeRowTrigger(pParse, pTrigger, TK_INSERT, 0, TRIGGER_BEFORE,
125360 if( pTrigger ){
125362 sqlite3CodeRowTrigger(pParse, pTrigger, TK_INSERT, 0, TRIGGER_AFTER,
125425 #ifdef pTrigger
125426 #undef pTrigger
125687 Trigger *pTrigger; /* List of DELETE triggers on the table pTab */
125971 pTrigger = 0;
125975 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_DELETE, 0, 0);
125976 regTrigCnt = pTrigger!=0 || sqlite3FkRequired(pParse, pTab, 0, 0);
125978 pTrigger = 0;
126093 sqlite3GenerateRowDelete(pParse, pTab, pTrigger, iDataCur, iIdxCur,
126364 if( pTrigger && isUpdate ){
126367 sqlite3GenerateRowDelete(pParse, pTab, pTrigger, iDataCur, iIdxCur,
126370 if( pTrigger && isUpdate ){
141044 pList = pTab->pTrigger;
141102 Trigger *pTrigger = 0; /* The new trigger */
141243 pTrigger = (Trigger*)sqlite3DbMallocZero(db, sizeof(Trigger));
141244 if( pTrigger==0 ) goto trigger_cleanup;
141245 pTrigger->zName = zName;
141247 pTrigger->table = sqlite3DbStrDup(db, pTableName->a[0].zName);
141248 pTrigger->pSchema = db->aDb[iDb].pSchema;
141249 pTrigger->pTabSchema = pTab->pSchema;
141250 pTrigger->op = (u8)op;
141251 pTrigger->tr_tm = tr_tm==TK_BEFORE ? TRIGGER_BEFORE : TRIGGER_AFTER;
141253 sqlite3RenameTokenRemap(pParse, pTrigger->table, pTableName->a[0].zName);
141254 pTrigger->pWhen = pWhen;
141257 pTrigger->pWhen = sqlite3ExprDup(db, pWhen, EXPRDUP_REDUCE);
141259 pTrigger->pColumns = pColumns;
141262 pParse->pNewTrigger = pTrigger;
141270 sqlite3DeleteTrigger(db, pTrigger);
141272 assert( pParse->pNewTrigger==pTrigger );
141370 pLink->pNext = pTab->pTrigger;
141371 pTab->pTrigger = pLink;
141567 SQLITE_PRIVATE void sqlite3DeleteTrigger(sqlite3 *db, Trigger *pTrigger){
141568 if( pTrigger==0 || pTrigger->bReturning ) return;
141569 sqlite3DeleteTriggerStep(db, pTrigger->step_list);
141570 sqlite3DbFree(db, pTrigger->zName);
141571 sqlite3DbFree(db, pTrigger->table);
141572 sqlite3ExprDelete(db, pTrigger->pWhen);
141573 sqlite3IdListDelete(db, pTrigger->pColumns);
141574 sqlite3DbFree(db, pTrigger);
141586 Trigger *pTrigger = 0;
141605 pTrigger = sqlite3HashFind(&(db->aDb[j].pSchema->trigHash), zName);
141606 if( pTrigger ) break;
141608 if( !pTrigger ){
141617 sqlite3DropTriggerPtr(pParse, pTrigger);
141627 static Table *tableOfTrigger(Trigger *pTrigger){
141628 return sqlite3HashFind(&pTrigger->pTabSchema->tblHash, pTrigger->table);
141635 SQLITE_PRIVATE void sqlite3DropTriggerPtr(Parse *pParse, Trigger *pTrigger){
141641 iDb = sqlite3SchemaToIndex(pParse->db, pTrigger->pSchema);
141643 pTable = tableOfTrigger(pTrigger);
141644 assert( (pTable && pTable->pSchema==pTrigger->pSchema) || iDb==1 );
141651 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
141663 db->aDb[iDb].zDbSName, pTrigger->zName
141666 sqlite3VdbeAddOp4(v, OP_DropTrigger, iDb, 0, 0, pTrigger->zName, 0);
141674 Trigger *pTrigger;
141679 pTrigger = sqlite3HashInsert(pHash, zName, 0);
141680 if( ALWAYS(pTrigger) ){
141681 if( pTrigger->pSchema==pTrigger->pTabSchema ){
141682 Table *pTab = tableOfTrigger(pTrigger);
141685 for(pp=&pTab->pTrigger; *pp; pp=&((*pp)->pNext)){
141686 if( *pp==pTrigger ){
141693 sqlite3DeleteTrigger(db, pTrigger);
141739 && pTab->pTrigger!=0
141744 if( pList==pTab->pTrigger ){
141748 while( ALWAYS(p->pNext) && p->pNext!=pTab->pTrigger ) p = p->pNext;
141892 Trigger *pTrigger, /* The trigger step that defines the RETURNING */
141906 assert( pTrigger == &(pReturning->retTrig) );
141930 pParse->eTriggerOp = pTrigger->op;
142083 Trigger *pTrigger, /* Trigger to code */
142097 assert( pTrigger->zName==0 || pTab==tableOfTrigger(pTrigger) );
142110 pPrg->pTrigger = pTrigger;
142124 pSubParse->zAuthContext = pTrigger->zName;
142125 pSubParse->eTriggerOp = pTrigger->op;
142132 pTrigger->zName, onErrorText(orconf),
142133 (pTrigger->tr_tm==TRIGGER_BEFORE ? "BEFORE" : "AFTER"),
142134 (pTrigger->op==TK_UPDATE ? "UPDATE" : ""),
142135 (pTrigger->op==TK_INSERT ? "INSERT" : ""),
142136 (pTrigger->op==TK_DELETE ? "DELETE" : ""),
142140 if( pTrigger->zName ){
142142 sqlite3MPrintf(db, "-- TRIGGER %s", pTrigger->zName), P4_DYNAMIC
142150 if( pTrigger->pWhen ){
142151 pWhen = sqlite3ExprDup(db, pTrigger->pWhen, 0);
142162 codeTriggerProgram(pSubParse, pTrigger->step_list, orconf);
142169 VdbeComment((v, "End: %s.%s", pTrigger->zName, onErrorText(orconf)));
142177 pProgram->token = (void *)pTrigger;
142198 Trigger *pTrigger, /* Trigger to code */
142205 assert( pTrigger->zName==0 || pTab==tableOfTrigger(pTrigger) );
142212 pPrg && (pPrg->pTrigger!=pTrigger || pPrg->orconf!=orconf);
142218 pPrg = codeRowTrigger(pParse, pTrigger, pTab, orconf);
142304 Trigger *pTrigger, /* List of triggers on table pTab */
142319 for(p=pTrigger; p; p=p->pNext){
142374 Trigger *pTrigger, /* List of triggers on table pTab */
142386 for(p=pTrigger; p; p=p->pNext){
142734 Trigger *pTrigger; /* List of triggers on pTab, if required */
142773 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_UPDATE, pChanges, &tmask);
142775 assert( pTrigger || tmask==0 );
142777 # define pTrigger 0
142999 sqlite3BeginWriteOperation(pParse, pTrigger || hasFK, iDb);
143011 if( chngPk || pTrigger || hasFK ){
143015 if( chngKey || pTrigger || hasFK ){
143130 if( !pParse->nested && !pTrigger && !hasFK && !chngKey && !bReplace ){
143275 assert( chngKey || pTrigger || hasFK || regOldRowid==regNewRowid );
143288 if( chngPk || hasFK || pTrigger ){
143291 pTrigger, pChanges, 0, TRIGGER_BEFORE|TRIGGER_AFTER, pTab, onError
143325 pParse, pTrigger, pChanges, 1, TRIGGER_BEFORE, pTab, onError
143370 sqlite3CodeRowTrigger(pParse, pTrigger, TK_UPDATE, pChanges,
143503 sqlite3CodeRowTrigger(pParse, pTrigger, TK_UPDATE, pChanges,
143556 #ifdef pTrigger
143557 #undef pTrigger