• last updated 33 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

these queries were not picked up by the QE

added partial postgresql support. trigger creation and alter table ... drop column not supported yet.

changed ec_column_type_widget to check for postgresql or oracle

Changes folder_id to parent_id in duplicate_check query

Added queries to delete cr_items entry when last revision deleted

Added queries to delete cr_items entry when last revision is deleted

Entry in cr_items should be deleted after last revision is deleted (bug in original version)

corrected revision_new and lob upload query

*** empty log message ***

fixed single quote error for postgresql. Reported by Bart T.

removed requirement on acs-notifications

converted notification calls to acs_mail_nt calls

converted notification calls to acs_mail_nt calls

fixed a couple of typos in content_type__drop_attribute

uncomplete ported queries

    • -0
    • +53
    /openacs-4/packages/calendar/www/cal-item-oracle.xql
    • -0
    • +53
    /openacs-4/packages/calendar/www/cal-item-postgresql.xql
    • -0
    • +33
    /openacs-4/packages/calendar/www/cal-options-oracle.xql
    • -0
    • +33
    /openacs-4/packages/calendar/www/cal-options-postgresql.xql
    • -0
    • +21
    /openacs-4/packages/calendar/www/cal-weekview-oracle.xql
uncomplete port of queries

    • -0
    • +141
    /openacs-4/packages/calendar/tcl/cal-item-procs-oracle.xql
    • -0
    • +16
    /openacs-4/packages/calendar/tcl/cal-item-procs.xql
    • -0
    • +38
    /openacs-4/packages/calendar/tcl/calendar-community-core-procs-postgresql.xql
    • -0
    • +100
    /openacs-4/packages/calendar/tcl/calendar-procs-oracle.xql
    • -0
    • +15
    /openacs-4/packages/calendar/tcl/calendar-procs.xql
ported calendar data model

ported calendar data model

fixed get_path to match oracle version

Port group-type/change-join-policy

This query wrongly extracted from comment in party::new

This query wrongly extracted from comment in group::new

Initial port of the acs-datetime package. All database calls to Oracle-

specific functions have been replaced with Tcl procedures. These Tcl

procedures should mimic exactly thier Oracle counterparts to reduce the

chance of introducing bugs into the system. Future enhancements are likely

forthcoming to increase the robustness of the code.

Importing.

    • -0
    • +13
    /openacs-4/packages/acs-datetime/tcl/acs-datetime-procs.xql
fixed exception message in content_type__drop_attribute

RAC: Added *xql missing from previous commit

    • -0
    • +69
    /openacs-4/packages/address-book/tcl/address-book-procs.xql
    • -0
    • +11
    /openacs-4/packages/address-book/www/address-ae-2.xql
    • -0
    • +42
    /openacs-4/packages/address-book/www/address-delete-oracle.xql
    • -0
    • +18
    /openacs-4/packages/address-book/www/address-delete.xql
    • -0
    • +25
    /openacs-4/packages/address-book/www/address-swap-oracle.xql
    • -0
    • +11
    /openacs-4/packages/address-book/www/address-swap.xql
    • -0
    • +30
    /openacs-4/packages/address-book/www/attr-ae-2-oracle.xql
    • -0
    • +34
    /openacs-4/packages/address-book/www/attr-ae-2-postgresql.xql
    • -0
    • +22
    /openacs-4/packages/address-book/www/attr-ae-2.xql
    • -0
    • +38
    /openacs-4/packages/address-book/www/attr-ae.xql
    • -0
    • +15
    /openacs-4/packages/address-book/www/attr-delete-oracle.xql
    • -0
    • +17
    /openacs-4/packages/address-book/www/attr-delete-postgresql.xql
    • -0
    • +15
    /openacs-4/packages/address-book/www/attr-delete.xql
  1. … 14 more files in changeset.
RAC (Nov 23, 2001): Unfinished port for address-book.

The places package needs to be replaced by acs-references. This makes the data model file crash. The *xql files were created but untouched.

Similar to previous fix.

Added missing where clause in "bboard_message_set.message_set_content"

query. Thanks to Louis Zirkel for catching this.

Fix for message-edit-3 blowing up. Tested on both PG and Oracle. Thanks

go out to Louis. - Arjun

"In digging into the code I found that there is a call to

bboard_message_clear_categories which in turn calls db_dml to call a

stored proc. This doesn't seem to work, but changing the db_dml call

to db_exec_plsql seems to have resolved the issue." -- Louis Zirkel