• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Changed the representation of tree_sortkeys from "text" to "bit varying".

    • -81
    • +47
    ./sql/postgresql/bookmarks-create.sql
    • -10
    • +6
    ./tcl/bookmarks-init-postgresql.xql
    • -38
    • +23
    ./tcl/bookmarks-procs-postgresql.xql
    • -2
    • +1
    ./www/bookmarks-user-list-postgresql.xql
    • -14
    • +6
    ./www/permissions-reset-all-2-postgresql.xql
    • -14
    • +6
    ./www/permissions-reset-all-postgresql.xql
    • -18
    • +10
    ./www/tree-dynamic-postgresql.xql
  1. … 50 more files in changeset.

Some more speeding-up type activity...

Fixed folder toggle to show/hide bookmarks under folders...

    • -31
    • +31
    ./sql/postgresql/bookmarks-create.sql
Adding my_bookmarks_select query to index-oracle.xql

Added my_bookmarks_select query to index-postgresql.xql to allow views of own bookmarks to avoid permissions_p hit

Update to return type (integer to varchar) for bookmark__name

Hmmm. Methinks an index on bm_bookmarks.tree_sortkey might help with the performance issues...*grin*

Fixed insert with quotes, and started work on tweaking the regexes for bookmarks-import. The import_list variable was not being tested properly for existence; this is fixed.

    • -10
    • +6
    ./www/bookmark-add-one-2-postgresql.xql
Fixing import from bookmarks.htmCVS: ----------------------------------------------------------------------

    • -12
    • +3
    ./www/bookmarks-import-postgresql.xql
Finished global permissions setting

    • -0
    • +26
    ./www/permissions-reset-all-2-oracle.xql
    • -0
    • +50
    ./www/permissions-reset-all-2-postgresql.xql
    • -0
    • +16
    ./www/permissions-reset-all-oracle.xql
    • -0
    • +28
    ./www/permissions-reset-all-postgresql.xql
Porting delete-dead-links

    • -21
    • +10
    ./www/delete-dead-links-postgresql.xql
Updated one-host.xql

Ummmm...ok. NOW Most Popular hosts/URLs working! *grin*

Most Popular hosts/URLs working.

    • -0
    • +31
    ./www/most-popular-oracle.xql
    • -0
    • +59
    ./www/most-popular-postgresql.xql
Search functionality working.

    • -0
    • +63
    ./www/search-oracle.xql
    • -0
    • +77
    ./www/search-postgresql.xql
Javascript version working...successful w/ Opera 5 for Linux, Mozilla 0.9.1 and Galeon 0.11 on Linux. Konq isn't working yet (?? any ideas ??), and I haven't tested on WinX yet. I didn't change the actual js though (just the PG query), so hopefully it'll be ok.

    • -26
    • +31
    ./www/tree-dynamic-postgresql.xql
Updating js tree...

Forgot to update bookmarks.info

Adding files for Javascript view

    • -0
    • +33
    ./www/tree-dynamic-oracle.xql
    • -0
    • +37
    ./www/tree-dynamic-postgresql.xql
    • -0
    • +14
    ./www/tree-dynamic.xql
Bookmark Import working

    • -15
    • +10
    ./www/bookmarks-check-postgresql.xql
    • -0
    • +66
    ./www/bookmarks-import-oracle.xql
    • -0
    • +70
    ./www/bookmarks-import-postgresql.xql
    • -0
    • +70
    ./www/bookmarks-import.xql
Syncing with server after move; adding fixes to CONNECT BY replacements. Presently, some are broken once multiple users are added to site

Fixed error in bookmarks__new; context_id was not being set in acs_objects for all bookmarks -- added dead links checking

    • -0
    • +27
    ./www/bookmarks-user-list-oracle.xql
    • -0
    • +37
    ./www/bookmarks-user-list-postgresql.xql
    • -0
    • +42
    ./www/delete-dead-links-oracle.xql
    • -0
    • +55
    ./www/delete-dead-links-postgresql.xql

1. Added a check that PG was initdb's with the collation order for

characters that we expect.

2. Jon added a "sql/common" directory for the insert statements which

load data for acs-references, so I added a new datamodel type "common"

to the APM.

3. Created a new db API routine that returns true if a given db_type is

compatible with the current RDBMS.

4. Added a workaround for a PL/pgSQL "execute" bug in acs-workflow (other

cases had been fixed previously by others but this one was missed)

5. Diddled a couple of .info files using the APM.

  1. … 10 more files in changeset.
Check Links also working for individual users

Bookmarks administration (by Admin) working...

    • -0
    • +47
    ./www/bookmarks-check-oracle.xql
    • -0
    • +55
    ./www/bookmarks-check-postgresql.xql
Fixed error in actually selecting bookmarks to view. Hadn't tried that yet...you can use them now.

    • -0
    • +16
    ./www/bookmark-access-oracle.xql
    • -0
    • +26
    ./www/bookmark-access-postgresql.xql
Fixed error in sort order on index page. Added editing and viewing. Basic

functionality is working.

    • -44
    • +16
    ./sql/postgresql/bookmarks-create.sql
    • -0
    • +47
    ./www/bookmark-add-one-2-oracle.xql
    • -0
    • +49
    ./www/bookmark-add-one-2-postgresql.xql
    • -0
    • +34
    ./www/bookmark-add-one-2.xql
    • -0
    • +35
    ./www/bookmark-edit-2-oracle.xql
    • -0
    • +45
    ./www/bookmark-edit-2-postgresql.xql
    • -0
    • +20
    ./www/bookmark-edit-2.xql
    • -0
    • +8
    ./www/bookmark-edit-oracle.xql
    • -0
    • +15
    ./www/bookmark-edit-postgresql.xql
    • -0
    • +40
    ./www/bookmark-edit.xql
    • -0
    • +32
    ./www/bookmark-view-oracle.xql
    • -0
    • +22
    ./www/bookmark-view.xql
Fixed error in tree_sortkey insert trigger; hopefully tree_sortkey being created/updated properly now.

Fixed error in bookmark__get_in_closed_p that was causing it to always return true...

Bookmark delete is working

    • -7
    • +8
    ./www/bookmark-delete-2-postgresql.xql