auth::sync::job::create_entry (public)

 auth::sync::job::create_entry -job_id job_id -operation operation \
    -username username [ -user_id user_id ] [ -success ] \
    [ -message message ] [ -element_messages element_messages ]

Defined in packages/acs-authentication/tcl/sync-procs.tcl

Record a batch job entry.

Switches:
-job_id (required)
The ID of the batch job you're ending.
-operation (required)
One of 'insert', 'update', or 'delete'.
-username (required)
The username of the user being inserted/updated/deleted.
-user_id (optional)
The user_id of the local user account, if known.
-success (optional, boolean)
Whether or not the operation went well.
-message (optional)
Any error message to stick into the log.
-element_messages (optional)
Returns:
entry_id

Partial Call Graph (max 5 caller/called nodes):
%3 test_auth_sync_process_ims_implementations auth_sync_process_ims_implementations (test acs-authentication) auth::sync::job::create_entry auth::sync::job::create_entry test_auth_sync_process_ims_implementations->auth::sync::job::create_entry test_sync_start_end sync_start_end (test acs-authentication) test_sync_start_end->auth::sync::job::create_entry db_dml db_dml (public) auth::sync::job::create_entry->db_dml db_nextval db_nextval (public) auth::sync::job::create_entry->db_nextval auth::sync::job::action auth::sync::job::action (public) auth::sync::job::action->auth::sync::job::create_entry

Testcases:
sync_start_end, auth_sync_process_ims_implementations
Source code:
    set success_p_db [expr {$success_p ? "t" : "f"}]

    set entry_id [db_nextval "auth_batch_job_entry_id_seq"]

    db_dml insert_entry {} -clobs [list $element_messages]

    return $entry_id
Generic XQL file:
packages/acs-authentication/tcl/sync-procs.xql

PostgreSQL XQL file:
<fullquery name="auth::sync::job::create_entry.insert_entry">
    <querytext>

            insert into auth_batch_job_entries
            (entry_id, job_id, operation, username, user_id, success_p, message, element_messages)
            values
            (:entry_id, :job_id, :operation, :username, :user_id, :success_p_db, :message, :element_messages)

        </querytext>
</fullquery>
packages/acs-authentication/tcl/sync-procs-postgresql.xql

Oracle XQL file:
<fullquery name="auth::sync::job::create_entry.insert_entry">
    <querytext>

            insert into auth_batch_job_entries
            (entry_id, job_id, operation, username, user_id, success_p, message, element_messages)
            values
            (:entry_id, :job_id, :operation, :username, :user_id, :success_p_db, :message, empty_clob())
            returning element_messages into :1

        </querytext>
</fullquery>
packages/acs-authentication/tcl/sync-procs-oracle.xql

[ hide source ] | [ make this the default ]
Show another procedure: