• last updated 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Working on bookmark-delete

    • -0
    • +18
    ./www/bookmark-delete-2-oracle.xql
    • -0
    • +19
    ./www/bookmark-delete-2-postgresql.xql
    • -0
    • +15
    ./www/bookmark-delete-oracle.xql
    • -0
    • +20
    ./www/bookmark-delete-postgresql.xql
    • -0
    • +12
    ./www/bookmark-delete.xql
Fix accidental edit to sql/oracle/bookmarks-create.sql...

Open/Close All Folders working...

    • -18
    • +10
    ./sql/postgresql/bookmarks-create.sql
Updating proc file

    • -0
    • +4
    ./www/toggle-open-close-postgresql.xql
Fixing multiple functions without return values....oops!

    • -17
    • +15
    ./sql/postgresql/bookmarks-create.sql
    • -0
    • +36
    ./www/toggle-open-close-oracle.xql
    • -0
    • +28
    ./www/toggle-open-close-postgresql.xql
'Create new folder' works.

    • -10
    • +12
    ./sql/postgresql/bookmarks-create.sql
    • -3
    • +23
    ./tcl/bookmarks-procs-postgresql.xql
    • -0
    • +26
    ./www/folder-add-2-oracle.xql
    • -0
    • +27
    ./www/folder-add-2-postgresql.xql
Continuing to work on procs, index page now successfully loading...

    • -14
    • +17
    ./sql/postgresql/bookmarks-create.sql
Adding most-popular.xql queryfile

    • -10
    • +9
    ./sql/postgresql/bookmarks-create.sql
    • -0
    • +29
    ./www/most-popular.xql

Staring work with query porter and xql files. Done queries in tcl, and index files in www...

    • -0
    • +49
    ./tcl/bookmarks-init-oracle.xql
    • -0
    • +53
    ./tcl/bookmarks-init-postgresql.xql
    • -0
    • +14
    ./tcl/bookmarks-init.xql
    • -0
    • +87
    ./tcl/bookmarks-procs-oracle.xql
    • -0
    • +90
    ./tcl/bookmarks-procs-postgresql.xql
    • -0
    • +20
    ./tcl/bookmarks-procs.xql
    • -0
    • +49
    ./www/index-oracle.xql
    • -0
    • +58
    ./www/index-postgresql.xql

Initial data model changes for OpenACS (Postgres added). bookmark.info

also updated. www files not yet touched

    • -0
    • +865
    ./sql/postgresql/bookmarks-create.sql
    • -0
    • +162
    ./sql/postgresql/bookmarks-drop.sql

1. Ripped out the '' vs. NULL string kludge, which was a stupid idea in the

first place (MY stupid idea, for the record).

2. More .xql file porting...

  1. … 23 more files in changeset.

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +747
    ./sql/oracle/bookmarks-create.sql
    • -0
    • +75
    ./sql/oracle/bookmarks-drop.sql
    • -0
    • +141
    ./tcl/bookmarks-init.tcl
    • -0
    • +258
    ./tcl/bookmarks-procs.tcl
    • -0
    • +27
    ./www/bookmark-access.tcl
    • -0
    • +84
    ./www/bookmark-add-import.adp
    • -0
    • +73
    ./www/bookmark-add-import.tcl
    • -0
    • +101
    ./www/bookmark-add-one-2.tcl
    • -0
    • +45
    ./www/bookmark-add-one.adp
    • -0
    • +138
    ./www/bookmark-add-one.tcl
    • -0
    • +39
    ./www/bookmark-delete-2.tcl
    • -0
    • +28
    ./www/bookmark-delete.adp
  1. … 2465 more files in changeset.