Skip to content

Instantly share code, notes, and snippets.

@bogdanRada

bogdanRada/sql_query.rb

Forked from mihaic195/sql_query.rb
Created February 25, 2022 11:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bogdanRada/a03b573e8f5804cb3c085a9b1fb2efbe to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bogdanRada/a03b573e8f5804cb3c085a9b1fb2efbe to your computer and use it in GitHub Desktop.
Download ZIP
Simple sql query for extracting the direct URL of an attachment
Raw
sql_query.rb
SELECT blobs.storage_url
FROM active_storage_blobs AS blobs
INNER JOIN active_storage_attachments AS attachments ON attachments.blob_id = blobs.id
WHERE attachments.record_type = 'Model1'
AND attachments.name = 'logo'
LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment