![]() |
![]() |
![]() |
GNOME Data Access 3.0 manual | ![]() |
---|---|---|---|---|
GdaDataModelImport; GdaDataModelImportClass; GdaDataModelImportPrivate; GdaDataModel* gda_data_model_import_new_file (const gchar *filename, gboolean random_access, GdaParameterList *options); GdaDataModel* gda_data_model_import_new_mem (const gchar *data, gboolean random_access, GdaParameterList *options); GdaDataModel* gda_data_model_import_new_xml_node (xmlNodePtr node); GSList* gda_data_model_import_get_errors (GdaDataModelImport *model); void gda_data_model_import_clean_errors (GdaDataModelImport *model);
"data-string" gchararray : Read / Write / Construct Only "filename" gchararray : Read / Write / Construct Only "options" GdaParameterList : Read / Write / Construct Only "random-access" gboolean : Read / Write / Construct Only "xml-node" gpointer : Read / Write / Construct Only
Imports data from a string or a file
The GdaDataModelImport data model imports data from a string or a file. The data can either be in a CSV (comma separated values) format or in an XML format as described by the libgda-array.dtd DTD (as a side way it is also possible to import data from an already-build XML tree validated against that DTD).
The caller must decide, upon construction, if the new GdaDataModelImport must support random access or simply a cursor based access. Random acces makes it easier to use the resulting data model but consumes more memory as all the data is copied in memory, and is thus not suitable for large data sets. Note that importing from an already-build XML tree will always result in a random access data model.
Various import options can be specified using parameters in a GdaParameterList object. The available options depend on the format of the imported data listed here:
"SEPARATOR" (string, CVS import only): specifies the separator to consider
"ESCAPE_CHAR" (string, CVS import only): specifies the character used to "escape" the strings contained between two separators
"ENCODING" (string, CVS import only): specifies the character set used in the imported data
"TITLE_AS_FIRST_LINE" (boolean, CVS import only): TRUE to specify that the first line of the imported data contains the column names
"GDA_TYPE_<col number>" (gda type, CVS import only): specifies the requested GDA type for the column numbered "col number"
"DBMS_TYPE_<col number>" (string, CVS import only): specifies the requested DBMS type for the column numbered "col number"; if the DBMS type is listed in the dictionary used by the created model, then the GDA type is set in accordance
GdaDataModel* gda_data_model_import_new_file (const gchar *filename, gboolean random_access, GdaParameterList *options);
Creates a new GdaDataModel object which contains the data stored within the filename
file.
The options are the following ones:
For the CSV format:
ENCODING (string): specifies the encoding of the data in the file
SEPARATOR (string): specifies the CSV separator (comma as default)
QUOTE (string): specifies the character used to as quote park (double quote as default)
TITLE_AS_FIRST_LINE (boolean): consider that the first line of the file contains columns' titles
DBMS_TYPE_<column number> (string): specifies the type of value expected in column <column number>
Other formats: no option
filename : |
the file to import data from |
random_access : |
TRUE if random access will be required |
options : |
list of importing options |
Returns : | a pointer to the newly created GdaDataModel. |
GdaDataModel* gda_data_model_import_new_mem (const gchar *data, gboolean random_access, GdaParameterList *options);
Creates a new GdaDataModel object which contains the data stored in the data
string.
Important note: the data
string is not copied for memory efficiency reasons and should not
therefore be altered in any way as long as the returned data model exists.
data : |
a string containng the data to import |
random_access : |
TRUE if random access will be required |
options : |
list of importing options, see gda_data_model_import_new_file() for more information
|
Returns : | a pointer to the newly created GdaDataModel. |
GdaDataModel* gda_data_model_import_new_xml_node (xmlNodePtr node);
Creates a new GdaDataModel and loads the data in node
. The resulting data model
can be accessed in a random way.
node : |
an XML node corresponding to a <data-array> tag |
Returns : | a pointer to the newly created GdaDataModel. |
GSList* gda_data_model_import_get_errors (GdaDataModelImport *model);
Get the list of errors which model
has to report. The returned list is a list of
GError structures, and must not be modified
model : |
a GdaDataModelImport object |
Returns : | the list of errors (which must not be modified), or NULL
|
void gda_data_model_import_clean_errors (GdaDataModelImport *model);
Clears the history of errors model
has to report
model : |
a GdaDataModelImport object |