Odoo/odoo/tools/sql.py, branch 14.0

[FIX] base: allow using another postgres schema than public

2021-03-19T11:52:26+00:00

Before 1721ec1363 and fdc4ef97c9d09, Odoo did work fine when the
user had another default schema than 'public'.
This commit restores this behaviour by searching
for existing objects in the user's current schema,
which is the first in the schema search path and
the one used when no schema is specified when
creating objects.

closes odoo/odoo#68141

X-original-commit: 223781b34afacd1c0c5674d395cece6d472b048c
Signed-off-by: Olivier Dony (odo)

[FIX] tools.sql, website_*: increment counter with skip lock

2020-09-28T13:38:28+00:00

*blog, forum, slides

Based on https://github.com/odoo/odoo/pull/48552#discussion_r440061218 suggestion

Add a new method 'increment_skip_lock' in tools.sql to allow to easily
increment a specific field of 1 if the record is not locked.

The method return boolean if at least 1 record has been incremented.

closes odoo/odoo#58534

Signed-off-by: Jérémy Kersten (jke)

[IMP] core: optimize `model._auto_init()` on a new model

2020-04-03T11:40:28+00:00

Create the table with all the columns from scratch, with the NOT NULL
constraint when required.  Also do not call `_check_removed_columns()`
on a new table.

This saves 0.5% of the total installation time.

X-original-commit: 0727cacf5194a143b15ab4cb9893f3035a67be1f

[FIX] core: delay constraint application in case of upgrade

2020-02-06T18:28:29+00:00

closes odoo/odoo#44800

Co-authored-with: Xavier Dollé 
X-original-commit: bc2bb5e03c2b32d4ee1b0597ea5889c17d2b0e0e
Signed-off-by: Xavier Dollé (xdo)

[FIX] sql_db: ignore PG views when verifying table type

2019-12-24T19:08:11+00:00

Collisions in table names of ORM models with built-in PG structures such
as "attributes", "domains", "routines", "parameters", ... could occur
and render the result of `table_kind` meaningless.

Based on what was done via https://github.com/odoo/odoo/pull/16651 more
than 2 years ago, it seems relying on our tables being in the 'public'
schema is safe, even though it's only a default from PG. We reuse that
same logic rather than the alternative of excluding
('information_schema', 'pg_catalog', ...), even though it looks safer at
first. If we did the latter we'd have to change the other comparison for
consistency, i.e. more risks.

closes odoo/odoo#42358

X-original-commit: d8e74eb14990c82f65a44ffe163aa84159d6ccc4
Signed-off-by: Denis Vermylen

[FIX] base: allow custom model to use SQL (materialized) views instead of table

2019-12-03T07:45:25+00:00

closes odoo/odoo#41267

X-original-commit: f17d389c4625e95f52c299c13a3f2983127c70bc
Signed-off-by: Raphael Collet (rco) 
Co-authored-by: Denis Ledoux 
Co-authored-by: Raphael Collet

[ADD] test_lint: Add sql-injection pylint check

2019-10-02T14:16:38+00:00

closes odoo/odoo#36583

Signed-off-by: Xavier Morel (xmo)

[FIX] sql_db: add flush() in savepoint()

2019-08-26T13:39:16+00:00

closes odoo/odoo#36060

Signed-off-by: Raphael Collet (rco)

[IMP] models: ORM speedup

2019-08-20T12:43:59+00:00

This branch is the combination of several optimizations in the ORM:

* store field values once in the cache: the cache reflects more
faithfully the database, only fields that explicitly depend on the
context have an extra indirection in the cache;

* delay recomputations by default: use method `recompute` to explicitly
flush out pending recomputations;

* delay updates in method `write`: updates are stored in a data
structure that can be flushed efficiently to the database with method
`flush` (which also flush out recomputations);

* make method `modified` take advantage of inverse fields to inverse
dependencies;

* filter records by evaluating a domain on records in Python;

* a computed field with `readonly=False` behaves like a normal field
with an onchange method;

* computed fields are computed in superuser mode by default.

Work done by Toufik Ben Jaa, Raphael Collet, Denis Ledoux and Fabien
Pinckaers.

closes odoo/odoo#35659

Signed-off-by: Denis Ledoux

[RFR] Hide implementation of constraint definition storage, courtesy of Raphael Collet

2018-08-16T08:33:06+00:00