OpenACS / openacs-4 / packages / lars-blogger / tcl

entry-procs-oracle.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 110
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 08 Mar 2004
7:04 pm

andrewg

Added a missing column.

Options
    • -0
    • +1
    ./entry-procs-oracle.xql
Friday 27 Feb 2004
7:30 pm

lars

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

Options
    • -0
    • +1
    ./entry-procs-oracle.xql
  2. … 18 more files in changeset.
Friday 20 Feb 2004
6:43 am

bdolicki

Commiting integration of Site Wide Categories into Weblogger. While

implementing this I've also fixed numerous random bugs.

Some comments off the top of my head regarding this implementation:

* Weblogger currently doesn't take advantage of nested categories. You

can use trees that are nested but categories in those trees are

treated as if they were all flat.

* I've provided a migration script from old to new categories. The

script just copies data and doesn't delete anything. It is written

in Tcl so that it can take advantage of the APIs.

* I left the legacy categories in system. There are several reasons

for that:

- Site-Wide categories don't have short names and thus speaking

URLs are not implemented. Some people might prefer to keep

speaking URLs, especially if they don't want to break them

after migration

- Blogger-specific categories are simpler and thus easier to use.

- Having both solutions available for a while makes transition less

painful.

* I had lots of problems with Oracle port. At first I thought just

that it is slightly instable because we are working on HEAD and

categories are in flux... Only after having fixed a lot of bugs I

realized that LEGACY CATEGOIRIES NEVER WORKED IN ORACLE. At that

point it was easier to make them actually work in oracle :-)

* Actually it seems that the whole Weblogger never worked in Oracle, I

was fixing bugs such as broken filtering by date (because Oracle's

trunc() uses different format strings from PostgreSQL's date_trunc()

etc. etc.

* Juggling pieces of Tcl from .tcl to .xql (via variable and command

substitution) and pieces of SQL from .xql to .tcl (via db_map) was

fun :-)

* Implementing nested multirows (to show all categories one object is

in), in combination with included templates thought me a lot about

the templating system. One of the lessons: <multirow name="@foo@">

with variable could actually work if a bunch of bugs with variable

substitution were fixed in templating system. Until then using:

template::multirow -local -ulevel 1 upvar $foo myfoo will be

necessary.

* Some extensions for db_multirow, <multiple> and friends to support

grouping and tables-within-tables would be really useful. I didn't

dare do such large-scale hacks on db_multirow

* one-entry{tcl,adp} should be replaced with blog{tcl,adp} - after all

getting one entry is just a special case of getting many entries.

Options
    • -0
    • +1
    ./entry-procs-oracle.xql
  2. … 15 more files in changeset.
Thursday 05 Feb 2004
6:46 pm

lars

Committed lots of fixes from Joel

Options
    • -0
    • +2
    ./entry-procs-oracle.xql
  2. … 11 more files in changeset.
Thursday 08 Jan 2004
10:08 am

lars

Fixed bug #1362: Blog entries loose their time when editing

Options
    • -0
    • +14
    ./entry-procs-oracle.xql
  2. … 4 more files in changeset.
Sunday 14 Dec 2003
12:10 pm

lars

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

Options
    • -10
    • +5
    ./entry-procs-oracle.xql
  2. … 34 more files in changeset.
Saturday 13 Dec 2003
6:13 pm

lars

Get category info with an outer join instead of a separate query

Options
    • -2
    • +6
    ./entry-procs-oracle.xql
  2. … 3 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

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

Options
    • -0
    • +19
    ./entry-procs-oracle.xql
  2. … 598 more files in changeset.
Monday 08 Dec 2003
5:47 am

vinodk

Fix bug 1275 patch 375

Options
    • -0
    • +1
    ./entry-procs-oracle.xql
  2. … 1 more file in changeset.
Monday 24 Nov 2003
2:32 pm

lars

Fixed bug: Request error when posting entry -- was bad Oracle query in the RSS datasource. While fixing, I wrote test cases to expose it, and while doing that I had to invent and restructure lots of API.

- Removed pages under /admin which are now under www

Options
    • -0
    • +19
    ./entry-procs-oracle.xql
  2. … 34 more files in changeset.
Friday 17 Oct 2003
2:39 am

lars

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

Options
    • -7
    • +10
    ./entry-procs-oracle.xql
  2. … 16 more files in changeset.
Wednesday 01 Oct 2003
9:12 pm

daveb

Completed trackback support. Added trackback parameters and explanation of what trackback is. It's turned on by default.

Finished trackback support. Added support for templated comments to include notice of which comments are trackback.

Options
    • -0
    • +27
    ./entry-procs-oracle.xql
  2. … 5 more files 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
    • -18
    • +29
    ./entry-procs-oracle.xql
  2. … 816 more files in changeset.
Tuesday 01 Jul 2003
3:28 pm

simonc

fixed an embarrassing amount of bugs, now let us have fun! :)

Options
    • -0
    • +11
    ./entry-procs-oracle.xql
  2. … 34 more files in changeset.
Monday 12 May 2003
12:50 am

lars

Fixed notifications to include title_url

Options
    • -1
    • +1
    ./entry-procs-oracle.xql
  2. … 4 more files in changeset.
Thursday 13 Mar 2003
6:03 pm

lars

- Applied Joel Aufrect's patch to add title_url (with modifications)

- fixed bug #336 by adding a catch

- showing minimum 3 last postings

Options
    • -0
    • +1
    ./entry-procs-oracle.xql
  2. … 29 more files in changeset.
3:24 pm

lars

Merged over changes from HEAD

Options
    • -0
    • +1
    ./entry-procs-oracle.xql
  2. … 37 more files in changeset.
Sunday 02 Feb 2003
1:01 am

jeffd

fix postgresisms bug 200 and bug 201

Options
    • -18
    • +16
    ./entry-procs-oracle.xql
  2. … 1 more file in changeset.
Monday 27 Jan 2003
5:17 pm

lars

- Upgraded lars-blogger to use the new richtext widget;

- fixed several bugs in the Oracle version

Options
    • -0
    • +33
    ./entry-procs-oracle.xql
  2. … 20 more files in changeset.