OpenACS / openacs-4 / packages / file-storage / sql / oracle

file-storage-views-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 25 Dec
Commits this week: 0
Total Lines of Code (LoC): 103
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./file-storage-views-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -6
    • +3
    ./file-storage-views-create.sql
  2. … 8099 more files in changeset.
Friday 15 Mar 2019
10:36 am

antoniop

Align fs_objects view definition in Oracle with the one in Postgres

Options
    • -6
    • +3
    ./file-storage-views-create.sql
  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
    • -2
    • +3
    ./file-storage-views-create.sql
  2. … 2478 more files in changeset.
Wednesday 12 Jul 2006
2:58 am

donb

Made fs_objects count folder items the same was fs_folders does.

Options
    • -2
    • +2
    ./file-storage-views-create.sql
  2. … 4 more files in changeset.
Friday 07 Jul 2006
1:35 am

maltes

Added view support for Symlinks. This works in a hardlink fashion at the moment and is not tested on Oracle, though I doubt it will fail.

Options
    • -2
    • +3
    ./file-storage-views-create.sql
  2. … 5 more files in changeset.
Sunday 19 Mar 2006
10:10 pm

emmar

Set cr_items.name as fs_objects.name instead of cr_revisions.filename

Options
    • -2
    • +2
    ./file-storage-views-create.sql
  2. … 1 more file in changeset.
Thursday 25 Aug 2005
8:40 pm

maltes

Fixed the counting. Special treatment for oracle not using the "in" statement. PLEASE TEST IT SOMEONE!!!

Options
    • -2
    • +2
    ./file-storage-views-create.sql
Thursday 26 May 2005
10:28 am

maltes

Added callbacks for integration with PM. Made sure the package_id is set correctly

Options
    • -1
    • +1
    ./file-storage-views-create.sql
  2. … 61 more files 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
    • -4
    • +10
    ./file-storage-views-create.sql
  2. … 2275 more files in changeset.
Friday 03 Sep 2004
5:58 pm

tracya

filestorage was displying the ugly filename instead of the pretty title for the main entry; also wasn't updating the filename to the newest upload (still need to ask DaveB about getting the links to work with the latest upload filename

Options
    • -2
    • +2
    ./file-storage-views-create.sql
  2. … 7 more files in changeset.
Wednesday 01 Sep 2004
9:46 pm

tracya

showing date of latest file change for folders

Options
    • -2
    • +6
    ./file-storage-views-create.sql
  2. … 2 more files in changeset.
Monday 23 Aug 2004
7:30 pm

tracya

listing of files listed first revision date instead of last revision date - also fixed upgrade script

Options
    • -3
    • +5
    ./file-storage-views-create.sql
  2. … 1 more file in changeset.
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -4
    • +5
    ./file-storage-views-create.sql
  2. … 687 more files in changeset.
Wednesday 23 Jun 2004
2:56 am

daveb

Patch#538. Use filename instead of title for link text.

Options
    • -2
    • +3
    ./file-storage-views-create.sql
  2. … 7 more files in changeset.
Tuesday 25 May 2004
8:54 pm

tracya

fixing broken view, file storage broken

Options
    • -2
    • +2
    ./file-storage-views-create.sql
7:39 pm

donb

Fixed bug 1853: missing comma in fs_objects view declaration committed to

HEAD got merged to 5.1 ...

Options
    • -2
    • +2
    ./file-storage-views-create.sql
  2. … 3 more files in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -4
    • +6
    ./file-storage-views-create.sql
  2. … 834 more files in changeset.
Sunday 16 May 2004
6:53 pm

daveb

Show title on folder listing. If filename is different than title, show that as well. Show cr_mime_types.label mime type description instead of techincal mime type "code".

Options
    • -4
    • +6
    ./file-storage-views-create.sql
  2. … 6 more files in changeset.
Saturday 17 May 2003
12:37 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -48
    • +45
    ./file-storage-views-create.sql
  2. … 64 more files in changeset.
Thursday 27 Mar 2003
1:48 pm

lars

Make fs_objects return the content_length for files

Options
    • -2
    • +2
    ./file-storage-views-create.sql
  2. … 1 more file in changeset.
Thursday 20 Mar 2003
11:09 pm

donb

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.

Options
    • -56
    • +45
    ./file-storage-views-create.sql
  2. … 46 more files in changeset.
Monday 17 Feb 2003
9:31 pm

donb

First whack at speeding up (though not rationalizing, unfortunately) file

storage for PostgreSQL. Also fixes the fs_files view.

Options
    • -1
    • +6
    ./file-storage-views-create.sql
  2. … 10 more files in changeset.
Wednesday 11 Dec 2002
2:27 pm

peterm

I18N: Names of folders in dotLRN (Assignments, Handouts etc.) can be message keys now so needed to invoke the localize procedure on the folder names in the file-storage UI

Options
    • -4
    • +1
    ./file-storage-views-create.sql
  2. … 2 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
    • -9
    • +14
    ./file-storage-views-create.sql
  2. … 27 more files in changeset.
Wednesday 22 May 2002
10:50 am

yon

added support for publishing fs_objects to the file system; also added some archiving infrastructure stuff

Options
    • -3
    • +3
    ./file-storage-views-create.sql
  2. … 14 more files in changeset.
Tuesday 21 May 2002
4:51 pm

yon

adding key (cr_items.name) to file-storage views

Options
    • -3
    • +8
    ./file-storage-views-create.sql
  2. … 1 more file in changeset.
Thursday 18 Apr 2002
8:09 pm

yon

removed the urls from these views, they don't belong here

Options
    • -9
    • +3
    ./file-storage-views-create.sql
  2. … 1 more file in changeset.
Thursday 04 Apr 2002
5:01 am

yon

added updating of last_modified time of folders when certain actions are performed within them; i hope the postgresql version works

Options
    • -0
    • +98
    ./file-storage-views-create.sql
  2. … 20 more files in changeset.