Skip to content

Instantly share code, notes, and snippets.

View odony's full-sized avatar

Olivier Dony (ODO) odony

View GitHub Profile
@odony
odony / find_indexes.sql
Last active March 10, 2023 09:15
Determine useful indexes for DELETE in res_users
WITH fk_actions ( code, action ) AS (
VALUES ( 'a', 'error' ),
( 'r', 'restrict' ),
( 'c', 'cascade' ),
( 'n', 'set null' ),
( 'd', 'set default' )),
fk_list AS (
SELECT pg_constraint.oid as fkoid, conrelid, confrelid as parentid,
conname, relname, nspname,
fk_actions_update.action as update_action,
@odony
odony / l10n_uk.totp.patch
Created March 29, 2023 10:07
l10n_uk.totp.patch
diff --git l10n_uk_reports/models/hmrc_service.py l10n_uk_reports/models/hmrc_service.py
index c1927802e68..e5fe7db0a97 100644
--- l10n_uk_reports/models/hmrc_service.py
+++ l10n_uk_reports/models/hmrc_service.py
@@ -129,7 +129,7 @@ class HmrcService(models.AbstractModel):
if remote_needed: #no need when on a private network
gov_dict['Gov-Client-Public-IP'] = urls.url_quote(remote_address)
gov_dict['Gov-Client-Public-Port'] = urls.url_quote(str(environ.get('REMOTE_PORT')))
- if self.env.user.totp_enabled:
+ if 'totp_enabled' in self.env.user._fields and self.env.user.totp_enabled: