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: 14 Jun
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 07 Apr 2021
9:54 pm

gustafn

stick to content-repository API instead of duplicating code here.

Options
    • -66
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 3 more files in changeset.
Tuesday 06 Apr 2021
9:16 pm

gustafn

new function: ::content::revision::export_to_filesystem

This change moves functionality from file-storage to acs-content-repository.

all application packages should be free of internals, such as the storage

type. Storage_type should be handeled in the content-repository package.

We are not yet done, there is still more to do in this respect in

the file-storage package.

Options
    • -16
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 7 more files in changeset.
Friday 23 Oct 2020
7:03 pm

gustafn

use bind variables instead of tcl variable substition in xql fullqueries

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 16 more files in changeset.
Wednesday 20 Nov 2019
2:18 pm

antoniop

Fix missing query due to naming convention reform by rewriting the entire proc based on a single portable recursive query

Options
    • -20
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Friday 15 Mar 2019
10:58 am

antoniop

Reduce divergency between oracle and postgres codebase

Options
    • -49
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 5 more files in changeset.
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.
Wednesday 24 May 2017
8:49 pm

antoniop

Remove sql duplication, converge oracle and postgres codebase

Options
    • -17
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 3 more files in changeset.
Sunday 03 Jul 2016
8:27 pm

gustafn

- reduce dependencies on acs_object_party_privilege_map (for PostgreSQL)

Options
    • -6
    • +5
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Saturday 02 Jan 2016
9:13 pm

gustafn

.xql-file reform of file-storage

Options
    • -63
    • +0
    ./file-storage-procs-postgresql.xql
  2. … 18 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.
Friday 16 May 2008
2:05 pm

marioa

Fixed error with fs_context_bar_list: argument extra_vars isn't use. Add extra_vars to query.

Options
    • -1
    • +1
    ./file-storage-procs-postgresql.xql
  2. … 2 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.
Saturday 10 Dec 2005
12:55 pm

maltes

Added fs::get_object_pretty_name from patch #722

Options
    • -0
    • +7
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 04 Oct 2005
5:16 pm

skaufman

fixed query for fs::add_file.create_item

Options
    • -1
    • +2
    ./file-storage-procs-postgresql.xql
Friday 30 Sep 2005
8:14 pm

skaufman

partial fix bug 2369

Options
    • -1
    • +2
    ./file-storage-procs-postgresql.xql
  2. … 2 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 16 Aug 2005
1:05 pm

daveb

Add support for editing text/* files.

Options
    • -0
    • +106
    ./file-storage-procs-postgresql.xql
  2. … 2 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.
Monday 13 Dec 2004
5:33 pm

andrewg

Adding rss support, turned off and hidden by default.

Options
    • -0
    • +16
    ./file-storage-procs-postgresql.xql
  2. … 31 more files in changeset.
Wednesday 24 Nov 2004
12:09 am

hramado

Adding fs_objects.title to select_folder_contents used by syllabus-portlet

Options
    • -0
    • +1
    ./file-storage-procs-postgresql.xql
Thursday 30 Sep 2004
12:10 pm

darior

Bux fixing in dotlrn-syllabus portlet, when the professor upload the syllabus the portlet not show it because the select not return the column title

Options
    • -0
    • +1
    ./file-storage-procs-postgresql.xql
Tuesday 07 Sep 2004
10:44 pm

andrewg

Moved fs::publish_versioned_object_to_file_system.select_file_name out to database specific files, to fix a bug downloading archives in Oracle installations. The bug caused the entire contents of content-repository-content-files to get copied into the temp directory, once for each file in the archive. Great for filling up disk drives.

Options
    • -0
    • +8
    ./file-storage-procs-postgresql.xql
  2. … 2 more files in changeset.
Monday 09 Aug 2004
11:48 pm

daveb

Call file_storage__delete_folder on folder_delete. Add

Folder notification. Fixes bug#2057.

Options
    • -0
    • +9
    ./file-storage-procs-postgresql.xql
  2. … 4 more files in changeset.
Tuesday 27 Jul 2004
1:57 am

jvdongen

Moved calls to do_notification from ui-scripts to tcl api

Added delete_file and delete_version procs to tcl api

Added get_parent proc to tcl api

Modified file-add.tcl so that add-version is no longer required

Removed all version-add* files

Modified file.tcl to use file-add instead of version-add

Options
    • -1
    • +20
    ./file-storage-procs-postgresql.xql
  2. … 16 more files in changeset.