• last updated 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Require latest acs-kernel, as new features use freshly defined db utilities

Enhancement for the db abstraction interface: now the system is also able to specify

and reflect in the db table column properties and constraints as unique, foreign keys (as before),

not null, default value (as before) and index creation (directly as class attribute flag).

Such column properties will be added to the data model also after first table creation

without the need for an upgrade script. This should cover the most typical

"incremental upgrade" use cases. Change in column type and dropping of tables, indexes

or constraints still has to be performed manually.

Also, flag for require view allows one to rebuild it automatically.

    • -13
    • +144
    /openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl
Added new database utility to retrieve primary keys of a table.

Source for the postgres version: https://wiki.postgresql.org/wiki/Retrieve_primary_key_columns

Source for the oracle version: http://stackoverflow.com/questions/4749650/function-that-would-return-the-data-retreived-from-a-select-query-oracle

file upgrade-5.9.1d19-5.9.1d20.sql was initially added on branch oacs-5-9.

Added new database functions to check for various properties and constraints in database metadata:

- foreign key constraint

- unique constraint

- not null constraint

- get column default value

file upgrade-5.9.1d18-5.9.1d19.sql was initially added on branch oacs-5-9.

Made all creation of fallback database utilities conditional to object existance

Move fallback utilities definitions after ones coming from database

function, so the latter have precedence.

This is needed upstream because create_all_functions here skips

function creation when it already exist (motivated in comment).

    • -163
    • +164
    /openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl
Put CSP stuff in the installer page only when required (an error is thrown and we need the back button)

In such case, make the nonce attribute safer by using the proc instead of the (likely missing) variable

- fix for complex interaction of nested repeat fields and ckeditor instances (many thanks to Thomas Renner for the help)

    • -86
    • +100
    /openacs-4/packages/xowiki/tcl/form-field-procs.tcl
Make timed_id just a proc variable instead of instance's

- add safety-belt for subject lines: in case the string passed in for the subject line contains CRLF, the produced mail might end up destroyed. so remove crlf and add a warning, in case it happens (client bug)

Fixed root_folder_id variable not being passed properly to the includelet by the fs-portlet

Make available a clock based id to templates, so they can use it to attach easily javascript event handlers to elements

- don't hard-code community_member_admin_url

- improve support for IPv6

Remove possible lefrover trigger and function from the old good days.

New instances don't even have this, but old born instances that get

updated could still have it. It is not necessary anymore and breaks

current cast rules in postgres.

file upgrade-2.9.0-2.9.1d1.sql was initially added on branch oacs-5-9.

Fix extra "at" chars

Handlers were already in the adp

Introduce nonce attribute in script tags to comply with csp

Set required hkey variable

    • -1
    • +2
    /openacs-4/packages/xowiki/tcl/xowiki-procs.tcl
- add repeat fields dynamically via js if needed.

This can improves load times for long complex nested repeat structure significantly

    • -9
    • +7
    /openacs-4/packages/xowiki/tcl/repeat-procs.tcl
- fix non-existing link

- clean dirty editor buffer

    • -2
    • +2
    /openacs-4/packages/xowiki/tcl/xowiki-procs.tcl
- reduce number of update statements to keep #dead tuples low

    • -30
    • +44
    /openacs-4/packages/xowiki/tcl/xowiki-procs.tcl
- make admin/list more robust

    • -1
    • +7
    /openacs-4/packages/xowiki/www/admin/list.tcl
- standardize entries in de_DE: rule of thumb: when en_US entry does not end with colon, then the german entry should not do so either.

This way, we avoid .adp pages with double colons.

- added missing query email_image::new_item.lob_size

- replaced local query by API call "content::item::set_live_revision -revision_id $revision_id"

Allow to identify and set handlers also on form fields by form id and field name (confirm and generic ones).

This could be desirable in pages with multiple ad_forms having fields with the same name (and thus no unique id), or other hand made forms not having id field at all.

- fix cr_revision_latest_tr once more to reduce the number of dead tuples generated for xo* classes

- bump version number to 5.9.1d25