OpenACS

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 6
Total Committers: 146
Last Commit: 17:59
Commits this week: 6
Total Lines of Code (LoC): 7,561,327
Net change in LoC this week: 325

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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 15 Nov 2017
5:35 pm

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -13
    • +0
    /openacs-4/packages/acs-content-repository/tcl/symlink-procs-oracle.xql
    • -13
    • +0
    /openacs-4/packages/acs-content-repository/tcl/symlink-procs-postgresql.xql
    • -0
    • +13
    /openacs-4/packages/acs-content-repository/tcl/symlink-procs.xql
    • -13
    • +0
    /openacs-4/packages/acs-content-repository/tcl/extlink-procs-oracle.xql
    • -13
    • +0
    /openacs-4/packages/acs-content-repository/tcl/extlink-procs-postgresql.xql
    • -0
    • +13
    /openacs-4/packages/acs-content-repository/tcl/extlink-procs.xql
5:29 pm

antoniop

Add missing new xql file

Options
    • -0
    • +23
    /openacs-4/packages/acs-automated-testing/tcl/aa-test-procs.xql
5:28 pm

antoniop

Reduce divergence between postgres and oracle codebase

Options
    • -23
    • +0
    /openacs-4/packages/acs-automated-testing/tcl/aa-test-procs-oracle.xql
    • -34
    • +0
    /openacs-4/packages/acs-automated-testing/tcl/aa-test-procs-postgresql.xql
    • -7
    • +8
    /openacs-4/packages/acs-automated-testing/tcl/aa-test-procs.tcl
4:56 pm

antoniop

Reduce divergence between oracle and postgres codebase

Options
    • -28
    • +0
    /openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql
    • -28
    • +0
    /openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql
    • -0
    • +26
    /openacs-4/packages/acs-authentication/tcl/sync-procs.xql
4:37 pm

antoniop

Reduce divergence between postgres and oracle codebase

Options
    • -37
    • +0
    /openacs-4/packages/acs-admin/www/users/complex-search-oracle.xql
    • -38
    • +0
    /openacs-4/packages/acs-admin/www/users/complex-search-postgresql.xql
    • -9
    • +3
    /openacs-4/packages/acs-admin/www/users/complex-search.tcl
    • -5
    • +28
    /openacs-4/packages/acs-admin/www/users/complex-search.xql
3:35 pm

antoniop

Ehm... reintroduce dual for oracle compliance

Options
    • -4
    • +4
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
3:32 pm

antoniop

Use dual for oracle compliance

Options
    • -2
    • +2
    /openacs-4/packages/news/www/index.xql
3:30 pm

antoniop

Add dual for oracle compliance

Options
    • -2
    • +2
    /openacs-4/packages/news/www/admin/process-2.xql
3:25 pm

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -27
    • +0
    /openacs-4/packages/news/www/admin/process-2-oracle.xql
    • -27
    • +0
    /openacs-4/packages/news/www/admin/process-2-postgresql.xql
    • -90
    • +2
    /openacs-4/packages/news/www/admin/process-2.tcl
    • -0
    • +17
    /openacs-4/packages/news/www/admin/process-2.xql
3:12 pm

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -28
    • +0
    /openacs-4/packages/news/www/admin/revision-add-oracle.xql
    • -29
    • +0
    /openacs-4/packages/news/www/admin/revision-add-postgresql.xql
    • -1
    • +6
    /openacs-4/packages/news/www/admin/revision-add.tcl
    • -0
    • +21
    /openacs-4/packages/news/www/admin/revision-add.xql
2:48 pm

antoniop

Use tcl to do date calculations instead of db, reduce postgres/oracle divergencies

Options
    • -7
    • +0
    /openacs-4/packages/news/www/admin/approve-oracle.xql
    • -7
    • +0
    /openacs-4/packages/news/www/admin/approve-postgresql.xql
    • -9
    • +2
    /openacs-4/packages/news/www/admin/approve.tcl
2:42 pm

antoniop

Reduce divergence between oracle and postgres codebase, optimize queries

Options
    • -48
    • +0
    /openacs-4/packages/news/www/index-oracle.xql
    • -48
    • +0
    /openacs-4/packages/news/www/index-postgresql.xql
    • -3
    • +3
    /openacs-4/packages/news/www/index.tcl
    • -1
    • +41
    /openacs-4/packages/news/www/index.xql
2:26 pm

antoniop

Do date calculations in tcl rather than in db, reduce oracle and postgres divergency

Options
    • -14
    • +0
    /openacs-4/packages/news/www/item-create-oracle.xql
    • -14
    • +0
    /openacs-4/packages/news/www/item-create-postgresql.xql
    • -2
    • +4
    /openacs-4/packages/news/www/item-create.tcl
2:12 pm

antoniop

Reduce divergence between oracle and postgres code

Options
    • -7
    • +2
    /openacs-4/packages/news/lib/latest-news-oracle.xql
    • -4
    • +1
    /openacs-4/packages/news/lib/latest-news-postgresql.xql
    • -4
    • +2
    /openacs-4/packages/news/lib/latest-news.tcl
    • -0
    • +10
    /openacs-4/packages/news/lib/latest-news.xql
12:08 pm

antoniop

Reduce oracle/postgres divergence

Options
    • -22
    • +0
    /openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql
    • -23
    • +0
    /openacs-4/packages/rss-support/tcl/rss-generation-service-procs-postgresql.xql
    • -2
    • +21
    /openacs-4/packages/rss-support/tcl/rss-generation-service-procs.xql
