Changeset 9239

Timestamp:

03/16/10 20:54:36 (3 years ago)

Author:

p_lindheimer

Message:

add code to migrate from localprefixes.conf if they never did before here re #4144

Files:

• freepbx/trunk/upgrades/2.8.0alpha2/tables.php (modified) (2 diffs)

freepbx/trunk/upgrades/2.8.0alpha2/tables.php

@@ -43 +43 @@
-) 
-";
+
+// Before doing anything, migrate check if we need to migrate from a state where no local prefix tables existed
+// if not, this will do nothing...
+//
+__migrate_legacy_localprefix();
+
-outn(_("Checking if trunk_dialpatterns table exists.."));
-$check = $db->query($trunk_dialpatterns);
@@ -110 +116 @@
-  }
-}
+
+//----------------------------------------------------------------------------------------------
+// Legacy migration if no tables existed prior to get info from localprefixes.conf
+
+/* If localprefixes.conf exists and there is no trunk_dialpatterns OR trunks_dialpatterns then we
+   are in an upgrade situation where the never had either since these were upgraded in core
+   originally so they won't have gone through the sequential upgrade migrations. So, we'll just yank
+   the orignal code from core's install and go though the silliness of upgrading to the old table
+   which we will then go and blow away.
+ */
+function __migrate_legacy_localprefix() {
+  global $db;
+  global $amp_conf;
+
+  // Is the old table there?
+  $test = 'SELECT trunkid FROM trunks_dialpatterns LIMIT 1';
+  $check = $db->getRow($test, DB_FETCHMODE_ASSOC);
+  if(!DB::IsError($check)) {
+    return true;
+  }
+  // Is the new table there?
+  $test = 'SELECT trunkid FROM trunk_dialpatterns LIMIT 1';
+  $check = $db->getRow($test, DB_FETCHMODE_ASSOC);
+  if(!DB::IsError($check)) {
+    return true;
+  }
+  //Neither table, is there a fixlocalprefixes.conf file?
+  $localPrefixFile = $amp_conf['ASTETCDIR']."/localprefixes.conf";
+  $conf == array();
+  __parse_DialRulesFile($localPrefixFile, $conf, $section);
+  if (count($conf) == 0) {
+    return true;
+  }
+
+  // At this point, we have not tables a localprefixes file with something in it
+  //
+  $sql = "
+  CREATE TABLE `trunks_dialpatterns` 
+  ( 
+    `trunkid` INTEGER,
+    `rule` VARCHAR( 255 ) NOT NULL, 
+    `seq` INTEGER,
+    PRIMARY KEY  (`trunkid`, `rule`, `seq`) 
+  ) 
+  ";
+  outn(_("Checking if trunks_dialpatterns table exists.."));
+  $check = $db->query($sql);
+  if(DB::IsError($check) && $check->getCode() != DB_ERROR_ALREADY_EXISTS) {
+    die_freepbx("Can not create trunks_dialpatterns table");
+  } else if(DB::IsError($check) && $check->getCode() == DB_ERROR_ALREADY_EXISTS) {
+    out(_("already exists"));
+  } else {
+    out(_("created"));
+    outn(_("loading table from localprefixes.conf.."));
+    $rules_arr = array();
+    foreach ($conf as $tname => $rules) {
+      $tid = ltrim($tname,'trunk-');
+    uksort($rules,'__order_DialRules'); //make sure they are in order
+      $seq = 1;
+      foreach ($rules as $rule) {
+        $rules_arr[] = array($tid,$rule,$seq);
+        $seq++;
+      }
+    }
+    $compiled = $db->prepare("INSERT INTO `trunks_dialpatterns` (trunkid, rule, seq) VALUES (?,?,?)");
+    $result = $db->executeMultiple($compiled,$rules_arr);
+    if(DB::IsError($result)) {
+      die_freepbx($result->getDebugInfo().'error populating trunks_dialpatterns table');  
+    }
+    out(_("loaded"));
+  }
+}
+function __order_DialRules($a, $b) {
+  return substr($a,4) > substr($b,4);
+}
+// Get values from localprefix configuration file where values are stored
+// for fixlocalprefix macro
+//
+function __parse_DialRulesFile($filename, &$conf, &$section) {
+  if (is_null($conf)) {
+    $conf = array();
+  }
+  if (is_null($section)) {
+    $section = "general";
+  }
+  
+  if (file_exists($filename)) {
+    $fd = fopen($filename, "r");
+    while ($line = fgets($fd, 1024)) {
+      if (preg_match("/^\s*([a-zA-Z0-9-_]+)\s*=\s*(.*?)\s*([;#].*)?$/",$line,$matches)) {
+        // name = value
+        // option line
+        $conf[$section][ $matches[1] ] = $matches[2];
+      } else if (preg_match("/^\s*\[(.+)\]/",$line,$matches)) {
+        // section name
+        $section = strtolower($matches[1]);
+      } else if (preg_match("/^\s*#include\s+(.*)\s*([;#].*)?/",$line,$matches)) {
+        // include another file
+        
+        if ($matches[1][0] == "/") {
+          // absolute path
+          $filename = $matches[1];
+        } else {
+          // relative path
+          $filename =  dirname($filename)."/".$matches[1];
+        }
+        __parse_DialRulesFile($filename, $conf, $section);
+      }
+    }
+  }
+}