GdaDdlColumn

GdaDdlColumn — Object to represent table column

Stability Level

Stable, unless otherwise indicated

Properties

gboolean autoinc Read / Write
gchar * check Read / Write
gchar * comment Read / Write
gchar * default Read / Write
gchar * name Read / Write
gboolean nnul Read / Write
gboolean pkey Read / Write
guint scale Read / Write
guint size Read / Write
gboolean unique Read / Write

Object Hierarchy

    GObject
    ╰── GdaDdlColumn

Implemented Interfaces

GdaDdlColumn implements GdaDdlBuildable.

Includes

#include <libgda/libgda.h>

Description

This object represents a column of a table or a view. The column can be constracted manually using API or generated from xml file together with other databse objects. See GdaDdlCreator. GdaDdlColumn implements GdaDdlBuildable interface for parsing xml file.

Functions

gda_ddl_column_error_quark ()

GQuark
gda_ddl_column_error_quark (void);

gda_ddl_column_new ()

GdaDdlColumn *
gda_ddl_column_new (void);

Returns

New instance of GdaDdlColumn

Since: 6.0


gda_ddl_column_new_from_meta ()

GdaDdlColumn *
gda_ddl_column_new_from_meta (GdaMetaTableColumn *column);

Create new GdaDdlColumn instance from the corresponding GdaMetaTableColumn object. If NULL is passed this function works exactly as gda_ddl_column_new()

Parameters

column

a GdaMetaTableColumn instance

 

Returns

New object that should be freed with gda_ddl_column_free()


gda_ddl_column_free ()

void
gda_ddl_column_free (GdaDdlColumn *self);

Convenient function to free the object

Parameters

self

a GdaDdlColumn instance

 

Since: 6.0


gda_ddl_column_get_name ()

const gchar *
gda_ddl_column_get_name (GdaDdlColumn *self);

Returns name of the column

Parameters

self

a GdaDdlColumn instance

 

Returns

Column name as a string or NULL.

Since: 6.0


gda_ddl_column_set_name ()

void
gda_ddl_column_set_name (GdaDdlColumn *self,
                         const gchar *name);

Set column name.

Parameters

self

a GdaDdlColumn object

 

name

name as a string

 

Since: 6.0


gda_ddl_column_get_gtype ()

GType
gda_ddl_column_get_gtype (GdaDdlColumn *self);

Return of column type as GType

Parameters

self

a GdaDdlColumn object

 

Since: 6.0


gda_ddl_column_get_ctype ()

const gchar *
gda_ddl_column_get_ctype (GdaDdlColumn *self);

Returns column type as a string derivied from GType

Parameters

self

a GdaDdlColumn object

 

Returns

column type as a string or NULL

Since: 6.0


gda_ddl_column_set_type ()

void
gda_ddl_column_set_type (GdaDdlColumn *self,
                         GType type);

Set type of the column as a GType

Parameters

self

a GdaDdlColumn instance

 

type

GType for column

 

Since: 6.0


gda_ddl_column_get_scale ()

guint
gda_ddl_column_get_scale (GdaDdlColumn *self);

Scale is used for float number representation to specify a number of decimal digits. This value is ignore for column types except float or double.

Parameters

self

a GdaDdlColumn object

 

Returns

Current scale value

Since: 6.0


gda_ddl_column_set_scale ()

void
gda_ddl_column_set_scale (GdaDdlColumn *self,
                          guint scale);

Scale is used for float number representation to specify a number of decimal digits. This value is ignore for column types except float or double.

Parameters

self

a GdaDdlColumn

 

scale

scale value to set

 

Since: 6.0


gda_ddl_column_get_pkey ()

gboolean
gda_ddl_column_get_pkey (GdaDdlColumn *self);

Returns a primary key flag

Parameters

self

a GdaDdlColumn object

 

Returns

TRUE if the column is primary key, FALSE otherwise

Since: 6.0


gda_ddl_column_set_pkey ()

void
gda_ddl_column_set_pkey (GdaDdlColumn *self,
                         gboolean pkey);

Parameters

self

a GdaDdlColumn object

 

pkey

value to set

 

Since: 6.0


gda_ddl_column_get_nnul ()

gboolean
gda_ddl_column_get_nnul (GdaDdlColumn *self);

Specify if the column's value can be NULL.

Parameters

self

a GdaDdlColumn object

 

Returns

TRUE if value can be NULL, FALSE otherwise.

Since: 6.0


gda_ddl_column_set_nnul ()

void
gda_ddl_column_set_nnul (GdaDdlColumn *self,
                         gboolean nnul);

Parameters

self

a GdaDdlColumn object

 

nnul

value to set for nnul

 

Since: 6.0


gda_ddl_column_get_autoinc ()

gboolean
gda_ddl_column_get_autoinc (GdaDdlColumn *self);

Get value for autoinc key

Parameters

self

a GdaDdlColumn object

 

Returns

TRUE if column should be auto-incremented, FALSE otherwise.

Since: 6.0


gda_ddl_column_set_autoinc ()

void
gda_ddl_column_set_autoinc (GdaDdlColumn *self,
                            gboolean autoinc);

Set value for auto-incremented key.

Parameters

self

a GdaDdlColumn object

 

autoinc

value to set

 

Since: 6.0


gda_ddl_column_get_unique ()

