acs::db::nsdb-postgresql method call acs_rel_type create_type (public)

 <instance of acs::db::nsdb-postgresql> call acs_rel_type create_type \
    [ -dbn dbn ] -rel_type rel_type  -pretty_name pretty_name  \
    -pretty_plural pretty_plural  [ -supertype supertype ] \
    -table_name table_name  -id_column id_column  \
    -package_name package_name  -object_type_one object_type_one  \
    [ -role_one role_one ] -min_n_rels_one min_n_rels_one  \
    -max_n_rels_one max_n_rels_one  -object_type_two object_type_two  \
    [ -role_two role_two ] -min_n_rels_two min_n_rels_two  \
    -max_n_rels_two max_n_rels_two  [ -composable_p composable_p ]

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} {character varying} integer integer {character varying} {character varying} integer integer boolean

Switches:

-dbn (optional)

-rel_type (required)

-pretty_name (required)

-pretty_plural (required)

-supertype (optional, defaults to "relationship")

-table_name (required)

-id_column (required)

-package_name (required)

-object_type_one (required)

-role_one (optional, accept empty)

-min_n_rels_one (required)

-max_n_rels_one (required)

-object_type_two (required)

-role_two (optional, accept empty)

-min_n_rels_two (required)

-max_n_rels_two (required)

-composable_p (optional, defaults to "t")

Testcases:

No testcase defined.

Source code:

db_with_handle -dbn $dbn __DB {
   set s [ns_pg_bind 0or1row $__DB {select acs_rel_type__create_type(:rel_type,:pretty_name,:pretty_plural,:supertype,:table_name,:id_column,:package_name,:object_type_one,:role_one,CAST(:min_n_rels_one AS integer),CAST(:max_n_rels_one AS integer),:object_type_two,:role_two,CAST(:min_n_rels_two AS integer),CAST(:max_n_rels_two AS integer),:composable_p)}]
   return [ns_set value $s 0]
}

XQL Not present:

Generic, PostgreSQL, Oracle