src/server/util/date.c

Fri, 01 Nov 2024 12:25:52 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Fri, 01 Nov 2024 12:25:52 +0100
changeset 562
69fc4ecc5f60
parent 415
d938228c382e
permissions
-rw-r--r--

fix pgext uses a wrong field number, if the column has the same name as a resource or property column

27
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
1 /*
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
3 *
44
3da1f7b6847f added some error messages
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 27
diff changeset
4 * Copyright 2013 Olaf Wintermann. All rights reserved.
27
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
5 *
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
6 * Redistribution and use in source and binary forms, with or without
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
7 * modification, are permitted provided that the following conditions are met:
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
8 *
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
9 * 1. Redistributions of source code must retain the above copyright
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
10 * notice, this list of conditions and the following disclaimer.
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
11 *
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
12 * 2. Redistributions in binary form must reproduce the above copyright
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
13 * notice, this list of conditions and the following disclaimer in the
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
14 * documentation and/or other materials provided with the distribution.
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
15 *
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
25 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
26 * POSSIBILITY OF SUCH DAMAGE.
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
27 */
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
28
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
29 #include <stdlib.h>
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
30 #include "pool.h"
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
31
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
32 #include "date.h"
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
33
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
34 char *date_wkday[] = {
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
35 "Sun",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
36 "Mon",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
37 "Tue",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
38 "Wed",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
39 "Thu",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
40 "Fri",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
41 "Sat"
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
42 };
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
43
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
44 char *date_month[] = {
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
45 "Jan",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
46 "Feb",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
47 "Mar",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
48 "Apr",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
49 "May",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
50 "Jun",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
51 "Jul",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
52 "Aug",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
53 "Sep",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
54 "Oct",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
55 "Nov",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
56 "Dec"
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
57 };
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
58
415
d938228c382e switch from ucx 2 to 3
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 44
diff changeset
59 cxmutstr date_format_http(time_t t, pool_handle_t *pool) {
d938228c382e switch from ucx 2 to 3
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 44
diff changeset
60 cxmutstr d;
27
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
61 d.ptr = NULL;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
62 d.length = 0;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
63
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
64 struct tm date;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
65 gmtime_r(&t, &date);
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
66
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
67 char *str = pool_malloc(pool, 32);
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
68 snprintf(
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
69 str,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
70 32,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
71 "%s, %02d %s %d %02d:%02d:%02d GMT",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
72 date_wkday[date.tm_wday],
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
73 date.tm_mday,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
74 date_month[date.tm_mon],
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
75 1900 + date.tm_year,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
76 date.tm_hour,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
77 date.tm_min,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
78 date.tm_sec);
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
79
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
80 d.length = 29;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
81 d.ptr = str;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
82
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
83 return d;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
84 }
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
85
415
d938228c382e switch from ucx 2 to 3
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 44
diff changeset
86 cxmutstr date_format_iso8601(time_t t, pool_handle_t *pool) {
d938228c382e switch from ucx 2 to 3
Olaf Wintermann <olaf.wintermann@gmail.com>
parents: 44
diff changeset
87 cxmutstr d;
27
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
88 d.ptr = NULL;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
89 d.length = 0;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
90
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
91 struct tm date;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
92 gmtime_r(&t, &date);
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
93
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
94 char *str = pool_malloc(pool, 24);
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
95 snprintf(
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
96 str,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
97 24,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
98 "%d-%02d-%02dT%02d:%02d:%02dZ",
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
99 1900 + date.tm_year,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
100 date.tm_mon + 1,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
101 date.tm_mday,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
102 date.tm_hour,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
103 date.tm_min,
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
104 date.tm_sec);
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
105
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
106 d.length = 20;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
107 d.ptr = str;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
108
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
109 return d;
05b7576dca2b added put method
Olaf Wintermann <olaf.wintermann@gmail.com>
parents:
diff changeset
110 }

mercurial