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

    • -0
    • +1197
    ./sql/postgresql/timespan-create.sql
    • -0
    • +17
    ./sql/postgresql/timespan-drop.sql
Oracle date functions ported to postgres

    • -0
    • +205
    ./sql/postgresql/oracle-compat-create.sql
    • -0
    • +15
    ./sql/postgresql/oracle-compat-drop.sql
Initial revision

    • -0
    • +1366
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +28
    ./sql/postgresql/acs-events-drop.sql
    • -0
    • +344
    ./sql/postgresql/activity-create.sql
    • -0
    • +15
    ./sql/postgresql/activity-drop.sql
    • -0
    • +210
    ./sql/postgresql/recurrence-create.sql
    • -0
    • +14
    ./sql/postgresql/recurrence-drop.sql
Initial port, added parameter EventFutureLimit referred by the API but never registered to APM in aD version, made a singleton service

Initial revision, moved under oracle subdirectory since tests are oracle specific

    • -0
    • +509
    ./sql/oracle/test/acs-events-test.sql
    • -0
    • +1003
    ./sql/oracle/test/timespan-test.sql
moved to correct subdirectory under oracle, since tests are oracle specific

Initial revision, moved to correct subdirectory

    • -0
    • +984
    ./sql/oracle/acs-events-create.sql
    • -0
    • +26
    ./sql/oracle/acs-events-drop.sql
    • -0
    • +284
    ./sql/oracle/activity-create.sql
    • -0
    • +16
    ./sql/oracle/activity-drop.sql
    • -0
    • +206
    ./sql/oracle/recurrence-create.sql
    • -0
    • +10
    ./sql/oracle/recurrence-drop.sql
    • -0
    • +782
    ./sql/oracle/timespan-create.sql
    • -0
    • +12
    ./sql/oracle/timespan-drop.sql
moved to correct subdirectory

initial import.