Lines Matching refs:querystr
2452 smart_str querystr = {0}; local
2455 smart_str_appends(&querystr, "select relname from pg_class where oid=");
2456 smart_str_append_unsigned(&querystr, oid);
2457 smart_str_0(&querystr);
2459 …if ((tmp_res = PQexec(pg_result->conn, querystr.c)) == NULL || PQresultStatus(tmp_res) != PGRES_TU…
2463 smart_str_free(&querystr);
2468 smart_str_free(&querystr);
5471 smart_str querystr = {0}; local
5495 smart_str_appends(&querystr,
5505 smart_str_appends(&querystr,
5516 smart_str_appendl(&querystr, escaped, new_len);
5520 smart_str_appends(&querystr, "' AND n.nspname = '");
5524 smart_str_appendl(&querystr, escaped, new_len);
5528 smart_str_appends(&querystr, "' ORDER BY a.attnum;");
5529 smart_str_0(&querystr);
5532 pg_result = PQexec(pg_link, querystr.c);
5535 smart_str_free(&querystr);
5539 smart_str_free(&querystr);
6479 static int do_exec(smart_str *querystr, int expect, PGconn *pg_link, ulong opt TSRMLS_DC) argument
6482 if (PQsendQuery(pg_link, querystr->c)) {
6489 pg_result = PQexec(pg_link, querystr->c);
6502 static inline void build_tablename(smart_str *querystr, PGconn *pg_link, const char *table) argument
6516 smart_str_appendl(querystr, token, len);
6519 smart_str_appends(querystr, escaped);
6526 smart_str_appendc(querystr, '.');
6527 smart_str_appendl(querystr, tmp, len);
6530 smart_str_appendc(querystr, '.');
6531 smart_str_appends(querystr, escaped);
6545 smart_str querystr = {0}; local
6556 smart_str_appends(&querystr, "INSERT INTO ");
6557 build_tablename(&querystr, pg_link, table);
6558 smart_str_appends(&querystr, " DEFAULT VALUES");
6573 smart_str_appends(&querystr, "INSERT INTO ");
6574 build_tablename(&querystr, pg_link, table);
6575 smart_str_appends(&querystr, " (");
6586 smart_str_appends(&querystr, tmp);
6589 smart_str_appendl(&querystr, fld, fld_len - 1);
6591 smart_str_appendc(&querystr, ',');
6594 querystr.len--;
6595 smart_str_appends(&querystr, ") VALUES (");
6610 smart_str_appendc(&querystr, '\'');
6611 smart_str_appendl(&querystr, tmp, new_len);
6612 smart_str_appendc(&querystr, '\'');
6615 smart_str_appendl(&querystr, Z_STRVAL_PP(val), Z_STRLEN_PP(val));
6619 smart_str_append_long(&querystr, Z_LVAL_PP(val));
6622 smart_str_appendl(&querystr, buf, snprintf(buf, sizeof(buf), "%F", Z_DVAL_PP(val)));
6625 smart_str_appendl(&querystr, "NULL", sizeof("NULL")-1);
6632 smart_str_appendc(&querystr, ',');
6635 querystr.len--;
6636 smart_str_appends(&querystr, ");");
6640 smart_str_0(&querystr);
6643 do_exec(&querystr, PGRES_COMMAND_OK, pg_link, (opt & PGSQL_CONV_OPTS) TSRMLS_CC) == 0) {
6656 *sql = querystr.c;
6659 smart_str_free(&querystr);
6748 static inline int build_assignment_string(PGconn *pg_link, smart_str *querystr, HashTable *ht, int … argument
6768 smart_str_appends(querystr, tmp);
6771 smart_str_appendl(querystr, fld, fld_len - 1);
6774 smart_str_appends(querystr, " IS ");
6776 smart_str_appendc(querystr, '=');
6785 smart_str_appendc(querystr, '\'');
6786 smart_str_appendl(querystr, tmp, new_len);
6787 smart_str_appendc(querystr, '\'');
6790 smart_str_appendl(querystr, Z_STRVAL_PP(val), Z_STRLEN_PP(val));
6794 smart_str_append_long(querystr, Z_LVAL_PP(val));
6797 …smart_str_appendl(querystr, buf, MIN(snprintf(buf, sizeof(buf), "%F", Z_DVAL_PP(val)), sizeof(buf)…
6800 smart_str_appendl(querystr, "NULL", sizeof("NULL")-1);
6806 smart_str_appendl(querystr, pad, pad_len);
6808 querystr->len -= 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 TSRMLS_CC))
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 TSRMLS_CC) == 0) {
6878 *sql = querystr.c;
6881 smart_str_free(&querystr);
6927 smart_str querystr = {0}; local
6948 smart_str_appends(&querystr, "DELETE FROM ");
6949 build_tablename(&querystr, pg_link, table);
6950 smart_str_appends(&querystr, " WHERE ");
6952 …if (build_assignment_string(pg_link, &querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")…
6955 smart_str_appendc(&querystr, ';');
6956 smart_str_0(&querystr);
6958 if ((opt & PGSQL_DML_EXEC) && do_exec(&querystr, PGRES_COMMAND_OK, pg_link, opt TSRMLS_CC) == 0) {
6970 *sql = querystr.c;
6973 smart_str_free(&querystr);
7061 smart_str querystr = {0}; local
7084 smart_str_appends(&querystr, "SELECT * FROM ");
7085 build_tablename(&querystr, pg_link, table);
7086 smart_str_appends(&querystr, " WHERE ");
7088 …if (build_assignment_string(pg_link, &querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")…
7091 smart_str_appendc(&querystr, ';');
7092 smart_str_0(&querystr);
7094 pg_result = PQexec(pg_link, querystr.c);
7098 php_error_docref(NULL TSRMLS_CC, E_NOTICE, "Failed to execute '%s'", querystr.c);
7108 *sql = querystr.c;
7111 smart_str_free(&querystr);
