![]() |
![]() |
![]() |
GNOME Data Access manual | ![]() |
---|
GdaDataModelQueryGdaDataModelQuery — An implementation of GdaDataModel based on a SELECT query |
GdaDataModelQuery; GdaDataModelQueryClass; GdaDataModelQueryPrivate; GdaDataModel* gda_data_model_query_new (GdaQuery *query); GdaParameterList* gda_data_model_query_get_param_list (GdaDataModelQuery *model); gboolean gda_data_model_query_refresh (GdaDataModelQuery *model, GError **error); gboolean gda_data_model_query_set_modification_query (GdaDataModelQuery *model, const gchar *query, GError **error);
"delete-query" gpointer : Read / Write "insert-query" gpointer : Read / Write "query" gpointer : Read / Write / Construct Only "update-query" gpointer : Read / Write
The GdaDataModelQuery data model simply stores the values returned by a SELECT query. The connection used to execute the SELECT query (given when the object is constructed) is the same as the one provided th the GdaDict object to which the query relates.
GdaDataModel* gda_data_model_query_new (GdaQuery *query);
Creates a new GdaDataModel object using the data returned by the execution of the
query
SELECT query.
query : |
a SELECT query |
Returns : | a pointer to the newly created GdaDataModel. |
GdaParameterList* gda_data_model_query_get_param_list (GdaDataModelQuery *model);
If some parameters are required to execute the SELECT query used in the model
data model, then
creates a new GdaParameterList; otherwise does nothing and returns NULL
.
model : |
a GdaDataModelQuery data model |
Returns : | a new GdaParameterList object, or NULL
|
gboolean gda_data_model_query_refresh (GdaDataModelQuery *model, GError **error);
(Re)-runs the SELECT query to update the contents of model
model : |
a GdaDataModelQuery data model |
error : |
a place to store errors, or NULL
|
Returns : | TRUE if no error occured |
gboolean gda_data_model_query_set_modification_query (GdaDataModelQuery *model, const gchar *query, GError **error);
Sets the modification query to be used by model
to actually perform any change
to the dataset in the database.
The provided query (the query
SQL) must be either a INSERT, UPDATE or DELETE query. It can contain
parameters, and the parameters named '_<num>' will be replaced with the value of the
<num>th column in model
's data set when run.
model : |
a GdaDataModelQuery data model |
query : |
the SQL code for a query |
error : |
a place to store errors, or NULL
|
Returns : | TRUE if no error occured. |
delete-query
" property"delete-query" gpointer : Read / Write
DELETE Query to be executed to remove data.
insert-query
" property"insert-query" gpointer : Read / Write
INSERT Query to be executed to add data.
query
" property"query" gpointer : Read / Write / Construct Only
SELECT Query to be executed to populate the model with data.
<< GdaDataModelHash | GdaDataModelFilterSQL >> |