• last updated 16 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
@, #, %, &, 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

added some optional parameters to make fs procs more modular for attachments

created a rename_folder method.

    • -0
    • +13
    ./file-storage-procs-postgresql.xql
tune folder contents query

    • -17
    • +19
    ./file-storage-procs-postgresql.xql
copy methods and some procs for simple

  1. … 3 more files in changeset.
adding a safety check

  1. … 1 more file in changeset.
reverting back to 1.2

adding "download archive" code; moved some stuff around in publish_to_file_system procs

  1. … 7 more files in changeset.
added support for publishing fs_objects to the file system; also added some archiving infrastructure stuff

  1. … 9 more files in changeset.
Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

  1. … 58 more files in changeset.
fix count query to check contents :)

Minor mods to add the ability to specify the title of an fs object using a urlvar and a minor doc update

  1. … 5 more files in changeset.
mistakenly commited some stuff i didn't want to yet

adding folder-contents view (altough it's not linked yet) and other fixes

    • -76
    • +57
    ./file-storage-procs-postgresql.xql
  1. … 3 more files in changeset.
added updating of last_modified time of folders when certain actions are performed within them; i hope the postgresql version works

    • -15
    • +15
    ./file-storage-procs-postgresql.xql
  1. … 18 more files in changeset.
added PG support for new simple objects (not fully tested yet)

    • -0
    • +15
    ./fs-simple-procs-oracle.xql
    • -0
    • +12
    ./fs-simple-procs-postgresql.xql
    • -0
    • +78
    ./fs-simple-procs.tcl
    • -0
    • +29
    ./fs-simple-procs.xql
  1. … 5 more files in changeset.
some code for seeing if files are newer than a certain number of days ago

Added post-instantiation function so APM installs root folder when instance installed.

added delete link

  1. … 2 more files in changeset.
added some useful views and changed a few places to use these new views instead of querying directly from the content repository, there are more places to change still

    • -25
    • +11
    ./file-storage-procs-postgresql.xql
  1. … 2 more files in changeset.
fixing a bad query

    • -20
    • +0
    ./file-storage-procs-postgresql.xql
made a template to be included in other templates that displays the contents of a folder, used in in the index page

    • -0
    • +20
    ./file-storage-procs-postgresql.xql
  1. … 5 more files in changeset.
cleaned up a little more to remove code duplication. added api to get the contents of a folder.

    • -0
    • +30
    ./file-storage-procs-postgresql.xql
  1. … 4 more files in changeset.
fixed some more stuff up (hopefully pgsql version works)

  1. … 4 more files in changeset.