- Methods: All Methods Documented Methods Hide Methods
- Source: Display Source Hide Source
- Variables: Show Variables Hide Variables
Class ::xo::db::sql::acs
::xo::db::sql::acs create ...
Class Relations
::xo::db::Class create ::xo::db::sql::acs \ -superclass ::xotcl::ObjectMethods (to be applied on the object)
add_user (scripted, public)
xo::db::sql::acs add_user [ -dbn dbn ] [ -user_id user_id ] \ [ -object_type object_type ] [ -creation_date creation_date ] \ [ -creation_user creation_user ] [ -creation_ip creation_ip ] \ -authority_id authority_id -username username -email email \ [ -url url ] -first_names first_names -last_name last_name \ -password password -salt salt [ -screen_name screen_name ] \ [ -email_verified_p email_verified_p ] \ [ -member_state member_state ]Automatically generated method
- Switches:
- -dbn
(optional)- -user_id
(optional)- -object_type
(defaults to"user"
) (optional)- -creation_date
(defaults to"now()"
) (optional)- -creation_user
(optional)- -creation_ip
(optional)- -authority_id
(required)- -username
(required)- -url
(optional)- -first_names
(required)- -last_name
(required)- -password
(required)- -salt
(required)- -screen_name
(optional)- -email_verified_p
(defaults to"t"
) (optional)- -member_state
(defaults to"approved"
) (optional)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: {USER_ID null} {OBJECT_TYPE user} {CREATION_DATE now()} {CREATION_USER null} {CREATION_IP null} {AUTHORITY_ID {}} {USERNAME {}} {EMAIL {}} {URL null} {FIRST_NAMES {}} {LAST_NAME {}} {PASSWORD {}} {SALT {}} {SCREEN_NAME null} {EMAIL_VERIFIED_P t} {MEMBER_STATE approved} foreach var [list USER_ID OBJECT_TYPE CREATION_DATE CREATION_USER CREATION_IP AUTHORITY_ID USERNAME EMAIL URL FIRST_NAMES LAST_NAME PASSWORD SALT SCREEN_NAME EMAIL_VERIFIED_P MEMBER_STATE] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select acs__add_user($_USER_ID, $_OBJECT_TYPE, $_CREATION_DATE, $_CREATION_USER, $_CREATION_IP, $_AUTHORITY_ID, $_USERNAME, $_EMAIL, $_URL, $_FIRST_NAMES, $_LAST_NAME, $_PASSWORD, $_SALT, $_SCREEN_NAME, $_EMAIL_VERIFIED_P, $_MEMBER_STATE) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }magic_object_id (scripted, public)
xo::db::sql::acs magic_object_id [ -dbn dbn ] -name nameAutomatically generated method
- Switches:
- -dbn
(optional)- -name
(required)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: {NAME {}} foreach var [list NAME] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select acs__magic_object_id($_NAME) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }remove_user (scripted, public)
xo::db::sql::acs remove_user [ -dbn dbn ] -user_id user_idAutomatically generated method
- Switches:
- -dbn
(optional)- -user_id
(required)- Partial Call Graph (max 5 caller/called nodes):
- Testcases:
- No testcase defined.
#function_args: {USER_ID {}} foreach var [list USER_ID] { set varname [string tolower $var] if {[info exists $varname]} { set $var [set $varname] set _$var :$var } else { set _$var null } } set sql " select acs__remove_user($_USER_ID) " db_with_handle -dbn $dbn db { #ns_log notice "--sql=$sql" return [ ns_set value [ns_pg_bind 0or1row $db $sql] 0 ] }
- Methods: All Methods Documented Methods Hide Methods
- Source: Display Source Hide Source
- Variables: Show Variables Hide Variables