gboolean
gda_ddl_column_get_unique (GdaDdlColumn *self);

Get value for unique key

Parameters

self

a GdaDdlColumn object

 

Returns

TRUE if column should have a unique value, FALSE otherwise.

Since: 6.0


gda_ddl_column_set_unique ()

void
gda_ddl_column_set_unique (GdaDdlColumn *self,
                           gboolean unique);

Set value for unique key.

Parameters

self

a GdaDdlColumn object

 

unique

value to set

 

Since: 6.0


gda_ddl_column_get_comment ()

const gchar *
gda_ddl_column_get_comment (GdaDdlColumn *self);

Get value for column comment.

Parameters

self

a GdaDdlColumn object

 

Returns

Column comment as a string. NULL is returned if comment is not set.

Since: 6.0


gda_ddl_column_set_comment ()

void
gda_ddl_column_set_comment (GdaDdlColumn *self,
                            const gchar *comnt);

Set value for column comment.

Parameters

self

a GdaDdlColumn object

 

comnt

comment to set

 

Since: 6.0


gda_ddl_column_get_size ()

guint
gda_ddl_column_get_size (GdaDdlColumn *self);

Parameters

self

a GdaDdlColumn instance

 

Returns

Current value for column size.

Since: 6.0


gda_ddl_column_set_size ()

void
gda_ddl_column_set_size (GdaDdlColumn *self,
                         guint size);

Set value for column size. This is relevant only for string column type.

Parameters

self

a GdaDdlColumn instance

 

size

value to set

 

Since: 6.0


gda_ddl_column_get_default ()

const gchar *
gda_ddl_column_get_default (GdaDdlColumn *self);

Returns default value for the column. Can be NULL if the default value hasn't been set.

Parameters

self

a GdaDdlColumn instance

 

Returns

Default value for the column as a string.

Since: 6.0


gda_ddl_column_set_default ()

void
gda_ddl_column_set_default (GdaDdlColumn *self,
                            const gchar *value);

Parameters

self

a GdaDdlColumn instance

 

value

default value to set for column as a string

 

Since: 6.0


gda_ddl_column_get_check ()

const gchar *
gda_ddl_column_get_check (GdaDdlColumn *self);

Returns value of the check field.

Parameters

self

a GdaDdlColumn instance

 

Returns

Column check string

Since: 6.0


gda_ddl_column_set_check ()

void
gda_ddl_column_set_check (GdaDdlColumn *self,
                          const gchar *value);

Sets check string to the column.

Parameters

self

a GdaDdlColumn instance

 

value

value to set

 

Since: 6.0


gda_ddl_column_prepare_create ()

gboolean
gda_ddl_column_prepare_create (GdaDdlColumn *self,
                               GdaServerOperation *op,
                               guint order,
                               GError **error);

This method populate op with information stored in self .

Parameters

self

a GdaDdlColumn instance

 

op

a GdaServerOperation instance to update for TABLE_CREATE operation

 

error

a GError container

 

Returns

TRUE if successful, FALSE otherwise.

Since: 6.0


gda_ddl_column_prepare_add ()

gboolean
gda_ddl_column_prepare_add (GdaDdlColumn *self,
                            GdaServerOperation *op,
                            GError **error);

Populate op with information stored in self . This method is used to prepare op for GDA_SERVER_OPERATION_ADD_COLUMN operation.

Parameters

self

a GdaDdlColumn instance

 

op

GdaServerOperation to add information

 

error

error storage container

 

Returns

TRUE if success, FALSE otherwise.

Types and Values

GDA_TYPE_DDL_COLUMN

#define GDA_TYPE_DDL_COLUMN (gda_ddl_column_get_type())

struct GdaDdlColumnClass

struct GdaDdlColumnClass {
  GObjectClass parent;
};

enum GdaDdlColumnError

Values used to describe the source of the error.

Members

GDA_DDL_COLUMN_ERROR_TYPE

Set if wrong column type was given in the xml file.

 

GDA_DDL_COLUMN_ERROR

#define GDA_DDL_COLUMN_ERROR gda_ddl_column_error_quark()

GdaDdlColumn

typedef struct _GdaDdlColumn GdaDdlColumn;

Property Details

The “autoinc” property

  “autoinc”                  gboolean

Can value be autoincremented.

Flags: Read / Write

Default value: FALSE


The “check” property

  “check”                    gchar *

Column check string.

Flags: Read / Write

Default value: NULL


The “comment” property

  “comment”                  gchar *

Column comment.

Flags: Read / Write

Default value: NULL


The “default” property

  “default”                  gchar *

Default value.

Flags: Read / Write

Default value: NULL


The “name” property

  “name”                     gchar *

Column name.

Flags: Read / Write

Default value: NULL


The “nnul” property

  “nnul”                     gboolean

Can value be NULL.

Flags: Read / Write

Default value: TRUE


The “pkey” property

  “pkey”                     gboolean

Is is primery key.

Flags: Read / Write

Default value: FALSE


The “scale” property

  “scale”                    guint

Number of decimal for numeric type.

Flags: Read / Write

Allowed values: <= 64

Default value: 2


The “size” property

  “size”                     guint

Column size.

Flags: Read / Write

Allowed values: <= 9999

Default value: 80


The “unique” property

  “unique”                   gboolean

Can value be unique.

Flags: Read / Write

Default value: FALSE