/drupal7/sites/all/modules/date/date_api/date_api_sql.inc - Diff - Club Drupal - Forge Centrale Marseille

Révision b720ea3e

Ajouté par Assos Assos il y a plus de 8 ans

ID b720ea3e228dedd3fb885a701de1fa3594e3feef
Parent 2b6d131e
Enfant a6e869e4

Weekly update of contrib modules

       switch (Database::getConnection()->databaseType()) {
         case 'mysql':
           return "CONCAT(" . implode(",", $array) . ")";
         case 'pgsql':
           return implode(" || ", $array);
+      }
+    }
     /**
      * Helper function to do cross-database NULL replacements
      * Helper function to do cross-database NULL replacements.
+     *
      * @param array $array
      *   An array of values to test for NULL values.
-...
       switch ($side) {
         case 'r':
           return "RPAD($str, $size, '$pad')";
         default:
           return "LPAD($str, $size, '$pad')";
+      }
-...
     /**
      * A class to manipulate date SQL.
      */
     // @codingStandardsIgnoreStart
     class date_sql_handler {
       var $db_type = NULL;
       var $date_type = DATE_DATETIME;
-...
       /**
        * The object constuctor.
        */
       function __construct($date_type = DATE_DATETIME, $local_timezone = NULL, $offset = '+00:00') {
       public function __construct($date_type = DATE_DATETIME, $local_timezone = NULL, $offset = '+00:00') {
         $this->db_type = Database::getConnection()->databaseType();
         $this->date_type = $date_type;
         $this->db_timezone = 'UTC';
-...
       /**
        * See if the db has timezone name support.
        */
       function db_tz_support($reset = FALSE) {
       public function db_tz_support($reset = FALSE) {
         $has_support = variable_get('date_db_tz_support', -1);
         if ($has_support == -1 || $reset) {
           $has_support = FALSE;
-...
                 $has_support = TRUE;
+              }
               break;
             case 'pgsql':
               $test = db_query("SELECT '2008-02-15 12:00:00 UTC' AT TIME ZONE 'US/Central'")->fetchField();
               if ($test == '2008-02-15 06:00:00') {
-...
        *   set a fixed offset, not a timezone, so any value other than
        *   '+00:00' should be used with caution.
        */
       function set_db_timezone($offset = '+00:00') {
       public function set_db_timezone($offset = '+00:00') {
         static $already_set = FALSE;
         $type = Database::getConnection()->databaseType();
         if (!$already_set) {
-...
             case 'mysql':
               db_query("SET @@session.time_zone = '$offset'");
               break;
             case 'pgsql':
               db_query("SET TIME ZONE INTERVAL '$offset' HOUR TO MINUTE");
               break;
             case 'sqlsrv':
               // Issue #1201342, This is the wrong way to set the timezone, this
               // still needs to be fixed. In the meantime, commenting this out makes
-...
       /**
        * Return timezone offset for the date being processed.
        */
       function get_offset($comp_date = NULL) {
       public function get_offset($comp_date = NULL) {
         if (!empty($this->db_timezone) && !empty($this->local_timezone)) {
           if ($this->db_timezone != $this->local_timezone) {
             if (empty($comp_date)) {
-...
               case DATE_UNIX:
                 $field = "FROM_UNIXTIME($field)";
                 break;
               case DATE_ISO:
                 $field = "STR_TO_DATE($field, '%Y-%m-%dT%T')";
                 break;
               case DATE_DATETIME:
                 break;
+            }
             break;
           case 'pgsql':
             switch ($this->date_type) {
               case DATE_UNIX:
                 $field = "$field::ABSTIME";
                 break;
               case DATE_ISO:
                 $field = "TO_DATE($field, 'FMYYYY-FMMM-FMDDTFMHH24:FMMI:FMSS')";
                 break;
               case DATE_DATETIME:
                 break;
+            }
             break;
           case 'sqlite':
             switch ($this->date_type) {
               case DATE_UNIX:
                 $field = "datetime($field, 'unixepoch')";
                 break;
               case DATE_ISO:
               case DATE_DATETIME:
                 $field = "datetime($field)";
                 break;
+            }
             break;
           case 'sqlsrv':
             switch ($this->date_type) {
               case DATE_UNIX:
                 $field = "DATEADD(s, $field, '19700101 00:00:00:000')";
                 break;
               case DATE_ISO:
               case DATE_DATETIME:
                 $field = "CAST($field as smalldatetime)";
                 break;
+            }
             break;
           break;
+        }
         // Adjust the resulting value to the right timezone/offset.
-...
           switch ($this->db_type) {
             case 'mysql':
               return "ADDTIME($field, SEC_TO_TIME($offset))";
             case 'pgsql':
               return "($field + INTERVAL '$offset SECONDS')";;
               return "($field + INTERVAL '$offset SECONDS')";
             case 'sqlite':
               return "datetime($field, '$offset seconds')";
             case 'sqlsrv':
               return "DATEADD(second, $offset, $field)";
+          }
-...
             switch ($direction) {
               case 'ADD':
                 return "DATE_ADD($field, INTERVAL $count $granularity)";
               case 'SUB':
                 return "DATE_SUB($field, INTERVAL $count $granularity)";
+            }
-...
             switch ($direction) {
               case 'ADD':
                 return "($field + INTERVAL '$count $granularity')";
               case 'SUB':
                 return "($field - INTERVAL '$count $granularity')";
+            }
-...
             switch ($direction) {
               case 'ADD':
                 return "datetime($field, '+$count $granularity')";
               case 'SUB':
                 return "datetime($field, '-$count $granularity')";
+            }
-...
           switch ($this->db_type) {
             case 'mysql':
               return "CONVERT_TZ($field, $db_zone, $localzone)";
             case 'pgsql':
               // WITH TIME ZONE assumes the date is using the system
               // timezone, which should have been set to UTC.
-...
             );
             $format = strtr($format, $replace);
             return "DATE_FORMAT($field, '$format')";
           case 'pgsql':
             $replace = array(
               'Y' => 'YYYY',
-...
             );
             $format = strtr($format, $replace);
             return "TO_CHAR($field, '$format')";
           case 'sqlite':
             $replace = array(
               // 4 digit year number.
-...
             );
             $format = strtr($format, $replace);
             return "strftime('$format', $field)";
           case 'sqlsrv':
             $replace = array(
               // 4 digit year number.
-...
         switch (strtoupper($extract_type)) {
           case 'DATE':
             return $field;
           case 'YEAR':
             return "EXTRACT(YEAR FROM($field))";
           case 'MONTH':
             return "EXTRACT(MONTH FROM($field))";
           case 'DAY':
             return "EXTRACT(DAY FROM($field))";
           case 'HOUR':
             return "EXTRACT(HOUR FROM($field))";
           case 'MINUTE':
             return "EXTRACT(MINUTE FROM($field))";
           case 'SECOND':
             return "EXTRACT(SECOND FROM($field))";
           // ISO week number for date.
           case 'WEEK':
             switch ($this->db_type) {
-...
                 // WEEK using arg 3 in MySQl should return the same value as
                 // Postgres EXTRACT.
                 return "WEEK($field, 3)";
               case 'pgsql':
                 return "EXTRACT(WEEK FROM($field))";
+            }
-...
                 // MySQL returns 1 for Sunday through 7 for Saturday, PHP date
                 // functions and Postgres use 0 for Sunday and 6 for Saturday.
                 return "INTEGER(DAYOFWEEK($field) - 1)";
               case 'pgsql':
                 return "EXTRACT(DOW FROM($field))";
+            }
-...
             switch ($this->db_type) {
               case 'mysql':
                 return "DAYOFYEAR($field)";
               case 'pgsql':
                 return "EXTRACT(DOY FROM($field))";
+            }
-...
+      }
       /**
        * Create a complete datetime value out of an
        * incomplete array of selected values.
        * Create a complete date/time value out of an incomplete array of values.
+       *
        * For example, array('year' => 2008, 'month' => 05) will fill
        * in the day, hour, minute and second with the earliest possible
-...
             case 'empty_min':
             case 'min':
               return date_format($dates[0], 'Y-m-d H:i:s');
             case 'empty_max':
             case 'max':
               return date_format($dates[1], 'Y-m-d H:i:s');
             default:
               return;
+          }
-...
+      }
       /**
        *  A function to test the validity of various date parts
        * A function to test the validity of various date parts.
        */
       function part_is_valid($value, $type) {
         if (!preg_match('/^[0-9]*$/', $value)) {
-...
               return FALSE;
+            }
             break;
           case 'month':
             if ($value < 0 || $value > 12) {
               return FALSE;
+            }
             break;
           case 'day':
             if ($value < 0 || $value > 31) {
               return FALSE;
+            }
             break;
           case 'week':
             if ($value < 0 || $value > 53) {
               return FALSE;
-...
             $formats['display'] = 'Y';
             $formats['sql'] = 'Y';
             break;
           case 'month':
             $formats['display'] = date_limit_format($short, array('year', 'month'));
             $formats['sql'] = 'Y-m';
             break;
           case 'day':
             $formats['display'] = date_limit_format($short, array('year', 'month', 'day'));
             $args = array('year', 'month', 'day');
             $formats['display'] = date_limit_format($short, $args);
             $formats['sql'] = 'Y-m-d';
             break;
           case 'hour':
             $formats['display'] = date_limit_format($short, array('year', 'month', 'day', 'hour'));
             $args = array('year', 'month', 'day', 'hour');
             $formats['display'] = date_limit_format($short, $args);
             $formats['sql'] = 'Y-m-d\TH';
             break;
           case 'minute':
             $formats['display'] = date_limit_format($short, array('year', 'month', 'day', 'hour', 'minute'));
             $args = array('year', 'month', 'day', 'hour', 'minute');
             $formats['display'] = date_limit_format($short, $args);
             $formats['sql'] = 'Y-m-d\TH:i';
             break;
           case 'second':
             $formats['display'] = date_limit_format($short, array('year', 'month', 'day', 'hour', 'minute', 'second'));
             $args = array('year', 'month', 'day', 'hour', 'minute', 'second');
             $formats['display'] = date_limit_format($short, $args);
             $formats['sql'] = 'Y-m-d\TH:i:s';
             break;
           case 'week':
             $formats['display'] = 'F j Y (W)';
             $formats['sql'] = 'Y-\WW';
-...
           '#type' => 'radios',
           '#default_value' => $granularity,
           '#options' => $this->date_parts(),
           );
         );
         return $form;
+      }
-...
         $direction = $results[1];
         $count = $results[2];
         $item = $results[3];
         $replace = array(
           'now' => '@',
           '+' => 'P',
-...
           'second' => 'S',
           '  ' => '',
           ' ' => '',
           );
         $prefix = in_array($item, array('hours', 'hour', 'minutes', 'minute', 'seconds', 'second')) ? 'T' : '';
         return $prefix . strtr($direction, $replace) . $count . strtr($item, $replace);
         );
         $args = array('hours', 'hour', 'minutes', 'minute', 'seconds', 'second');
         if (in_array($item, $args)) {
           $prefix = 'T';
+        }
         else {
           $prefix = '';
+        }
         $return = $prefix;
         $return .= strtr($direction, $replace);
         $return .= $count;
         $return .= strtr($item, $replace);
         return $return;
+      }
       /**
        * Use the parsed values from the ISO argument to determine the
        * granularity of this period.
        * Granularity arguments handler.
+       *
        * Use the parsed values from the ISO argument
        * to determine the granularity of this period.
        */
       function arg_granularity($arg) {
         $granularity = '';
-...
+          }
           return array($min_date, $max_date);
+        }
          // Intercept invalid info and fall back to the current date.
         // Intercept invalid info and fall back to the current date.
         $now = date_now();
         return array($now, $now);
+      }
+    }
     // @codingStandardsIgnoreEnd

Formats disponibles : Unified diff

Projet

Général

Profil

Club Drupal

Révision b720ea3e

Ajouté par Assos Assos il y a plus de 8 ans