Fisheye: Tag 1.2.4.1 refers to a dead (removed) revision in file `openacs-4/packages/search/sql/oracle/load-site-wide-search'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2.4.1 refers to a dead (removed) revision in file `openacs-4/packages/search/sql/oracle/search-ctxsys.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/search/sql/oracle/search-im-convert.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.3.4.1 refers to a dead (removed) revision in file `openacs-4/packages/search/sql/oracle/search-index-create.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.3.4.1 refers to a dead (removed) revision in file `openacs-4/packages/search/sql/oracle/search-index-drop.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2.4.1 refers to a dead (removed) revision in file `openacs-4/packages/search/sql/oracle/search-index-from-scratch.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/search/sql/oracle/search-packages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-packages-create.sql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/search/sql/oracle/search-packages-create.sql 31 Aug 2006 07:31:29 -0000 1.4 +++ openacs-4/packages/search/sql/oracle/search-packages-create.sql 16 Apr 2008 12:41:13 -0000 1.4.4.1 @@ -239,248 +239,3 @@ / show errors --- TRIGGERS SHOULD GO IN THEIR OWN PACKAGE -- - --------------------------------------------------------- --- Forum triggers and procedures - --- create or replace trigger forums_messages_sws_insert_tr --- after insert on forums_messages for each row --- begin --- site_wide_search.register_event (:new.message_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger forums_messages_sws_update_tr --- after update on forums_messages for each row --- begin --- site_wide_search.register_event (:new.message_id, 'UPDATE'); --- end; --- / --- show errors - --- create or replace trigger forums_messages_sws_delete_tr --- after delete on forums_messages for each row --- begin --- site_wide_search.register_event (:new.message_id, 'DELETE'); --- end; --- / --- show errors - - --------------------------------------------------------- --- static-portal triggers and procedures - --- create or replace trigger static_portal_sws_insert_tr --- after insert on static_portal_content for each row --- begin --- site_wide_search.register_event (:new.content_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger static_portal_sws_update_tr --- after update on static_portal_content for each row --- begin --- site_wide_search.register_event (:new.content_id, 'UPDATE'); --- end; --- / --- show errors - --- create or replace trigger static_portal_sws_delete_tr --- after delete on static_portal_content for each row --- begin --- site_wide_search.register_event (:new.content_id, 'DELETE'); --- end; --- / --- show errors - --------------------------------------------------------- --- ACS-events triggers and procedures --- I think only calendar makes use of the acs-events tables. - --- create or replace trigger acs_events_sws_insert_tr --- after insert on acs_events for each row --- begin --- site_wide_search.register_event (:new.event_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger acs_events_sws_update_tr --- after update on acs_events for each row --- begin --- site_wide_search.register_event (:new.event_id, 'UPDATE'); --- end; --- / --- show errors - --- create or replace trigger acs_events_sws_delete_tr --- after delete on acs_events for each row --- begin --- site_wide_search.register_event (:new.event_id, 'DELETE'); --- end; --- / --- show errors - --------------------------------------------------------- --- FAQ triggers and procedures - --- create or replace trigger faq_q_and_as_sws_insert_tr --- after insert on faq_q_and_as for each row --- begin --- site_wide_search.register_event (:new.entry_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger faq_q_and_as_sws_update_tr --- after update on faq_q_and_as for each row --- begin --- site_wide_search.register_event (:new.entry_id, 'UPDATE'); --- end; --- / --- show errors - --- create or replace trigger faq_q_and_as_sws_delete_tr --- after delete on faq_q_and_as for each row --- begin --- site_wide_search.register_event (:new.entry_id, 'DELETE'); --- end; --- / --- show errors - - --------------------------------------------------------- --- Survey Procs - --- create or replace trigger surveys_sws_insert_tr --- after insert on surveys for each row --- begin --- site_wide_search.register_event (:new.survey_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger surveys_sws_update_tr --- after update on surveys for each row --- begin --- site_wide_search.register_event (:new.survey_id, 'UPDATE'); --- end; --- / --- show errors - - --- create or replace trigger surveys_sws_delete_tr --- after delete on surveys for each row --- begin --- site_wide_search.register_event (:new.survey_id, 'DELETE'); --- end; --- / --- show errors - --------------------------------------------------------- --- Photobook Procs - --- create or replace trigger phb_person_sws_insert_tr --- after insert on phb_person for each row --- begin --- site_wide_search.register_event (:new.person_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger phb_person_sws_update_tr --- after update on phb_person for each row --- begin --- site_wide_search.register_event (:new.person_id, 'UPDATE'); --- end; --- / --- show errors - - --- create or replace trigger phb_person_sws_delete_tr --- after delete on phb_person for each row --- begin --- site_wide_search.register_event (:new.person_id, 'DELETE'); --- end; --- / --- show errors - --------------------------------------------------------- --- FAQ Procs - --- create or replace trigger faq_q_and_as_sws_insert_tr --- after insert on faq_q_and_as for each row --- begin --- site_wide_search.register_event (:new.faq_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger faq_q_and_as_sws_update_tr --- after update on faq_q_and_as for each row --- begin --- site_wide_search.register_event (:new.faq_id, 'UPDATE'); --- end; --- / --- show errors - - --- create or replace trigger faq_q_and_as_sws_delete_tr --- after delete on faq_q_and_as for each row --- begin --- site_wide_search.register_event (:new.faq_id, 'DELETE'); --- end; --- / --- show errors - --------------------------------------------------------- --- Survey Procs - --- create or replace trigger surveys_sws_insert_tr --- after insert on surveys for each row --- begin --- site_wide_search.register_event (:new.survey_id, 'INSERT'); --- end; --- / --- show errors - --- create or replace trigger surveys_sws_update_tr --- after update on surveys for each row --- begin --- site_wide_search.register_event (:new.survey_id, 'UPDATE'); --- end; --- / --- show errors - - --- create or replace trigger surveys_sws_delete_tr --- after delete on surveys for each row --- begin --- site_wide_search.register_event (:new.survey_id, 'DELETE'); --- end; --- / --- show errors - --------------------------------------------------------- --- The user_datastore proc which is called on every change of the datastore. - -create or replace procedure sws_user_datastore_proc ( p_rid in rowid, p_tlob in out nocopy clob ) -is - v_object_id site_wide_index.object_id%type; -begin - site_wide_search.logger ('entered sws_user_datastore_proc'); - - select indexed_content - into p_tlob - from site_wide_index swi, acs_objects ao - where swi.object_id = ao.object_id - and p_rid = swi.rowid; - - site_wide_search.logger ('in sws_user_datastore_proc with type ' || v_object_id); - -end; -/ -show errors; Index: openacs-4/packages/search/sql/oracle/search-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-tables-create.sql,v diff -u -r1.7 -r1.7.4.1 --- openacs-4/packages/search/sql/oracle/search-tables-create.sql 31 Aug 2006 07:31:29 -0000 1.7 +++ openacs-4/packages/search/sql/oracle/search-tables-create.sql 16 Apr 2008 12:41:13 -0000 1.7.4.1 @@ -15,46 +15,13 @@ -- -- --- Create database tables for .LRN site-wide search -- -- @author openacs@dirkgomez.de -- @version $Id$ -- @creation-date 13-May-2005 -- -- Partly ported from ACES. --- Central table for site-wide search. -create table site_wide_index ( - object_id integer - constraint sws_index_pk primary key - constraint sws_index_fk references acs_objects(object_id) on delete cascade, - object_name varchar(4000), - indexed_content clob, - -- Dirk Gomez: no not null constraint because we also want to - -- be able to index objects which are not tied to an object, - -- in particular people. - package_id integer - constraint swi_package_id_fk - references apm_packages - on delete cascade, - -- Dirk Gomez: This is a .LRNism. It looks like .LRN has not - -- only object-granular permiissions, but also - -- community-granular ones. In search we need not only check - -- whether a user has the right to view this object, but also - -- its community. In pure OpenACS this should always be a - -- null column and it should have no referential integrity. - -- community_id integer - -- constraint swi_community_id_fk - -- references dotlrn_communities_all - -- on delete cascade, - -- DAVEB: We'll need to add a way for dotlrn to integrate - -- without tying it into the search table. - -- Dirk Gomez: That's the place to put an object's relevant - -- date which is part of the ranking function. In calendar - -- this is the item date, in forum it could be the last reply - -- date to a thread etc. - relevant_date date -); create table search_observer_queue ( object_id integer,