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 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 21 Mar 2003
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.
2:51 am

vinodk

- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

Options
    • -0
    • +720
    ./upgrade/upgrade-4.2-4.6.sql
  2. … 30 more files in changeset.
Friday 20 Sep 2002
11:34 pm

jeffd

typo in fs_simple_object__name and comment for outstanding bug

Options
    • -2
    • +2
    ./file-storage-simple-package-create.sql
  2. … 1 more file in changeset.
Wednesday 18 Sep 2002
8:03 am

jeffd

selects change to perform patch 425 Deds Castillo

Options
    • -3
    • +3
    ./file-storage-package-create.sql
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
    • -3
    • +19
    ./file-storage-package-create.sql
    • -2
    • +2
    ./file-storage-simple-package-create.sql
    • -8
    • +8
    ./file-storage-views-create.sql
  4. … 25 more files in changeset.
Tuesday 13 Aug 2002
10:03 pm

arjun

added missing perform. fix thanks to Hamilton Chua

Options
    • -2
    • +2
    ./file-storage-simple-package-create.sql
Tuesday 06 Aug 2002
2:41 am

donb

file_storage__get_package_id was looking through the item's children rather

than parents in its attempt to find the root folder associated with the item.

Someone else commited a fix that wasn't complete as it wouldn't work for items

in nested subfolders. Perhaps today's scripts would work but a general fix

seems better.

Options
    • -8
    • +7
    ./file-storage-package-create.sql
Sunday 04 Aug 2002
5:33 pm

yon

fixed file_storage__get_package_id

Options
    • -9
    • +10
    ./file-storage-package-create.sql
Monday 29 Jul 2002
5:53 am

chak

fixed a bunch of queries that were select

s instead of perform.. file uploading works on pg now

Options
    • -339
    • +337
    ./file-storage-package-create.sql
  2. … 5 more files in changeset.
Saturday 20 Jul 2002
1:17 am

donb

Added stuff to form processing including the new form builder type

"file" which is a bit cleaner than the widget-only kludge which existed

before.

Options
    • -4
    • +35
    ./file-storage-package-create.sql
  2. … 11 more files in changeset.
Wednesday 17 Jul 2002
10:09 pm

yon

fixed name method for fs_simple_objects

Options
    • -2
    • +2
    ./file-storage-simple-create.sql
    • -11
    • +17
    ./file-storage-simple-package-create.sql
  3. … 2 more files in changeset.
Thursday 30 May 2002
1:02 am

arjun

copy methods and some procs for simple

Options
    • -1
    • +58
    ./file-storage-simple-package-create.sql
  2. … 6 more files in changeset.
Saturday 25 May 2002
4:27 pm

yon

changed from using content_item.update_last_modified to acs_object.update_last_modified

Options
    • -5
    • +5
    ./file-storage-package-create.sql
    • -1
    • +3
    ./file-storage-simple-package-create.sql
  3. … 2 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.
Friday 12 Apr 2002
8:15 pm

jong

took out create or replace for PG 7.1 compatibility

Options
    • -2
    • +3
    ./file-storage-views-create.sql
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
    • -722
    • +7
    ./file-storage-create.sql
    • -8
    • +4
    ./file-storage-drop.sql
    • -0
    • +686
    ./file-storage-package-create.sql
    • -1
    • +1
    ./file-storage-sc-create.sql
    • -1
    • +1
    ./file-storage-sc-drop.sql
    • -8
    • +1
    ./file-storage-simple-create.sql
    • -4
    • +1
    ./file-storage-simple-package-create.sql
    • -0
    • +98
    ./file-storage-views-create.sql
    • -0
    • +12
    ./file-storage-views-drop.sql
  10. … 12 more files in changeset.
Tuesday 02 Apr 2002
9:00 am

ben

added PG support for new simple objects (not fully tested yet)

Options
    • -0
    • +71
    ./file-storage-simple-create.sql
    • -0
    • +121
    ./file-storage-simple-package-create.sql
  3. … 8 more files in changeset.