• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Changeset MAIN:hectorr:20210727093255:5 does not match your current filter (clear filter).

file q-and-a-delete-oracle.xql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./www/admin/q-and-a-delete-oracle.xql
file q-and-a-edit.tcl was initially added on branch oacs-5-10.

    • -0
    • +0
    ./www/admin/q-and-a-edit.tcl
file q-and-a-edit.adp was initially added on branch oacs-5-10.

    • -0
    • +0
    ./www/admin/q-and-a-edit.adp
file q-and-a-edit-2.tcl was initially added on branch oacs-5-10.

    • -0
    • +0
    ./www/admin/q-and-a-edit-2.tcl
file q-and-a-delete.tcl was initially added on branch oacs-5-10.

    • -0
    • +0
    ./www/admin/q-and-a-delete.tcl
file q-and-a-delete-postgresql.xql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./www/admin/q-and-a-delete-postgresql.xql
Adapt file names to OpenACS naming conventions

    • -0
    • +17
    ./www/admin/q-and-a-delete-oracle.xql
    • -0
    • +15
    ./www/admin/q-and-a-delete-postgresql.xql
    • -0
    • +24
    ./www/admin/q-and-a-new-2-postgresql.xql
    • -17
    • +0
    ./www/admin/q_and_a-delete-oracle.xql
    • -15
    • +0
    ./www/admin/q_and_a-delete-postgresql.xql
  1. … 7 more files in changeset.
Whitespace changes, breaking overlong lines, and removal of old *SQL*

    • -40
    • +89
    ./www/admin/q-and-a-add-edit.tcl
Phase out usage of obsolete acs_named_objects table

Whitespace cleanup

    • -13
    • +13
    ./www/admin/q-and-a-add-edit.tcl
make packages in principle installable under PG 13+

  1. … 19 more files in changeset.
make FAQ package installable under PG 13+

Set procs in the 'faq::twt' namespace as private

Redefine faq questions and answers as text, the same as downstream, then redefine all database function api so that argument types are taken from table definition

    • -27
    • +29
    ./sql/postgresql/faq-package-create.sql
file upgrade-5.10.0d7-5.10.0d8.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.10.0d7-5.10.0d8.sql
Deprecated get_referrer and NsSettoTclString, replace them with versions that respect OpenACS naming convention

  1. … 7 more files in changeset.
Deprecate value_if_exists proc, replace occurrences with plain tcl idioms

  1. … 4 more files in changeset.
Add page contract

Add ad_include_contract

fix messagekey broken since 15 years

Bring files on oacs-5-10 in sync with HEAD

    • -8
    • +10
    ./www/admin/faq-delete-postgresql.xql
    • -7
    • +10
    ./www/admin/q_and_a-delete-postgresql.xql
  1. … 149 more files in changeset.
Don't rely on the delete trigger being named consistently on different installations

Add again double quotes in the add constraint as well

Add double quotes in case constraints were defined using e.g. $ in the old days

Use generic acs_object__delete, so also eventual relations are deleted

    • -0
    • +17
    ./www/admin/faq-delete-oracle.xql
    • -0
    • +15
    ./www/admin/faq-delete-postgresql.xql
    • -0
    • +17
    ./www/admin/q_and_a-delete-oracle.xql
    • -0
    • +15
    ./www/admin/q_and_a-delete-postgresql.xql
Actually delete from the acs_object, or it will stay around

Streamline faq entry deletion exploiting newly defined on delete cascade

    • -12
    • +0
    ./www/admin/q_and_a-delete-postgresql.xql
Streamline faq deletion exploiting newly defined on delete cascade

    • -13
    • +0
    ./www/admin/faq-delete-postgresql.xql
Put on delete cascade defined in previous upgrades in creation sql as well

Faq vs Search trigger reform: turns out after delete trigger on faq_q_and_as is quite pointless and makes it more complicated for faq package instances to properly uninstantiated. More details in the comments.

    • -0
    • +24
    ./sql/postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql