Difference between revisions of "Database upgrade"

From OpenEMR Project Wiki
(Replaced content with "Upgrading ADODB to PDO. Todo: * Remove tables config & config_seq * Migrate category_to_document table")
 
Line 1: Line 1:
Upgrading ADODB to PDO.
Upgrading ADODB to PDO.


Remove all sqlFetchArray() calls.
Todo:


Example
  * Remove tables config & config_seq
<code>
  * Migrate category_to_document table
$res2 = sqlStatement("select * from lang_languages where lang_description = ?",array($GLOBALS['language_default']));
for ($iter = 0;$row = sqlFetchArray($res2);$iter++)
$result2[$iter] = $row;`
</code>
Becomes
<code>
  $result2 = sqlStatement("select * from lang_languages where lang_description = ?",array($GLOBALS['language_default']));
</code>
 
Change the while clause to a `foreach $x as $y`. Also remove the `sqlNumRows`
<code>
$lres = sqlStatement("SELECT * FROM list_options " .
  "WHERE list_id = 'lbfnames' AND activity = 1 ORDER BY seq, title");
if (sqlNumRows($lres)) {
  while ($lrow = sqlFetchArray($lres)) {
    $option_id = $lrow['option_id']; // should start with LBF
    $title = $lrow['title'];
    genMiscLink('RBot','cod','2',xl_form_title($title),
      "patient_file/encounter/load_form.php?formname=$option_id");
  }
  }
</code>
<code>
$lres = sqlStatement("SELECT * FROM list_options " .
  "WHERE list_id = 'lbfnames' AND activity = 1 ORDER BY seq, title");
if ($lres) {
  foreach ($lres as $lrow) {
    $option_id = $lrow['option_id']; // should start with LBF
    $title = $lrow['title'];
    genMiscLink('RBot','cod','2',xl_form_title($title),
      "patient_file/encounter/load_form.php?formname=$option_id");
  }
}
</code>

Latest revision as of 01:23, 3 November 2016

Upgrading ADODB to PDO.

Todo:

* Remove tables config & config_seq
* Migrate category_to_document table