Top |
Functions
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 |
[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).
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).
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).
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).
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;