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

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 28
Last Commit: 22 Oct
Commits this week: 0
Total Lines of Code (LoC): 5,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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 15 Nov 2003
7:47 pm

daveb

Removing unused file-add-2.

Simplified upgrade to swap name and title.

Added upgrade for oracle and fixed oracle functions.

Options
    • -8
    • +6
    ./file-storage-package-create.sql
    • -9
    • +644
    ./upgrade/upgrade-4.6.3-4.8.sql
  3. … 7 more files in changeset.
7:31 pm

daveb

Complete upgrade script.

Options
    • -0
    • +135
    ./upgrade/upgrade-4.6.3-4.8.sql
7:31 pm

daveb

file upgrade-4.6.3-4.8.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.3-4.8.sql
7:17 pm

daveb

Clean up postgresql functions so name refers to name and title refers to title.

Move everything into one upgrade script.

Options
    • -29
    • +29
    ./file-storage-package-create.sql
    • -253
    • +0
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  3. … 5 more files in changeset.
Sunday 09 Nov 2003
4:36 am

daveb

Moved root folder creation to apm after-mount callback. Added UI to

dav enable a file-storage instance. Converted file-add to ad_form and

cr_import_content. fix.sql includes fixes to bugs in acs-kernel and

acs-content-repository. Added update_last_modfiied for the content_item

when a new revision is uploaded so that last modified is displayed

correctly.

Options
    • -8
    • +10
    ./file-storage-package-create.sql
  2. … 11 more files in changeset.
Thursday 16 Oct 2003
7:31 pm

marka

corrected the number of operatives to file_move

Options
    • -2
    • +4
    ./file-storage-package-create.sql
Tuesday 14 Oct 2003
8:41 pm

daveb

Drop and recreate fs_folders view to get rid of fs-simple.

Options
    • -0
    • +22
    ./upgrade/upgrade-4.6.1-4.6.2.sql
Tuesday 30 Sep 2003
2:14 pm

peterm

upgrade file fix: using create or replace function instead of create function

Options
    • -4
    • +4
    ./upgrade/upgrade-4.6.2-4.6.3.sql
Thursday 25 Sep 2003
2:30 pm

lars

Fixed bugs #423: download w/url, #753: publish_url problem, and #427: root folder name wrong

Options
    • -2
    • +2
    ./file-storage-package-create.sql
  2. … 1 more file in changeset.
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -5
    • +7
    ./file-storage-package-create.sql
    • -0
    • +253
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  3. … 815 more files in changeset.
Monday 07 Jul 2003
4:22 pm

olah

Forgot to noquote title and context bar.

Options
    • -3
    • +3
    ./file-storage-create.sql
2:37 pm

olah

1. Added support for retrieval of live revision of files by their URL (a.k.a. virtual URLs).

This will make relative linking of images and sub-documents in HTML documents work.

As a small bonus, HTML and text documents will be templated, but only if they

are being stored in the db. Files stored in the file system look like before ...

2. Provided upgrade scripts for file-storage and the CR.

Options
    • -1
    • +34
    ./file-storage-create.sql
    • -1
    • +8
    ./file-storage-drop.sql
    • -0
    • +36
    ./upgrade/upgrade-4.6.2-4.7d3.sql
  4. … 12 more files in changeset.
Monday 23 Jun 2003
8:47 pm

janines

add user id and IP address to update_last_modified()

Options
    • -5
    • +7
    ./file-storage-package-create.sql
    • -0
    • +253
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  3. … 9 more files in changeset.
8:47 pm

janines

file upgrade-4.6.2-4.6.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  2. … 1 more file in changeset.
Saturday 17 May 2003
12:37 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +38
    ./file-storage-package-create.sql
    • -64
    • +0
    ./file-storage-simple-create.sql
    • -183
    • +0
    ./file-storage-simple-package-create.sql
    • -49
    • +43
    ./file-storage-views-create.sql
    • -0
    • +66
    ./upgrade/upgrade-4.6-4.6.1.sql
    • -0
    • +188
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  7. … 59 more files in changeset.
Friday 28 Mar 2003
9:56 am

lars

Forgot to fix the upgrade scripts when I fixed the 0 content size typo yesterday. I wonder if we should write new upgrade scripts

Options
    • -1
    • +1
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  2. … 1 more file 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.
Friday 21 Mar 2003
3:49 pm

donb

Fixed typo in PG upgrade script ("can''t" vs. "can't") and added symlinks

as registered content types to folders in order to ease further extension

of the semantics of file-storage.

Options
    • -3
    • +14
    ./file-storage-package-create.sql
    • -1
    • +4
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  3. … 2 more files in changeset.
3:55 am

donb

1. One fix to track APM changes made by Peter, in acs-subsite

2. changed attachments to use cr_extlinks

3. Fixed a couple of problems with my prior commit to file-storage that

removed fs_urls.

Options
    • -2
    • +16
    ./file-storage-package-create.sql
    • -4
    • +85
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  3. … 2 more files in changeset.
Thursday 20 Mar 2003
11:13 pm

donb

file upgrade-4.6.1-4.6.2.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  2. … 1 more file in changeset.
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
    • -1
    • +12
    ./file-storage-package-create.sql
    • -64
    • +0
    ./file-storage-simple-create.sql
    • -183
    • +0
    ./file-storage-simple-package-create.sql
    • -52
    • +43
    ./file-storage-views-create.sql
    • -0
    • +104
    ./upgrade/upgrade-4.6.1-4.6.2.sql
  6. … 42 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -3
    • +3
    ./file-storage-simple-package-create.sql
  2. … 39 more files in changeset.
Tuesday 18 Feb 2003
5:56 pm

donb

Inserted modified views from 4.6.1 ...

Options
    • -10
    • +11
    ./file-storage-views-create.sql
2:43 am

donb

1. Got rid of the "create or replace function" decls used for triggers, due

to the brand-new PG 7.3 "opaque" vs. "trigger" issue.

2. Added a new "fs::get_folder_object_ids" for use when you just need the

object ids rather than a bunch of (slow) permissions information,

(slow) counts of items in folders and subfolders, last modified info,

etc. dotLRN was calling "fs::get_folder_contents" when cloning folders

despite making use of only the object_id and that proc used to be unimaginably

slow. It's faster now due to the new permissions code but it's still slow

enough to warrant avoiding it when possible.

3. Fixed typo in my last commit.

Options
    • -3
    • +3
    ./file-storage-views-create.sql
  2. … 4 more files in changeset.
Monday 17 Feb 2003
9:32 pm

donb

file upgrade-4.6-4.6.1.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6-4.6.1.sql
9:31 pm

donb

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

storage for PostgreSQL. Also fixes the fs_files view.

Options
    • -10
    • +14
    ./file-storage-views-create.sql
    • -0
    • +66
    ./upgrade/upgrade-4.6-4.6.1.sql
  3. … 9 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -3
    • +3
    ./file-storage-simple-package-create.sql
  2. … 54 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -3
    • +3
    ./file-storage-simple-package-create.sql
  2. … 54 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -0
    • +720
    ./upgrade/upgrade-4.2-4.6.sql
  2. … 103 more files in changeset.
Tuesday 29 Oct 2002
2:52 am

vinodk

file upgrade-4.2-4.6.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.2-4.6.sql
  2. … 1 more file in changeset.