Lines Matching refs:pTrigger
16910 Trigger *pTrigger; /* List of triggers stored in pSchema */ member
17945 Trigger *pTrigger; /* Trigger this program was coded from */ member
103504 static void renameWalkTrigger(Walker *pWalker, Trigger *pTrigger){
103508 sqlite3WalkExpr(pWalker, pTrigger->pWhen);
103511 for(pStep=pTrigger->step_list; pStep; pStep=pStep->pNext){
103861 Trigger *pTrigger = sParse.pNewTrigger;
103864 && sCtx.pTab->pSchema==pTrigger->pTabSchema
103872 renameWalkTrigger(&sWalker, pTrigger);
103873 for(pStep=pTrigger->step_list; pStep; pStep=pStep->pNext){
109436 Trigger *pTrigger;
109453 pTrigger = sqlite3TriggerList(pParse, pTab);
109454 while( pTrigger ){
109455 assert( pTrigger->pSchema==pTab->pSchema ||
109456 pTrigger->pSchema==db->aDb[1].pSchema );
109457 sqlite3DropTriggerPtr(pParse, pTrigger);
109458 pTrigger = pTrigger->pNext;
112301 Trigger *pTrigger; /* List of table triggers, if required */
112324 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_DELETE, 0, 0);
112327 # define pTrigger 0
112330 bComplex = pTrigger || sqlite3FkRequired(pParse, pTab, 0, 0);
112352 if( sqlite3IsReadOnly(pParse, pTab, (pTrigger?1:0)) ){
112363 assert(!isView || pTrigger);
112609 sqlite3GenerateRowDelete(pParse, pTab, pTrigger, iDataCur, iIdxCur,
112661 #ifdef pTrigger
112662 #undef pTrigger
112709 Trigger *pTrigger, /* List of triggers to (potentially) fire */
112742 if( sqlite3FkRequired(pParse, pTab, 0, 0) || pTrigger ){
112750 pParse, pTrigger, 0, 0, TRIGGER_BEFORE|TRIGGER_AFTER, pTab, onconf
112769 sqlite3CodeRowTrigger(pParse, pTrigger,
112828 sqlite3CodeRowTrigger(pParse, pTrigger,
115854 Trigger *p = pTop->pTriggerPrg->pTrigger;
116207 Trigger *pTrigger; /* Trigger definition to return */
116214 pTrigger = pFKey->apTrigger[iAction];
116216 if( action!=OE_None && !pTrigger ){
116323 pTrigger = (Trigger *)sqlite3DbMallocZero(db,
116328 if( pTrigger ){
116329 pStep = pTrigger->step_list = (TriggerStep *)&pTrigger[1];
116338 pTrigger->pWhen = sqlite3ExprDup(db, pWhen, EXPRDUP_REDUCE);
116350 fkTriggerDelete(db, pTrigger);
116367 pStep->pTrig = pTrigger;
116368 pTrigger->pSchema = pTab->pSchema;
116369 pTrigger->pTabSchema = pTab->pSchema;
116370 pFKey->apTrigger[iAction] = pTrigger;
116371 pTrigger->op = (pChanges ? TK_UPDATE : TK_DELETE);
116374 return pTrigger;
116997 Trigger *pTrigger; /* List of triggers on pTab, if required */
117037 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_INSERT, 0, &tmask);
117040 # define pTrigger 0
117048 assert( (pTrigger && tmask) || (pTrigger==0 && tmask==0) );
117068 sqlite3BeginWriteOperation(pParse, pSelect || pTrigger, iDb);
117081 assert( !pTrigger );
117179 if( pTrigger || readsTable(pParse, iDb, pTab) ){
117389 sqlite3CodeRowTrigger(pParse, pTrigger, TK_INSERT, 0, TRIGGER_BEFORE,
117508 bUseSeek = (isReplace==0 || (pTrigger==0 &&
117523 if( pTrigger ){
117525 sqlite3CodeRowTrigger(pParse, pTrigger, TK_INSERT, 0, TRIGGER_AFTER,
117577 #ifdef pTrigger
117578 #undef pTrigger
118016 Trigger *pTrigger = 0;
118018 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_DELETE, 0, 0);
118020 if( pTrigger || sqlite3FkRequired(pParse, pTab, 0, 0) ){
118022 sqlite3GenerateRowDelete(pParse, pTab, pTrigger, iDataCur, iIdxCur,
118270 Trigger *pTrigger = 0;
118273 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_DELETE, 0, 0);
118275 if( pTrigger || sqlite3FkRequired(pParse, pTab, 0, 0) ){
118278 sqlite3GenerateRowDelete(pParse, pTab, pTrigger, iDataCur, iIdxCur,
131509 pTrig->pNext = (pList ? pList : pTab->pTrigger);
131515 return (pList ? pList : pTab->pTrigger);
131538 Trigger *pTrigger = 0; /* The new trigger */
131686 pTrigger = (Trigger*)sqlite3DbMallocZero(db, sizeof(Trigger));
131687 if( pTrigger==0 ) goto trigger_cleanup;
131688 pTrigger->zName = zName;
131690 pTrigger->table = sqlite3DbStrDup(db, pTableName->a[0].zName);
131691 pTrigger->pSchema = db->aDb[iDb].pSchema;
131692 pTrigger->pTabSchema = pTab->pSchema;
131693 pTrigger->op = (u8)op;
131694 pTrigger->tr_tm = tr_tm==TK_BEFORE ? TRIGGER_BEFORE : TRIGGER_AFTER;
131696 sqlite3RenameTokenRemap(pParse, pTrigger->table, pTableName->a[0].zName);
131697 pTrigger->pWhen = pWhen;
131700 pTrigger->pWhen = sqlite3ExprDup(db, pWhen, EXPRDUP_REDUCE);
131702 pTrigger->pColumns = pColumns;
131705 pParse->pNewTrigger = pTrigger;
131713 sqlite3DeleteTrigger(db, pTrigger);
131715 assert( pParse->pNewTrigger==pTrigger );
131794 pLink->pNext = pTab->pTrigger;
131795 pTab->pTrigger = pLink;
131983 SQLITE_PRIVATE void sqlite3DeleteTrigger(sqlite3 *db, Trigger *pTrigger){
131984 if( pTrigger==0 ) return;
131985 sqlite3DeleteTriggerStep(db, pTrigger->step_list);
131986 sqlite3DbFree(db, pTrigger->zName);
131987 sqlite3DbFree(db, pTrigger->table);
131988 sqlite3ExprDelete(db, pTrigger->pWhen);
131989 sqlite3IdListDelete(db, pTrigger->pColumns);
131990 sqlite3DbFree(db, pTrigger);
132002 Trigger *pTrigger = 0;
132021 pTrigger = sqlite3HashFind(&(db->aDb[j].pSchema->trigHash), zName);
132022 if( pTrigger ) break;
132024 if( !pTrigger ){
132033 sqlite3DropTriggerPtr(pParse, pTrigger);
132043 static Table *tableOfTrigger(Trigger *pTrigger){
132044 return sqlite3HashFind(&pTrigger->pTabSchema->tblHash, pTrigger->table);
132051 SQLITE_PRIVATE void sqlite3DropTriggerPtr(Parse *pParse, Trigger *pTrigger){
132057 iDb = sqlite3SchemaToIndex(pParse->db, pTrigger->pSchema);
132059 pTable = tableOfTrigger(pTrigger);
132061 assert( pTable->pSchema==pTrigger->pSchema || iDb==1 );
132068 if( sqlite3AuthCheck(pParse, code, pTrigger->zName, pTable->zName, zDb) ||
132081 db->aDb[iDb].zDbSName, MASTER_NAME, pTrigger->zName
132084 sqlite3VdbeAddOp4(v, OP_DropTrigger, iDb, 0, 0, pTrigger->zName, 0);
132092 Trigger *pTrigger;
132097 pTrigger = sqlite3HashInsert(pHash, zName, 0);
132098 if( ALWAYS(pTrigger) ){
132099 if( pTrigger->pSchema==pTrigger->pTabSchema ){
132100 Table *pTab = tableOfTrigger(pTrigger);
132102 for(pp=&pTab->pTrigger; *pp!=pTrigger; pp=&((*pp)->pNext));
132105 sqlite3DeleteTrigger(db, pTrigger);
132319 Trigger *pTrigger, /* Trigger to code */
132333 assert( pTrigger->zName==0 || pTab==tableOfTrigger(pTrigger) );
132346 pPrg->pTrigger = pTrigger;
132360 pSubParse->zAuthContext = pTrigger->zName;
132361 pSubParse->eTriggerOp = pTrigger->op;
132368 pTrigger->zName, onErrorText(orconf),
132369 (pTrigger->tr_tm==TRIGGER_BEFORE ? "BEFORE" : "AFTER"),
132370 (pTrigger->op==TK_UPDATE ? "UPDATE" : ""),
132371 (pTrigger->op==TK_INSERT ? "INSERT" : ""),
132372 (pTrigger->op==TK_DELETE ? "DELETE" : ""),
132376 if( pTrigger->zName ){
132378 sqlite3MPrintf(db, "-- TRIGGER %s", pTrigger->zName), P4_DYNAMIC
132386 if( pTrigger->pWhen ){
132387 pWhen = sqlite3ExprDup(db, pTrigger->pWhen, 0);
132398 codeTriggerProgram(pSubParse, pTrigger->step_list, orconf);
132405 VdbeComment((v, "End: %s.%s", pTrigger->zName, onErrorText(orconf)));
132413 pProgram->token = (void *)pTrigger;
132435 Trigger *pTrigger, /* Trigger to code */
132442 assert( pTrigger->zName==0 || pTab==tableOfTrigger(pTrigger) );
132449 pPrg && (pPrg->pTrigger!=pTrigger || pPrg->orconf!=orconf);
132455 pPrg = codeRowTrigger(pParse, pTrigger, pTab, orconf);
132541 Trigger *pTrigger, /* List of triggers on table pTab */
132556 for(p=pTrigger; p; p=p->pNext){
132603 Trigger *pTrigger, /* List of triggers on table pTab */
132615 for(p=pTrigger; p; p=p->pNext){
132815 Trigger *pTrigger; /* List of triggers on pTab, if required */
132853 pTrigger = sqlite3TriggersExist(pParse, pTab, TK_UPDATE, pChanges, &tmask);
132855 assert( pTrigger || tmask==0 );
132857 # define pTrigger 0
133024 sqlite3BeginWriteOperation(pParse, pTrigger || hasFK, iDb);
133030 if( chngPk || pTrigger || hasFK ){
133034 if( chngKey || pTrigger || hasFK ){
133123 if( !pParse->nested && !pTrigger && !hasFK && !chngKey && !bReplace ){
133235 assert( chngKey || pTrigger || hasFK || regOldRowid==regNewRowid );
133243 if( chngPk || hasFK || pTrigger ){
133246 pTrigger, pChanges, 0, TRIGGER_BEFORE|TRIGGER_AFTER, pTab, onError
133278 pParse, pTrigger, pChanges, 1, TRIGGER_BEFORE, pTab, onError
133307 sqlite3CodeRowTrigger(pParse, pTrigger, TK_UPDATE, pChanges,
133421 sqlite3CodeRowTrigger(pParse, pTrigger, TK_UPDATE, pChanges,
133476 #ifdef pTrigger
133477 #undef pTrigger
