No way to read image data from database

Rails
1

db----
def self.up
create_table :db_files,:force => true do |t|
t.binary :data
t.timestamps
end
end
db----

controller----
def find_db_file
project=Project.find_by_id(params[:id])
project_snapshot=project.project_snapshot
send_data(project_snapshot.db_file.data,
:type => project_snapshot.content_type,
:filename => project_snapshot.filename,
:disposition => ‘inline’)
end
controller----

view-------
<%for p in @projects -%>
<%=image_tag(url_for
(:controller=>:projects,:action=>:find_db_file,:id=>p.id))-%>
<%end-%>
view-------

I try my best to display the image data in the database,but fail.It
seems everything is right.Even try from mysql to sqlite not works.This
really let me down.

2

I don’t know exactly what errors you are seeing but…

On Sun, Nov 1, 2009 at 11:05 AM, daociyiyou [email protected]
wrote:

db----
def self.up
create_table :db_files,:force => true do |t|
t.binary :data
t.timestamps
end
end
db—

I bet one of them is due to your not having content_type and filename in
your table.

I try my best to display the image data in the database,but fail.It
seems everything is right.Even try from mysql to sqlite not works.This
really let me down.

–
www.abetaday.com

3

hi
content_type and filename fields are in another table called
project_snapshots.I do it according to the attachment_fu plugin
struction.I can just not display the image in the databse.

4

it seems -------<%=image_tag(url_for
(:controller=>:projects,:action=>:find_db_file,:id=>p.id))-%>-------
does not display the image but the image’s alt words.when i right-
click the alt words to check the image,i get the the url for the
find_db_file action.Is this problem related with the database?

5

Attachment_fu works fine in :file_system mode, but
not in :db_file mode. It seems to upload only about 45 bytes of data
instead of the entire image.Either t.binary :data or
t.binary :data,:limit => 10.megabyte can not works.
anyone can help me? Nearly a week time spent on it.

6

I believe many peopel meet this problem

7

Marnen Laibow-Koser wrote:

daociyiyou wrote:

Attachment_fu works fine in :file_system mode, but
not in :db_file mode.
[…]

Then don’t use :db_file mode. :slight_smile: Images don’t belong in the DB.
Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

I was feeling masochistic about a year and a half ago, and had it
working in :db_file mode (the challenge of one of those “proof is left
as an exercise for the reader”), but the performance was so abysmal it
was quickly evident that it was not a viable, long-term solution. It can
be done, but I’m not even sure I have that ‘tester’ rails app on my
machine any longer.

Just store your images on the file system, and get on with the fun
things…

8

daociyiyou wrote:

Attachment_fu works fine in :file_system mode, but
not in :db_file mode.
[…]

Then don’t use :db_file mode. :slight_smile: Images don’t belong in the DB.
Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

9

Thanks! My server do not approve the file system store,that is why
using the db_file.

10

Hi

send_data(project_snapshot.db_file.data,
                          :type  => project_snapshot.content_type,
                          :filename => project_snapshot.filename,
                          :disposition => 'inline')

Can you try here StringIO.new(project_snapshot.db_file.data)?

Sijo

11

What does your generated HTML look like for the view in question?

What you have looks familiar, but image_tag may be messing you up.

Can you get it to work if you ignore the helper and write the
appropriate html to wrap the inline content yourself?

12

daociyiyou wrote:

Thanks! My server do not approve the file system store,that is why
using the db_file.

Find a different server, then, or use S3. Even if you can get this to
work, you’re asking for trouble.

Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]