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

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

1. Fixed apm_load_queries. Again? Yes, again. I fixed it real good this

time.

2. Added .xql files for acs-admin. APM .xql files have mostly but not

completely been ported. It sort of works though, cool!

    • -0
    • +22
    /openacs-4/packages/acs-admin/tcl/apm-admin-procs-oracle.xql
    • -0
    • +15
    /openacs-4/packages/acs-admin/tcl/apm-admin-procs.xql
    • -0
    • +16
    /openacs-4/packages/acs-admin/www/index.xql
    • -0
    • +15
    /openacs-4/packages/acs-admin/www/apm/bulk-intall.xql
    • -0
    • +33
    /openacs-4/packages/acs-admin/www/apm/cvs-status.xql
    • -0
    • +15
    /openacs-4/packages/acs-admin/www/apm/file-add-2.xql
    • -0
    • +13
    /openacs-4/packages/acs-admin/www/apm/file-add.xql
    • -0
    • +22
    /openacs-4/packages/acs-admin/www/apm/file-remove.xql
    • -0
    • +28
    /openacs-4/packages/acs-admin/www/apm/file-watch.xql
    • -0
    • +14
    /openacs-4/packages/acs-admin/www/apm/index-oracle.xql
    • -0
    • +26
    /openacs-4/packages/acs-admin/www/apm/index-postgresql.xql
    • -0
    • +24
    /openacs-4/packages/acs-admin/www/apm/index.xql
  1. … 46 more files in changeset.
fixed abstraction for queryname_root formation