xo::db::sql::acs_rel_type proc create_type (public)

 xo::db::sql::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/xotcl-core/tcl/05-db-procs.tcl

Automatically generated method

Switches:

-dbn

(optional)

-rel_type

(required)

-pretty_name

(required)

-pretty_plural

(required)

-supertype

(defaults to "relationship") (optional)

-table_name

(required)

-id_column

(required)

-package_name

(required)

-object_type_one

(required)

-role_one

(optional)

-min_n_rels_one

(required)

-max_n_rels_one

(required)

-object_type_two

(required)

-role_two

(optional)

-min_n_rels_two

(required)

-max_n_rels_two

(required)

-composable_p

(defaults to "t") (optional)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

#function_args: {REL_TYPE {}} {PRETTY_NAME {}} {PRETTY_PLURAL {}} {SUPERTYPE relationship} {TABLE_NAME {}} {ID_COLUMN {}} {PACKAGE_NAME {}} {OBJECT_TYPE_ONE {}} {ROLE_ONE null} {MIN_N_RELS_ONE {}} {MAX_N_RELS_ONE {}} {OBJECT_TYPE_TWO {}} {ROLE_TWO null} {MIN_N_RELS_TWO {}} {MAX_N_RELS_TWO {}} {COMPOSABLE_P t}
foreach var [list REL_TYPE PRETTY_NAME PRETTY_PLURAL SUPERTYPE TABLE_NAME ID_COLUMN PACKAGE_NAME OBJECT_TYPE_ONE ROLE_ONE MIN_N_RELS_ONE MAX_N_RELS_ONE OBJECT_TYPE_TWO ROLE_TWO MIN_N_RELS_TWO MAX_N_RELS_TWO COMPOSABLE_P]  {
  set varname [string tolower $var]
  if {[info exists $varname]} {
    set $var [set $varname]
    set _$var :$var
  } else {
    set _$var null
  }
}
set sql "
select acs_rel_type__create_type($_REL_TYPE, $_PRETTY_NAME, $_PRETTY_PLURAL, $_SUPERTYPE, $_TABLE_NAME, $_ID_COLUMN, $_PACKAGE_NAME, $_OBJECT_TYPE_ONE, $_ROLE_ONE, $_MIN_N_RELS_ONE, $_MAX_N_RELS_ONE, $_OBJECT_TYPE_TWO, $_ROLE_TWO, $_MIN_N_RELS_TWO, $_MAX_N_RELS_TWO, $_COMPOSABLE_P) 
    "
db_with_handle -dbn $dbn db {
  #ns_log notice "--sql=$sql"
  return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ]
}

XQL Not present:

Generic, PostgreSQL, Oracle