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'))

Answer 1

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.