cal-item-procs-postgresql.xql

  • last updated 23 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.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

  1. … 2478 more files in changeset.
make calendar::item::get.select_item_data_with_attachment behave like calendar::item::get.select_item_data where info of acs_event is prioritized over acs_activity

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.
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.

    • -17
    • +111
    ./cal-item-procs-postgresql.xql
  1. … 8 more files in changeset.
More cleanup and bugfixes, moved cal-item-new to using ad_form, added timezones (peter marklund)

  1. … 14 more files in changeset.
merge of 4.6.3b1 to HEAD

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

  1. … 53 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.
-- fix attribute order

-- add context_id as on_which_calendar (id)

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 conflicts

  1. … 1 more file in changeset.
Fix timestamp function fixes bug 1429 patch 219

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.

Added some hacks for dotLRN events that might be useful elsewhere. I'm not

*too* worried about hacking in this style since this package needs to be

entirely rewritten except for the graphics!

  1. … 3 more files in changeset.
*** empty log message ***

  1. … 3 more files in changeset.
*** empty log message ***

  1. … 1 more file in changeset.
*** empty log message ***

  1. … 4 more files in changeset.
*** empty log message ***

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

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