Class 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
    • Constructor Summary

      Constructors 
      Constructor Description
      DB_User()  
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      DB_Statement def_domain​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      java.lang.String get_SQL​(java.lang.String schema)
      Generate a SQL string with the appropriate values set for each argument.
      DB_Statement handle​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement has_all_groups​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement has_all_records​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement info​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      DB_Statement is_active​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      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.
      DB_Statement login​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      DB_Statement login​(java.lang.String p_netid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement netid_from_oauthid​(java.lang.String p_oauthid)
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      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.
      DB_Statement update_starting_address()
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      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.
      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.
      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.
      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.
      DB_Statement verify_or_die​(java.lang.Long p_user_id)
      Generate the arguments for the corresponding stored procedure in the database.
      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.
      DB_Statement verify_or_die​(java.lang.String p_netid)
      Generate the arguments for the corresponding stored procedure in the database.
      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
    • Constructor Detail

      • DB_User

        public DB_User()
    • 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.