• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Updated version numbers to upgrade to changes made for Oracle 9i support

  1. … 37 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -12
    • +12
    ./sql/oracle/timespan-create.sql
    • -30
    • +30
    ./sql/oracle/test/timespan-test.sql
  1. … 270 more files in changeset.
info file fix: making version name in version url be up-to-date (have the version name in it). Upgrades fail on unique constraint of version url otherwise.

  1. … 1 more file in changeset.
Bumped up EventFutureLimit to 5 (see #523)

added upgrade script for index creation on start_date (see bug #634)

    • -0
    • +1
    ./sql/oracle/upgrade/upgrade-0.2d-0.3d.sql
    • -0
    • +1
    ./sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql
Remove 'ACS' from the package nme

1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

  1. … 6 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -14
    • +14
    ./sql/postgresql/acs-events-create.sql
    • -9
    • +9
    ./sql/postgresql/oracle-compat-create.sql
    • -4
    • +4
    ./sql/postgresql/oracle-compat-drop.sql
    • -4
    • +4
    ./sql/postgresql/recurrence-create.sql
    • -25
    • +25
    ./sql/postgresql/timespan-create.sql
    • -44
    • +44
    ./sql/postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./sql/postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./sql/postgresql/test/timespan-test.sql
    • -5
    • +5
    ./sql/postgresql/test/utest-create.sql
  1. … 32 more files in changeset.
removing the file listings from the info files since those are no longer used by OpenACS

  1. … 28 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

    • -44
    • +44
    ./sql/postgresql/test/acs-events-test.sql
    • -51
    • +51
    ./sql/postgresql/test/time_intervals-test.sql
    • -19
    • +19
    ./sql/postgresql/test/timespan-test.sql
    • -5
    • +5
    ./sql/postgresql/test/utest-create.sql
  1. … 50 more files in changeset.
Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

    • -14
    • +14
    ./sql/postgresql/acs-events-create.sql
    • -9
    • +9
    ./sql/postgresql/oracle-compat-create.sql
    • -4
    • +4
    ./sql/postgresql/oracle-compat-drop.sql
    • -4
    • +4
    ./sql/postgresql/recurrence-create.sql
    • -25
    • +25
    ./sql/postgresql/timespan-create.sql
  1. … 13 more files in changeset.
Changed link to SDM to a link to bug-tracker.

merge bartt PG 7.3 fixes from HEAD

    • -3
    • +3
    ./sql/postgresql/oracle-compat-create.sql
    • -2
    • +2
    ./sql/postgresql/test/acs-events-test.sql
  1. … 51 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

    • -3
    • +3
    ./sql/postgresql/oracle-compat-create.sql
    • -2
    • +2
    ./sql/postgresql/test/acs-events-test.sql
  1. … 51 more files in changeset.
merge from oacs-4-6

    • -15
    • +9
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 108 more files in changeset.
- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

    • -15
    • +9
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 28 more files in changeset.
changing to provide acs-events (like package_key) rather than acs-event, calendar won't install otherwise

- Converted inneficient query to INNER JOINs.

- Added Oracle upgrade script.

    • -0
    • +740
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -11
    • +18
    ./sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
acs-events provided acs-event. now provides matches package key

  1. … 1 more file in changeset.
Added new files to .info files

  1. … 38 more files in changeset.
fix some broken links

  1. … 23 more files in changeset.
manually updating the .info file since the UI is not working for me. bumped revto 0.2d

adding upgrade file for acs_event__recurrence_timespan_edit fuction fix

    • -0
    • +47
    ./sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
fix acs_event__recurrence_timespan_edit thanks to deds@infiniteinfo.com

    • -12
    • +24
    ./sql/postgresql/acs-events-create.sql
fixed calendar for PG

    • -3
    • +3
    ./sql/postgresql/oracle-compat-create.sql
  1. … 10 more files in changeset.
added support for editing time intervals

    • -1
    • +32
    ./sql/postgresql/acs-events-create.sql

Added some stuff to acs-events, like an html_p arg to "new" to set this

existing but unused table column.

    • -32
    • +79
    ./sql/postgresql/acs-events-create.sql
    • -12
    • +37
    ./sql/postgresql/activity-create.sql
    • -15
    • +18
    ./sql/postgresql/test/acs-events-test.sql
applied patches 130,131,132,133,134,135,137

    • -2
    • +2
    ./sql/postgresql/acs-events-create.sql
  1. … 7 more files in changeset.

1. Added session-update.tcl, a small utility which somewhat safely allows

you to put up a link that changes a session_property, for instance to

change the number of items displayed or that sort of thing. The caller

must sign their values and URL, which are verified by the callee via

ad_page_contract. If the referrer doesn't match the signed expected

referrer, you get bounced. I think this is reasonably secure (though

permissions should always be rigorously checked on all pages, of course)

2. acs_events had an html_p flag in the datamodel but no way to set it.

Fixed. It should really be a mime-type but since it's not using the

CR, and since I'm extremely busy with other stuff, I didn't fix it.

3. While doing #1 above I learned that signing and verifying arrays didn't

quite work. Fixed.

4. Found and fixed a small problem with my earlier work on the currency widget.

  1. … 13 more files in changeset.
Tests to make sure API ok

    • -0
    • +1157
    ./sql/postgresql/test/acs-events-test.sql
    • -0
    • +607
    ./sql/postgresql/test/time_intervals-test.sql
    • -0
    • +622
    ./sql/postgresql/test/timespan-test.sql
    • -0
    • +603
    ./sql/postgresql/test/utest-create.sql
    • -0
    • +15
    ./sql/postgresql/test/utest-drop.sql
    • -0
    • +353
    ./sql/postgresql/test/utest.sql