Changeset 5503 for trunk

Timestamp:

Mar 31, 2010, 8:16:27 PM (14 years ago)

Author:

nikrou

Message:

Feature 1559 : remove custom function (std) for sqlite

Location:

trunk/include/dblayer

Files:

• functions_pdo-sqlite.inc.php (modified) (2 diffs)
• functions_sqlite.inc.php (modified) (2 diffs)

trunk/include/dblayer/functions_pdo-sqlite.inc.php

@@ -51 +51 @@
   $link->sqliteCreateFunction('if', 'pwg_if', 3);
 
-  $link->sqliteCreateAggregate('std', 'pwg_std_step', 'pwg_std_finalize');
   $link->sqliteCreateFunction('regexp', 'pwg_regexp', 2);
 
@@ -567 +566 @@
   return preg_match($pattern, $string);
 }
-
-function pwg_std_step(&$values, $rownumber, $value) 
-{
-  $values[] = $value;
-
-  return $values;
-}
-
-function pwg_std_finalize(&$values, $rownumber) 
-{
-  if (count($values)<=1)
-  {
-    return 0;
-  }
-
-  $total = 0;
-  $total_square = 0;
-  foreach ($values as $value)
-  {
-    $total += $value;
-    $total_square += pow($value, 2);
-  }
-
-  $mean = $total/count($values);
-  $var = $total_square/count($values) - pow($mean, 2);
-  
-  return sqrt($var);
-}
 ?>

trunk/include/dblayer/functions_sqlite.inc.php

@@ -60 +60 @@
   $link->createFunction('if', 'pwg_if', 3);
 
-  $link->createAggregate('std', 'pwg_std_step', 'pwg_std_finalize');
   $link->createFunction('regexp', 'pwg_regexp', 2);
 
@@ -579 +578 @@
   return preg_match($pattern, $string);
 }
-
-function pwg_std_step(&$values, $rownumber, $value) 
-{
-  $values[] = $value;
-
-  return $values;
-}
-
-function pwg_std_finalize(&$values, $rownumber) 
-{
-  if (count($values)<=1)
-  {
-    return 0;
-  }
-
-  $total = 0;
-  $total_square = 0;
-  foreach ($values as $value)
-  {
-    $total += $value;
-    $total_square += pow($value, 2);
-  }
-
-  $mean = $total/count($values);
-  $var = $total_square/count($values) - pow($mean, 2);
-  
-  return sqrt($var);
-}
 ?>