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