File: neutralize.sql

package info (click to toggle)
odoo 18.0.0%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 878,716 kB
  • sloc: javascript: 927,937; python: 685,670; xml: 388,524; sh: 1,033; sql: 415; makefile: 26
file content (9 lines) | stat: -rw-r--r-- 320 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
 
-- happy path
UPDATE iap_account
SET account_token = REGEXP_REPLACE(account_token, '(\+.*)?$', '+disabled')
WHERE LENGTH(account_token) <= 33;
-- Legacy (invalid) records (pre v17)
UPDATE iap_account
SET account_token = 'dummy_value+disabled'
WHERE LENGTH(account_token) > 33
    AND account_token NOT LIKE '%+disabled';