Lines Matching refs:querystr
2451 smart_str querystr = {0}; local
2454 smart_str_appends(&querystr, "select relname from pg_class where oid=");
2455 smart_str_append_unsigned(&querystr, oid);
2456 smart_str_0(&querystr);
2458 …if ((tmp_res = PQexec(pg_result->conn, ZSTR_VAL(querystr.s))) == NULL || PQresultStatus(tmp_res) !…
2462 smart_str_free(&querystr);
2467 smart_str_free(&querystr);
5498 smart_str querystr = {0}; local
5522 smart_str_appends(&querystr,
5532 smart_str_appends(&querystr,
5543 smart_str_appendl(&querystr, escaped, new_len);
5547 smart_str_appends(&querystr, "' AND n.nspname = '");
5551 smart_str_appendl(&querystr, escaped, new_len);
5555 smart_str_appends(&querystr, "' ORDER BY a.attnum;");
5556 smart_str_0(&querystr);
5559 pg_result = PQexec(pg_link, ZSTR_VAL(querystr.s));
5562 smart_str_free(&querystr);
5566 smart_str_free(&querystr);
6488 static int do_exec(smart_str *querystr, int expect, PGconn *pg_link, zend_ulong opt) /* {{{ */ argument
6491 if (PQsendQuery(pg_link, ZSTR_VAL(querystr->s))) {
6498 pg_result = PQexec(pg_link, ZSTR_VAL(querystr->s));
6512 static inline void build_tablename(smart_str *querystr, PGconn *pg_link, const char *table) /* {{{ … argument
6526 smart_str_appendl(querystr, token, len);
6529 smart_str_appends(querystr, escaped);
6536 smart_str_appendc(querystr, '.');
6537 smart_str_appendl(querystr, tmp, len);
6540 smart_str_appendc(querystr, '.');
6541 smart_str_appends(querystr, escaped);
6556 smart_str querystr = {0}; local
6566 smart_str_appends(&querystr, "INSERT INTO ");
6567 build_tablename(&querystr, pg_link, table);
6568 smart_str_appends(&querystr, " DEFAULT VALUES");
6582 smart_str_appends(&querystr, "INSERT INTO ");
6583 build_tablename(&querystr, pg_link, table);
6584 smart_str_appends(&querystr, " (");
6593 smart_str_appends(&querystr, tmp);
6596 smart_str_appendl(&querystr, ZSTR_VAL(fld), ZSTR_LEN(fld));
6598 smart_str_appendc(&querystr, ',');
6600 ZSTR_LEN(querystr.s)--;
6601 smart_str_appends(&querystr, ") VALUES (");
6613 smart_str_appendc(&querystr, '\'');
6614 smart_str_appendl(&querystr, tmp, new_len);
6615 smart_str_appendc(&querystr, '\'');
6618 smart_str_appendl(&querystr, Z_STRVAL_P(val), Z_STRLEN_P(val));
6622 smart_str_append_long(&querystr, Z_LVAL_P(val));
6625 smart_str_appendl(&querystr, buf, snprintf(buf, sizeof(buf), "%F", Z_DVAL_P(val)));
6628 smart_str_appendl(&querystr, "NULL", sizeof("NULL")-1);
6635 smart_str_appendc(&querystr, ',');
6638 ZSTR_LEN(querystr.s)--;
6639 smart_str_appends(&querystr, ");");
6643 smart_str_0(&querystr);
6646 do_exec(&querystr, PGRES_COMMAND_OK, pg_link, (opt & PGSQL_CONV_OPTS)) == 0) {
6656 *sql = querystr.s;
6659 smart_str_free(&querystr);
6751 static inline int build_assignment_string(PGconn *pg_link, smart_str *querystr, HashTable *ht, int … argument
6765 smart_str_appends(querystr, tmp);
6768 smart_str_appendl(querystr, ZSTR_VAL(fld), ZSTR_LEN(fld));
6771 smart_str_appends(querystr, " IS ");
6773 smart_str_appendc(querystr, '=');
6782 smart_str_appendc(querystr, '\'');
6783 smart_str_appendl(querystr, tmp, new_len);
6784 smart_str_appendc(querystr, '\'');
6787 smart_str_appendl(querystr, Z_STRVAL_P(val), Z_STRLEN_P(val));
6791 smart_str_append_long(querystr, Z_LVAL_P(val));
6794 …smart_str_appendl(querystr, buf, MIN(snprintf(buf, sizeof(buf), "%F", Z_DVAL_P(val)), sizeof(buf)-…
6797 smart_str_appendl(querystr, "NULL", sizeof("NULL")-1);
6803 smart_str_appendl(querystr, pad, pad_len);
6805 if (querystr->s) {
6806 ZSTR_LEN(querystr->s) -= pad_len;
6818 smart_str querystr = {0}; local
6847 smart_str_appends(&querystr, "UPDATE ");
6848 build_tablename(&querystr, pg_link, table);
6849 smart_str_appends(&querystr, " SET ");
6851 if (build_assignment_string(pg_link, &querystr, Z_ARRVAL_P(var_array), 0, ",", 1, opt))
6854 smart_str_appends(&querystr, " WHERE ");
6856 …if (build_assignment_string(pg_link, &querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")…
6859 smart_str_appendc(&querystr, ';');
6860 smart_str_0(&querystr);
6862 if ((opt & PGSQL_DML_EXEC) && do_exec(&querystr, PGRES_COMMAND_OK, pg_link, opt) == 0) {
6872 *sql = querystr.s;
6875 smart_str_free(&querystr);
6924 smart_str querystr = {0}; local
6945 smart_str_appends(&querystr, "DELETE FROM ");
6946 build_tablename(&querystr, pg_link, table);
6947 smart_str_appends(&querystr, " WHERE ");
6949 …if (build_assignment_string(pg_link, &querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")…
6952 smart_str_appendc(&querystr, ';');
6953 smart_str_0(&querystr);
6955 if ((opt & PGSQL_DML_EXEC) && do_exec(&querystr, PGRES_COMMAND_OK, pg_link, opt) == 0) {
6964 *sql = querystr.s;
6967 smart_str_free(&querystr);
7052 smart_str querystr = {0}; local
7075 smart_str_appends(&querystr, "SELECT * FROM ");
7076 build_tablename(&querystr, pg_link, table);
7077 smart_str_appends(&querystr, " WHERE ");
7079 …if (build_assignment_string(pg_link, &querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")…
7082 smart_str_appendc(&querystr, ';');
7083 smart_str_0(&querystr);
7085 pg_result = PQexec(pg_link, ZSTR_VAL(querystr.s));
7089 php_error_docref(NULL, E_NOTICE, "Failed to execute '%s'", ZSTR_VAL(querystr.s));
7096 *sql = querystr.s;
7099 smart_str_free(&querystr);
