cal-item-procs-oracle.xql

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
calendar reform (part 2):

- make "forgotten" fields "related_link_url", "related_link_text",

"redirect_to_rel_link_p" of acs-events usable from the calendar.

- add web interface for "location" field as well

- bump version to 2.10.0d4

  1. … 14 more files in changeset.
calendar reform:

2.10.0d1: add table cal_uids and upsert operation for it

Add table cal_uids for CalDAV handling p o

New Function: cal_uid__upsert() p o

calendar::item::edit.cal_uid_upsert p o

calendar::item::new.insert_cal_uid p o

calendar.info

sql/oracle/cal-item-create.sql

sql/oracle/upgrade/upgrade-2.10.0d0-2.10.0d1.sql

sql/postgresql/cal-item-create.sql

sql/postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql

tcl/cal-item-procs-oracle.xql

tcl/cal-item-procs-postgresql.xql

2.10.0d2:

Add location as optional last parameter to cal_item__new (14/15)

Oracle: code was already out of sync with postgres, parameter

package_id was missing

Requires acs_event__new with location support acs-events 0.6.2d1

calendar.info

sql/oracle/cal-item-create.sql

sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql

sql/postgresql/cal-item-create.sql

sql/postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql

2.10.0d3:

Fix bug #3340: Delete acs_activity and recurrence,

when last cal_item referring to it is deleted.

calendar.info

sql/postgresql/cal-item-create.sql

sql/oracle/cal-item-create.sql

  1. … 12 more files in changeset.
Reduce divergencies between oracle and postgres codebase

  1. … 2 more files in changeset.
Oops, there are two queries to grab a calendar item. One if the use of

attachments is disabled (which I'd changed earlier), and one if attachments

are enabled (which I'd missed earlier). Thanks to Michael at MGH for catching

this while testing.

  1. … 1 more file in changeset.
More support for the related link stuff in acs-events.

  1. … 2 more files in changeset.
Support for more editing options for recurring events. Allow editing one item, future instance, or all instancs of a recurring item

  1. … 2 more files in changeset.
reverting invadvertent commits on calendar package

  1. … 6 more files in changeset.
varous bug fixes, enhance date field to use the new calendar javascript and integrates with ad_form date widget

  1. … 20 more files in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
Fixing a date format bug in calendar::item::add_recurrence.create_recurrence.

add datasource and url contracts for Fts, add callbacks for sc stuff, add calendar_package_id to calendar::item::get areturn array

  1. … 4 more files in changeset.
pass name through so acs_object.title will be set.

  1. … 1 more file in changeset.
Moved cal-item-2-procs stuff into cal-item-procs. i

Moved all procs into calendar::item namespace.

Removed unused queries.

  1. … 8 more files in changeset.
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)

  1. … 275 more files in changeset.
merge from oacs-4-6

  1. … 130 more files in changeset.
use permission api rather than hit db directly

  1. … 5 more files in changeset.
Fixed permissions settings in calendar. The original code skirted around

the fact that context_id in the calendar item was being set to NULL by

physically copying the parent calendar's permissions and attaching them

to the new item.

This messed up recurring items because the code to copy an item didn't copy

the permissions, just context_id.

I changed the calendar item create code to set context_id to the calendar

parent, which seems to work fine. After all this is how the perms system

is meant to work ...

  1. … 2 more files in changeset.
fixed delete confirmation

  1. … 2 more files in changeset.
added support for editing recurring events

  1. … 8 more files in changeset.
fixed up view of calendar items and deletion of recurrences

  1. … 7 more files in changeset.
uncomplete port of queries

    • -0
    • +141
    ./cal-item-procs-oracle.xql
  1. … 7 more files in changeset.