Changeset 13150

Timestamp:

12/30/11 18:11:04 (1 year ago)

Author:

p_lindheimer

Message:

adds migration for recordingfile field in cdr table

Files:

• freepbx/branches/2.10/upgrades/2.10.0beta3/migration.php (modified) (1 diff)

freepbx/branches/2.10/upgrades/2.10.0beta3/migration.php

@@ -27 +27 @@
-  out("Not Required");
-}
+
+// added again here for alpha testerd uprgrading
+$sql = "SELECT sortorder FROM freepbx_settings";
+$confs = $db->getRow($sql, DB_FETCHMODE_ASSOC);
+if (DB::IsError($confs)) { // no error... Already done
+  $sql = "ALTER TABLE freepbx_settings ADD sortorder INT ( 11 ) NOT NULL DEFAULT 0";
+  $results = $db->query($sql);
+  if(DB::IsError($results)) {
+    die($results->getMessage());
+  }
+  out("Added field sortorder to freepbx_settings");
+}
+
+// Need to migrate the CDR table adding the recordingfile field. We get the creds from cdr_mysql.conf
+// since $amp_conf is not really authoritative.
+//
+$db_creds = parse_ini_file($amp_conf['ASTETCDIR'] . '/cdr_mysql.conf');
+if ($db_creds === false) {
+  out(_("Error parsing cdr_mysql.conf no migration done"));
+} else {
+  $db_creds['hostname'] = !empty($db_creds['hostname']) ? $db_creds['hostname'] : 'localhost';
+  $datasource = 'mysql://'
+    . $db_creds['user']
+    . ':'
+    . $db_creds['password']
+    . '@'
+    . $db_creds['hostname']
+    . '/'
+    . $db_creds['dbname'];
+  $db_cdr = DB::connect($datasource); // attempt connection
+
+  $sql = "desc cdr";
+  $sql = "select * from cdr";
+    //$results = $db_cdr->query($sql);
+    $results = $db_cdr->getAll($sql);
+
+  $sql = "SELECT recordingfile FROM cdr";
+  $confs = $db_cdr->getRow($sql, DB_FETCHMODE_ASSOC);
+  outn(_("checking if recordingfile file field needed in cdr.."));
+  if (DB::IsError($confs)) { // no error... Already done
+      $sql = "ALTER TABLE cdr ADD recordingfile VARCHAR ( 255 )";
+    $results = $db_cdr->query($sql);
+    if(DB::IsError($results)) {
+      out(_("failed"));
+      freepbx_log(FPBX_LOG_ERROR,"failed to add recordingfile filed to cdr table during migration");
+    }
+    out(_("added"));
+  } else {
+    out(_("already there"));
+  }
+}
-?>