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

fixed acs-admin main page queries

    • -0
    • +17
    /openacs-4/packages/acs-admin/www/index-oracle.xql
    • -0
    • +17
    /openacs-4/packages/acs-admin/www/index-postgresql.xql
fixed admin page queries

updated package spec to include new .xql files

changed case type to boolean

ported templating to use standard db api

  1. … 13 more files in changeset.