OpenACS

openacs-4

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 4
Total Committers: 144
Last Commit: 16:56
Commits this week: 4
Total Lines of Code (LoC): 6,317,726
Net change in LoC this week: 335

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 18 Jul 2001
4:52 am

gilbertw

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.

Options
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-0.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-0.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2-postgresql.xql
    • -2
    • +7
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add-2.xql
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subsubcategory-add.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subsubcategory-add.xql
2:03 am

gilbertw

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

Options
    • -2
    • +15
    ./packages/ecommerce/tcl/ecommerce-widgets-procs-oracle.xql
    • -2
    • +16
    ./packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
1:59 am

gilbertw

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.

Options
    • -1
    • +7
    ./packages/ecommerce/www/admin/cat/category-add-0.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-0.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-2-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-2-postgresql.xql
    • -2
    • +7
    ./packages/ecommerce/www/admin/cat/category-add-2.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add-2.xql
    • -1
    • +6
    ./packages/ecommerce/www/admin/cat/category-add.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/category-add.xql
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subcategory-add-0.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-0.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-2-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-2-postgresql.xql
    • -2
    • +7
    ./packages/ecommerce/www/admin/cat/subcategory-add-2.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add-2.xql
    • -1
    • +5
    ./packages/ecommerce/www/admin/cat/subcategory-add.tcl
    • -1
    • +1
    ./packages/ecommerce/www/admin/cat/subcategory-add.xql
Tuesday 17 Jul 2001
11:56 pm

gilbertw

fixed oracle sign() calls

Options
    • -5
    • +5
    ./packages/ecommerce/www/admin/products/offers-postgresql.xql
    • -3
    • +3
    ./packages/ecommerce/www/admin/products/sale-prices-postgresql.xql
9:11 pm

pascals

/bin/bash: q: command not found

Options
    • -1
    • +1
    ./packages/general-comments/www/comment-add-3-postgresql.xql
8:26 am

jong

Initial OpenACS import

Options
    • -0
    • +96
    ./packages/acs-reference/sql/postgresql/country.sql
    • -0
    • +87
    ./packages/acs-reference/sql/postgresql/currency.sql
    • -0
    • +44
    ./packages/acs-reference/sql/postgresql/language.sql
    • -0
    • +43
    ./packages/acs-reference/sql/postgresql/s-and-p.sql
    • -0
    • +91
    ./packages/acs-reference/sql/postgresql/us-counties.sql
    • -0
    • +40
    ./packages/acs-reference/sql/postgresql/us-states.sql
    • -0
    • +68
    ./packages/acs-reference/sql/postgresql/us-zipcodes.sql
8:25 am

jong

Another PG type fix, and added overloaded new.

Options
    • -3
    • +35
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
7:49 am

jong

Worked on permissions syntax

Options
    • -14
    • +17
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
7:40 am

jong

Initial revision for OpenACS.

Options
    • -0
    • +62
    ./packages/acs-reference/acs-reference.info
7:03 am

jong

Pulled inserts into own files.

Options
    • -43
    • +1
    ./packages/acs-reference/sql/common/s-and-p-data.sql
    • -4
    • +1
    ./packages/acs-reference/sql/common/timezone-data.sql
    • -45
    • +1
    ./packages/acs-reference/sql/common/us-states.sql
    • -5
    • +2
    ./packages/acs-reference/sql/common/us-zipcodes-data.sql
7:03 am

jong

Pulled inserts out of sql files for commonality.

Options
    • -0
    • +259
    ./packages/acs-reference/sql/common/country-data.sql
    • -0
    • +205
    ./packages/acs-reference/sql/common/currency-data.sql
    • -0
    • +146
    ./packages/acs-reference/sql/common/language-data.sql
7:02 am

jong

Moved sql to data dependent dirs

Options
    • -76
    • +0
    ./packages/acs-reference/sql/common/us-zipcodes.sql
7:01 am

jong

Renamed data to -data and moved sql to database dependent directories.

Options
    • -335
    • +0
    ./packages/acs-reference/sql/common/country.sql
    • -284
    • +0
    ./packages/acs-reference/sql/common/currency.sql
    • -188
    • +0
    ./packages/acs-reference/sql/common/language.sql
    • -99
    • +0
    ./packages/acs-reference/sql/common/us-counties.sql
6:59 am

jong

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.

Options
    • -0
    • +91
    ./packages/acs-reference/sql/oracle/country.sql
    • -0
    • +93
    ./packages/acs-reference/sql/oracle/currency.sql
    • -0
    • +49
    ./packages/acs-reference/sql/oracle/language.sql
    • -0
    • +47
    ./packages/acs-reference/sql/oracle/s-and-p.sql
    • -0
    • +99
    ./packages/acs-reference/sql/oracle/us-counties.sql
    • -0
    • +44
    ./packages/acs-reference/sql/oracle/us-states.sql
    • -0
    • +76
    ./packages/acs-reference/sql/oracle/us-zipcodes.sql
6:55 am

jong

updated to reflect removal of timezone data temporarily

Options
    • -3
    • +4
    ./packages/acs-reference/sql/oracle/acs-reference-data.sql
