• last updated 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Introduce ON DELETE CASCADE on faq main datamodel tables, so generic acs_object db api can be used to e.g. delete a faq (fixes downstream errors when deleting FAQ package)

    • -0
    • +64
    ./sql/oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
    • -0
    • +62
    ./sql/postgresql/upgrade/upgrade-5.10.0d5-5.10.0d6.sql
Update italian localization

Implement uninstantiate apm callback to delete existent FAQs in advance

    • -0
    • +14
    ./tcl/apm-callback-procs.xql
Whitespace changes

Whitespace changes

Localize faq admin labels and bump version number

Fix message key