Load Binary Data From a File via ActiveRecord Create

Question

Is there an easy (or generally accepted) way to load up a binary column using the create method of ActiveRecord?

For example, what I'm trying to do is something similar to this:

MyTableObject.create(name: 'Test', image: File.read('PathToMyFile.jpg'))

It doesn't seem to be ... unless I'm just doing it wrong. The create method returns true and I do see the record in the DB; however, the image isn't recoverable and the reported filesize doesn't match up. — jerhinesmith
– jerhinesmith, Commented Aug 27, 2009 at 20:51

jerhinesmith · Accepted Answer · 2018-06-01 17:19:28Z

4

I was able to get this working. Rather than doing:

MyTableObject.create(
    name: 'Test',
    image: File.read('PathToMyFile.jpg')
)

which did insert a record into the database but without the correct binary representation of the file

MyTableObject.create(
    name: 'Test',
    image: File.open('PathToMyFile.jpg', 'rb').read
)

seemed to do the trick.

edited Jun 1, 2018 at 17:19

answered Aug 27, 2009 at 20:58

jerhinesmith

15.6k18 gold badges64 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Irongaze.com Over a year ago

Looks like a Windows-only problem - in Windows (but not unix-alikes like Linux or OSX) binary and text files are handled differently, hence the need for the explicit 'rb' mode param to correctly load the file.

David Keener Over a year ago

Not a Windows-only problem. I had the same problem with a UNIX system (XUBUNTU, to be precise). And the recommended solution also worked on my system.

Jean · Accepted Answer · 2022-06-06 14:53:32Z

0

You can also use binread https://ruby-doc.org/core-3.1.2/IO.html#binread-method

MyTableObject.create(name: 'Test', image: File.binread('PathToMyFile.jpg'))

answered Jun 6, 2022 at 14:53

Jean

8558 silver badges17 bronze badges

Collectives™ on Stack Overflow

Load Binary Data From a File via ActiveRecord Create

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related