~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
 *
4
 *  Copyright (C) 2008 Sun Microsystems
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
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
20
#include "drizzled/server_includes.h"
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
21
#include CSTDINT_H
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
22
#include "drizzled/temporal.h"
23
#include "drizzled/error.h"
24
#include "drizzled/session.h"
25
#include "drizzled/function/time/month.h"
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
26
27
int64_t Item_func_month::val_int()
28
{
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
29
  assert(fixed);
30
31
  if (args[0]->is_null())
32
  {
33
    /* For NULL argument, we return a NULL result */
34
    null_value= true;
35
    return 0;
36
  }
37
38
  /* Grab the first argument as a DateTime object */
39
  drizzled::DateTime temporal;
40
  Item_result arg0_result_type= args[0]->result_type();
41
  
42
  switch (arg0_result_type)
43
  {
813.1.19 by Jay Pipes
To remain in compatibility with MySQL, added ability to interpret
44
    case DECIMAL_RESULT: 
45
      /* 
46
       * For doubles supplied, interpret the arg as a string, 
47
       * so intentionally fall-through here...
48
       * This allows us to accept double parameters like 
49
       * 19971231235959.01 and interpret it the way MySQL does:
50
       * as a TIMESTAMP-like thing with a microsecond component.
51
       * Ugh, but need to keep backwards-compat.
52
       */
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
53
    case STRING_RESULT:
54
      {
813.1.14 by Jay Pipes
Quick fix for shadowing problem in second.cc
55
        char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
56
        String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
57
        String *res= args[0]->val_str(&tmp);
58
        if (! temporal.from_string(res->c_ptr(), res->length()))
59
        {
60
          /* 
61
          * Could not interpret the function argument as a temporal value, 
62
          * so throw an error and return 0
63
          */
64
          my_error(ER_INVALID_DATETIME_VALUE, MYF(0), res->c_ptr());
65
          return 0;
66
        }
67
      }
68
      break;
69
    case INT_RESULT:
813.1.14 by Jay Pipes
Quick fix for shadowing problem in second.cc
70
      if (temporal.from_int64_t(args[0]->val_int()))
71
        break;
72
      /* Intentionally fall-through on invalid conversion from integer */
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
73
    default:
74
      {
75
        /* 
76
        * Could not interpret the function argument as a temporal value, 
77
        * so throw an error and return 0
78
        */
79
        null_value= true;
813.1.14 by Jay Pipes
Quick fix for shadowing problem in second.cc
80
        char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING];
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
81
        String tmp(buff,sizeof(buff), &my_charset_utf8_bin);
82
        String *res;
83
84
        res= args[0]->val_str(&tmp);
85
86
        my_error(ER_INVALID_DATETIME_VALUE, MYF(0), res->c_ptr());
87
        return 0;
88
      }
89
  }
90
  return (int64_t) temporal.months();
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
91
}
92
93
String* Item_func_monthname::val_str(String* str)
94
{
813.1.8 by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors
95
  assert(fixed);
96
97
  if (args[0]->is_null())
98
  {
99
    /* For NULL argument, we return a NULL result */
100
    null_value= true;
101
    return (String *) 0;
102
  }
574.3.14 by Lee
moving functions from item_timefunc to functions/time directory
103
  const char *month_name;
104
  uint32_t   month= (uint) val_int();
105
  Session *session= current_session;
106
107
  if (null_value || !month)
108
  {
109
    null_value=1;
110
    return (String*) 0;
111
  }
112
  null_value=0;
113
  month_name= session->variables.lc_time_names->month_names->type_names[month-1];
114
  str->set(month_name, strlen(month_name), system_charset_info);
115
  return str;
116
}