OpenACS / openacs-4 / packages / file-storage / tcl

file-storage-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 22
Last Commit: 02 May
Commits this week: 0
Total Lines of Code (LoC): 279
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 31 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 15 Jun 2018
5:11 pm

antoniop

While working on reducing divergencies between oracle and postgres codebase and testing changes I have found the following issues:

- fs::add_created_version.new_text_revision query was defined in postgres only

- version-delete and folder-delete were broken in case notification was enabled,

because this was issued after object was deleted and therefore all references

needed to build notification message were missing (and query failed looking up the object)

Options
    • -43
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 4 more files in changeset.
Tuesday 21 Nov 2017
12:31 pm

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -8
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Friday 03 Nov 2017
4:11 pm

antoniop

Uniform API when deleting folder, drill through some calling levels in stored procedure, use a simpler db_string instead of db_exec_plsql

Options
    • -4
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Friday 15 Sep 2017
10:03 pm

gustafn

use fast recursive query instead of slow query bbased on tree_sortkeys

Options
    • -11
    • +8
    ./file-storage-procs-postgresql.xql
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -86
    • +5
    ./file-storage-procs-postgresql.xql
  2. … 7834 more files in changeset.
Tuesday 02 Apr 2013
2:04 pm

victorg

Using acs_permission__permission_p for checking persmissions instead of querying view acs_object_party_privilege_map (for PG >= 8.4).

Options
    • -0
    • +43
    ./file-storage-procs-postgresql.xql
  2. … 4 more files in changeset.
Monday 10 Nov 2008
12:29 am

donb

1. Merge 2.4.1 to HEAD other than assessment, imsld, lorsm, and views.

2. Bump version numbers to 2.5.0d1.

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 379 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -0
    • +114
    ./file-storage-procs-postgresql.xql
  2. … 2478 more files in changeset.
Thursday 29 Sep 2005
8:51 pm

skaufman

partial fix of bug 2639 -- patch 736

Options
    • -1
    • +2
    ./file-storage-procs-postgresql.xql
  2. … 5 more files in changeset.
Tuesday 01 Mar 2005
11:53 pm

skaufman

added query for fs::notification::get_url

Options
    • -0
    • +17
    ./file-storage-procs-postgresql.xql
  2. … 1 more file in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -1
    • +55
    ./file-storage-procs-postgresql.xql
  2. … 2275 more files in changeset.
Saturday 19 Jun 2004
4:47 pm

tils

Fixing bug '#19 Enable notifications on file upload'. Modified patch #534 to make it actually work on HEAD. Should work for Oracle as well but not tested on that db yet. This could do with some cleanup, and i18n-ization.

Options
    • -0
    • +16
    ./file-storage-procs-postgresql.xql
  2. … 19 more files in changeset.
Wednesday 02 Jun 2004
12:54 am

donb

Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 25 more files in changeset.
Thursday 19 Feb 2004
5:44 pm

daveb

Put fs::new_root_folder tcl procedure back in. It has new optional parameters

but should behave the same as the original procedure.

Options
    • -3
    • +4
    ./file-storage-procs-postgresql.xql
  2. … 4 more files in changeset.
Monday 16 Feb 2004
8:07 pm

daveb

Add message that displays WebDAV accessible URL to folder view.

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 5 more files in changeset.
Sunday 15 Feb 2004
2:41 am

daveb

Give root folders for each package a unique cr_items.name in case multiple

package instances called "File Storage" are mounted. Fixed bug#1332

Options
    • -7
    • +6
    ./file-storage-procs-postgresql.xql
  2. … 10 more files in changeset.
Monday 15 Dec 2003
12:21 pm

daveb

The rest of the UI changes

Options
    • -2
    • +35
    ./file-storage-procs-postgresql.xql
  2. … 10 more files in changeset.
Wednesday 13 Aug 2003
3:30 pm

lars

Timezonized

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 5 more files in changeset.
Saturday 17 May 2003
12:37 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -25
    • +33
    ./file-storage-procs-postgresql.xql
  2. … 64 more files in changeset.
Tuesday 21 Jan 2003
2:10 pm

jeffd

last_modified should be last_modified_ansi

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -4
    • +4
    ./file-storage-procs-postgresql.xql
  2. … 54 more files in changeset.
Monday 18 Nov 2002
6:58 pm

lars

Date/time/number localization

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 85 more files in changeset.
Tuesday 17 Sep 2002
11:03 pm

jeffd

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

Options
    • -1
    • +2
    ./file-storage-procs-postgresql.xql
  2. … 27 more files in changeset.
Friday 26 Jul 2002
3:01 am

arjun

$n_past-days in comment replaced with $ n_past-days

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
Thursday 25 Jul 2002
10:05 pm

rmello

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.

Options
    • -2
    • +6
    ./file-storage-procs-postgresql.xql
Tuesday 23 Jul 2002
3:31 pm

yon

pg fixes

Options
    • -8
    • +6
    ./file-storage-procs-postgresql.xql
  2. … 8 more files in changeset.
Monday 22 Jul 2002
11:48 pm

ben

fixed small pG bug

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
Tuesday 02 Jul 2002
9:40 pm

ben

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

Options
    • -3
    • +3
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Friday 28 Jun 2002
5:12 pm

yon

created a rename_folder method.

Options
    • -0
    • +13
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Monday 24 Jun 2002
9:14 pm

yon

tune folder contents query

Options
    • -17
    • +19
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.