Forum OpenACS Development: Blob question
I'm about half way through the simple survey data model and I just encountered a blob in one of the tables.
create table survsimp_question_responses ( response_id ..., . . . attachment_answer blob, . );
I read through Dan's content repository documentation and I didn't see any mention on how to handle blobs when the old data model didn't already use the content repository. Do I just make attachment_answer reference cr_items and modify the query to use the content repository?
This content repository stuff is confusing. :)
I'm sure Dan would be more than glad to help you out with questions, he's already done this for the APM.
If you have any problems with it, just let me know, and I'll be glad to help out.
I finally got a chance to get back to porting. I took a look at the apm_package_versions table. The lines that reference the cr_items table have been commented out.
-- This constraint can't be added yet, as the cr_items table -- has not been created yet. -- constraint apm_package_ver_item_id_fk -- references cr_items(item_id),
Dan, it looks like the cr_items table was ported but this constraint might not have been uncommented. Also, the Oracle sql doesn't have the constraint listed. Both the Postgresql and Oracle code have been modified to use the cr_items table. Should I do the same for the simple_survey table? Thanks.
Don, I might be able to finish this package this weekend. I'll let you know on Monday. Now where did I put those Oracle CDs? :)