• last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Initial Postgres port. Rough only.

deleted for OpenACS. All files put in common

    • -535
    • +0
    ./packages/acs-reference/sql/oracle/timezone-data.sql
Fixed error in tree_sortkey insert trigger; hopefully tree_sortkey being created/updated properly now.

initial OpenACS revision

    • -0
    • +335
    ./packages/acs-reference/sql/common/country.sql
    • -0
    • +284
    ./packages/acs-reference/sql/common/currency.sql
    • -0
    • +188
    ./packages/acs-reference/sql/common/language.sql
    • -0
    • +123
    ./packages/acs-reference/sql/common/s-and-p-data.sql
    • -0
    • +535
    ./packages/acs-reference/sql/common/timezone-data.sql
    • -0
    • +25
    ./packages/acs-reference/sql/common/timezone-drop.sql
    • -0
    • +40049
    ./packages/acs-reference/sql/common/timezone-rules.sql
    • -0
    • +512
    ./packages/acs-reference/sql/common/timezones.sql
    • -0
    • +3154
    ./packages/acs-reference/sql/common/us-counties-data.sql
    • -0
    • +99
    ./packages/acs-reference/sql/common/us-counties.sql
    • -0
    • +122
    ./packages/acs-reference/sql/common/us-states.sql
    • -0
    • +42205
    ./packages/acs-reference/sql/common/us-zipcodes-data.sql
    • -0
    • +76
    ./packages/acs-reference/sql/common/us-zipcodes.sql
    • -0
    • +16
    ./packages/acs-reference/sql/postgresql/acs-reference-data.sql
    • -0
    • +41
    ./packages/acs-reference/sql/postgresql/acs-reference-drop.sql
patch supplied by Dave Bauer to pass in security_inherit_p flag when creating new content_item. Work-around for data-change violation

fixed helper function timespan_days. use float instead of varchar.

fixed date calculations. used timespan_days() to calculate intervals. had to cast some arithmetic into float to pass to timespan_days.

added drop function for timespan_days.

added timespan_days helper function. from OpenACS 3.2.5.

fixed oracle sign calculation

fixed query name for ec_package_url_lookup_mem.ec_mountpoint

fixed issues.tcl. used db_map to handle dynamic queries. rewrote order_by bind variable to use a normal variable with a switch statement to verify the contents. for some reason the bind variable version kept enclosing the order_by variable in ' ' which is not correct.

fixed query name in .xql file for ec_package_url_lookup.

fixed sql query within the uplevel. used upvar as DanW suggested.

    • -6
    • +5
    ./packages/ecommerce/tcl/ecommerce-procs.tcl

- changed the XML parsing throughout to go through a simplified API to later upgrade XML parsing in a central place.

- updated support for ns_xml 1.4, and added work-arounds for previous versions.

- added installer check for ns_xml compatibility at boot time.

    • -5
    • +192
    ./packages/acs-tcl/tcl/30-xml-utils-procs.tcl
    • -16
    • +16
    ./packages/acs-tcl/tcl/apm-xml-procs.tcl

The query extractor incorrectly named a query.

Change api_set_public default to 1 (public) to match usage in

package-view.tcl etc, and add documentation.

Tests to make sure API ok

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

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

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

    • -0
    • +1366
    ./packages/acs-events/sql/postgresql/acs-events-create.sql
    • -0
    • +28
    ./packages/acs-events/sql/postgresql/acs-events-drop.sql
    • -0
    • +344
    ./packages/acs-events/sql/postgresql/activity-create.sql
    • -0
    • +15
    ./packages/acs-events/sql/postgresql/activity-drop.sql
    • -0
    • +210
    ./packages/acs-events/sql/postgresql/recurrence-create.sql
    • -0
    • +14
    ./packages/acs-events/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

    • -18
    • +38
    ./packages/acs-events/acs-events.info
Initial revision, moved under oracle subdirectory since tests are oracle specific

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

    • -509
    • +0
    ./packages/acs-events/sql/test/acs-events-test.sql
    • -1003
    • +0
    ./packages/acs-events/sql/test/timespan-test.sql
Initial revision, moved to correct subdirectory

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

    • -26
    • +0
    ./packages/acs-events/sql/acs-events-drop.sql
    • -284
    • +0
    ./packages/acs-events/sql/activity-create.sql
    • -16
    • +0
    ./packages/acs-events/sql/activity-drop.sql
    • -10
    • +0
    ./packages/acs-events/sql/recurrence-drop.sql
    • -782
    • +0
    ./packages/acs-events/sql/timespan-create.sql
    • -12
    • +0
    ./packages/acs-events/sql/timespan-drop.sql
Fixed error in bookmark__get_in_closed_p that was causing it to always return true...

Bookmark delete is working

    • -1
    • +1
    ./packages/bookmarks/www/bookmark-delete-2.tcl

added .xql files.

    • -54
    • +535
    ./packages/ecommerce/ecommerce.info
Chugging allong in porting. form-procs (huge file!) is 89% done.

    • -6
    • +6
    ./packages/cms/tcl/content-method-procs.tcl
    • -5
    • +65
    ./packages/cms/tcl/form-procs-oracle.xql
    • -6
    • +66
    ./packages/cms/tcl/form-procs-postgresql.xql
    • -82
    • +98
    ./packages/cms/tcl/form-procs.tcl
    • -0
    • +148
    ./packages/cms/tcl/form-procs.xql