Index: openacs-4/packages/search/www/admin/delete-object-type-from-index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/delete-object-type-from-index.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/delete-object-type-from-index.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Search admin index page - - @author openacs@dirkgomez.de -} { - object_type - -} -properties { -} -db_dml delete_object_type_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type=:object_type)} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/index-missing-objects.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/index-missing-objects.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/index-missing-objects.tcl 10 Jan 2007 21:22:14 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,20 +0,0 @@ -ad_page_contract { - index items of an object type which are not yet indexed - - @author openacs@dirkgomez.de -} { - object_type -} -properties { -} - -if {$object_type eq "file_storage_object"} { - db_dml reindex_file_storage_object { - insert into search_observer_queue (object_id, event) - select object_id, 'INSERT' from acs_objects, cr_items - where object_id=live_revision and - object_type in ('file_storage_object') and - object_id - not in (select object_id from site_wide_index)} -} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/index.adp,v diff -u -N --- openacs-4/packages/search/www/admin/index.adp 29 Jul 2008 22:04:14 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,66 +0,0 @@ - -Search Admin Page -@context;noquote@ - - - - - - - - - - - - - - - -
Object Type#Objects in the Index#Objects that should be in the Index
@object_type_count.object_type@@object_type_count.count_object_type@ - - @count_cal_item@ - @count_file_storage_object@ - @count_static_portal_content@ - @count_forums_message@ - @count_forums_forum@ - @count_news@ - @count_faq@ - @count_survey@ - @count_phb_person@ - - Delete @object_type_count.object_type@ from index
- -

Search Observer Queue

- -

Items in the search observer queue: @search_observer_queue_count@ - -

Reindexing

- - -

Index objects missing from the index

- - -

Index particular objects

-

-

- - -
- -

-

- - -
Index: openacs-4/packages/search/www/admin/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/index.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/index.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,38 +0,0 @@ -ad_page_contract { - Search admin index page - - @author openacs@dirkgomez.de -} -properties { -} -set context [list "Search Admin Page"] - -db_multirow object_type_count object_type_count { - select object_type, - count(swi.object_id) as count_object_type - from acs_objects ao, site_wide_index swi - where swi.object_id=ao.object_id - group by object_type - order by object_type} - -db_1row get_cal_item {select count(*) as count_cal_item from acs_objects where object_type in ('cal_item') } - -db_1row get_file_storage_object {select count(*) as count_file_storage_object from acs_objects, cr_items where object_id=live_revision and object_type in ('file_storage_object') } - -db_1row get_static_portal_content {select count(*) as count_static_portal_content from acs_objects where object_type in ('static_portal_content')} - -db_1row get_forums_message {select count(*) as count_forums_message from acs_objects where object_type in ('forums_message') } - -db_1row get_forums_forums {select count(*) as count_forums_forum from acs_objects where object_type in ('forums_forum') } - -db_1row get_news {select count(*) as count_news from acs_objects, cr_items, cr_news where news_id=live_revision and object_id=live_revision and object_type in ('news')} - -db_1row get_faq {select count(*) as count_faq from acs_objects where object_type in ('faq') } - -db_1row get_survey {select count(*) as count_survey from acs_objects where object_type in ('survey')} - -db_1row get_phb_person {select count(*) as count_phb_person from acs_objects,cr_items where object_type in ('phb_person') and object_id=live_revision } - -db_1row get_search_observer_queue_count { - select count(*) as search_observer_queue_count - from search_observer_queue -} \ No newline at end of file Index: openacs-4/packages/search/www/admin/list-object.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/list-object.adp,v diff -u -N --- openacs-4/packages/search/www/admin/list-object.adp 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,7 +0,0 @@ - -Search Admin Page -@context;noquote@ -

Object Name: @object_name@ -

Indexed Content: @indexed_content@ -

Package ID: @package_id@ -

