Cross Reference: /dovecot/src/lib-dict-backend/dict-sql.c

Lines Matching defs:query
122 	const char *query;
128 	while (hash_table_iterate(iter, dict->prep_stmt_hash, &query, &prep_stmt))
265 sql_dict_statement_init(struct sql_dict *dict, const char *query,
273 		prep_stmt = hash_table_lookup(dict->prep_stmt_hash, query);
275 			const char *query_dup = p_strdup(dict->pool, query);
276 			prep_stmt = sql_prepared_statement_init(dict->db, query);
283 		stmt = sql_statement_init(dict->db, query);
362 		     string_t *query, ARRAY_TYPE(sql_dict_param) *params,
380 	str_append(query, " WHERE");
385 			str_append(query, " AND");
386 		str_printfa(query, " %s = ?", sql_fields[i].name);
396 			str_append(query, " AND");
398 			str_printfa(query, " %s LIKE ?", sql_fields[i].name);
403 			str_printfa(query, " AND %s NOT LIKE ?", sql_fields[i].name);
409 			str_printfa(query, " %s LIKE '%%' AND "
417 				str_append(query, " AND");
418 			str_printfa(query, " %s LIKE ",
429 			str_append(query, " AND");
430 		str_printfa(query, " %s = '%s'", map->username_field,
453 	string_t *query = t_str_new(256);
456 	str_printfa(query, "SELECT %s FROM %s",
459 				 SQL_DICT_RECURSE_NONE, query,
465 	*stmt_r = sql_dict_statement_init(dict, str_c(query), &params);
674 	string_t *query = t_str_new(256);
675 	str_append(query, "SELECT ");
677 		str_printfa(query, "%s,", map->value_field);
690 		str_printfa(query, "%s,", sql_fields[i].name);
691 	str_truncate(query, str_len(query)-1);
693 	str_printfa(query, " FROM %s", map->table);
706 				 recurse_type, query, &params, error_r) < 0)
710 		str_append(query, " ORDER BY ");
712 			str_printfa(query, "%s", sql_fields[i].name);
714 				str_append_c(query, ',');
717 		str_printfa(query, " ORDER BY %s", map->value_field);
721 		str_printfa(query, " LIMIT %"PRIu64,
725 	*stmt_r = sql_dict_statement_init(dict, str_c(query), &params);
1021 			       const char *query,
1026 		sql_dict_statement_init(dict, query, params);
1138 	string_t *query;
1143 	query = t_str_new(64);
1144 	str_printfa(query, "UPDATE %s SET ", fields[0].map->table);
1149 			str_append_c(query, ',');
1150 		str_printfa(query, "%s=%s+?", first_value_field,
1155 				 build->key1, SQL_DICT_RECURSE_NONE, query,
1158 	*query_r = str_c(query);
1211 	string_t *query = t_str_new(256);
1229 	str_printfa(query, "DELETE FROM %s", map->table);
1232 				 SQL_DICT_RECURSE_NONE, query,
1238 			sql_dict_transaction_stmt_init(ctx, str_c(query), &params);
1269 	const char *query, *error;
1292 	if (sql_dict_update_query(&build, &query, &params, &error) < 0) {
1297 			sql_dict_transaction_stmt_init(ctx, query, &params);
1377 		/* see if we can merge this increment SQL query with the
1443 		/* see if we can merge this increment SQL query with the
1460 		const char *query, *error;
1483 		if (sql_dict_update_query(&build, &query, &params, &error) < 0) {
1488 				sql_dict_transaction_stmt_init(ctx, query, &params);