Lines Matching refs:querystr
2341 smart_str querystr = {0}; local
2344 smart_str_appends(&querystr, "select relname from pg_class where oid=");
2345 smart_str_append_unsigned(&querystr, oid);
2346 smart_str_0(&querystr);
2348 …if ((tmp_res = PQexec(pg_result->conn, querystr.c)) == NULL || PQresultStatus(tmp_res) != PGRES_TU…
2352 smart_str_free(&querystr);
2357 smart_str_free(&querystr);
5111 smart_str querystr = {0}; local
5134 smart_str_appends(&querystr,
5141 smart_str_appendl(&querystr, escaped, new_len);
5145 smart_str_appends(&querystr, "' AND c.relnamespace = n.oid AND n.nspname = '");
5149 smart_str_appendl(&querystr, escaped, new_len);
5153 smart_str_appends(&querystr, "' AND a.atttypid = t.oid ORDER BY a.attnum;");
5154 smart_str_0(&querystr);
5157 pg_result = PQexec(pg_link, querystr.c);
5160 smart_str_free(&querystr);
5164 smart_str_free(&querystr);
6112 static int do_exec(smart_str *querystr, int expect, PGconn *pg_link, ulong opt TSRMLS_DC) argument
6115 if (PQsendQuery(pg_link, querystr->c)) {
6122 pg_result = PQexec(pg_link, querystr->c);
6135 static inline void build_tablename(smart_str *querystr, PGconn *pg_link, const char *table) argument
6149 smart_str_appendl(querystr, token, len);
6152 smart_str_appends(querystr, escaped);
6159 smart_str_appendc(querystr, '.');
6160 smart_str_appendl(querystr, tmp, len);
6163 smart_str_appendc(querystr, '.');
6164 smart_str_appends(querystr, escaped);
6178 smart_str querystr = {0}; local
6189 smart_str_appends(&querystr, "INSERT INTO ");
6190 build_tablename(&querystr, pg_link, table);
6191 smart_str_appends(&querystr, " DEFAULT VALUES");
6206 smart_str_appends(&querystr, "INSERT INTO ");
6207 build_tablename(&querystr, pg_link, table);
6208 smart_str_appends(&querystr, " (");
6217 smart_str_appendl(&querystr, fld, fld_len - 1);
6218 smart_str_appendc(&querystr, ',');
6221 querystr.len--;
6222 smart_str_appends(&querystr, ") VALUES (");
6232 smart_str_appendl(&querystr, Z_STRVAL_PP(val), Z_STRLEN_PP(val));
6235 smart_str_append_long(&querystr, Z_LVAL_PP(val));
6238 smart_str_appendl(&querystr, buf, snprintf(buf, sizeof(buf), "%F", Z_DVAL_PP(val)));
6246 smart_str_appendc(&querystr, ',');
6249 querystr.len--;
6250 smart_str_appends(&querystr, ");");
6254 smart_str_0(&querystr);
6257 do_exec(&querystr, PGRES_COMMAND_OK, pg_link, (opt & PGSQL_CONV_OPTS) TSRMLS_CC) == 0) {
6270 *sql = querystr.c;
6273 smart_str_free(&querystr);
6314 static inline int build_assignment_string(smart_str *querystr, HashTable *ht, int where_cond, const… argument
6332 smart_str_appendl(querystr, fld, fld_len - 1);
6334 smart_str_appends(querystr, " IS ");
6336 smart_str_appendc(querystr, '=');
6341 smart_str_appendl(querystr, Z_STRVAL_PP(val), Z_STRLEN_PP(val));
6344 smart_str_append_long(querystr, Z_LVAL_PP(val));
6347 …smart_str_appendl(querystr, buf, MIN(snprintf(buf, sizeof(buf), "%F", Z_DVAL_PP(val)), sizeof(buf)…
6354 smart_str_appendl(querystr, pad, pad_len);
6356 querystr->len -= pad_len;
6366 smart_str querystr = {0}; local
6395 smart_str_appends(&querystr, "UPDATE ");
6396 build_tablename(&querystr, pg_link, table);
6397 smart_str_appends(&querystr, " SET ");
6399 if (build_assignment_string(&querystr, Z_ARRVAL_P(var_array), 0, ",", 1 TSRMLS_CC))
6402 smart_str_appends(&querystr, " WHERE ");
6404 …if (build_assignment_string(&querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")-1 TSRMLS…
6407 smart_str_appendc(&querystr, ';');
6408 smart_str_0(&querystr);
6410 if ((opt & PGSQL_DML_EXEC) && do_exec(&querystr, PGRES_COMMAND_OK, pg_link, opt TSRMLS_CC) == 0) {
6426 *sql = querystr.c;
6429 smart_str_free(&querystr);
6475 smart_str querystr = {0}; local
6496 smart_str_appends(&querystr, "DELETE FROM ");
6497 build_tablename(&querystr, pg_link, table);
6498 smart_str_appends(&querystr, " WHERE ");
6500 …if (build_assignment_string(&querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")-1 TSRMLS…
6503 smart_str_appendc(&querystr, ';');
6504 smart_str_0(&querystr);
6506 if ((opt & PGSQL_DML_EXEC) && do_exec(&querystr, PGRES_COMMAND_OK, pg_link, opt TSRMLS_CC) == 0) {
6518 *sql = querystr.c;
6521 smart_str_free(&querystr);
6609 smart_str querystr = {0}; local
6632 smart_str_appends(&querystr, "SELECT * FROM ");
6633 build_tablename(&querystr, pg_link, table);
6634 smart_str_appends(&querystr, " WHERE ");
6636 …if (build_assignment_string(&querystr, Z_ARRVAL_P(ids_array), 1, " AND ", sizeof(" AND ")-1 TSRMLS…
6639 smart_str_appendc(&querystr, ';');
6640 smart_str_0(&querystr);
6642 pg_result = PQexec(pg_link, querystr.c);
6646 php_error_docref(NULL TSRMLS_CC, E_NOTICE, "Failed to execute '%s'", querystr.c);
6656 *sql = querystr.c;
6659 smart_str_free(&querystr);
