1  INSERT INTO organizations (name)
 2  VALUES
 3  ('Apidae Systems'),
 4  ('Microvisor Systems'),
 5  ('Adafruit'),
 6  ('Arduino'),
 7  ('Bosch'),
 8  ('Bell Labs'),
 9  ('Sun Microsystems'),
10  ('FreeBSD Foundation'),
11  ('Linux Foundation'),
12  ('Cloud Native Computing Foundation'),
13  ('STMicroelectronics'),
14  ('Xerox PARC'),
15  ('Open Source Robotics Foundation'),
16  ('Canonical'),
17  ('Red Hat'),
18  ('Collabora'),
19  ('System76'),
20  ('Framework'),
21  ('SiFive'),
22  ('Raspberry Pi Foundation'),
23  ('Espressif'),
24  ('NXP'),
25  ('DFRobot'),
26  ('Texas Instruments'),
27  ('OpenBSD'),
28  ('QEMU'),
29  ('Tailscale'),
30  ('Apple'),
31  ('NATS')
32  ON CONFLICT (name) DO NOTHING;
33  
34  UPDATE organizations
35  SET domain = 'apidae-systems.microvisor.systems'
36  WHERE name = 'Apidae Systems';
37  
38  UPDATE organizations AS organization
39  SET symbol_asset_id = asset.id
40  FROM (
41      VALUES
42          ('OpenBSD', 'openbsd.png'),
43          ('QEMU', 'qemu.svg'),
44          ('Tailscale', 'tailscale.svg'),
45          ('Apple', 'apple.svg'),
46          ('NATS', 'nats.svg')
47  ) AS organization_symbol(organization_name, filename)
48  JOIN assets AS asset
49      ON asset.filename = organization_symbol.filename
50  WHERE organization.name = organization_symbol.organization_name;