~drizzle-trunk/drizzle/development

574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
1999.6.1 by kalebral at gmail
update Copyright strings to a more common format to help with creating the master debian copyright file
4
 *  Copyright (C) 2008 Sun Microsystems, Inc.
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
5
 *
6
 *  This program is free software; you can redistribute it and/or modify
7
 *  it under the terms of the GNU General Public License as published by
8
 *  the Free Software Foundation; version 2 of the License.
9
 *
10
 *  This program is distributed in the hope that it will be useful,
11
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13
 *  GNU General Public License for more details.
14
 *
15
 *  You should have received a copy of the GNU General Public License
16
 *  along with this program; if not, write to the Free Software
17
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
18
 */
19
2173.2.1 by Monty Taylor
Fixes incorrect usage of include
20
#include <config.h>
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
21
2173.2.1 by Monty Taylor
Fixes incorrect usage of include
22
#include <drizzled/temporal.h>
23
#include <drizzled/error.h>
24
#include <drizzled/session.h>
25
#include <drizzled/function/time/month.h>
26
#include <drizzled/typelib.h>
2241.3.2 by Olaf van der Spek
Refactor Session::variables
27
#include <drizzled/system_variables.h>
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
28
2241.3.2 by Olaf van der Spek
Refactor Session::variables
29
namespace drizzled {
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
30
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
31
int64_t Item_func_month::val_int()
32
{
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
33
  assert(fixed);
34
35
  if (args[0]->is_null())
36
  {
37
    /* For NULL argument, we return a NULL result */
38
    null_value= true;
39
    return 0;
40
  }
41
42
  /* Grab the first argument as a DateTime object */
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
43
  DateTime temporal;
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
44
  Item_result arg0_result_type= args[0]->result_type();
45
  
46
  switch (arg0_result_type)
47
  {
813.1.19 by Jay Pipes
To remain in compatibility with MySQL, added ability to interpret
48
    case DECIMAL_RESULT: 
49
      /* 
50
       * For doubles supplied, interpret the arg as a string, 
51
       * so intentionally fall-through here...
52
       * This allows us to accept double parameters like 
53
       * 19971231235959.01 and interpret it the way MySQL does:
54
       * as a TIMESTAMP-like thing with a microsecond component.
55
       * Ugh, but need to keep backwards-compat.
56
       */
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
57
    case STRING_RESULT:
58
      {
813.1.14 by Jay Pipes
Quick fix for shadowing problem in second.cc
59
        char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
60
        String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
61
        String *res= args[0]->val_str(&tmp);
1750.3.1 by David Shrewsbury
Use of String::c_ptr() in temporal functions can corrupt PBXT row cache, so make sure temporaries are used.
62
63
        if (res && (res != &tmp))
64
        {
65
          tmp.copy(*res);
66
        }
67
68
        if (! temporal.from_string(tmp.c_ptr(), tmp.length()))
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
69
        {
70
          /* 
71
          * Could not interpret the function argument as a temporal value, 
72
          * so throw an error and return 0
73
          */
1750.3.1 by David Shrewsbury
Use of String::c_ptr() in temporal functions can corrupt PBXT row cache, so make sure temporaries are used.
74
          my_error(ER_INVALID_DATETIME_VALUE, MYF(0), tmp.c_ptr());
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
75
          return 0;
76
        }
77
      }
78
      break;
79
    case INT_RESULT:
813.1.14 by Jay Pipes
Quick fix for shadowing problem in second.cc
80
      if (temporal.from_int64_t(args[0]->val_int()))
81
        break;
82
      /* Intentionally fall-through on invalid conversion from integer */
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
83
    default:
84
      {
85
        /* 
86
        * Could not interpret the function argument as a temporal value, 
87
        * so throw an error and return 0
88
        */
89
        null_value= true;
813.1.14 by Jay Pipes
Quick fix for shadowing problem in second.cc
90
        char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
91
        String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
92
        String *res;
93
94
        res= args[0]->val_str(&tmp);
95
1750.3.1 by David Shrewsbury
Use of String::c_ptr() in temporal functions can corrupt PBXT row cache, so make sure temporaries are used.
96
        if (res && (res != &tmp))
97
        {
98
          tmp.copy(*res);
99
        }
100
101
        my_error(ER_INVALID_DATETIME_VALUE, MYF(0), tmp.c_ptr());
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
102
        return 0;
103
      }
104
  }
105
  return (int64_t) temporal.months();
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
106
}
107
108
String* Item_func_monthname::val_str(String* str)
109
{
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
110
  assert(fixed);
111
112
  if (args[0]->is_null())
113
  {
114
    /* For NULL argument, we return a NULL result */
115
    null_value= true;
116
    return (String *) 0;
117
  }
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
118
  const char *month_name;
119
  uint32_t   month= (uint) val_int();
120
121
  if (null_value || !month)
122
  {
123
    null_value=1;
124
    return (String*) 0;
125
  }
126
  null_value=0;
2154.2.24 by Brian Aker
Merge in all changes for current_session, etc.
127
  month_name= getSession().variables.lc_time_names->month_names->type_names[month-1];
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
128
  str->set(month_name, strlen(month_name), system_charset_info);
129
  return str;
130
}
1280.1.10 by Monty Taylor
Put everything in drizzled into drizzled namespace.
131
132
} /* namespace drizzled */