PHP dbx::get_table_triggers 예제들

예제 #1

파일: mssql10_diff_triggers.php 프로젝트: williammoran/DBSteward

 /**
  * Returns list of triggers that should be added.
  *
  * @param old_table original table
  * @param new_table new table
  *
  * @return list of triggers that should be added
  */
 private static function get_new_triggers($old_schema, $old_table, $new_schema, $new_table)
 {
     $list = array();
     if ($new_table != NULL) {
         if ($old_table == NULL) {
             $list = dbx::get_table_triggers($new_schema, $new_table);
         } else {
             foreach (dbx::get_table_triggers($new_schema, $new_table) as $new_trigger) {
                 $old_contains_new = FALSE;
                 $old_triggers = dbx::get_table_triggers($old_schema, $old_table);
                 foreach ($old_triggers as $old_trigger) {
                     if (mssql10_trigger::equals($old_trigger, $new_trigger)) {
                         $old_contains_new = TRUE;
                         break;
                     }
                 }
                 if (!$old_contains_new) {
                     $list[] = $new_trigger;
                 }
             }
         }
     }
     return $list;
 }

예제 #2

파일: sql99_diff_triggers.php 프로젝트: williammoran/DBSteward

 protected static function get_table_triggers($schema, $table)
 {
     return dbx::get_table_triggers($schema, $table);
 }

예제 #3

파일: pgsql8_diff_triggers.php 프로젝트: williammoran/DBSteward

 /**
  * Returns list of triggers that should be added.
  *
  * @param old_table original table
  * @param new_table new table
  *
  * @return list of triggers that should be added
  */
 private static function get_new_triggers($old_schema, $old_table, $new_schema, $new_table)
 {
     $list = array();
     if ($new_table != null) {
         if ($old_table == null) {
             $list = dbx::get_table_triggers($new_schema, $new_table);
         } else {
             foreach (dbx::get_table_triggers($new_schema, $new_table) as $new_trigger) {
                 $old_contains_new = false;
                 $old_triggers = dbx::get_table_triggers($old_schema, $old_table);
                 foreach ($old_triggers as $old_trigger) {
                     if (pgsql8_trigger::equals($old_trigger, $new_trigger)) {
                         $old_contains_new = true;
                         break;
                     }
                 }
                 if (!$old_contains_new) {
                     $list[] = $new_trigger;
                 }
             }
         }
     }
     return $list;
 }