gda-statement-struct-select

gda-statement-struct-select

Types and Values

Description

Functions

gda_sql_statement_select_take_distinct ()

void
gda_sql_statement_select_take_distinct
                               (GdaSqlStatement *stmt,
                                gboolean distinct,
                                GdaSqlExpr *distinct_expr);

Sets the DISTINCT clause of stmt .

distinct_expr 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

distinct

a TRUE/FALSE value

 

distinct_expr

a GdaSqlExpr pointer representing what the DISTINCT is on, or NULL.

[allow-none]

gda_sql_statement_select_take_expr_list ()

void
gda_sql_statement_select_take_expr_list
                               (GdaSqlStatement *stmt,
                                GSList *expr_list);

Sets list of expressions selected by stmt

expr_list 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

expr_list

a list of GdaSqlSelectField pointers.

[element-type Gda.SqlSelectField]

gda_sql_statement_select_take_from ()

void
gda_sql_statement_select_take_from (GdaSqlStatement *stmt,
                                    GdaSqlSelectFrom *from);

Sets the FROM clause of stmt

from 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

from

a GdaSqlSelectFrom pointer

 

gda_sql_statement_select_take_where_cond ()

void
gda_sql_statement_select_take_where_cond
                               (GdaSqlStatement *stmt,
                                GdaSqlExpr *expr);

Sets the WHERE clause of stmt

expr 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

expr

a GdaSqlExpr pointer

 

gda_sql_statement_select_take_group_by ()

void
gda_sql_statement_select_take_group_by
                               (GdaSqlStatement *stmt,
                                GSList *group_by);

Sets the GROUP BY clause of stmt

group_by 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

group_by

a list of GdaSqlExpr pointer.

[element-type GdaSqlExpr]

gda_sql_statement_select_take_having_cond ()

void
gda_sql_statement_select_take_having_cond
                               (GdaSqlStatement *stmt,
                                GdaSqlExpr *expr);

Sets the HAVING clause of stmt

expr 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

expr

a GdaSqlExpr pointer

 

gda_sql_statement_select_take_order_by ()

void
gda_sql_statement_select_take_order_by
                               (GdaSqlStatement *stmt,
                                GSList *order_by);

Sets the ORDER BY clause of stmt

order_by 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

order_by

a list of GdaSqlSelectOrder pointer.

[element-type GdaSqlSelectOrder]

gda_sql_statement_select_take_limits ()

void
gda_sql_statement_select_take_limits (GdaSqlStatement *stmt,
                                      GdaSqlExpr *count,
                                      GdaSqlExpr *offset);

Sets the LIMIT clause of stmt

count and offset 's responsibility are transferred to stmt (which means stmt is then responsible for freeing them when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

count

a GdaSqlExpr pointer

 

offset

a GdaSqlExpr pointer

 

Types and Values

GdaSqlStatementSelect

typedef struct {
	GdaSqlAnyPart     any;
	gboolean          distinct;
	GdaSqlExpr       *distinct_expr;

	GSList           *expr_list;  /* list of GdaSqlSelectField pointers */
	GdaSqlSelectFrom *from;
	
	GdaSqlExpr       *where_cond; /* WHERE... */
	GSList           *group_by; /* list of GdaSqlExpr pointers */
	GdaSqlExpr       *having_cond; /* HAVING... */
	GSList           *order_by;   /* list of GdaSqlSelectOrder pointers */

	GdaSqlExpr       *limit_count;
	GdaSqlExpr       *limit_offset;
} GdaSqlStatementSelect;