• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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

*** empty log message ***

*** empty log message ***

New info files with truncated rather than PG timestamps.

trunc'd date put in .info file to make Oracle happy (PG dates include time

info)

*** empty log message ***

*** empty log message ***

More porting changes ...

    • -0
    • +17
    /openacs-4/packages/acs-admin/www/users/one-oracle.xql
    • -0
    • +17
    /openacs-4/packages/acs-admin/www/users/one-postgresql.xql

Fixed extractor and re-ran it, causing some file shuffling.

Removed more of the "default '' not null" kludge.

  1. … 4 more files in changeset.

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

Added ahmed.

fixed problem with initalizing a_order and added missing as to select query

*** empty log message ***

More porting of the APM is complete! Nearly done, a bug in the datamodel

API and we need to convert from direct use of blobs to using the

content repository.

fixed ad_table call in site-map