Changeset 9131

Timestamp:

03/11/10 15:29:16 (2 years ago)

Author:

p_lindheimer

Message:

enable the outbound routes migration code re #4110

Files:

• freepbx/trunk/upgrades/2.8.0alpha1/tables.php (modified) (3 diffs)

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

@@ -2 +2 @@
-global $amp_conf;
-global $db;
-
-// TODO: exit here for now. This will be migration code for new routes once the work is finished.
-return true;
-
-//TODO: DEBUG remove and restart for testing
-//
-$result = $db->query("DROP TABLE IF EXISTS `outbound_routes`");
-$result = $db->query("DROP TABLE IF EXISTS `outbound_route_patterns`");
-$result = $db->query("DROP TABLE IF EXISTS `outbound_route_trunks`");
-$result = $db->query("DROP TABLE IF EXISTS `outbound_route_sequence`");
-
-$outbound_routes = "
@@ -122 +112 @@
-        }
-        // assumption here is that routepriorities always return in order, I think that is correct, which means we inserted in order
-        // TODO: update existing pinsets here whether enabled or not
-        $seq = 0;
-        $outbound_route_sequence = array();
@@ -180 +169 @@
-        }
-
+        outn('Updating route sequence..');
-        $compiled = $db->prepare('INSERT INTO `outbound_route_sequence` (`route_id`, `seq`) values (?,?)');
-        $result = $db->executeMultiple($compiled,$outbound_route_sequence);
-        if(DB::IsError($result)) {
-          out("FATAL: ".$result->getDebugInfo()."\n".'error inserting into outbound_route_sequence table'); 
+        } else {
+          out("ok");
+          outn('Removing old extenions table..');
+          //TODO: add removal code once thoroughly tested
+          out("not implemented until thouroghly tested");
-        }
-      }