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: 30 Apr
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 21 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Tuesday 24 Jul 2001
9:51 pm

daveb

Datamodel loads in postgresql. Beginning work on Tcl

Options
    • -96
    • +246
    ./static-pages-create.sql
    • -6
    • +11
    ./static-pages-drop.sql
  3. … 1 more file in changeset.
Monday 02 Jul 2001
9:39 pm

rmello

Created the view corresponding to sp_session_id_seq.

Options
    • -1
    • +2
    ./static-pages-create.sql
Sunday 06 May 2001
9:54 pm

domingoa

Now it's close to work

Options
    • -160
    • +186
    ./static-pages-create.sql
    • -2
    • +2
    ./static-pages-drop.sql
    • -12
    • +8
    ./static-pages-sws.sql
  4. … 3 more files in changeset.
5:02 pm

domingoa

Start of postgresql port, if someone else want help fell free to edit this files

Options
    • -0
    • +641
    ./static-pages-create.sql
    • -0
    • +55
    ./static-pages-drop.sql
    • -0
    • +40
    ./static-pages-sws-drop.sql
    • -0
    • +65
    ./static-pages-sws.sql
  5. … 9 more files in changeset.