I have a situation where file data (e.g., images) is stored as blob fields in the source (Oracle) database. So, it would be nice for the file field handler to deal with creating files from blobs.

CommentFileSizeAuthor
#2 blob_save-1180188-2.patch4.85 KBmikeryan
#1 0001-Support-for-saving-BLOB-columns-into-the-file-field-.patch4.85 KBmoshe weitzman

Comments

moshe weitzman’s picture

moshe weitzman commented
StatusFileSize
new 0001-Support-for-saving-BLOB-columns-into-the-file-field-.patch4.85 KB

This in-progress patch tries to create the source table with a BLOB column. The column gets created but I am getting an error during data insertion. Could someone take a look? I will meanwhile work on the file handling part of the patch.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
StatusFileSize
new blob_save-1180188-2.patch4.85 KB

A RETURNING clause for mainimage was needed, took a little trial-and-error to figure out the right syntax with multiple LOBs...

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Fixed

Committed file_blob support to 7.x-2.x. file_link was copied to D7 from D6 as well.

moshe weitzman’s picture

moshe weitzman commented

I just committed support for migrating from BLOB column into file entity. There is an example in wine.inc (WineFileBlobMigration)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.