OpenACS / openacs-4 / packages / lars-blogger

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 3,411
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 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 05 Mar 2004
10:01 pm

andrewg

The call to rss_gen_subscr.del was failing because it's a function and Oracle requires that we assign it's return value into a variable. So now we have a v_foo variable to accept the value. rss_gen_subscr.del should really be a procedure, not a function, but that's a much bigger fix and we may revamp RSS instead.

Options
    • -2
    • +3
    ./oracle/lars-blogger-package-create.sql
9:58 pm

andrewg

Shorter constraint names to make Oracle happy

Options
    • -3
    • +3
    ./oracle/lars-blogger-create.sql
Friday 27 Feb 2004
7:30 pm

lars

Merged in changes from openacs-5-0-0-final to jcd-merge-pre503

Options
    • -0
    • +132
    ./oracle/upgrade/upgrade-0.8.9-0.9.0.sql
    • -132
    • +0
    ./oracle/upgrade/upgrade-0.8.9-9.0.sql
    • -0
    • +184
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
    • -177
    • +0
    ./postgresql/upgrade/upgrade-0.8.9-9.0.sql
  5. … 15 more files in changeset.
Friday 20 Feb 2004
6:19 am

bdolicki

It may sound insane that I'm *finishing* porting of legacy, obsolete,

blogger-specific categories to Oracle, but because of its brokeness

my new stuff was broken too, so I had to fix it ... oh never mind

Options
    • -1
    • +5
    ./oracle/lars-blogger-package-create.sql
Wednesday 11 Feb 2004
12:02 pm

lars

- Implemented parameters for content length in RSS feed and on blog index/archive pages

- Bumped version number to 1.0.2

- Require acs-tcl version 5.0.1

Options
    • -0
    • +5
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
  2. … 3 more files in changeset.
11:56 am

lars

Renamed upgrade script 1.0a3-1.0a4 to 1.1-2.0d1, so it reflects the actual version upgrade, and so it allows us to bump up the version number on 5.0 branch (no data model script there, though)

Options
    • -138
    • +0
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
    • -0
    • +138
    ./postgresql/upgrade/upgrade-1.1-2.0d1.sql
Wednesday 04 Feb 2004
11:37 am

lars

Fixed bug #1440 and other bugs already fixed in PG version

Options
    • -0
    • +132
    ./oracle/upgrade/upgrade-0.8.9-0.9.0.sql
    • -132
    • +0
    ./oracle/upgrade/upgrade-0.8.9-9.0.sql
11:37 am

lars

file upgrade-0.8.9-0.9.0.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.8.9-0.9.0.sql
10:44 am

lars

Fixed bug #1465: The upgrade script mistakenly put in a funtion name for the name_method for weblogger_channels, but the function itself didn't exist; the create-script didn't have this.

Options
    • -10
    • +12
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
Tuesday 03 Feb 2004
7:56 pm

lars

Fixing misnamed upgrade script (0.8.9-9.0 -> 0.8.9-0.9.0)

Options
    • -0
    • +177
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
    • -177
    • +0
    ./postgresql/upgrade/upgrade-0.8.9-9.0.sql
7:56 pm

lars

file upgrade-0.8.9-0.9.0.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
Tuesday 06 Jan 2004
5:15 am

vinodk

Upgrade script for changes which allow package uninstantiation

Options
    • -95
    • +2
    ./oracle/upgrade/upgrade-1.0a3-1.0a4.sql
    • -70
    • +2
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
Sunday 14 Dec 2003
5:41 pm

lars

Weird character in file

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
5:25 pm

gyang

Technorati and Blogroll support for lars-blogger

Options
    • -1
    • +13
    ./postgresql/lars-blogger-create.sql
    • -1
    • +2
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  4. … 5 more files in changeset.
2:02 pm

gyang

Blogroll feature for lars-blogger. The patch includes datamodel

and admin UI pages for adding items to the blogroll, as well as an

includelet to display the blogroll. The includelet has been added

to the blogger front page.

Options
    • -0
    • +105
    ./postgresql/lars-blogger-blogroll-create.sql
    • -0
    • +11
    ./postgresql/lars-blogger-blogroll-drop.sql
    • -1
    • +2
    ./postgresql/lars-blogger-create.sql
    • -1
    • +4
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +100
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  6. … 15 more files in changeset.
1:32 pm

lars

Recreate pinds_blog_entry.new to not insert into obsolete posted_date column

Options
    • -3
    • +1
    ./oracle/lars-blogger-package-create.sql
    • -0
    • +95
    ./oracle/upgrade/upgrade-1.0a3-1.0a4.sql
    • -3
    • +1
    ./postgresql/lars-blogger-pb.sql
    • -0
    • +70
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
12:10 pm

lars

Merged posted_date and entry_date into entry_date, which is now a full timestamp

