OpenACS / openacs-4 / packages / search

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 17:27
Commits this week: 0
Total Lines of Code (LoC): 862
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 29 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 31 Aug 2006
9:31 am

emmar

Remove 'exit' lines that caused datamodel to be incompletely installed. Comment out creation of triggers for forums, static-portal, acs-events, faq, survey and photobook (should go in their own package)

Options
    • -0
    • +1
    ./oracle/search-create.sql
    • -3
    • +1
    ./oracle/search-ctxsys.sql
    • -7
    • +1
    ./oracle/search-from-scratch.sql
    • -2
    • +1
    ./oracle/search-index-create.sql
    • -3
    • +1
    ./oracle/search-index-drop.sql
    • -5
    • +0
    ./oracle/search-index-from-scratch.sql
    • -180
    • +179
    ./oracle/search-packages-create.sql
    • -2
    • +0
    ./oracle/search-sc-create.sql
    • -2
    • +1
    ./oracle/search-tables-create.sql
    • -3
    • +2
    ./oracle/syndication-create.sql
    • -2
    • +0
    ./oracle/syndication-drop.sql
Thursday 10 Aug 2006
6:01 pm

daveb

Remove reference to dotlrn

Options
    • -5
    • +7
    ./oracle/search-tables-create.sql
Tuesday 08 Nov 2005
7:24 pm

dirkg

commiting search work from sloan

Options
    • -2
    • +6
    ./oracle/load-site-wide-search
    • -1
    • +0
    ./oracle/search-create.sql
    • -14
    • +27
    ./oracle/search-from-scratch.sql
    • -4
    • +13
    ./oracle/search-index-create.sql
    • -2
    • +2
    ./oracle/search-index-drop.sql
    • -270
    • +266
    ./oracle/search-packages-create.sql
    • -24
    • +2
    ./oracle/search-packages-drop.sql
    • -0
    • +2
    ./oracle/search-sc-create.sql
    • -14
    • +32
    ./oracle/search-tables-create.sql
    • -6
    • +0
    ./oracle/search-tables-drop.sql
    • -0
    • +2
    ./oracle/syndication-create.sql
    • -0
    • +3
    ./oracle/syndication-drop.sql
  13. … 30 more files in changeset.
Tuesday 07 Jun 2005
9:58 pm

dirkg

Added package_id to site_wide_index table

Options
    • -1
    • +8
    ./oracle/search-tables-create.sql
9:00 pm

dirkg

Added indexed_content field to the site_wide_index table. This

field will hold "textualized" content of binaries.

Options
    • -1
    • +2
    ./oracle/search-tables-create.sql
Saturday 21 May 2005
1:34 pm

dirkg

first draft for .lrn search. run load-site-wide-search shell script to install

Options
    • -0
    • +48
    ./oracle/load-site-wide-search
    • -0
    • +41
    ./oracle/search-ctxsys.sql
    • -0
    • +49
    ./oracle/search-from-scratch.sql
    • -0
    • +152
    ./oracle/search-im-convert.sql
    • -0
    • +43
    ./oracle/search-index-create.sql
    • -0
    • +32
    ./oracle/search-index-drop.sql
    • -0
    • +20
    ./oracle/search-index-from-scratch.sql
    • -44
    • +476
    ./oracle/search-packages-create.sql
    • -2
    • +24
    ./oracle/search-packages-drop.sql
    • -7
    • +48
    ./oracle/search-tables-create.sql
    • -0
    • +6
    ./oracle/search-tables-drop.sql
Tuesday 27 Jul 2004
12:49 pm

jeffd

fix a couple typos for syndication

Options
    • -0
    • +1
    ./postgresql/search-create.sql
  2. … 1 more file in changeset.
Monday 26 Jul 2004
3:04 pm

jeffd

add a syndication table which holds xml fragments which can be assembled to create rss feeds

Options
    • -0
    • +1
    ./oracle/search-create.sql
    • -0
    • +15
    ./oracle/syndication-create.sql
    • -0
    • +3
    ./oracle/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
    • -0
    • +18
    ./postgresql/syndication-create.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  6. … 2 more files in changeset.
Friday 14 May 2004
12:17 pm

jeffd

Put functions into a search:: namespace and make most private.

Add a search::queue and search::dequeue command

define_function_args/package_exec_plsql to avoid db specific xql files.

unset datasource when finished with it.

bump to 5.2.0d2 + postgresql upgrade script.

Options
    • -4
    • +8
    ./postgresql/search-packages-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  3. … 5 more files in changeset.
Monday 13 Oct 2003
12:20 am

tilmanns

