insert.sql

  WITH grenoble AS (
    SELECT id from dataset where spatial = 'Grenoble-Alpes Métropole'
  )

  INSERT into resource
    (dataset_id, url, format, title)
    SELECT grenoble.id, resource.* FROM (VALUES
      ('https://app-be8e53a7-9b77-4f95-bea0-681b97077017.cleverapps.io/gtfs_rt', 'gtfs-rt', 'Flux temps réel GTFS RT'),
      ('https://app-be8e53a7-9b77-4f95-bea0-681b97077017.cleverapps.io/', 'siri-lite', 'API temps réel Siri Lite')
    ) as resource, grenoble;