Options
    • -2
    • +14
    ./oracle/lars-blogger-create.sql
    • -0
    • +22
    ./oracle/upgrade/upgrade-1.0a3-1.0a4.sql
    • -2
    • +1
    ./postgresql/lars-blogger-create.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  5. … 31 more files in changeset.
Saturday 13 Dec 2003
9:02 pm

gyang

Multiple ping URLs in lars-blogger. Currently lars-blogger can only

ping one server (typically weblogs.com) when an entry is posted. With

this change there is an admin user interface to add multiple ping URLs,

just like Movable Type, which will each be pinged when the blog is

updated.

Options
    • -1
    • +16
    ./postgresql/lars-blogger-create.sql
    • -1
    • +2
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  3. … 6 more files in changeset.
7:03 pm

gyang

Upgrade script for lars-blogger from 1.0a3 to 1.0a4

Options
    • -0
    • +14
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -2
    • +2
    ./postgresql/lars-blogger-categories-pb.sql
    • -0
    • +14
    ./postgresql/upgrade/upgrade-1.0a2-1.0a3.sql
  3. … 597 more files in changeset.
Monday 08 Dec 2003
6:15 am

vinodk

Allow package uninstantiation

Options
    • -7
    • +1
    ./oracle/lars-blogger-drop.sql
    • -1
    • +11
    ./oracle/lars-blogger-package-create.sql
  3. … 4 more files in changeset.
6:10 am

vinodk

allow package to be dropped cleanly

split out pl from ddl

Options
    • -1
    • +1
    ./oracle/notifications-drop.sql
    • -1
    • +5
    ./oracle/rss-unregister.sql
    • -72
    • +2
    ./postgresql/lars-blogger-categories-create.sql
    • -0
    • +79
    ./postgresql/lars-blogger-categories-pb.sql
    • -152
    • +2
    ./postgresql/lars-blogger-create.sql
    • -20
    • +12
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +174
    ./postgresql/lars-blogger-pb.sql
    • -1
    • +1
    ./postgresql/notifications-drop.sql
    • -1
    • +20
    ./postgresql/rss-unregister.sql
Wednesday 26 Nov 2003
2:34 pm

jeffd

fix the category __name method, bump version to 1.0a3, and provide upgrade script

Options
    • -2
    • +2
    ./postgresql/lars-blogger-categories-create.sql
    • -0
    • +14
    ./postgresql/upgrade/upgrade-1.0a2-1.0a3.sql
  3. … 1 more file in changeset.
2:34 pm

jeffd

file upgrade-1.0a2-1.0a3.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.0a2-1.0a3.sql
Friday 31 Oct 2003
3:12 pm

lars

Fixed install on Oracle: Ordering of category package and pinds_blog_entries table was reversed

Options
    • -94
    • +1
    ./oracle/lars-blogger-categories-create.sql
    • -1
    • +100
    ./oracle/lars-blogger-package-create.sql
Friday 24 Oct 2003
6:59 pm

lars

Renamed upgrade-0.8.5-9.0 to upgrade-0.8.9-9.0

Options
    • -132
    • +0
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +132
    ./oracle/upgrade/upgrade-0.8.9-9.0.sql
    • -177
    • +0
    ./postgresql/upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +177
    ./postgresql/upgrade/upgrade-0.8.9-9.0.sql
Friday 17 Oct 2003
2:39 am

lars

Added categories support in Oracle, changed 0 for no category to null

Options
    • -0
    • +134
    ./oracle/lars-blogger-categories-create.sql
    • -0
    • +12
    ./oracle/lars-blogger-categories-drop.sql
    • -1
    • +6
    ./oracle/lars-blogger-create.sql
    • -1
    • +3
    ./oracle/lars-blogger-drop.sql
    • -0
    • +138
    ./oracle/upgrade/upgrade-0.9.3-1.0d1.sql
    • -5
    • +5
    ./postgresql/lars-blogger-categories-create.sql
    • -2
    • +4
    ./postgresql/lars-blogger-create.sql
    • -4
    • +99
    ./postgresql/upgrade/upgrade-0.9.3-1.0d1.sql
  9. … 9 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +204
    ./oracle/upgrade/upgrade-1.0d1-1.0d2.sql
  2. … 23 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -3
    • +3
    ./oracle/lars-blogger-drop.sql
    • -11
    • +11
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +1
    ./oracle/notifications-drop.sql
    • -0
    • +1
    ./oracle/notifications-init.sql
    • -1
    • +2
    ./oracle/rss-register.sql
    • -2
    • +2
    ./oracle/rss-unregister.sql
  7. … 270 more files in changeset.
Monday 29 Sep 2003
10:05 am

steffenc

Added support for categories

Options
    • -0
    • +106
    ./postgresql/lars-blogger-categories-create.sql
    • -0
    • +12
    ./postgresql/lars-blogger-categories-drop.sql
    • -7
    • +14
    ./postgresql/lars-blogger-create.sql
    • -1
    • +3
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +85
    ./postgresql/upgrade/upgrade-0.9.3-1.0d1.sql
  6. … 25 more files in changeset.