acs::db::nsdb-postgresql method call acs_attribute create_attribute (public)

 <instance of acs::db::nsdb-postgresql> call acs_attribute create_attribute \
    [ -dbn dbn ] -object_type object_type  \
    -attribute_name attribute_name  -datatype datatype  \
    -pretty_name pretty_name  [ -pretty_plural pretty_plural ] \
    [ -table_name table_name ] [ -column_name column_name ] \
    [ -default_value default_value ] [ -min_n_values min_n_values ] \
    [ -max_n_values max_n_values ] [ -sort_order sort_order ] \
    [ -storage storage ] [ -static_p static_p ] \
    [ -create_column_p create_column_p ] \
    [ -database_type database_type ] [ -size size ] [ -null_p null_p ] \
    [ -references references ] [ -check_expr check_expr ] \
    [ -column_spec column_spec ]

Defined in packages/acs-tcl/tcl/00-acs-tcl-init.tcl

Automatically generated method TYPES: {character varying} {character varying} {character varying} {character varying} {character varying} {character varying} {character varying} {character varying} integer integer integer {character varying} boolean boolean {character varying} {character varying} boolean {character varying} {character varying} {character varying}

Switches:

-dbn (optional)

-object_type (required)

-attribute_name (required)

-datatype (required)

-pretty_name (required)

-pretty_plural (optional, accept empty)

-table_name (optional, accept empty)

-column_name (optional, accept empty)

-default_value (optional, accept empty)

-min_n_values (optional, defaults to "1")

-max_n_values (optional, defaults to "1")

-sort_order (optional, accept empty)

-storage (optional, defaults to "type_specific")

-static_p (optional, defaults to "f")

-create_column_p (optional, defaults to "f")

-database_type (optional, accept empty)

-size (optional, accept empty)

-null_p (optional, defaults to "t")

-references (optional, accept empty)

-check_expr (optional, accept empty)

-column_spec (optional, accept empty)

Testcases:

No testcase defined.

Source code:

db_with_handle -dbn $dbn __DB {
   set s [ns_pg_bind 0or1row $__DB {select acs_attribute__create_attribute(:object_type,:attribute_name,:datatype,:pretty_name,:pretty_plural,:table_name,:column_name,:default_value,CAST(:min_n_values AS integer),CAST(:max_n_values AS integer),CAST(:sort_order AS integer),:storage,:static_p,:create_column_p,:database_type,:size,:null_p,:references,:check_expr,:column_spec)}]
   return [ns_set value $s 0]
}

XQL Not present:

Generic, PostgreSQL, Oracle