• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
adding timezone support

  1. … 6 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -25
    • +33
    ./file-storage-procs-postgresql.xql
  1. … 57 more files in changeset.
fixing incorrect PG query children_have_permission_p.child_perms. It would select everything under the folders parent instead of everything under the folder. The symptom was the empty folders could not be deleted. Bug reported by Carl Robert Blesius

Fixed bug #397 - bad query to db_blob_get_file, one OF knew about, flagged,

but didn't fix ... grrr ...

Removed the vile fs_simple_objects added by OF to store URLs in file

storage despite the existence of a non-versioned URL type in the content

repository. Upgrade scripts provided. I added Tcl API to the content

repository to honor our desire to export the SQL API to Tcl client code.

1. folder contents are now counted correctly (bug fix)

2. The fs_objects view is now usable in PG (it was a UNION view before and

therefore didn't scale)

3. Code in file storage is considerably simpler now and all file storage

objects are now stored in the content repository, as they should

be.

The Oracle version may need some work I'll finish testing this afternoon.

  1. … 41 more files in changeset.
Fixed download archives for PostgreSQL

Moved over my new permissions stuff plus improved file storage stuff (mostly

speed improvements in PG-land)

  1. … 16 more files in changeset.
1. Got rid of the "create or replace function" decls used for triggers, due

to the brand-new PG 7.3 "opaque" vs. "trigger" issue.

2. Added a new "fs::get_folder_object_ids" for use when you just need the

object ids rather than a bunch of (slow) permissions information,

(slow) counts of items in folders and subfolders, last modified info,

etc. dotLRN was calling "fs::get_folder_contents" when cloning folders

despite making use of only the object_id and that proc used to be unimaginably

slow. It's faster now due to the new permissions code but it's still slow

enough to warrant avoiding it when possible.

3. Fixed typo in my last commit.

  1. … 3 more files in changeset.
First whack at speeding up (though not rationalizing, unfortunately) file

storage for PostgreSQL. Also fixes the fs_files view.

  1. … 9 more files in changeset.
1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

    • -24
    • +22
    ./file-storage-procs-postgresql.xql
  1. … 23 more files in changeset.
- 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

  1. … 19 more files in changeset.
Switched to "file copy" ...

  1. … 7 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

  1. … 54 more files in changeset.
last_modified should be last_modified_ansi

Patches to make OpenACS PG 7.3 compatible.

  1. … 54 more files in changeset.
Date/time/number localization

  1. … 83 more files in changeset.
fixed file storage guessing of mimetype so as not to create new mime types - not the appropriate place.

I18N: converting file-storage to using the message catalog

  1. … 49 more files in changeset.
fix tree_sortkey query, bind variable for revision_id

    • -2
    • +2
    ./file-storage-search-procs-postgresql.xql
Roll in fixes from sloan.

Adds folder-edit to rename folders.

some bug fixes in postgresql procs.

Adds file_upload_name to fs views.

Supports upload of files with unkown mimetype (needs change to acs-kernel datamodel)

changed vendor to openacs.

Needs db upgrade script. Notched version from 4.1c to 4.2

  1. … 24 more files in changeset.
add missing ad_library calls

  1. … 14 more files in changeset.
cleanup javadoc tags (eg @cvs_id @cvs @cvs-id: instead if @cvs-id)

  1. … 691 more files in changeset.
put \\ at the end so it doesn't get confused

@, #, %, &, and + are also special characters because of urls. we might think

about just replacing any non-alphanumeric or space character with an

underscore.

made download-archive and the publish_object_to_file_system api file system

safe, that is, removed file system special characters according to the

'filename' tcl api.

@see http://dev.scriptics.com/man/tcl8.3/TclCmd/filename.htm#M29

  1. … 1 more file in changeset.
fixed a bunch of queries that were select

s instead of perform.. file uploading works on pg now

  1. … 5 more files in changeset.
$n_past-days in comment replaced with $ n_past-days

We use $n_past-days instead of :n_past_days becasuse he pgdriver

bind variable emulation puts single-quotes around the n_past_days

integer. Postgresql tries to turn '-1' into a date datatype

so now()-'-1' fails but now()- -1 works fine.

By Dave Bauer in the process of migrating the openacs.org site.

pg fixes

  1. … 8 more files in changeset.
fixed small pG bug