OpenACS / openacs-4 / packages

static-pages

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 17 May
Commits this week: 0
Total Lines of Code (LoC): 8,256
Net change in LoC this week: 0

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 11 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 02 Mar 2003
11:52 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -3
    • +3
    ./sql/postgresql/static-page-pb.sql
  2. … 14 more files in changeset.
Thursday 06 Feb 2003
2:03 pm

jeffd

- Adds table cr_extension_mime_type_map,

- Adds function cr_filename_to_mime_type [-create] filename

- Adds function cr_create_mime_type -extension -mime_type -description

- Removes *_maybe_create_new_mime_type

- Updates acs-content-repository to 4.6.3. Ugrade scripts provided.

- Updates dependency information for several packages.

- Adds most mime types plus comprehensive list of extension to mime-typemappings.

- Maps .c .h .c++ .pl etc to text/plain

Options
    • -93
    • +2
    ./tcl/static-pages-procs.tcl
  2. … 9 more files in changeset.
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
    ./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
    ./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
    ./tcl/static-pages-procs.tcl
Thursday 16 Jan 2003
2:58 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -13
    • +10
    ./static-pages.info
    • -0
    • +444
    ./sql/oracle/static-page-pb.sql
    • -0
    • +161
    ./sql/oracle/static-page-ph.sql
    • -589
    • +21
    ./sql/oracle/static-pages-create.sql
    • -0
    • +45
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +602
    ./sql/postgresql/static-page-pb.sql
    • -585
    • +2
    ./sql/postgresql/static-pages-create.sql
    • -0
    • +26
    ./sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
    • -5
    • +32
    ./tcl/static-pages-init.tcl
    • -19
    • +47
    ./tcl/static-pages-procs-oracle.xql
    • -20
    • +46
    ./tcl/static-pages-procs-postgresql.xql
    • -50
    • +509
    ./tcl/static-pages-procs.tcl
    • -4
    • +4
    ./tcl/static-pages-procs.xql
    • -6
    • +22
    ./www/page-visit.tcl
    • -14
    • +22
    ./www/admin/fs-scan-progress.tcl
  16. … 20 more files in changeset.
Saturday 21 Dec 2002
7:00 pm

andrewp

Replaced ns_schedule_daily with ad_schedule_proc.

Options
    • -4
    • +1
    ./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
    ./tcl/static-pages-init.tcl
    • -37
    • +47
    ./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
    ./tcl/static-pages-procs-oracle.xql
    • -0
    • +9
    ./tcl/static-pages-procs-postgresql.xql
    • -1
    • +32
    ./tcl/static-pages-procs.tcl
    • -53
    • +10
    ./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
    ./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
    ./sql/oracle/static-page-pb.sql
    • -1
    • +2
    ./sql/oracle/static-page-ph.sql
    • -1
    • +20
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -3
    • +7
    ./sql/postgresql/static-page-pb.sql
    • -11
    • +8
    ./tcl/static-pages-procs-oracle.xql
    • -12
    • +8
    ./tcl/static-pages-procs-postgresql.xql
    • -15
    • +72
    ./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
    ./tcl/static-pages-init.tcl
    • -1
    • +76
    ./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
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +8
    ./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
    ./tcl/static-pages-procs.tcl
    • -2
    • +61
    ./www/page-visit.tcl
    • -7
    • +2
    ./www/admin/fs-scan-progress.tcl
    • -3
    • +2
    ./www/admin/fs-scan.tcl
    • -1
    • +2
    ./www/admin/index.adp
    • -2
    • +2
    ./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
    ./static-pages.info
    • -5
    • +7
    ./sql/oracle/static-pages-create.sql
    • -1
    • +10
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +5
    ./sql/postgresql/upgrade/upgrade-4.2a-4.3.sql
    • -5
    • +9
    ./tcl/static-pages-init.tcl
    • -0
    • +23
    ./tcl/static-pages-procs-oracle.xql
    • -0
    • +21
    ./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
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +0
    ./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
    ./sql/oracle/static-page-pb.sql
    • -0
    • +15
    ./sql/oracle/upgrade/upgrade-4.2a-4.3.sql
    • -15
    • +24
    ./sql/postgresql/static-page-pb.sql
    • -0
    • +15
    ./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
    ./sql/postgresql/static-page-pb.sql
    • -585
    • +2
    ./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
    ./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
    ./sql/oracle/static-page-pb.sql
    • -0
    • +160
    ./sql/oracle/static-page-ph.sql
    • -589
    • +19
    ./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
    ./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
    ./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
    ./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
    ./tcl/static-pages-init.tcl
    • -8
    • +8
    ./tcl/static-pages-procs-oracle.xql
    • -8
    • +8
    ./tcl/static-pages-procs-postgresql.xql
    • -22
    • +194
    ./tcl/static-pages-procs.tcl
    • -4
    • +4
    ./tcl/static-pages-procs.xql
    • -7
    • +16
    ./www/admin/fs-scan-progress.tcl
    • -4
    • +6
    ./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
    ./www/admin/fs-scan.adp
    • -5
    • +13
    ./www/admin/fs-scan.tcl
Wednesday 11 Dec 2002
10:55 pm

andrewp

Fixed sp_sync_cr_with_filesystem and the fs-scan-progress.tcl page so

that the scan will properly continue after hitting an error on a

single file, rather than terminating abruptly. Also tweaked sp_*_item

output procs slightly.

Options
    • -5
    • +35
    ./tcl/static-pages-procs.tcl
    • -7
    • +11
    ./www/admin/fs-scan-progress.tcl
Monday 09 Dec 2002
3:29 pm

jeffd

sync info files with package data and correct provides identifiers

Options
    • -6
    • +2
    ./static-pages.info
  2. … 36 more files in changeset.
Wednesday 04 Dec 2002
11:10 pm

andrewp

Added TODO comments about deleting stale items and all their attached

comments, only.

Options
    • -1
    • +16
    ./tcl/static-pages-procs.tcl
Saturday 30 Nov 2002
6:42 pm

jeffd

merge from oacs-4-6

Options
    • -27
    • +0
    ./tcl/static-pages-sc-procs-postgresql.xql
    • -0
    • +27
    ./tcl/static-pages-sc-procs.xql
    • -0
    • +14
    ./www/admin/display-policy-toggle-oracle.xql
    • -14
    • +0
    ./www/admin/display-policy-toggle-orcale.xql
    • -1
    • +1
    ./www/admin/index.adp
  6. … 24 more files in changeset.
Thursday 24 Oct 2002
10:36 pm

donb

1. Minor wording change to the static pages admin index template

2. Made ad_form_new_p require a key name since guessing's arcane and

unreliable

Options
    • -1
    • +1
    ./www/admin/index.adp
  2. … 1 more file in changeset.