/ 
XSDSQL_20130411
River stage zero No dependents
/ blx::xsdsql::schema_repository::sql::generic::column

NAME

blx::xsdsql::schema_repository::sql::generic::column - a generic colum class

SYNOPSIS

use blx::xsdsql::schema_repository::sql::generic::column

DESCRIPTION

this package is a class - instance it with the method new

VERSION

0.10.0

FUNCTIONS

this module defined the followed functions

new - constructor

PARAMS:
    COLUMN_SEQUENCE - a sequence number into the table - the first column has sequence 0
    XSD_SEQ  - a sequence number into xsd
    MIN_OCCURS - default 1
    MAX_OCCURS - default 1
    NAME  - a basename of xml node
    PATH     - a path name of xml xml node
    PATH_REFERENCE - the referenced by column
    TABLE_REFERENCE    - the table referenced by column
    INTERNAL_REFERENCE - true if the column is an array of simple types
    PK_SEQ  - sequence position number into the primary key
    GROUP_REF - true if the column reference a group
    TABLE_NAME - the table name of the column
    CHOICE    - if true the column is part of a choice
    ATTRIBUTE    - if true the column  is an attribute
    SYS_ATTRIBUTES - if true the column contain system attributes
    ELEMENT_FORM - the value of form attribute (Q)ualified|(U)nqualified

set_attrs_value - set a value of attributes

the arguments are a pairs NAME => VALUE
the method return a self object

get_attrs_value - return a list of attributes values

the arguments are a list of attributes name

get_column_sequence - return the sequence into the table - the first column has sequence 0

get_sql_type - return the sql type of the column

get_sql_name - return the sql name of the column

get_min_occurs - return the value of the minoccurs into the xsd schema

get_max_occurs - return the value of the maxoccurs into the xsd schema

is_internal_reference - return true if the column is an array of simple types

is_group_reference - return true if the column reference a xsd group

is_choice - return true if the column is a part of a choice

is_attribute - return true if the column is an attribute

is_sys_attributes - return true if then column contain system attributes in the form name="value"[,..]

get_path - return the node path name

get_path_reference - return the path referenced

get_table_reference - return the table referenced

get_table_name - return the table name of the column

is_pk - return true if the column is part of the primary key

get_pk_seq - return the sequence into the primary key

get_xsd_seq - return a sequence number into a choice

get_element_form - return the value of form attribute (Q)ualified|(U)nqualified

get_URI - return the external URI referenced

set_sql_name - ser the sql name of the column

params:
        COLUMNNAME_LIST => hash for store a uniq names

set_sql_type - set the sql type of the column

params:
        EXTRA_TABLES = an object of type  blx::xsdsql::schema_repository::sql::generic::extra_tables

EXPORT

None by default.

EXPORT_OK

none

SEE ALSO

See blx::xsdsql::schema_repository::sql::generic::catalog, it's the base class See blx:.xsdsql::generator for generate the schema of the database and blx::xsdsql::parser for parse a xsd file (schema file)

AUTHOR

lorenzo.bellotti, <pauseblx@gmail.com>

COPYRIGHT

Copyright (C) 2010 by lorenzo.bellotti

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

See http://www.perl.com/perl/misc/Artistic.html