gda-statement-struct-update

gda-statement-struct-update

Types and Values

Description

Functions

gda_sql_statement_update_take_table_name ()

void
gda_sql_statement_update_take_table_name
                               (GdaSqlStatement *stmt,
                                GValue *value);

Sets the name of the table to delete from in stmt .

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

Parameters

stmt

a GdaSqlStatement pointer

 

value

a table name, as a G_TYPE_STRING GValue

 

gda_sql_statement_update_take_on_conflict ()

void
gda_sql_statement_update_take_on_conflict
                               (GdaSqlStatement *stmt,
                                GValue *value);

Sets the name of the resolution conflict algorithm used by stmt . value 's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).

Parameters

stmt

a GdaSqlStatement pointer

 

value

name of the resolution conflict algorithm, as a G_TYPE_STRING GValue

 

gda_sql_statement_update_take_condition ()

void
gda_sql_statement_update_take_condition
                               (GdaSqlStatement *stmt,
                                GdaSqlExpr *cond);

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

 

cond

a GdaSqlExpr pointer

 

gda_sql_statement_update_take_set_value ()

void
gda_sql_statement_update_take_set_value
                               (GdaSqlStatement *stmt,
                                GValue *fname,
                                GdaSqlExpr *expr);

Specifies that the field named fname will be updated with the expression expr .

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

Parameters

stmt

a GdaSqlStatement pointer

 

fname

a field name, as a G_TYPE_STRING GValue

 

expr

a GdaSqlExpr pointer

 

Types and Values

GdaSqlStatementUpdate

typedef struct {
	GdaSqlAnyPart     any;
	gchar            *on_conflict; /* conflict resolution clause */
	GdaSqlTable      *table;
	GSList           *fields_list; /* list of GdaSqlField pointers */
	GSList           *expr_list;   /* list of GdaSqlExpr pointers */
	GdaSqlExpr       *cond;
} GdaSqlStatementUpdate;