<commit_before><items>
    <folder type="TABLE">
        <name>DURCO Table Menu</name>
        <item type="TABLE" reloadparent="true">
            <title>Crud Table</title>
            <prompt type="confirm">
                <label>Generate a CRUD Matrix for the current table ?</label>
            </prompt>
            <sql>
                <![CDATA[
                    declare
                        pragma autonomous_transaction;
                    begin 
                        crudo.generate_matrices.crud_table( i_owner => '#OBJECT_OWNER#', i_table_name => '#OBJECT_NAME#');
                    commit;
                    exception when others then
                        rollback;
                        raise;
                    end;
                ]]>
            </sql>
            <help>This action Generates a crud for the table</help>
        </item>
    </folder>
</items><commit_msg>Added Menu Items for Overrides. Changed Menu Name to reflect name of Application<commit_after><items>
    <folder type="TABLE">
        <name>CRUDO Table Menu</name>

        <!-- CRUD Table -->
        <item type="TABLE" reloadparent="true">
            <title>Crud Table</title>
            <prompt type="confirm">
                <label>Generate a CRUD Matrix for the current table ?</label>
            </prompt>
            <sql>
                <![CDATA[
                    declare
                        pragma autonomous_transaction;
                    begin 
                        crudo.generate_matrices.crud_table( i_owner => '#OBJECT_OWNER#', i_table_name => '#OBJECT_NAME#');
                    commit;
                    exception when others then
                        rollback;
                        raise;
                    end;
                ]]>
            </sql>
            <confirmation>
                <title>Confirmation</title>
                <prompt>CRUD MATRIX generated for table #OBJECT_OWNER#.#OBJECT_NAME#</prompt>
            </confirmation>
            <help>This action Generates a crud for the table</help>
        </item>

        <!-- Add Override -->
        <item type="TABLE" reloadparent="true">
            <title>Add CRUD Override Record</title>
            <prompt>
                <label>Object Owner</label>
                <default><![CDATA[select sys_context('userenv', 'current_schema') from dual]]></default>
                <value><![CDATA[select username from all_users order by username]]></value>
            </prompt>
            <prompt><label>Object Name</label></prompt>
            <prompt>
                <label>Object Type :</label>
                <value><![CDATA[STATIC:FUNCTION:MATERIALIZED VIEW:PACKAGE:PACKAGE BODY:PROCEDURE:TRIGGER:VIEW]]></value>
            </prompt>

            <prompt>
                <label>Create</label>
                <value><![CDATA[STATIC:Y:N]]></value>
            </prompt>
            <prompt>
                <label>Read</label>
                <value><![CDATA[STATIC:Y:N]]></value>
            </prompt>
            <prompt>
                <label>Update</label>
                <value><![CDATA[STATIC:Y:N]]></value>
            </prompt>
            <prompt>
                <label>Delete</label>
                <value><![CDATA[STATIC:Y:N]]></value>
            </prompt>
            <sql>
                    <![CDATA[
                        declare
                            pragma autonomous_transaction;
                        begin
                            crudo.generate_matrices.set_override
                            ( 
                                i_table_owner => '#OBJECT_OWNER#', 
                                i_table_name => '#OBJECT_NAME#',
                                i_object_owner => '#0#',
                                i_object_name => '#1#',
                                i_object_type => '#2#',
                                i_create => '#3#',                            
                                i_read => '#4#',
                                i_update => '#5#',
                                i_delete => '#6#'
                            );
                        commit;
                        exception when others then
                            rollback;
                            raise;
                        end;
                    ]]>
                </sql>
                <confirmation>
                <title>Confirmation</title>
                <prompt>Override record added for table #OBJECT_OWNER#.#OBJECT_NAME#</prompt>
            </confirmation>

                <help>This action creates a Manual Override crud matrix record</help>
        </item>
        
        <!-- Remove Override -->
        <item type="TABLE" reloadparent="true">
            <title>Remove CRUD Override Record</title>
            <prompt> <label>Object Owner</label> </prompt>
            <prompt> <label>Object Name</label> </prompt>
            <prompt>
                <label>Object Type :</label>
                <value><![CDATA[STATIC:FUNCTION:MATERIALIZED VIEW:PACKAGE:PACKAGE BODY:PROCEDURE:TRIGGER:VIEW]]></value>
            </prompt>
            <sql>
                    <![CDATA[
                        declare
                            pragma autonomous_transaction;
                        begin
                            crudo.generate_matrices.remove_override
                            ( 
                                i_table_owner => '#OBJECT_OWNER#', 
                                i_table_name => '#OBJECT_NAME#',
                                i_object_owner => '#0#',
                                i_object_name => '#1#',
                                i_object_type => '#2#'
                            );
                        commit;
                        exception when others then
                            rollback;
                            raise;
                        end;
                    ]]>
            </sql>
            <confirmation>
            <title>Confirmation</title>
            <prompt>Override record for #2# #0#.#1# on table #OBJECT_OWNER#.#OBJECT_NAME# removed</prompt>
            </confirmation>
            <help>This action removes a Manual Override crud matrix record</help>
        </item>
        
    </folder>
</items>
{'fraction_non_alphanumeric': 0.10809092354156732, 'fraction_numerical': 0.0020664441265299633, 'mean_word_length': 1.0622746640445755, 'pattern_counts': {'":': 0, '<': 144, '<?xml version=': 0, '>': 162, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4540815', 'n_tokens_mistral': 1615, 'n_tokens_neox': 1440, 'n_words': 307}