• last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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

    • -1
    • +117
    ./sql/oracle/utilities-create.sql
    • -0
    • +225
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -9
    • +155
    ./sql/postgresql/utilities-create.sql
file upgrade-5.9.1d18-5.9.1d19.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d18-5.9.1d19.sql
- add nonces to script tags

- add body handlers

  1. … 7 more files in changeset.
- Improved compatiblity with PostgreSQL before 9.2:

don't use SQL-language function names to reference parameters to

obtain compatibility for earlier PostgreSQL versions

(see https://www.postgresql.org/docs/9.2/static/release-9-2.html

item E.19.3.9.3)

- fix upgrade script for PostgreSQL before 9.2: the old version checked

already the version number, but actually the SQL compilation failed

due to the unknown "IF EXISTS" for sequences.

- Added support for W3C Content Security Policy(CSP)

* For details about CSP, see https://www.w3.org/TR/CSP/

* New calls:

security::csp::nonce:

Generate a CSP nonce token token

security::csp::require /directive/ /value/:

Add a requirements of a page to the CSP in order to generate

later a tailored policy with the minimal permissions for

this page. For example, the following requirement is

currently added per default to the oacs-master template to

permit style tags and style attribites in the markup.

security::csp::require style-src 'unsafe-inline'

security::csp::render:

Generate a policy from the requirements

* Added Kernel Parameter CSPEnabledP to activate/desctivate CSP

(default on)

- Bump version numbers

acs-tcl to 5.9.1d11

acs-bootstrap-installer to 5.9.1d4

acs-kernel to 5.9.1d17

  1. … 7 more files in changeset.
- add kernel parameter to make ad_session_id cookies secure (useful on sites, where all sessions are via https, improves security rating on e.g. mozillas observatory tool)

  1. … 1 more file in changeset.
- don't change names of arguments unless necessary, since such cases require a DROP FUNCTION

composition-rel reform:

- apply changes developed by Michael Steigman for making rel-types

configurable whether these should be composable or not

(default is: these are composable, which was up to now the only

choice)

- improved documentation of log argument lists of SQL functions

- Background:

http://openacs.org/forums/message-view?message_id=5330734

http://openacs.org/forums/message-view?message_id=4031049

- bump version number of acs-kernel to 5.9.1d16

    • -1
    • +2
    ./sql/oracle/acs-relationships-create.sql
    • -23
    • +32
    ./sql/oracle/groups-body-create.sql
    • -25
    • +36
    ./sql/postgresql/groups-body-create.sql
    • -8
    • +5
    ./sql/postgresql/rel-segments-create.sql
    • -4
    • +6
    ./sql/test/rel-segments-test-types-create.sql
  1. … 20 more files in changeset.
file upgrade--5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql
file upgrade-5.9.1d15-5.9.1d16.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d15-5.9.1d16.sql
- use dollar quoting for SQL comments

    • -9
    • +9
    ./sql/postgresql/acs-objects-create.sql
- add verbosity setting

- make it easy to log SQL statements as these are executed

    • -4
    • +4
    ./sql/postgresql/acs-kernel-create.sql
- added kernel parameter MaxUrlLength (default 2000) to remove

hard-coded length in request-processor-procs.

- lifted data model restriction of 100 characters for url-segments

(changing types of "site_nodes.name" from "varchar(100)" to "text")

(PostgreSQL only)

- site_node__node_id

* use built-in string functions instead of characterwise loop

* use default for last argument

* Improve source-code documentation

- bumped version number of kernel to 5.9.1d15

    • -35
    • +44
    ./sql/postgresql/site-nodes-create.sql
  1. … 1 more file in changeset.
file upgrade-5.9.1d14-5.9.1d15.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d14-5.9.1d15.sql
- improve source code documentation

- polishing update script

- make same change as well for older pg versions

- make upgrade script more robust to allow multiple runs

- fix upgrade script

- remove dependency on acs_object_party_privilege_map

    • -25
    • +15
    ./sql/postgresql/groups-body-create.sql
file upgrade-5.9.1d12-5.9.1d13.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d12-5.9.1d13.sql
- improve source code documentation

file upgrade-5.9.1d11-5.9.1d12.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d11-5.9.1d12.sql
- added new function acs_permission.permissions_all as replacement for acs_permssions_all

- removed all dependencies on acs_permssions_all in kernel (such that acs_object_paths and acs_object_context_index can be dropped for PostgreSQL)

  1. … 6 more files in changeset.
- change language of function from plpgsql to sql to avoid mismatch

file upgrade-5.9.1d10-5.9.1d11.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d10-5.9.1d11.sql
- Add SQL schema acs_permission to allow to call sql-functions for

Oracle and PostgreSQL in exactly the same way

- Move postgres permission function to the new neamespace and provide

stubs for backward compatibility

- New function permission::get_parties_with_permission

to support a restricted form of reverse lookup for permssions

in order to reduce the dependencies on

acs_object_party_privilege_map for PostgreSQL

- make upgrade scripts more robust (support repeated loading)

- bump verison number of acs-tcl to 5.9.1d9

- bump version number of acs-kernel to 5.9.1d11

  1. … 8 more files in changeset.
- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

- bump version number to 5.9.1d10

    • -2
    • +4
    ./sql/oracle/acs-permissions-create.sql
    • -0
    • +197
    ./sql/oracle/upgrade/upgrade-5.9.1d9-5.9.1d10.sql
    • -2
    • +2
    ./sql/postgresql/groups-body-create.sql
file upgrade-5.9.1d9-5.9.1d10.sql was initially added on branch oacs-5-9.

    • -0
    • +0
    ./sql/oracle/upgrade/upgrade-5.9.1d9-5.9.1d10.sql
    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-5.9.1d9-5.9.1d10.sql