                                          :format]
                       (select [:echo-granule-id
                                :granule-ur
-                               `(concat ~collection-id "") ; don't know how else to select constant
+                               collection-id
                                :compressed-xml
                                :xml-mime-type]
                               (from granule-echo-table)

  (copy-provider (oc/create-db (oc/db-spec)) "FIX_PROV1")
  (copy-single-collection (oc/create-db (oc/db-spec)) "FIX_PROV1" "C1000000073-FIX_PROV1")
  (get-provider-collection-list-sql  "FIX_PROV1")
  (copy-collection-data-sql "FIX_PROV1")
  (copy-granule-data-for-provider (oc/create-db (oc/db-spec)) "FIX_PROV1")
  (delete-collection-granules-sql "FIX_PROV1" "C1000000073-FIX_PROV1")
  )

  [provider-id]
  (keyword (str (catalog-rest-tablespace) "." provider-id "-dataset-records")))

(defn catalog-rest-granule-table
  "Get the granule table name for a given provider."
  [provider-id]
  (keyword (str (catalog-rest-tablespace) "." provider-id "-granule-records")))

(defn metadata-db-concept-table
  "Get the collection/granule table name for a given provider."
  [provider-id concept-type]
  (keyword (str (metadata-db-tablespace) "." (tables/get-table-name provider-id concept-type))))

(defn create-provider-url
  []
  (format "%s/providers" (metadata-db-url)))
