view-month-display-postgresql.xql

  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Lumped all the different view-pages' query into one thus drastically slashing the amount of code that looks subtly different but effectively always retrieves calendar items for a particular interval.

    • -34
    • +0
    ./view-month-display-postgresql.xql
  1. … 13 more files in changeset.
The date format string is constant - it is always the ANSI date format. There is no need to create a variable in TCL and then pass it on as a bind variable to the database. Instead I have hard-wired the format string into the database which means less code and maybe even slightly more efficiency.

  1. … 12 more files in changeset.
Make calendar play nice with calendar-portlets. I am slowly approaching alpha status with this.

  1. … 20 more files in changeset.
adding timezone support to the month/week/day/list view templates

    • -10
    • +4
    ./view-month-display-postgresql.xql
  1. … 9 more files in changeset.
Retrieve calendar_id directly from calendars table

sanitized the query: removed unnecessary subqueries and the query now uses the same permission clause like calendar::calendar_list

    • -15
    • +12
    ./view-month-display-postgresql.xql
  1. … 1 more file in changeset.
noquote fixes: moved as much html generation into adp files

  1. … 42 more files in changeset.
draft version of noquoted calendar package

    • -0
    • +40
    ./view-month-display-postgresql.xql
  1. … 22 more files in changeset.