file-storage-procs-postgresql.xql

  • last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between oracle and postgres codebase

    • -49
    • +0
    ./file-storage-procs-postgresql.xql
  1. … 5 more files in changeset.
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)

    • -43
    • +0
    ./file-storage-procs-postgresql.xql
  1. … 4 more files in changeset.
Reduce divergency between oracle and postgres codebase

  1. … 2 more files in changeset.
Uniform API when deleting folder, drill through some calling levels in stored procedure, use a simpler db_string instead of db_exec_plsql

  1. … 2 more files in changeset.
use fast recursive query instead of slow query bbased on tree_sortkeys

    • -11
    • +8
    ./file-storage-procs-postgresql.xql
merged changes from the oacs-5-9 branch and resolved conflicts

    • -86
    • +5
    ./file-storage-procs-postgresql.xql
  1. … 7834 more files in changeset.
Remove sql duplication, converge oracle and postgres codebase

    • -17
    • +0
    ./file-storage-procs-postgresql.xql
  1. … 3 more files in changeset.
- reduce dependencies on acs_object_party_privilege_map (for PostgreSQL)

  1. … 2 more files in changeset.
.xql-file reform of file-storage

    • -63
    • +0
    ./file-storage-procs-postgresql.xql
  1. … 18 more files in changeset.
Using acs_permission__permission_p for checking persmissions instead of querying view acs_object_party_privilege_map (for PG >= 8.4).

    • -0
    • +43
    ./file-storage-procs-postgresql.xql
  1. … 4 more files in changeset.
1. Merge 2.4.1 to HEAD other than assessment, imsld, lorsm, and views.

2. Bump version numbers to 2.5.0d1.

  1. … 379 more files in changeset.
Fixed error with fs_context_bar_list: argument extra_vars isn't use. Add extra_vars to query.

  1. … 2 more files in changeset.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

    • -0
    • +114
    ./file-storage-procs-postgresql.xql
  1. … 2478 more files in changeset.
Added fs::get_object_pretty_name from patch #722

  1. … 2 more files in changeset.
fixed query for fs::add_file.create_item

partial fix bug 2369

  1. … 2 more files in changeset.
partial fix of bug 2639 -- patch 736

  1. … 5 more files in changeset.
Add support for editing text/* files.

    • -0
    • +106
    ./file-storage-procs-postgresql.xql
  1. … 2 more files in changeset.
added query for fs::notification::get_url

    • -0
    • +17
    ./file-storage-procs-postgresql.xql
  1. … 1 more file in changeset.
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

    • -1
    • +55
    ./file-storage-procs-postgresql.xql
  1. … 2275 more files in changeset.
Adding rss support, turned off and hidden by default.

    • -0
    • +16
    ./file-storage-procs-postgresql.xql
  1. … 31 more files in changeset.
Adding fs_objects.title to select_folder_contents used by syllabus-portlet

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

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.

  1. … 2 more files in changeset.
Call file_storage__delete_folder on folder_delete. Add

Folder notification. Fixes bug#2057.

  1. … 4 more files in changeset.
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

    • -1
    • +20
    ./file-storage-procs-postgresql.xql
  1. … 16 more files in changeset.
Backported notification support for file-storage from HEAD.

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

    • -0
    • +16
    ./file-storage-procs-postgresql.xql
  1. … 19 more files in changeset.
Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

  1. … 25 more files in changeset.
Fixed Bug #1858: qualifying "rename" works in 8i bug chokes in 9i causing

the reported error on installation. Fixed by changing the name to "edit_name"

and implemented it for PG as well (to keep names similar)

  1. … 28 more files in changeset.