Index: openacs-4/packages/bug-tracker/bug-tracker.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/bug-tracker.info,v diff -u -r1.26 -r1.27 --- openacs-4/packages/bug-tracker/bug-tracker.info 26 Jun 2008 22:09:09 -0000 1.26 +++ openacs-4/packages/bug-tracker/bug-tracker.info 15 Feb 2010 20:09:21 -0000 1.27 @@ -8,7 +8,7 @@ f f - + Lars Pind Tracks bugs and features, versions and maintainers, in software projects. 2008-05-13 @@ -17,7 +17,7 @@ Contains the best of SDM, Bugzilla, FogBUGZ, and bughost.com. 0 - + Index: openacs-4/packages/bug-tracker/catalog/bug-tracker.en_US.ISO-8859-1.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/catalog/bug-tracker.en_US.ISO-8859-1.xml,v diff -u -r1.12 -r1.13 --- openacs-4/packages/bug-tracker/catalog/bug-tracker.en_US.ISO-8859-1.xml 29 Jun 2008 01:05:36 -0000 1.12 +++ openacs-4/packages/bug-tracker/catalog/bug-tracker.en_US.ISO-8859-1.xml 15 Feb 2010 20:09:21 -0000 1.13 @@ -87,6 +87,7 @@ Deleted Description format + Details download Download patch content Duplicate Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v diff -u -r1.17 -r1.18 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 26 Jun 2008 23:55:30 -0000 1.17 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 15 Feb 2010 20:09:21 -0000 1.18 @@ -847,6 +847,8 @@ create index bt_patch_bug_map_patch_id_idx on bt_patch_bug_map(patch_id); create index bt_patch_bug_map_bug_id_idx on bt_patch_bug_map(bug_id); +\i bug-tracker-search-triggers-create.sql + -- AutoSubmition functionality \i auto-error-report.sql Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql 25 Feb 2005 17:08:11 -0000 1.8 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql 15 Feb 2010 20:09:21 -0000 1.9 @@ -65,3 +65,5 @@ delete from acs_objects where object_type = 'bt_patch'; select acs_object_type__drop_type('bt_patch', 't'); + +\i bug-tracker-search-triggers-drop.sql Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-create.sql 15 Feb 2010 20:09:21 -0000 1.1 @@ -0,0 +1,36 @@ +-- Bug tracker search triggers +-- +-- @author Don Baccus (dhogaza@pacifier.com) +-- @cvs-id $Id: bug-tracker-search-triggers-create.sql,v 1.1 2010/02/15 20:09:21 donb Exp $ + +-- Triggers for the bug item table. + +create or replace function bt_bug_search__itrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''INSERT''); + return new; +end;' language 'plpgsql'; + +create or replace function bt_bug_search__utrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''UPDATE''); + return old; +end;' language 'plpgsql'; + +create or replace function bt_bug_search__dtrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''DELETE''); + return old; +end;' language 'plpgsql'; + +create trigger bt_bug_search__itrg after insert on bt_bugs +for each row execute procedure bt_bug_search__itrg (); + +create trigger bt_bug_search__utrg after update on bt_bugs +for each row execute procedure bt_bug_search__utrg (); + +create trigger bt_bug_search__dtrg after delete on bt_bugs +for each row execute procedure bt_bug_search__dtrg (); Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers-drop.sql 15 Feb 2010 20:09:21 -0000 1.1 @@ -0,0 +1,7 @@ +drop trigger bt_bug_search__itrg on bt_bugs; +drop trigger bt_bug_search__utrg on bt_bugs; +drop trigger bt_bug_search__dtrg on bt_bugs; + +drop function bt_bug_search__itrg (); +drop function bt_bug_search__utrg (); +drop function bt_bug_search__dtrg (); Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-search-triggers.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.4d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/Attic/upgrade-1.4d6-1.4d7.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4d6-1.4d7.sql 15 Feb 2010 20:09:21 -0000 1.1 @@ -0,0 +1,37 @@ + +-- Bug tracker search triggers +-- +-- @author Don Baccus (dhogaza@pacifier.com) +-- @cvs-id $Id: upgrade-1.4d6-1.4d7.sql,v 1.1 2010/02/15 20:09:21 donb Exp $ + +-- Triggers for the bug item table. + +create or replace function bt_bug_search__itrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''INSERT''); + return new; +end;' language 'plpgsql'; + +create or replace function bt_bug_search__utrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''UPDATE''); + return old; +end;' language 'plpgsql'; + +create or replace function bt_bug_search__dtrg () +returns trigger as ' +begin + perform search_observer__enqueue(new.bug_id,''DELETE''); + return old; +end;' language 'plpgsql'; + +create trigger bt_bug_search__itrg after insert on bt_bugs +for each row execute procedure bt_bug_search__itrg (); + +create trigger bt_bug_search__utrg after update on bt_bugs +for each row execute procedure bt_bug_search__utrg (); + +create trigger bt_bug_search__dtrg after delete on bt_bugs +for each row execute procedure bt_bug_search__dtrg (); Index: openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl,v diff -u -r1.3 -r1.4 --- openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl 1 Dec 2005 13:25:27 -0000 1.3 +++ openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl 15 Feb 2010 20:09:21 -0000 1.4 @@ -34,8 +34,7 @@ foreach assignee [workflow::case::role::get_assignees -case_id $case_id -role_id $role_id] { array set ass $assignee template::multirow -local append roles \ - $role(pretty_name) $ass(email) $ass(party_id) $ass(name) \ - "[ad_url][acs_community_member_url -user_id $ass(party_id)]" + $role(pretty_name) $ass(email) $ass(party_id) $ass(name) array unset ass } array unset role