psql function to reformat Device.device_model and populate Device.framework

[christocracy]

We need a psql script to iterate devices table and populate the framework column where null

An old style device_model takes the form:

device_model	framework
Moto G (5) Plus (ReactNative)	null

Where Framework takes the form:

• ReactNative
• Flutter
• Cordova

We need to find that text FrameworkName, remove it (including brackets) from device_model and use it to populate framework.

• In the end, the two columns will look like this:

device_model	framework
Moto G (5) Plus	react-native

• I want the framework name reformatted too, such that:
  • ReactNative -> react-native
  • Cordova -> cordova
  • Flutter -> flutter

[Sigura]

update public.devices set
  device_model = trim(REGEXP_REPLACE(device_model, '^([^(]*).*$', '\1')),
  framework = (
    CASE trim(REGEXP_REPLACE(device_model, '^[^(]*\(([^)]*)\)$', '\1'))
        WHEN 'ReactNative' THEN 'react-native'
        WHEN 'Cordova' THEN 'cordova'
        WHEN 'Flutter' THEN 'flutter'
        ELSE null
    END
  )
where framework is null;

[christocracy]

Sample data after execute:

[Sigura]

Looks like all is fine and we can close this issue?