• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

fixed ec_product__new for postgresql. also did a db_map for sysdate call.

fixed ec_product__new function

fixed sort key calculation. postgres driver encloses bind variables in ' ' which makes the sort key calculation fail. the key calculation is done in tcl now.

fixed queryname names. fixed outer join which wasn't picked up by the query extractor.

fixed sort key calculations. the postgres driver puts ' ' around the bind variable. the old code performed calculations like "and sort_key = (:prev_sort_key + :next_sort_key)/2", which caused postgres to barf. this calculation is now done in tcl.

fixed oracle sign() calls

/bin/bash: q: command not found

Initial OpenACS import

    • -0
    • +91
    /openacs-4/packages/acs-reference/sql/postgresql/us-counties.sql
    • -0
    • +40
    /openacs-4/packages/acs-reference/sql/postgresql/us-states.sql
    • -0
    • +68
    /openacs-4/packages/acs-reference/sql/postgresql/us-zipcodes.sql
Another PG type fix, and added overloaded new.

Worked on permissions syntax

Initial revision for OpenACS.

    • -0
    • +62
    /openacs-4/packages/acs-reference/acs-reference.info
Pulled inserts into own files.

Pulled inserts out of sql files for commonality.

    • -0
    • +259
    /openacs-4/packages/acs-reference/sql/common/country-data.sql
    • -0
    • +205
    /openacs-4/packages/acs-reference/sql/common/currency-data.sql
    • -0
    • +146
    /openacs-4/packages/acs-reference/sql/common/language-data.sql
Moved sql to data dependent dirs

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.