andrewp in OpenACS

About

32 commits
  • Committer is not mapped to a user
  • First commit: 04 December 2002
  • Last commit: 07 June 2003
Last Week All Time
Commits: 0 32
Files changed: 0 50
Change in LOC: 0 98

Line History

Line Count Graph
Line Count Graph

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
 
Saturday 07 Jun 2003
10:39 pm

andrewp

Added config for DB API multi-db support.

Options
    • -4
    • +24
    /openacs-4/etc/config.tcl
Friday 11 Apr 2003
5:57 am

andrewp

Trivial tweak to syntax of db_available_pools proc.

Options
    • -1
    • +1
    /openacs-4/packages/acs-bootstrap-installer/db-init-checks-oracle.tcl
    • -2
    • +2
    /openacs-4/packages/acs-bootstrap-installer/db-init-checks-postgresql.tcl
    • -4
    • +4
    /openacs-4/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
    • -9
    • +9
    /openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl
Thursday 10 Apr 2003
2:11 am

andrewp

Added acs/database DB API config section.

Options
    • -0
    • +38
    /openacs-4/packages/acs-core-docs/www/xml/files/openacs4.tcl.txt
12:39 am

andrewp

Completed db_* api multi-database support. Can now use db api for

both Oracle and PostgreSQL at the same time.

Options
    • -0
    • +18
    /openacs-4/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
    • -588
    • +5
    /openacs-4/packages/acs-tcl/tcl/00-database-procs-oracle.tcl
    • -966
    • +5
    /openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql.tcl
    • -386
    • +2140
    /openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl
Monday 17 Mar 2003
9:21 pm

andrewp

Added comment only re. number_p returns true for empty_string.

Options
    • -1
    • +15
    /openacs-4/packages/acs-bootstrap-installer/tcl/00-proc-procs.tcl
9:18 pm

andrewp

Added base multi-db support to the db_* API.

Options
    • -1
    • +1
    /openacs-4/packages/acs-bootstrap-installer/db-init-checks-oracle.tcl
    • -2
    • +2
    /openacs-4/packages/acs-bootstrap-installer/db-init-checks-postgresql.tcl
    • -12
    • +90
    /openacs-4/packages/acs-bootstrap-installer/tcl/20-db-bootstrap-procs.tcl
    • -56
    • +90
    /openacs-4/packages/acs-tcl/tcl/00-database-procs-oracle.tcl
    • -69
    • +95
    /openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql.tcl
    • -72
    • +225
    /openacs-4/packages/acs-tcl/tcl/00-database-procs.tcl
    • -2
    • +4
    /openacs-4/packages/acs-tcl/tcl/table-display-procs.tcl
9:17 pm

andrewp

Made ns_logs slightly clearer.

Options
    • -8
    • +11
    /openacs-4/packages/acs-bootstrap-installer/bootstrap.tcl
Sunday 16 Mar 2003
10:12 pm

andrewp

Added title and CVS Id.

Options
    • -0
    • +6
    /openacs.org-dev/packages/acs-core-docs/www/xml/files/openacs4.tcl.txt
Wednesday 22 Jan 2003
10:22 pm

andrewp

In some cases when file not in DB yet, static_page_id was referenced

but not yet set at all, fixed.

Options
    • -1
    • +2
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
10:01 pm

andrewp

- Overhauled sp_maybe_create_new_mime_type to no longer have ANY side

effects (fixes bug 145).

- sp_sync_cr_with_filesystem_internal is now robust to errors caught

in do_sp_new (calling static_page.new), it continues on with other

files.

- Removed a few unnecessary ns_logs.

Options
    • -64
    • +101
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
Monday 20 Jan 2003
5:04 pm

andrewp

Fixed bad typo bug in sp_maybe_create_new_mime_type - if file-storage

package was installed, proc would fail due to left missing 'eval'.

Options
    • -3
    • +3
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
Saturday 21 Dec 2002
7:00 pm

andrewp

Replaced ns_schedule_daily with ad_schedule_proc.

Options
    • -4
    • +1
    /openacs-4/packages/static-pages/tcl/static-pages-init.tcl
Monday 16 Dec 2002
10:11 am

andrewp

Replaced ns_share with nsv, and related improvements to mutex locking.

Options
    • -2
    • +9
    /openacs-4/packages/static-pages/tcl/static-pages-init.tcl
    • -37
    • +47
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
8:48 am

andrewp

www/page-visit.tcl now works properly with files under package

directories and under the global www/ page root.

Options
    • -0
    • +8
    /openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql
    • -0
    • +9
    /openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
    • -1
    • +32
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
    • -53
    • +10
    /openacs-4/packages/static-pages/www/page-visit.tcl
5:30 am

andrewp

Failure to check for empty_string in sp_serve_html_page was breaking

/doc/static-pages/.

Options
    • -2
    • +3
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
4:22 am

andrewp

Now correctly sets mime type using sp_maybe_create_new_mime_type,

