• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added package_id to site_wide_index table

Added indexed_content field to the site_wide_index table. This

field will hold "textualized" content of binaries.

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

    • -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
fix a couple typos for syndication

  1. … 1 more file in changeset.
add a syndication table which holds xml fragments which can be assembled to create rss feeds

    • -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
  1. … 2 more files in changeset.
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.

    • -4
    • +8
    ./postgresql/search-packages-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  1. … 5 more files in changeset.
Applied fix from Carsten Clasohm - now upgrade works on pg7.3 as well (tried it on 7.2 too). Fixes #631

    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
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)

  1. … 275 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 26 more files in changeset.
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 ...

    • -1
    • +1
    ./postgresql/search-packages-create.sql
  1. … 37 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 53 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

    • -1
    • +1
    ./postgresql/search-packages-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
  1. … 53 more files in changeset.
merge from oacs-4-6

    • -4
    • +4
    ./postgresql/search-packages-create.sql
  1. … 28 more files in changeset.
changes to make search work with openfts 0.3

    • -4
    • +4
    ./postgresql/search-packages-create.sql
  1. … 4 more files in changeset.
renamed jon's upgrade file 4.5->4.5.1

    • -35
    • +0
    ./postgresql/upgrade/upgrade-4.2-4.5.1.sql
    • -0
    • +35
    ./postgresql/upgrade/upgrade-4.5-4.5.1.sql
initial revision

    • -0
    • +35
    ./postgresql/upgrade/upgrade-4.2-4.5.1.sql
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.

    • -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
    • -3
    • +3
    ./postgresql/search-packages-create.sql
  1. … 6 more files in changeset.
*** empty log message ***

  1. … 7 more files in changeset.
fixed/changed operation_nargs values

*** empty log message ***

enhanced search package

  1. … 9 more files in changeset.
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.

  1. … 8 more files in changeset.
added on delete cascade so that items still in the queue can be deleted without triggering RI constraint error

Initial revision

    • -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
  1. … 11 more files in changeset.