Lines Matching defs:statement
480 apr_dbd_prepared_t **statement)
491 if (!*statement) {
492 *statement = apr_palloc(pool, sizeof(apr_dbd_prepared_t));
494 (*statement)->nargs = nargs;
495 (*statement)->nvals = nvals;
496 (*statement)->types = types;
559 (*statement)->prepared = 0;
560 (*statement)->name = apr_pstrdup(pool, query);
563 (*statement)->name = apr_pstrdup(pool, label);
565 /* length of SQL query that prepares this statement */
603 (*statement)->prepared = 1;
609 int *nrows, apr_dbd_prepared_t *statement,
630 if (statement->prepared) {
631 res = PQexecPrepared(sql->conn, statement->name, statement->nargs,
635 res = PQexecParams(sql->conn, statement->name, statement->nargs, 0,
689 static void dbd_pgsql_bind(apr_dbd_prepared_t *statement,
695 for (i = 0, j = 0; i < statement->nargs; i++, j++) {
700 switch (statement->types[i]) {
721 int *nrows, apr_dbd_prepared_t *statement,
731 val = apr_palloc(pool, sizeof(*val) * statement->nargs);
732 len = apr_pcalloc(pool, sizeof(*len) * statement->nargs);
733 fmt = apr_pcalloc(pool, sizeof(*fmt) * statement->nargs);
735 dbd_pgsql_bind(statement, values, val, len, fmt);
737 return dbd_pgsql_pquery_internal(pool, sql, nrows, statement,
742 int *nrows, apr_dbd_prepared_t *statement,
752 values = apr_palloc(pool, sizeof(*values) * statement->nvals);
754 for (i = 0; i < statement->nvals; i++) {
758 return dbd_pgsql_pquery(pool, sql, nrows, statement, values);
763 apr_dbd_prepared_t *statement,
786 if (statement->prepared) {
787 res = PQexecPrepared(sql->conn, statement->name, statement->nargs,
791 res = PQexecParams(sql->conn, statement->name, statement->nargs, 0,
868 if (statement->prepared) {
869 rv = PQsendQueryPrepared(sql->conn, statement->name,
870 statement->nargs, values, len, fmt, 0);
873 rv = PQsendQueryParams(sql->conn, statement->name,
874 statement->nargs, 0, values, len, fmt, 0);
925 apr_dbd_prepared_t *statement,
935 val = apr_palloc(pool, sizeof(*val) * statement->nargs);
936 len = apr_pcalloc(pool, sizeof(*len) * statement->nargs);
937 fmt = apr_pcalloc(pool, sizeof(*fmt) * statement->nargs);
939 dbd_pgsql_bind(statement, values, val, len, fmt);
941 return dbd_pgsql_pselect_internal(pool, sql, results, statement,
947 apr_dbd_prepared_t *statement,
957 values = apr_palloc(pool, sizeof(*values) * statement->nvals);
959 for (i = 0; i < statement->nvals; i++) {
963 return dbd_pgsql_pselect(pool, sql, results, statement, seek, values);
966 static void dbd_pgsql_bbind(apr_pool_t *pool, apr_dbd_prepared_t * statement,
973 for (i = 0, j = 0; i < statement->nargs; i++, j++) {
974 type = (values[j] == NULL ? APR_DBD_TYPE_NULL : statement->types[i]);
1044 int *nrows, apr_dbd_prepared_t * statement,
1054 val = apr_palloc(pool, sizeof(*val) * statement->nargs);
1055 len = apr_pcalloc(pool, sizeof(*len) * statement->nargs);
1056 fmt = apr_pcalloc(pool, sizeof(*fmt) * statement->nargs);
1058 dbd_pgsql_bbind(pool, statement, values, val, len, fmt);
1060 return dbd_pgsql_pquery_internal(pool, sql, nrows, statement,
1065 int *nrows, apr_dbd_prepared_t * statement,
1075 values = apr_palloc(pool, sizeof(*values) * statement->nvals);
1077 for (i = 0; i < statement->nvals; i++) {
1081 return dbd_pgsql_pbquery(pool, sql, nrows, statement, values);
1086 apr_dbd_prepared_t * statement,
1096 val = apr_palloc(pool, sizeof(*val) * statement->nargs);
1097 len = apr_pcalloc(pool, sizeof(*len) * statement->nargs);
1098 fmt = apr_pcalloc(pool, sizeof(*fmt) * statement->nargs);
1100 dbd_pgsql_bbind(pool, statement, values, val, len, fmt);
1102 return dbd_pgsql_pselect_internal(pool, sql, results, statement,
1108 apr_dbd_prepared_t * statement, int seek,
1118 values = apr_palloc(pool, sizeof(*values) * statement->nvals);
1120 for (i = 0; i < statement->nvals; i++) {
1124 return dbd_pgsql_pbselect(pool, sql, results, statement, seek, values);