rather than always using text/html.

Options
    • -2
    • +3
    /openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql
    • -1
    • +2
    /openacs-4/packages/static-pages/sql/oracle/static-page-ph.sql
    • -1
    • +20
    /openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -3
    • +7
    /openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql
    • -11
    • +8
    /openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql
    • -12
    • +8
    /openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
    • -15
    • +72
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
12:49 am

andrewp

Added proc sp_sync_cr_with_filesystem_scheduled, so can optionally

schedule to run every night at e.g. 4 am.

Options
    • -0
    • +7
    /openacs-4/packages/static-pages/tcl/static-pages-init.tcl
    • -1
    • +76
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
12:25 am

andrewp

Upgrade script now properly converts existing filenames from page to

server root relative, for both Oracle and Postgres.

Options
    • -4
    • +6
    /openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +8
    /openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
Thursday 12 Dec 2002
11:40 pm

andrewp

- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

Options
    • -15
    • +83
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
    • -2
    • +61
    /openacs-4/packages/static-pages/www/page-visit.tcl
    • -7
    • +2
    /openacs-4/packages/static-pages/www/admin/fs-scan-progress.tcl
    • -3
    • +2
    /openacs-4/packages/static-pages/www/admin/fs-scan.tcl
    • -1
    • +2
    /openacs-4/packages/static-pages/www/admin/index.adp
    • -2
    • +2
    /openacs-4/packages/static-pages/www/admin/index.tcl
11:01 pm

andrewp

- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

Options
    • -7
    • +8
    /openacs-4/packages/static-pages/static-pages.info
    • -5
    • +7
    /openacs-4/packages/static-pages/sql/oracle/static-pages-create.sql
    • -1
    • +10
    /openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +5
    /openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
    • -5
    • +9
    /openacs-4/packages/static-pages/tcl/static-pages-init.tcl
    • -0
    • +23
    /openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql
    • -0
    • +21
    /openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
9:02 pm

andrewp

file upgrade-4.2a-4.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    /openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +0
    /openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
9:02 pm

andrewp

- Name of root folder is now unique in the CR even if have multiple

package instances, for both Oracle and Postgres.

- All Postgres functions now defined with "create or replace".

Options
    • -2
    • +4
    /openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql
    • -0
    • +15
    /openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -15
    • +24
    /openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql
    • -0
    • +15
    /openacs-4/packages/static-pages/sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
8:48 pm

andrewp

Moved Postgres functions and bodies out of static-pages-create.sql

into separate files (just like for Oracle) - necessary to more cleanly

support upgrade files. No other changes.

Options
    • -0
    • +589
    /openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql
    • -585
    • +2
    /openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql
8:48 pm

andrewp

file static-page-pb.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    /openacs-4/packages/static-pages/sql/postgresql/static-page-pb.sql
7:39 pm

andrewp

Moved Oracle package headers and bodies out of static-pages-create.sql

into separate files - necessary to more cleanly support upgrade files.

Also added a few comments. No other changes.

Options
    • -0
    • +441
    /openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql
    • -0
    • +160
    /openacs-4/packages/static-pages/sql/oracle/static-page-ph.sql
    • -589
    • +19
    /openacs-4/packages/static-pages/sql/oracle/static-pages-create.sql
7:39 pm

andrewp

file static-page-pb.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    /openacs-4/packages/static-pages/sql/oracle/static-page-pb.sql
7:39 pm

andrewp

file static-page-ph.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    /openacs-4/packages/static-pages/sql/oracle/static-page-ph.sql
2:48 am

andrewp

Show result message from sp_sync_cr_with_filesystem at bottom of page.

Options
    • -0
    • +5
    /openacs-4/packages/static-pages/www/admin/fs-scan.adp
2:32 am

andrewp

Added mutex locking prevent errors if more than one copy of

sp_sync_cr_with_filesystem runs at once for a single package instance,

plus related changes. Changed sp_sync_cr_with_filesystem proc to a

wrapper proc which now calls sp_sync_cr_with_filesystem_internal, in

order to properly free the mutex upon any unexpected error.

Options
    • -1
    • +13
    /openacs-4/packages/static-pages/tcl/static-pages-init.tcl
    • -8
    • +8
    /openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql
    • -8
    • +8
    /openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
    • -22
    • +194
    /openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
    • -4
    • +4
    /openacs-4/packages/static-pages/tcl/static-pages-procs.xql
    • -7
    • +16
    /openacs-4/packages/static-pages/www/admin/fs-scan-progress.tcl
    • -4
    • +6
    /openacs-4/packages/static-pages/www/admin/fs-scan.tcl
2:29 am

andrewp

The fs-scan page now shows a message when an error readin a file is

encountered, just like the fs-scan-progress page.

Options
    • -1
    • +1
    /openacs-4/packages/static-pages/www/admin/fs-scan.adp
    • -5
    • +13
    /openacs-4/packages/static-pages/www/admin/fs-scan.tcl