Sanity checks

Scripts that require sanity checks

• Add column to table

Scripts not requiring additional sanity checks

• “im_menu__new” checks if menu item already exists
• “im_component_plugin__new” checks if plugin already exists

Create privileges

-- New Privilege to allow accounting guys to change hours
select acs_privilege__create_privilege('add_hours_all','Edit Hours All','Edit Hours All');
select acs_privilege__add_child('admin', 'add_hours_all');

select im_priv_create('add_hours_all', 'Accounting');
select im_priv_create('add_hours_all', 'P/O Admins');
select im_priv_create('add_hours_all', 'Senior Managers');

Sample Script ‘Add Column’

create or replace function inline_0 ()
returns integer as '
declare
        v_count         integer;
begin
        select count(*) into v_count from information_schema.columns where
              table_name = ''acs_object_types''
              and column_name = ''icon_path'';

user_tab_columns
        where lower(table_name) = ''acs_object_types'' and lower(column_name) = ''icon_path'';
        IF v_count > 0 THEN return 1; END IF;

        alter table acs_object_types add column icon_path character varying(100);
        RETURN 0;

end;' language 'plpgsql';
select inline_0 ();
drop function inline_0 ();

Check existence of column:

        select count(*) into v_count from information_schema.columns where
              table_name = ''acs_object_types''
              and column_name = ''icon_path'';

Check existence of table:

select count(*) into v_count from pg_tables where tablename = ''im_capacity_planning'';

Check for existing constraints

        select count(*) into v_count from pg_constraint
        where lower(conname) = ''im_hours_project_fk'';

Check existence of index:

        select count(*) into v_count
        from pg_indexes
        where tablename = ''im_tickets'' and indexname = ''im_ticket_type_id_idx'';

Create categories

SELECT im_category_new (16006, 'Rejected', 'Intranet Absence Status');

Create menu item

SELECT im_new_menu(
        'intranet-timesheet2',
        'timesheet2_absences_bankholiday',
        'New Bank Holiday',
        '/intranet-timesheet2/absences/new?absence_type_id=5004',
        50,
        'timesheet2_absences',
        null
);

Create menu permissions

SELECT im_new_menu_perms('timesheet2_absences_bankholiday', 'Employees');

Debugging

RAISE NOTICE 'workflow_case__notify_assignee: Subject=%, Body=%', v_subject, v_body;