OpenACS / openacs-4 / packages / static-pages / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 21 Nov
Commits this week: 0
Total Lines of Code (LoC): 2,005
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 10 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 25 Mar 2004
11:52 am

jeffd

make static pages work with tip 43; bump to 5.2.0d2, upgrade oracle, postgres

Options
    • -31
    • +44
    ./static-page-pb.sql
    • -0
    • +180
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  3. … 6 more files in changeset.
Tuesday 14 Oct 2003
9:06 pm

daveb

Fixed relative path, removed extra single quotes not needed outside plpgsql

function.

Options
    • -6
    • +6
    ./upgrade/upgrade-4.2a-4.3.sql
Saturday 17 May 2003
2:25 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -3
    • +3
    ./static-page-pb.sql
  2. … 18 more files in changeset.
Sunday 02 Mar 2003
11:52 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
    ./static-page-pb.sql
  2. … 14 more files in changeset.
Thursday 16 Jan 2003
2:58 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -0
    • +602
    ./static-page-pb.sql
    • -585
    • +2
    ./static-pages-create.sql
    • -0
    • +26
    ./upgrade/upgrade-4.2a-4.3.sql
  4. … 32 more files in changeset.
Monday 16 Dec 2002
4:22 am

andrewp

Now correctly sets mime type using sp_maybe_create_new_mime_type,

rather than always using text/html.

Options
    • -3
    • +7
    ./static-page-pb.sql
  2. … 6 more files in changeset.
12:25 am

andrewp

Upgrade script now properly converts existing filenames from page to

server root relative, for both Oracle and Postgres.

Options
    • -1
    • +8
    ./upgrade/upgrade-4.2a-4.3.sql
  2. … 1 more file in changeset.
Thursday 12 Dec 2002
11:01 pm

andrewp

- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

Options
    • -1
    • +5
    ./upgrade/upgrade-4.2a-4.3.sql
  2. … 6 more files in changeset.
9:02 pm

andrewp

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

Options
    • -0
    • +0
    ./upgrade/upgrade-4.2a-4.3.sql
  2. … 1 more file in changeset.
9:02 pm

andrewp

- Name of root folder is now unique in the CR even if have multiple

package instances, for both Oracle and Postgres.

- All Postgres functions now defined with "create or replace".

Options
    • -15
    • +24
    ./static-page-pb.sql
    • -0
    • +15
    ./upgrade/upgrade-4.2a-4.3.sql
  3. … 2 more files in changeset.
8:48 pm

andrewp

Moved Postgres functions and bodies out of static-pages-create.sql

into separate files (just like for Oracle) - necessary to more cleanly

support upgrade files. No other changes.

Options
    • -0
    • +589
    ./static-page-pb.sql
    • -585
    • +2
    ./static-pages-create.sql
8:48 pm

andrewp

file static-page-pb.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./static-page-pb.sql
Friday 14 Dec 2001
11:45 pm

daveb

Added sp_folder_get_tree_sortkey function to the drop script

Options
    • -1
    • +2
    ./static-pages-drop.sql
Sunday 09 Dec 2001
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -1
    • +8
    ./static-pages-create.sql
  2. … 18 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -77
    • +56
    ./static-pages-create.sql
  2. … 62 more files in changeset.
Monday 03 Dec 2001
8:17 pm

daveb

Removing unused static-pages-sws files from sql/postgresql

Options
    • -2
    • +2
    ./static-pages-drop.sql
    • -40
    • +0
    ./static-pages-sws-drop.sql
    • -61
    • +0
    ./static-pages-sws.sql
5:58 pm

daveb

Fixed file update error in postgreql. It adds an mtime column, update your

datamodel on PG. Code checks for storage_type to run the correct queries/code

for Oracle/PG.

Options
    • -7
    • +19
    ./static-pages-create.sql
  2. … 4 more files in changeset.
1:32 am

donb

Removed some misnamed files from file-storage and removed a garbage file

from static-pages.

Options
    • -846
    • +0
    ./#static-pages-create.sql#
  2. … 6 more files in changeset.
Wednesday 31 Oct 2001
6:47 pm

daveb

fixed static_page__delete

Options
    • -4
    • +2
    ./static-pages-create.sql
6:15 pm

daveb

More fixes to static_page__grant/revoke permission and static-pagses-procs-postgresql.xql

Options
    • -5
    • +5
    ./static-pages-create.sql
  2. … 4 more files in changeset.
Tuesday 30 Oct 2001
10:53 pm

daveb

Fixed commentability on nested folders

Options
    • -2
    • +2
    ./static-pages-create.sql
9:59 pm

daveb

more adds

Options
    • -0
    • +846
    ./#static-pages-create.sql#
    • -0
    • +25
    ./static-pages-sc-create.sql
    • -0
    • +7
    ./static-pages-sc-drop.sql
Friday 26 Oct 2001
9:26 pm

daveb

Fixed more bugs in static-pages-create. Drop script now works.

Options
    • -8
    • +6
    ./static-pages-create.sql
5:31 am

daveb

Fixed static_page content type and static_page__new

Options
    • -2
    • +2
    ./static-pages-create.sql
Wednesday 24 Oct 2001
3:10 am

daveb

*** empty log message ***

Options
    • -2
    • +7
    ./static-pages-create.sql
    • -6
    • +13
    ./static-pages-drop.sql
Tuesday 23 Oct 2001
8:53 pm

daveb

Fixed static folders. Now stores file path relative to installation root and uses cr_fs_path to get the full file path.

Options
    • -67
    • +92
    ./static-pages-create.sql
  2. … 4 more files in changeset.
Friday 19 Oct 2001
4:11 am

donb

*** empty log message ***

Options
    • -2
    • +2
    ./static-pages-create.sql
  2. … 7 more files in changeset.
Tuesday 04 Sep 2001
7:04 pm

daveb

Fixed info file for postgresql and fixed Oracle version

Options
    • -3
    • +3
    ./static-pages-create.sql
  2. … 8 more files in changeset.
Saturday 04 Aug 2001
4:58 am

daveb

Postgresql ported - still needs modifications to work with static-pages. Oracle not tested and probably broken

Options
    • -12
    • +12
    ./static-pages-create.sql
  2. … 6 more files in changeset.
Friday 27 Jul 2001
5:56 pm

daveb

Fixed seq/sequence in static-pages-create.sql

Options
    • -3
    • +3
    ./static-pages-create.sql