5:59 am

jong

Initial Postgres port. Rough only.

Options
    • -150
    • +122
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
4:01 am

jong

deleted for OpenACS. All files put in common

Options
    • -335
    • +0
    ./packages/acs-reference/sql/oracle/country.sql
    • -284
    • +0
    ./packages/acs-reference/sql/oracle/currency.sql
    • -189
    • +0
    ./packages/acs-reference/sql/oracle/language.sql
    • -124
    • +0
    ./packages/acs-reference/sql/oracle/s-and-p-data.sql
    • -535
    • +0
    ./packages/acs-reference/sql/oracle/timezone-data.sql
    • -25
    • +0
    ./packages/acs-reference/sql/oracle/timezone-drop.sql
    • -40049
    • +0
    ./packages/acs-reference/sql/oracle/timezone-rules.sql
    • -512
    • +0
    ./packages/acs-reference/sql/oracle/timezones.sql
    • -3154
    • +0
    ./packages/acs-reference/sql/oracle/us-counties-data.sql
    • -99
    • +0
    ./packages/acs-reference/sql/oracle/us-counties.sql
    • -123
    • +0
    ./packages/acs-reference/sql/oracle/us-states.sql
    • -42205
    • +0
    ./packages/acs-reference/sql/oracle/us-zipcodes-data.sql
    • -76
    • +0
    ./packages/acs-reference/sql/oracle/us-zipcodes.sql
3:52 am

kenk

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

Options
    • -0
    • +3
    ./packages/bookmarks/bookmarks.info
    • -1
    • +1
    ./packages/bookmarks/sql/postgresql/bookmarks-create.sql
    • -1
    • +1
    ./packages/bookmarks/tcl/bookmarks-procs-postgresql.xql
    • -1
    • +1
    ./packages/bookmarks/www/bookmark-add-import.tcl
    • -0
    • +3
    ./packages/bookmarks/www/bookmark-add-one-2.tcl
3:44 am

jong

initial OpenACS revision

Options
    • -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
    • +219
    ./packages/acs-reference/sql/postgresql/acs-reference-create.sql
    • -0
    • +16
    ./packages/acs-reference/sql/postgresql/acs-reference-data.sql
    • -0
    • +41
    ./packages/acs-reference/sql/postgresql/acs-reference-drop.sql
1:46 am

danw

patch supplied by Dave Bauer to pass in security_inherit_p flag when creating new content_item. Work-around for data-change violation

Options
    • -1
    • +165
    ./packages/acs-content-repository/sql/postgresql/content-item.sql
Monday 16 Jul 2001
10:08 pm

gilbertw

fixed helper function timespan_days. use float instead of varchar.

Options
    • -2
    • +3
    ./packages/ecommerce/sql/postgresql/ecommerce-create.sql
    • -1
    • +1
    ./packages/ecommerce/sql/postgresql/ecommerce-drop.sql
10:07 pm

gilbertw

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

Options
    • -3
    • +3
    ./packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-procs-postgresql.xql
    • -7
    • +7
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql
8:33 pm

gilbertw

added drop function for timespan_days.

Options
    • -0
    • +1
    ./packages/ecommerce/sql/postgresql/ecommerce-drop.sql
8:32 pm

gilbertw

added timespan_days helper function. from OpenACS 3.2.5.

Options
    • -0
    • +11
    ./packages/ecommerce/sql/postgresql/ecommerce-create.sql
6:12 am

gilbertw

fixed oracle sign calculation

Options
    • -2
    • +2
    ./packages/ecommerce/tcl/ecommerce-credit-procs-postgresql.xql
    • -2
    • +2
    ./packages/ecommerce/tcl/ecommerce-scheduled-procs-postgresql.xql
Sunday 15 Jul 2001
10:47 pm

gilbertw

fixed query name for ec_package_url_lookup_mem.ec_mountpoint

Options
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-procs-oracle.xql
10:30 pm

gilbertw

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.

Options
    • -0
    • +83
    ./packages/ecommerce/www/admin/customer-service/issues-oracle.xql
    • -0
    • +86
    ./packages/ecommerce/www/admin/customer-service/issues-postgresql.xql
    • -50
    • +38
    ./packages/ecommerce/www/admin/customer-service/issues.tcl
7:01 pm

gilbertw

fixed query name in .xql file for ec_package_url_lookup.

Options
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-procs-postgresql.xql
7:47 am

gilbertw

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

Options
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-procs-oracle.xql
    • -1
    • +1
    ./packages/ecommerce/tcl/ecommerce-procs-postgresql.xql
    • -6
    • +5
    ./packages/ecommerce/tcl/ecommerce-procs.tcl
1:03 am

ben

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

Options
    • -0
    • +6
    ./packages/acs-bootstrap-installer/installer/index.tcl
    • -18
    • +22
    ./packages/acs-bootstrap-installer/tcl/40-db-query-dispatcher-procs.tcl
    • -5
    • +192
    ./packages/acs-tcl/tcl/30-xml-utils-procs.tcl
    • -16
    • +16
    ./packages/acs-tcl/tcl/apm-xml-procs.tcl