Applied fix from Carsten Clasohm - now upgrade works on pg7.3 as well (tried it on 7.2 too). Fixes #631

Options
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -18
    • +18
    ./oracle/search-sc-drop.sql
  2. … 275 more files in changeset.
Saturday 17 May 2003
1:23 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -1
    • +1
    ./postgresql/search-packages-drop.sql
    • -1
    • +1
    ./postgresql/search-tables-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  5. … 26 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -1
    • +1
    ./postgresql/search-packages-drop.sql
    • -1
    • +1
    ./postgresql/search-tables-create.sql
  4. … 37 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  3. … 53 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  3. … 53 more files in changeset.
Saturday 30 Nov 2002
6:42 pm

jeffd

merge from oacs-4-6

Options
    • -4
    • +4
    ./postgresql/search-packages-create.sql
  2. … 28 more files in changeset.
Thursday 10 Oct 2002
6:52 pm

danw

changes to make search work with openfts 0.3

Options
    • -4
    • +4
    ./postgresql/search-packages-create.sql
  2. … 4 more files in changeset.
Saturday 03 Aug 2002
8:00 pm

vinodk

renamed jon's upgrade file 4.5->4.5.1

Options
    • -35
    • +0
    ./postgresql/upgrade/upgrade-4.2-4.5.1.sql
    • -0
    • +35
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
2:39 am

jong

initial revision

Options
    • -0
    • +35
    ./postgresql/upgrade/upgrade-4.2-4.5.1.sql
Tuesday 02 Jul 2002
3:52 am

yon

the package is 99% ported to oracle. the only file that still requires a

little porting is www/search.tcl

now all someone needs to do is write the FtsEngineDriver for Oracle. i didn't

do it since i didn't need site-wide-search quite yet.

Options
    • -0
    • +3
    ./oracle/search-create.sql
    • -0
    • +3
    ./oracle/search-drop.sql
    • -0
    • +59
    ./oracle/search-packages-create.sql
    • -0
    • +2
    ./oracle/search-packages-drop.sql
    • -0
    • +185
    ./oracle/search-sc-create.sql
    • -0
    • +26
    ./oracle/search-sc-drop.sql
    • -0
    • +8
    ./oracle/search-tables-create.sql
    • -0
    • +1
    ./oracle/search-tables-drop.sql
    • -1
    • +1
    ./postgresql/search-drop.sql
    • -3
    • +3
    ./postgresql/search-packages-create.sql
    • -1
    • +1
    ./postgresql/search-tables-create.sql
  12. … 6 more files in changeset.
Friday 19 Oct 2001
4:11 am

donb

*** empty log message ***

Options
    • -12
    • +0
    ./postgresql/search-sc-create.sql
  2. … 7 more files in changeset.
Wednesday 03 Oct 2001
6:04 am

neophytosd

fixed/changed operation_nargs values

Options
    • -3
    • +5
    ./postgresql/search-sc-create.sql
Tuesday 18 Sep 2001
6:23 am

neophytosd

*** empty log message ***

Options
    • -0
    • +2
    ./postgresql/search-sc-drop.sql
Saturday 15 Sep 2001
11:31 pm

neophytosd

enhanced search package

Options
    • -2
    • +4
    ./postgresql/search-sc-create.sql
    • -6
    • +2
    ./postgresql/search-tables-create.sql
  3. … 9 more files in changeset.
Thursday 13 Sep 2001
6:59 am

danw

fixed virtual url handling for CR so that it will also display content that is not live. This was done so that non-live revision could be searched for. It is assumed that the user will only see content that they have permission to view regardless of whether it is live or not.

Options
    • -2
    • +3
    ./postgresql/search-tables-create.sql
  2. … 8 more files in changeset.
Friday 07 Sep 2001
5:01 am

danw

added on delete cascade so that items still in the queue can be deleted without triggering RI constraint error

Options
    • -1
    • +1
    ./postgresql/search-tables-create.sql
Sunday 02 Sep 2001
8:11 pm

neophytosd

Initial revision

Options
    • -0
    • +3
    ./postgresql/search-create.sql
    • -0
    • +3
    ./postgresql/search-drop.sql
    • -0
    • +39
    ./postgresql/search-packages-create.sql
    • -0
    • +2
    ./postgresql/search-packages-drop.sql
    • -0
    • +182
    ./postgresql/search-sc-create.sql
    • -0
    • +20
    ./postgresql/search-sc-drop.sql
    • -0
    • +10
    ./postgresql/search-tables-create.sql
    • -0
    • +1
    ./postgresql/search-tables-drop.sql
  9. … 11 more files in changeset.