• last updated 14 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Renamed data to -data and moved sql to database dependent directories.

Major change.

I put all database dependent parts in their directories and kept the data only in common.

This is needed for the database independence and pl(pg)sql differences.

updated to reflect removal of timezone data temporarily

Initial Postgres port. Rough only.

deleted for OpenACS. All files put in common

Fixed error in tree_sortkey insert trigger; hopefully tree_sortkey being created/updated properly now.

initial OpenACS revision

    • -0
    • +123
    /openacs-4/packages/acs-reference/sql/common/s-and-p-data.sql
    • -0
    • +535
    /openacs-4/packages/acs-reference/sql/common/timezone-data.sql
    • -0
    • +25
    /openacs-4/packages/acs-reference/sql/common/timezone-drop.sql
    • -0
    • +40049
    /openacs-4/packages/acs-reference/sql/common/timezone-rules.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.

- 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.

    • -16
    • +16
    /openacs-4/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.

Added Vinord's porting document.

    • -0
    • +351
    /web/openacs/www/4/porting-resources.html
Tests to make sure API ok

    • -0
    • +353
    /openacs-4/packages/acs-events/sql/postgresql/test/utest.sql
Initial revision

Oracle date functions ported to postgres

Initial revision

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

moved to correct subdirectory under oracle, since tests are oracle specific

Initial revision, moved to correct subdirectory

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