2 +--------------------------------------------------------------------+
4 +--------------------------------------------------------------------+
5 | Redistribution and use in source and binary forms, with or without |
6 | modification, are permitted provided that the conditions mentioned |
7 | in the accompanying LICENSE file are met. |
8 +--------------------------------------------------------------------+
9 | Copyright (c) 2013, Michael Wallner <mike@php.net> |
10 +--------------------------------------------------------------------+
18 #include <ext/date/php_date.h>
19 #include <ext/standard/php_string.h>
21 #include <Zend/zend_interfaces.h>
23 #include <libpq/libpq-fs.h>
26 #include "php_pqexc.h"
27 #include "php_pq_misc.h"
28 #include "php_pqconn_event.h"
30 #include "php_pq_type.h"
33 /* clear result object associated with a result handle */
34 void php_pqres_clear(PGresult
*r
) {
35 php_pq_object_t
*o
= PQresultInstanceData(r
, php_pqconn_event
);
38 php_pq_object_delref(o
);
44 /* clear any asynchronous results */
45 void php_pqconn_clear(PGconn
*conn
) {
47 php_pqconn_event_data_t
*evdata
= PQinstanceData(conn
, php_pqconn_event
);
49 while ((r
= PQgetResult(conn
))) {
53 if (evdata
&& evdata
->obj
) {
54 if (php_pq_callback_is_enabled(&evdata
->obj
->intern
->onevent
)) {
55 if (php_pq_callback_is_locked(&evdata
->obj
->intern
->onevent
)) {
56 php_pq_callback_disable(&evdata
->obj
->intern
->onevent
);
58 php_pq_callback_dtor(&evdata
->obj
->intern
->onevent
);
64 /* safe wrappers to clear any asynchronous wrappers before querying synchronously */
65 PGresult
*php_pq_exec(PGconn
*conn
, const char *query
) {
66 php_pqconn_clear(conn
);
67 return PQexec(conn
, query
);
69 PGresult
*php_pq_exec_params(PGconn
*conn
, const char *command
, int nParams
, const Oid
*paramTypes
, const char *const * paramValues
, const int *paramLengths
, const int *paramFormats
, int resultFormat
) {
70 php_pqconn_clear(conn
);
71 return PQexecParams(conn
, command
, nParams
, paramTypes
, paramValues
, paramLengths
, paramFormats
, resultFormat
);
73 PGresult
*php_pq_prepare(PGconn
*conn
, const char *stmtName
, const char *query
, int nParams
, const Oid
*paramTypes
) {
74 php_pqconn_clear(conn
);
75 return PQprepare(conn
, stmtName
, query
, nParams
, paramTypes
);
77 PGresult
*php_pq_exec_prepared(PGconn
*conn
, const char *stmtName
, int nParams
, const char *const * paramValues
, const int *paramLengths
, const int *paramFormats
, int resultFormat
) {
78 php_pqconn_clear(conn
);
79 return PQexecPrepared(conn
, stmtName
, nParams
, paramValues
, paramLengths
, paramFormats
, resultFormat
);
82 char *php_pq_rtrim(char *e
)
86 while (l
-- > 0 && e
[l
] == '\n') {
92 const char *php_pq_strmode(long mode
)
94 switch (mode
& (INV_READ
|INV_WRITE
)) {
95 case INV_READ
|INV_WRITE
:
106 int php_pq_compare_index_80(Bucket
*lptr
, Bucket
*rptr
)
108 zend_ulong l
= lptr
->h
;
109 zend_ulong r
= rptr
->h
;
119 int php_pq_compare_index_70(const void *lptr
, const void *rptr
) {
120 return php_pq_compare_index_80((Bucket
*) lptr
, (Bucket
*) rptr
);
123 void php_pq_hash_ptr_dtor(zval
*p
)
128 zend_class_entry
*php_pqdt_class_entry
;
130 ZEND_BEGIN_ARG_INFO_EX(ai_pqdt_to_string
, 0, 0, 0)
132 static PHP_METHOD(pqdt
, __toString
)
137 php_pq_call_method(getThis(), "format", 1, &rv
, php_pq_read_property(getThis(), "format", &tmp
));
138 RETVAL_ZVAL(&rv
, 1, 1);
141 ZEND_BEGIN_ARG_INFO_EX(ai_pqdt_create_from_format
, 0, 0, 2)
142 ZEND_ARG_INFO(0, format
)
143 ZEND_ARG_INFO(0, datetime
)
144 #if PHP_VERSION_ID >= 70200
145 ZEND_ARG_OBJ_INFO(0, object
, DateTimeZone
, 1)
147 ZEND_ARG_INFO(0, timezone
)
150 static PHP_METHOD(pqdt
, createFromFormat
)
152 zend_error_handling zeh
;
153 char *fmt_str
, *dt_str
;
154 size_t fmt_len
, dt_len
;
158 zend_replace_error_handling(EH_THROW
, exce(EX_INVALID_ARGUMENT
), &zeh
);
159 rv
= zend_parse_parameters(ZEND_NUM_ARGS(), "ss|O", &fmt_str
, &fmt_len
, &dt_str
, &dt_len
, &ztz
, php_date_get_timezone_ce());
160 zend_restore_error_handling(&zeh
);
163 php_pqdt_from_string(return_value
, fmt_str
, dt_str
, dt_len
, "Y-m-d H:i:s.uO", ztz
);
167 static zend_function_entry php_pqdt_methods
[] = {
168 PHP_ME(pqdt
, createFromFormat
, ai_pqdt_create_from_format
, ZEND_ACC_PUBLIC
|ZEND_ACC_STATIC
)
169 PHP_ME(pqdt
, __toString
, ai_pqdt_to_string
, ZEND_ACC_PUBLIC
)
170 PHP_MALIAS(pqdt
, jsonSerialize
, __toString
, ai_pqdt_to_string
, ZEND_ACC_PUBLIC
)
174 zval
*php_pqdt_from_string(zval
*zv
, char *input_fmt
, char *dt_str
, size_t dt_len
, const char *output_fmt
, zval
*ztimezone
)
178 php_date_instantiate(php_pqdt_class_entry
, zv
);
179 dobj
= php_date_obj_from_obj(Z_OBJ_P(zv
));
180 if (!php_date_initialize(dobj
, dt_str
, dt_len
, input_fmt
, ztimezone
, 1)) {
183 } else if (output_fmt
) {
185 ZVAL_STRING(&fmt
, output_fmt
);
186 php_pq_update_property(zv
, "format", &fmt
);
193 zend_string
*php_pqdt_to_string(zval
*zdt
, const char *format
)
199 if (php_pq_cast_object(zdt
, IS_STRING
, &rv
)) {
201 } else if (instanceof_function(Z_OBJCE_P(zdt
), php_date_get_date_ce())) {
205 ZVAL_STRING(&zfmt
, format
);
206 php_pq_call_method(zdt
, "format", 1, &rv
, &zfmt
);
207 zval_ptr_dtor(&zfmt
);
209 if (Z_TYPE(rv
) == IS_STRING
) {
218 zend_class_entry
*php_pqconv_class_entry
;
220 ZEND_BEGIN_ARG_INFO_EX(ai_pqconv_convert_types
, 0, 0, 0)
223 ZEND_BEGIN_ARG_INFO_EX(ai_pqconv_convert_from_string
, 0, 0, 2)
224 ZEND_ARG_INFO(0, data
)
225 ZEND_ARG_INFO(0, type
)
228 ZEND_BEGIN_ARG_INFO_EX(ai_pqconv_convert_to_string
, 0, 0, 2)
229 ZEND_ARG_INFO(0, data
)
230 ZEND_ARG_INFO(0, type
)
233 zend_function_entry php_pqconv_methods
[] = {
234 PHP_ABSTRACT_ME(pqconv
, convertTypes
, ai_pqconv_convert_types
)
235 PHP_ABSTRACT_ME(pqconv
, convertFromString
, ai_pqconv_convert_from_string
)
236 PHP_ABSTRACT_ME(pqconv
, convertToString
, ai_pqconv_convert_to_string
)
241 PHP_MINIT_FUNCTION(pq_misc
)
243 zend_class_entry
*json
, ce
= {0};
245 INIT_NS_CLASS_ENTRY(ce
, "pq", "Converter", php_pqconv_methods
);
246 php_pqconv_class_entry
= zend_register_internal_interface(&ce
);
248 memset(&ce
, 0, sizeof(ce
));
249 INIT_NS_CLASS_ENTRY(ce
,"pq", "DateTime", php_pqdt_methods
);
250 php_pqdt_class_entry
= zend_register_internal_class_ex(&ce
, php_date_get_date_ce());
252 zend_declare_property_stringl(php_pqdt_class_entry
, ZEND_STRL("format"), ZEND_STRL("Y-m-d H:i:s.uO"), ZEND_ACC_PUBLIC
);
254 /* stop reading this file right here! */
255 if ((json
= zend_hash_str_find_ptr(CG(class_table
), ZEND_STRL("jsonserializable")))) {
256 zend_class_implements(php_pqdt_class_entry
, 1, json
);
262 typedef struct _HashTableList
{
264 struct _HashTableList
*parent
;
267 typedef struct _ArrayParserState
{
268 const char *ptr
, *end
;
276 static char caa(ArrayParserState
*a
, const char *any
, unsigned advance
)
287 php_error_docref(NULL
, E_WARNING
, "Failed to parse array: expected one of '%s', got '%c'", any
, *a
->ptr
); \
291 static ZEND_RESULT_CODE
add_element(ArrayParserState
*a
, const char *start
)
294 zend_string
*zstr
= zend_string_init(start
, a
->ptr
- start
, 0);
297 php_stripslashes(zstr
);
298 ZVAL_STR(&zelem
, zstr
);
299 } else if (!zend_string_equals_literal(zstr
, "NULL")) {
300 ZVAL_STR(&zelem
, zstr
);
302 zend_string_release(zstr
);
306 if (!ZVAL_IS_NULL(&zelem
)) {
307 php_pqres_typed_zval(a
->res
, a
->typ
, &zelem
);
310 add_next_index_zval(&a
->list
->arr
, &zelem
);
314 static ZEND_RESULT_CODE
parse_array(ArrayParserState
*a
);
316 static ZEND_RESULT_CODE
parse_element(ArrayParserState
*a
, char delim
)
322 return parse_array(a
);
333 for (el
= a
->ptr
; a
->ptr
< a
->end
; ++a
->ptr
) {
336 a
->escaped
= !a
->escaped
;
342 } else if (a
->quotes
) {
343 if (SUCCESS
!= add_element(a
, el
)) {
350 php_error_docref(NULL
, E_WARNING
, "Failed to parse element, unexpected quote: '%.*s'", (int) (a
->ptr
- el
), el
);
356 if (delim
!= *a
->ptr
) {
363 return add_element(a
, el
);
370 php_error_docref(NULL
, E_WARNING
, "Failed to parse element, reached end of input");
374 static ZEND_RESULT_CODE
parse_elements(ArrayParserState
*a
)
376 char delims
[] = {'}', (char) PHP_PQ_DELIM_OF_ARRAY(a
->typ
), 0};
378 while (SUCCESS
== parse_element(a
, delims
[1])) {
379 switch (caa(a
, delims
, 0)) {
388 php_error_docref(NULL
, E_WARNING
, "Failed to parse elements, reached end of input");
398 static ZEND_RESULT_CODE
parse_array(ArrayParserState
*a
)
402 if (!caa(a
, "{", 1)) {
406 list
= ecalloc(1, sizeof(*list
));
407 array_init(&list
->arr
);
410 add_next_index_zval(&a
->list
->arr
, &list
->arr
);
411 list
->parent
= a
->list
;
415 if (SUCCESS
!= parse_elements(a
)) {
419 if (!caa(a
, "}", 1)) {
423 /* step one level back up */
424 if (a
->list
->parent
) {
425 HashTableList
*l
= a
->list
->parent
;
434 HashTable
*php_pq_parse_array(php_pqres_t
*res
, const char *val_str
, size_t val_len
, Oid typ
)
436 HashTable
*ht
= NULL
;
437 ArrayParserState a
= {0};
441 a
.end
= val_str
+ val_len
;
444 if (SUCCESS
!= parse_array(&a
)) {
446 HashTableList
*l
= a
.list
->parent
;
448 zval_dtor(&a
.list
->arr
);
456 php_error_docref(NULL
, E_NOTICE
, "Trailing input: '%s'", a
.ptr
);
460 HashTableList
*l
= a
.list
->parent
;
462 ht
= Z_ARRVAL(a
.list
->arr
);
476 * vim600: noet sw=4 ts=4 fdm=marker
477 * vim<600: noet sw=4 ts=4