defaria.com/blogs/Status/2004/08/new-trigger.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content="Here are the requirements as I understand them for the trigger that Steve Lipson wants for the SQL checkins. Basically he desires a trigger that will capture the checkin comment and other information and insert that information in the form...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>New Trigger - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2004/08/new-trigger.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2004/08/server-move-con.html" title="Server move (cont)">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2004/08/commentsqlcode.html" title="CommentSQLCode Trigger">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="New Trigger">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2004/08/new-trigger.html">
  26     <meta property="og:description" content="Here are the requirements as I understand them for the trigger that Steve Lipson wants for the SQL checkins. Basically he desires a trigger that will capture the checkin comment and other information and insert that information in the form...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content="Here are the requirements as I understand them for the trigger that Steve Lipson wants for the SQL checkins. Basically he desires a trigger that will capture the checkin comment and other information and insert that information in the form...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2004/08/new-trigger.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">New Trigger</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1499" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">New Trigger</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2004-08-03T18:54:16-08:00" itemprop="datePublished">August  3, 2004</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <p>Here are the requirements as I understand them for the trigger that Steve Lipson wants for the SQL checkins. Basically he desires a trigger that will capture the checkin comment and other information and insert that information in the form of a comment at the top of the checked in element. This trigger will:</p>
  85
  86 <ul>
  87   <li>Be a postop trigger for the checkin action</li>
  88   <li><b>Not</b> be an all element trigger rather it will be attached to certain file elements in the vob</li>
  89   <li>Be made for the &lt;<i>fill in vob name here</i>&gt; vob</li>
  90   <li>Only work on file elements - directory elements are to be skipped</li>
  91   <li>Only work on file elements that have an extension of .sql - other elements will be skipped</li>
  92 </ul>
  93
  94 <p>Roughly the psuedo code for this trigger will be:</p>
  95
  96 <div class="code"><pre>
  97 # Get name of element and its type
  98 $pname        = $ENV{CLEARCASE_PN};
  99 $element_type = $ENV{CLEARCASE_ELTYPE};
 100
 101 # Skip directories and elements that aren't .sql
 102 exit if $element_type =~ /directory/i || $pname !~ /\.sql$/i;
 103
 104 # Get comment and user
 105 $comment   = $ENV{CLEARCASE_COMMENT};
 106 $userid    = $ENV{CLEARCASE_USER};
 107
 108 # Format timestamp
 109 $timestamp = getCurrentTime;
 110
 111 # Parse output of lsactivity -cact -long
 112 ($activity_id, $activity_title, $activity_owner) = parseLSActivity;
 113
 114 # Open up $pname for reading and $pname.trig for writting
 115 open PNAME_IN, $pname
 116   or die "Unable to open $pname for reading - $!\n";
 117
 118 open PNAME_OUT, ">$pname.trig"
 119   or dir "Unable to open $pname.trig for writing - $!\n";
 120
 121 # Add comment to top of file
 122 print $PNAME_OUT &lt;&lt;END;
 123 -- Date:            $timestamp
 124 -- Activity: $activity_id: $activity_title
 125 -- Owner:    $activity_owner ($userid)
 126 -- Comment:  $comment
 127 END
 128
 129 # Append $pname
 130 while (<PNAME_IN>) {
 131   print PNAME_OUT $_;
 132 } # while
 133
 134 close PNAME;
 135 close PNAME_OUT;
 136
 137 # Switch $pname.trig -> $pname
 138 unlink $pname;
 139 rename "$pname.trig", $pname;
 140
 141 # Allow checkin to proceed
 142 exit 0;
 143 </pre></div>
 144
 145                 </div>
 146                 <nav class="page-navigation entry-navigation pagination content-nav">
 147                   <ul class="page-navigation-list">
 148
 149                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2004/08/server-move-con.html" title="Server move (cont)">Previous entry</a></li>
 150
 151
 152                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2004/08/commentsqlcode.html" title="CommentSQLCode Trigger">Next entry</a></li>
 153
 154                   </ul>
 155                 </nav>
 156                 <!--
 157 <aside id="zenback" class="zenback feedback">
 158   Please paste Zenback script code here.
 159 </aside>
 160 -->
 161
 162
 163               </article>
 164             </div>
 165             <aside class="widgets related" role="complementary">
 166               <nav class="widget-search widget">
 167   <div class="widget-content">
 168     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 169       <div>
 170         <input type="text" name="search" value="" placeholder="Search...">
 171
 172         <input type="hidden" name="IncludeBlogs" value="8">
 173
 174         <input type="hidden" name="limit" value="20">
 175         <button type="submit" name="button">
 176           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 177         </button>
 178       </div>
 179     </form>
 180   </div>
 181 </nav>
 182 <nav class="widget-archive-category widget">
 183   <h3 class="widget-header">Categories</h3>
 184   <div class="widget-content">
 185
 186
 187     <ul class="widget-list">
 188
 189
 190       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 191
 192
 193       </li>
 194
 195
 196
 197
 198       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 199
 200
 201       </li>
 202
 203
 204
 205
 206       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 207
 208
 209       </li>
 210
 211
 212
 213
 214       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 215
 216
 217       </li>
 218
 219
 220
 221
 222       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 223
 224
 225       </li>
 226
 227
 228
 229
 230       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 231
 232
 233       </li>
 234
 235
 236
 237
 238       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 239
 240
 241       </li>
 242
 243
 244
 245
 246       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 247
 248
 249       </li>
 250
 251
 252
 253
 254       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 255
 256
 257       </li>
 258
 259
 260
 261
 262       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 263
 264
 265       </li>
 266
 267
 268
 269
 270       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 271
 272
 273       </li>
 274
 275
 276
 277
 278       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 279
 280
 281       </li>
 282
 283     </ul>
 284
 285
 286   </div>
 287 </nav>
 288
 289
 290 <nav class="widget-archive-dropdown widget">
 291   <h3 class="widget-header">Archives</h3>
 292   <div class="widget-content">
 293     <select>
 294       <option>Select a Month...</option>
 295
 296       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 297
 298
 299
 300       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 301
 302
 303
 304       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 305
 306
 307
 308       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 309
 310
 311
 312       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 313
 314
 315
 316       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 317
 318
 319
 320       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 321
 322
 323
 324       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 325
 326
 327
 328       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 329
 330
 331
 332       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 333
 334
 335
 336       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 337
 338
 339
 340       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 341
 342
 343
 344       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 345
 346
 347
 348       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 349
 350
 351
 352       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 353
 354
 355
 356       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 357
 358
 359
 360       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 361
 362
 363
 364       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 365
 366
 367
 368       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 369
 370
 371
 372       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 373
 374
 375
 376       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 557
 558
 559
 560       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 561
 562
 563
 564       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 565
 566
 567
 568       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 569
 570
 571
 572       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 573
 574
 575
 576       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 577
 578
 579
 580       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 581
 582     </select>
 583   </div>
 584 </nav>
 585
 586
 587
 588 <div class="widget-syndication widget section">
 589   <div class="widget-content">
 590     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 591
 592   </div>
 593 </div>
 594
 595             </aside>
 596           </div>
 597         </div>
 598         <footer id="footer" role="contentinfo">
 599           <div id="footer-inner">
 600             <div id="footer-content">
 601   <nav role="navigation">
 602           <ul>
 603             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 604
 605
 606           </ul>
 607         </nav>
 608
 609   <p class="license">&copy; Copyright 2016.</p>
 610   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 611 </div>
 612           </div>
 613         </footer>
 614       </div>
 615     </div>
 616     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 617     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 618   </body>
 619 </html>