Community ID: @community_id@ Index: openacs-4/packages/search/www/admin/list-object.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/list-object.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/list-object.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,16 +0,0 @@ -ad_page_contract { - Search admin index page - - @author openacs@dirkgomez.de -} { - object_id - -} -properties { -} -set context [list "Search Admin Page"] - -db_1row get_object_content { - select object_name, indexed_content, package_id, community_id - from site_wide_index swi - where object_id=:object_id - order by object_id} \ No newline at end of file Index: openacs-4/packages/search/www/admin/list-objects.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/list-objects.adp,v diff -u -N --- openacs-4/packages/search/www/admin/list-objects.adp 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,11 +0,0 @@ - -Search Admin Page -@context;noquote@ - - - - - - - -
Object TypeObjects in the Index
@objects_per_type.object_id@@objects_per_type.object_name@
\ No newline at end of file Index: openacs-4/packages/search/www/admin/list-objects.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/list-objects.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/list-objects.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,17 +0,0 @@ -ad_page_contract { - Search admin index page - - @author openacs@dirkgomez.de -} { - object_type - -} -properties { -} -set context [list "Search Admin Page"] - -db_multirow objects_per_type objects_per_type { - select object_name, swi.object_id - from acs_objects ao, site_wide_index swi - where swi.object_id=ao.object_id - and ao.object_type=:object_type - order by object_id} \ No newline at end of file Index: openacs-4/packages/search/www/admin/reindex-calitem.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-calitem.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-calitem.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex CAL_ITEM - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_cal_item_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='cal_item')} -db_dml reindex_cal_item { - insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects where object_type in ('cal_item')} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-faq.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-faq.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-faq.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex FAQ - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_faq_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='faq')} -db_dml reindex_faq { - insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects where object_type in ('faq')} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-file-storage.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-file-storage.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-file-storage.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex FILE_STORAGE_OBJECT - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_file_storage_object_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='file_storage_object')} -db_dml reindex_file_storage_object { -insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects, cr_items where object_id=live_revision and object_type in ('file_storage_object') } - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-forums-message.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-forums-message.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-forums-message.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex FORUMS_MESSAGE - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_forums_message_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='forums_message')} -db_dml reindex_forums_message { - insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects where object_type in ('forums_message')} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-forums.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-forums.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-forums.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex FORUMS_FORUM - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_forums_forum_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='forums_forum')} -db_dml reindex_forums_forum { - insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects where object_type in ('forums_forum')} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-news.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-news.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-news.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex NEWS - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_news_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='news')} -db_dml reindex_news { -insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects, cr_items, cr_news where news_id=live_revision and object_id=live_revision and object_type in ('news')} -# and archive_date is null -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-one-item.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-one-item.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-one-item.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex one item - - @author openacs@dirkgomez.de -} { - object_id -} -properties { -} -db_dml reindex_forums_message { - insert into search_observer_queue (object_id, event) values (:object_id, 'UPDATE')} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-phb-person.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-phb-person.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-phb-person.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex PHB_PERSON - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_phb_person_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='phb_person')} -db_dml reindex_phb_person { -insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects,cr_items where object_type in ('phb_person') and object_id=live_revision } - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-static-portal.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-static-portal.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-static-portal.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex STATIC_PORTAL_CONTENT - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_static_portal_content_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='static_portal_content')} -db_dml reindex_static_portal_content { - insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects where object_type in ('static_portal_content')} - -ad_returnredirect ./index Index: openacs-4/packages/search/www/admin/reindex-survey.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/search/www/admin/Attic/reindex-survey.tcl,v diff -u -N --- openacs-4/packages/search/www/admin/reindex-survey.tcl 8 Nov 2005 18:24:08 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -ad_page_contract { - Reindex SURVEY - - @author openacs@dirkgomez.de -} { -} -properties { -} -db_dml delete_survey_from_index {delete from site_wide_index where object_id in (select object_id from acs_objects where object_type='survey')} -db_dml reindex_survey { - insert into search_observer_queue (object_id, event) select object_id, 'INSERT' from acs_objects where object_type in ('survey')} - -ad_returnredirect ./index