1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
|
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
*
* Copyright (C) 2008-2009 Sun Microsystems
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; version 2 of the License.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*/
/* Functions to handle date and time */
#include "config.h"
#include "drizzled/error.h"
#include "drizzled/util/test.h"
#include "drizzled/tztime.h"
#include "drizzled/session.h"
#include "drizzled/time_functions.h"
namespace drizzled
{
/* Some functions to calculate dates */
int calc_weekday(long daynr,bool sunday_first_day_of_week)
{
return ((int) ((daynr + 5L + (sunday_first_day_of_week ? 1L : 0L)) % 7));
}
uint32_t calc_week(DRIZZLE_TIME *l_time, uint32_t week_behaviour, uint32_t *year)
{
uint32_t days;
uint32_t daynr= calc_daynr(l_time->year,l_time->month,l_time->day);
uint32_t first_daynr= calc_daynr(l_time->year,1,1);
bool monday_first= test(week_behaviour & WEEK_MONDAY_FIRST);
bool week_year= test(week_behaviour & WEEK_YEAR);
bool first_weekday= test(week_behaviour & WEEK_FIRST_WEEKDAY);
uint32_t weekday= calc_weekday(first_daynr, !monday_first);
*year=l_time->year;
if (l_time->month == 1 && l_time->day <= 7-weekday)
{
if ((!week_year) && ((first_weekday && weekday != 0) || (!first_weekday && weekday >= 4)))
return 0;
week_year= 1;
(*year)--;
first_daynr-= (days=calc_days_in_year(*year));
weekday= (weekday + 53*7- days) % 7;
}
if ((first_weekday && weekday != 0) ||
(!first_weekday && weekday >= 4))
days= daynr - (first_daynr+ (7-weekday));
else
days= daynr - (first_daynr - weekday);
if (week_year && days >= 52*7)
{
weekday= (weekday + calc_days_in_year(*year)) % 7;
if ((!first_weekday && weekday < 4) || (first_weekday && weekday == 0))
{
(*year)++;
return 1;
}
}
return days/7+1;
}
void get_date_from_daynr(long daynr,
uint32_t *ret_year,
uint32_t *ret_month,
uint32_t *ret_day)
{
uint32_t year,temp,leap_day,day_of_year,days_in_year;
unsigned char *month_pos;
if (daynr <= 365L || daynr >= 3652500)
{ /* Fix if wrong daynr */
*ret_year= *ret_month = *ret_day =0;
}
else
{
year= (uint32_t) (daynr*100 / 36525L);
temp=(((year-1)/100+1)*3)/4;
day_of_year=(uint32_t) (daynr - (long) year * 365L) - (year-1)/4 +temp;
while (day_of_year > (days_in_year= calc_days_in_year(year)))
{
day_of_year-=days_in_year;
(year)++;
}
leap_day=0;
if (days_in_year == 366)
{
if (day_of_year > 31+28)
{
day_of_year--;
if (day_of_year == 31+28)
leap_day=1; /* Handle leapyears leapday */
}
}
*ret_month=1;
for (month_pos= days_in_month ;
day_of_year > (uint32_t) *month_pos ;
day_of_year-= *(month_pos++), (*ret_month)++)
;
*ret_year=year;
*ret_day=day_of_year+leap_day;
}
return;
}
enum enum_drizzle_timestamp_type
str_to_datetime_with_warn(const char *str,
uint32_t length,
DRIZZLE_TIME *l_time,
uint32_t flags)
{
int was_cut;
Session *session= current_session;
enum enum_drizzle_timestamp_type ts_type;
ts_type= str_to_datetime(str, length, l_time,
(flags | (session->variables.sql_mode &
(MODE_INVALID_DATES |
MODE_NO_ZERO_DATE))),
&was_cut);
if (was_cut || ts_type <= DRIZZLE_TIMESTAMP_ERROR)
make_truncated_value_warning(current_session, DRIZZLE_ERROR::WARN_LEVEL_WARN,
str, length, ts_type, NULL);
return ts_type;
}
bool
str_to_time_with_warn(const char *str, uint32_t length, DRIZZLE_TIME *l_time)
{
int warning;
bool ret_val= str_to_time(str, length, l_time, &warning);
if (ret_val || warning)
make_truncated_value_warning(current_session, DRIZZLE_ERROR::WARN_LEVEL_WARN,
str, length, DRIZZLE_TIMESTAMP_TIME, NULL);
return ret_val;
}
void localtime_to_TIME(DRIZZLE_TIME *to, struct tm *from)
{
to->neg=0;
to->second_part=0;
to->year= (int) ((from->tm_year+1900) % 10000);
to->month= (int) from->tm_mon+1;
to->day= (int) from->tm_mday;
to->hour= (int) from->tm_hour;
to->minute= (int) from->tm_min;
to->second= (int) from->tm_sec;
}
void make_date(const DRIZZLE_TIME *l_time, String *str)
{
str->alloc(MAX_DATE_STRING_REP_LENGTH);
uint32_t length= (uint32_t) my_date_to_str(l_time, str->c_ptr());
str->length(length);
str->set_charset(&my_charset_bin);
}
void make_datetime(const DRIZZLE_TIME *l_time, String *str)
{
str->alloc(MAX_DATE_STRING_REP_LENGTH);
uint32_t length= (uint32_t) my_datetime_to_str(l_time, str->c_ptr());
str->length(length);
str->set_charset(&my_charset_bin);
}
void make_truncated_value_warning(Session *session,
DRIZZLE_ERROR::enum_warning_level level,
const char *str_val,
uint32_t str_length,
enum enum_drizzle_timestamp_type time_type,
const char *field_name)
{
char warn_buff[DRIZZLE_ERRMSG_SIZE];
const char *type_str;
CHARSET_INFO *cs= &my_charset_utf8_general_ci;
char buff[128];
String str(buff,(uint32_t) sizeof(buff), system_charset_info);
str.copy(str_val, str_length, system_charset_info);
str[str_length]= 0; // Ensure we have end 0 for snprintf
switch (time_type) {
case DRIZZLE_TIMESTAMP_DATE:
type_str= "date";
break;
case DRIZZLE_TIMESTAMP_TIME:
type_str= "time";
break;
case DRIZZLE_TIMESTAMP_DATETIME: // FALLTHROUGH
default:
type_str= "datetime";
break;
}
if (field_name)
cs->cset->snprintf(cs, warn_buff, sizeof(warn_buff),
ER(ER_TRUNCATED_WRONG_VALUE_FOR_FIELD),
type_str, str.c_ptr(), field_name,
(uint32_t) session->row_count);
else
{
if (time_type > DRIZZLE_TIMESTAMP_ERROR)
cs->cset->snprintf(cs, warn_buff, sizeof(warn_buff),
ER(ER_TRUNCATED_WRONG_VALUE),
type_str, str.c_ptr());
else
cs->cset->snprintf(cs, warn_buff, sizeof(warn_buff),
ER(ER_WRONG_VALUE), type_str, str.c_ptr());
}
push_warning(session, level,
ER_TRUNCATED_WRONG_VALUE, warn_buff);
}
bool
calc_time_diff(DRIZZLE_TIME *l_time1, DRIZZLE_TIME *l_time2, int l_sign, int64_t *seconds_out,
long *microseconds_out)
{
long days;
bool neg;
int64_t microseconds;
/*
We suppose that if first argument is DRIZZLE_TIMESTAMP_TIME
the second argument should be TIMESTAMP_TIME also.
We should check it before calc_time_diff call.
*/
if (l_time1->time_type == DRIZZLE_TIMESTAMP_TIME) // Time value
days= (long)l_time1->day - l_sign * (long)l_time2->day;
else
{
days= calc_daynr((uint32_t) l_time1->year,
(uint32_t) l_time1->month,
(uint32_t) l_time1->day);
if (l_time2->time_type == DRIZZLE_TIMESTAMP_TIME)
days-= l_sign * (long)l_time2->day;
else
days-= l_sign*calc_daynr((uint32_t) l_time2->year,
(uint32_t) l_time2->month,
(uint32_t) l_time2->day);
}
microseconds= ((int64_t)days*86400L +
(int64_t)(l_time1->hour*3600L +
l_time1->minute*60L +
l_time1->second) -
l_sign*(int64_t)(l_time2->hour*3600L +
l_time2->minute*60L +
l_time2->second)) * 1000000L +
(int64_t)l_time1->second_part -
l_sign*(int64_t)l_time2->second_part;
neg= 0;
if (microseconds < 0)
{
microseconds= -microseconds;
neg= 1;
}
*seconds_out= microseconds/1000000L;
*microseconds_out= (long) (microseconds%1000000L);
return neg;
}
} /* namespace drizzled */
|