view-list-display-postgresql.xql

  • last updated 15 hours 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.

  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.
resurrected show_calendar_name_p and calendar_id_list

  1. … 3 more files in changeset.
starting to add timezone support to the calendar package. Have not finished this task yet as we are waiting for Dirk to help us fix some major breakages that are preventing us from testing

    • -27
    • +21
    ./view-list-display-postgresql.xql
  1. … 26 more files in changeset.
sanitized the query: removed unnecessary subqueries and the query now uses the same permission clause like calendar::calendar_list

  1. … 1 more file in changeset.
noquote fixes: moved as much html generation into adp files

    • -12
    • +12
    ./view-list-display-postgresql.xql
  1. … 42 more files in changeset.
draft version of noquoted calendar package

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