Package stanford.netdb.middleware
Class DB_User
- java.lang.Object
-
- stanford.netdb.logging.NetDB_Logger
-
- stanford.netdb.middleware.DB_Statement
-
- stanford.netdb.middleware.DB_User
-
- All Implemented Interfaces:
java.io.Serializable
public class DB_User extends DB_Statement
This class generates the SQL that is called in the database. Each method sets up the necessary variables containing the argument names and types, in the format that NetDB_Connection expects.- See Also:
NetDB_Connection, Serialized Form
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class stanford.netdb.middleware.DB_Statement
DB_Statement.STATEMENT_TYPE
-
-
Field Summary
Fields Modifier and Type Field Description static longserialVersionUID-
Fields inherited from class stanford.netdb.middleware.DB_Statement
ORA_FUN_CALL, ORA_PROC_CALL, SELECT
-
-
Constructor Summary
Constructors Constructor Description DB_User()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description DB_Statementdef_domain(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementdelete(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.java.lang.Stringget_SQL(java.lang.String schema)Generate a SQL string with the appropriate values set for each argument.DB_Statementhandle(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementhas_all_groups(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementhas_all_records(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinfo(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_comment, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementis_active(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementlock_record(java.lang.Long p_op_uid, java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementlocked_or_die(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementlogin(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementlogin(java.lang.Long p_user_id, java.lang.String p_netid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementlogin(java.lang.String p_netid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementnetid_from_oauthid(java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementorg(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.Long p_org_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementunlock_record(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupd_profile(java.lang.Long p_op_uid, java.lang.String p_def_group, java.lang.String p_def_domain)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupd_profile(java.lang.Long p_op_uid, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_comment, java.lang.String p_oauthid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementupdate_starting_address()Generate the arguments for the corresponding stored procedure in the database.DB_Statementusers_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementusers_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.Long p_access_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementusers_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.Long p_access_id, java.lang.String p_access_name)Generate the arguments for the corresponding stored procedure in the database.DB_Statementusers_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_access_name)Generate the arguments for the corresponding stored procedure in the database.DB_Statementverify_and_log(java.lang.Long p_op_uid, java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementverify_or_die(java.lang.Long p_user_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementverify_or_die(java.lang.Long p_user_id, java.lang.String p_netid)Generate the arguments for the corresponding stored procedure in the database.DB_Statementverify_or_die(java.lang.String p_netid)Generate the arguments for the corresponding stored procedure in the database.-
Methods inherited from class stanford.netdb.middleware.DB_Statement
get_first_out_param, get_next_out_param, get_parameter_name, get_type, get_values, statement_max_tries, statement_max_tries, statement_timeout, statement_timeout, toString
-
Methods inherited from class stanford.netdb.logging.NetDB_Logger
default_logger, default_logger, logger, logger
-
-
-
-
Field Detail
-
serialVersionUID
public static final long serialVersionUID
- See Also:
- Constant Field Values
-
-
Method Detail
-
get_SQL
public java.lang.String get_SQL(java.lang.String schema)
Generate a SQL string with the appropriate values set for each argument.
-
def_domain
public DB_Statement def_domain(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
delete
public DB_Statement delete(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
handle
public DB_Statement handle(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
has_all_groups
public DB_Statement has_all_groups(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
has_all_records
public DB_Statement has_all_records(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
info
public DB_Statement info(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_comment, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
insert
public DB_Statement insert(java.lang.Long p_op_uid, java.lang.String p_person_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups)
Generate the arguments for the corresponding stored procedure in the database.
-
is_active
public DB_Statement is_active(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
lock_record
public DB_Statement lock_record(java.lang.Long p_op_uid, java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
locked_or_die
public DB_Statement locked_or_die(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
login
public DB_Statement login(java.lang.Long p_user_id, java.lang.String p_netid)
Generate the arguments for the corresponding stored procedure in the database.
-
login
public DB_Statement login(java.lang.String p_netid)
Generate the arguments for the corresponding stored procedure in the database.
-
login
public DB_Statement login(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
netid_from_oauthid
public DB_Statement netid_from_oauthid(java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
org
public DB_Statement org(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.Long p_org_id)
Generate the arguments for the corresponding stored procedure in the database.
-
unlock_record
public DB_Statement unlock_record(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_comment, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_comment, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_groups)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups, java.lang.String p_oauthid)
Generate the arguments for the corresponding stored procedure in the database.
-
update
public DB_Statement update(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address, java.lang.Long p_active, java.lang.Long p_all_records, java.lang.Long p_all_groups)
Generate the arguments for the corresponding stored procedure in the database.
-
upd_profile
public DB_Statement upd_profile(java.lang.Long p_op_uid, java.lang.String p_def_group, java.lang.String p_def_domain, java.lang.String p_starting_address)
Generate the arguments for the corresponding stored procedure in the database.
-
upd_profile
public DB_Statement upd_profile(java.lang.Long p_op_uid, java.lang.String p_def_group, java.lang.String p_def_domain)
Generate the arguments for the corresponding stored procedure in the database.
-
update_starting_address
public DB_Statement update_starting_address()
Generate the arguments for the corresponding stored procedure in the database.
-
users_access
public DB_Statement users_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.Long p_access_id, java.lang.String p_access_name)
Generate the arguments for the corresponding stored procedure in the database.
-
users_access
public DB_Statement users_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.String p_access_name)
Generate the arguments for the corresponding stored procedure in the database.
-
users_access
public DB_Statement users_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
users_access
public DB_Statement users_access(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_user_id, java.lang.Long p_access_id)
Generate the arguments for the corresponding stored procedure in the database.
-
verify_and_log
public DB_Statement verify_and_log(java.lang.Long p_op_uid, java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
verify_or_die
public DB_Statement verify_or_die(java.lang.Long p_user_id, java.lang.String p_netid)
Generate the arguments for the corresponding stored procedure in the database.
-
verify_or_die
public DB_Statement verify_or_die(java.lang.String p_netid)
Generate the arguments for the corresponding stored procedure in the database.
-
verify_or_die
public DB_Statement verify_or_die(java.lang.Long p_user_id)
Generate the arguments for the corresponding stored procedure in the database.
-
-