11:40 am

antoniop

Uniform sql codebase

Options
    • -19
    • +0
    /openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql
    • -13
    • +0
    /openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql
    • -0
    • +14
    /openacs-4/packages/notifications/tcl/sweep-procs.xql
Tuesday 14 Nov 2017
6:03 pm

antoniop

Use cached api instead of query to retrieve node id from community and community_type

Options
    • -3
    • +7
    /openacs-4/packages/dotlrn/tcl/community-procs.tcl
    • -20
    • +0
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
5:43 pm

antoniop

Remove unused query from xql (no usage was found upstream and on Learn@WU)

Options
    • -8
    • +0
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
5:34 pm

antoniop

Get rid of dual idiom

Options
    • -9
    • +3
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
5:30 pm

antoniop

Oracle doesn't support limit :-|

Options
    • -4
    • +4
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
5:12 pm

antoniop

Streamline and optimize idiom

Options
    • -7
    • +2
    /openacs-4/packages/dotlrn/tcl/community-procs.tcl
    • -13
    • +5
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
4:46 pm

antoniop

Declare explicitly the only column we need in a way that DBMS can create a better query plan

Options
    • -2
    • +2
    /openacs-4/packages/dotlrn/tcl/community-procs.tcl
    • -4
    • +3
    /openacs-4/packages/dotlrn/tcl/community-procs.xql
3:49 pm

antoniop

Tolerate the same request variable specified multiple times

We use export_vars as arbiter to decide how this will be treated.

Also remove some postgres/oracle divergence

Options
    • -0
    • +1
    /openacs-4/packages/calendar/www/view-list-display.adp
    • -21
    • +16
    /openacs-4/packages/calendar/www/view-list-display.tcl
3:21 pm

antoniop

Replace db date conversion with tcl one, remove unneded statements (sort_by is already defined in page contract, ad_return_template is implicit)

Options
    • -7
    • +3
    /openacs-4/packages/calendar-portlet/www/calendar-list-portlet.tcl
Monday 13 Nov 2017
4:35 pm

antoniop

Fix typo

Options
    • -3
    • +3
    /openacs-4/packages/forums/www/moderate/move.tcl
    • -1
    • +1
    /openacs-4/packages/forums/www/moderate/move.xql
4:22 pm

antoniop

Port downstream only usage of reading info api

Also fix such api so that root message is retrieved for every given source message

Options
    • -2
    • +2
    /openacs-4/packages/forums/forums.info
    • -5
    • +16
    /openacs-4/packages/forums/sql/oracle/forums-reading-info-package-create.sql
    • -0
    • +163
    /openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d3-1.3.1d4.sql
    • -2
    • +6
    /openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql
    • -0
    • +34
    /openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3.1d3-1.3.1d4.sql
    • -1
    • +9
    /openacs-4/packages/forums/www/moderate/move-thread-oracle.xql
    • -0
    • +8
    /openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql
    • -0
    • +5
    /openacs-4/packages/forums/www/moderate/move-thread.tcl
3:31 pm

antoniop

Converge downstream reading_info feature with upstream

Port downstream only idiom to update reading_info table

Make more use of api when retrieving forum and message information

Optimize message existance query

Options
    • -10
    • +25
    /openacs-4/packages/forums/www/moderate/move.tcl
    • -20
    • +14
    /openacs-4/packages/forums/www/moderate/move.xql
1:52 pm

antoniop

Fix sql update to populate new forum_id column in existing data

Options
    • -3
    • +9
    /openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
    • -4
    • +9
    /openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
Friday 10 Nov 2017
6:21 pm

antoniop

Maintenance of forum reading count feature

- removal of forums_reading_info_user (1Mio rows on Learn@WU).

This materialized view had to be constantly synced with

forums_reading_info table. Reimplemented as view.

- simplify logics in stored procedure due to new datamodel

- fix inconsistencies between oracle and postgres function definition

- re-enabled parameter to decide whether use these stats or not in

administration

TODO: consider further reform of this feature as stats grow very

large on busy sites for probably little value added

Options
    • -2
    • +2
    /openacs-4/packages/forums/forums.info
    • -17
    • +10
    /openacs-4/packages/forums/sql/oracle/forums-reading-info-create.sql
    • -3
    • +3
    /openacs-4/packages/forums/sql/oracle/forums-reading-info-drop.sql
    • -143
    • +5
    /openacs-4/packages/forums/sql/oracle/forums-reading-info-package-create.sql
    • -0
    • +186
    /openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
    • -195
    • +68
    /openacs-4/packages/forums/sql/postgresql/forums-reading-info-create.sql
    • -9
    • +4
    /openacs-4/packages/forums/sql/postgresql/forums-reading-info-drop.sql
    • -0
    • +173
    /openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.3.1d2-1.3.1d3.sql
    • -5
    • +2
    /openacs-4/packages/forums/tcl/forums-procs.tcl
Thursday 09 Nov 2017
6:28 pm

antoniop

Remove deprecated idioms and unneded queries

Options
    • -8
    • +0
    /openacs-4/packages/forums/lib/message/post-oracle.xql
    • -8
    • +0
    /openacs-4/packages/forums/lib/message/post-postgresql.xql
    • -14
    • +13
    /openacs-4/packages/forums/lib/message/post.tcl
    • -13
    • +0
    /openacs-4/packages/forums/lib/message/post.xql