• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Dropped permissions and objects in drop script

added postgres datamodel and query files

    • -0
    • +10
    /openacs-4/packages/notes/notes.info
    • -0
    • +24
    /openacs-4/packages/notes/sql/postgresql/notes-drop.sql
    • -0
    • +25
    /openacs-4/packages/notes/www/add-edit-oracle.xql
    • -0
    • +25
    /openacs-4/packages/notes/www/add-edit-postgresql.xql
    • -0
    • +27
    /openacs-4/packages/notes/www/add-edit.xql
    • -0
    • +17
    /openacs-4/packages/notes/www/delete-oracle.xql
    • -0
    • +15
    /openacs-4/packages/notes/www/delete-postgresql.xql
    • -5
    • +2
    /openacs-4/packages/notes/www/delete.tcl
    • -0
    • +33
    /openacs-4/packages/notes/www/index-oracle.xql
    • -0
    • +24
    /openacs-4/packages/notes/www/index-postgresql.xql
*** empty log message ***

*** empty log message ***

added comment about db_dml -blob_files change

added more query files

tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

new query files

  1. … 62 more files in changeset.
*** empty log message ***

Start postgresql port

Start postgresql port

First port commit

    • -0
    • +14
    /openacs-4/packages/acs-lang/tcl/lang-init-oracle.xql
    • -0
    • +13
    /openacs-4/packages/acs-lang/tcl/lang-init-postgresql.xql
    • -0
    • +22
    /openacs-4/packages/acs-lang/tcl/lang-procs-oracle.xql
    • -0
    • +22
    /openacs-4/packages/acs-lang/tcl/lang-procs.xql
    • -0
    • +16
    /openacs-4/packages/acs-lang/tcl/locale-procs-oracle.xql
    • -0
    • +39
    /openacs-4/packages/acs-lang/tcl/locale-procs.xql
    • -0
    • +23
    /openacs-4/packages/acs-lang/tcl/localization-procs.xql
    • -0
    • +13
    /openacs-4/packages/acs-lang/www/format-test-oracle.xql
    • -0
    • +12
    /openacs-4/packages/acs-lang/www/format-test-postgresql.xql
  1. … 4 more files in changeset.
Changed version number (so I can test whether commiting works).

First cut at a nscache emulation in Tcl.

    • -0
    • +26
    /mod_nsd/tcl_modules/nscache.tcl
Port queries

    • -0
    • +13
    /openacs-4/packages/acs-subsite/www/register/banned-user.xql
    • -0
    • +13
    /openacs-4/packages/acs-subsite/www/register/deleted-user.xql
    • -0
    • +22
    /openacs-4/packages/acs-subsite/www/register/email-confirm.xql
    • -0
    • +24
    /openacs-4/packages/acs-subsite/www/register/restore-user.xql
    • -0
    • +15
    /openacs-4/packages/acs-subsite/www/register/user-join.xql
    • -0
    • +14
    /openacs-4/packages/acs-subsite/www/register/user-login.xql
    • -0
    • +18
    /openacs-4/packages/acs-subsite/www/register/user-new-2.xql
    • -0
    • +28
    /openacs-4/packages/acs-subsite/www/user/basic-info-update.xql
    • -0
    • +12
    /openacs-4/packages/acs-subsite/www/user/password-update.xql
Add missing query

Port queries

    • -0
    • +26
    /openacs-4/packages/acs-subsite/www/pvt/alerts-oracle.xql
    • -0
    • +23
    /openacs-4/packages/acs-subsite/www/pvt/alerts.xql
    • -0
    • +45
    /openacs-4/packages/acs-subsite/www/pvt/home.xql
    • -0
    • +15
    /openacs-4/packages/acs-subsite/www/pvt/unsubscribe-oracle.xql
Fix return type of acs_user__receives_alerts_p

Speedy replacement for permission_p from Matthew Avalos

Typo

finished porting portrait upload to work with CR

Port queries

    • -0
    • +15
    /openacs-4/packages/acs-subsite/www/permissions/grant.xql
    • -0
    • +72
    /openacs-4/packages/acs-subsite/www/permissions/one-oracle.xql
Port queries

    • -0
    • +27
    /openacs-4/packages/acs-subsite/www/index-oracle.xql
    • -0
    • +19
    /openacs-4/packages/acs-subsite/www/admin/index-oracle.xql
  1. … 15 more files in changeset.
Add content_item__get_title(integer) helper function

party__name should return varchar

work on protrait upload

added file support to CR data-model

Port datamodel and add to .info file.

NB. string-package.sql has not been done, it uses user-defined types

as function parameters, and is only used in acs-notifications (once)

which is being rewritten anyway.

Wrapped adding of files to the package table in a transaction to hopefully

speed it up a bit, and to roll 'em all back if there's an error.

Add instr(varchar,char) helper function