Search code examples
phpmysqlyamlpropel

Saving and retrieving blobs using Propel ORM

I am using Propel (1.4) with Symfony 1.31 (with mySQL db). I want to save save/retriev BLOB (gzipped) data to/from the database

My db schema is defined in YML.

Suppose the schema looks like this:

demo_blobbed_object:
  _attributes: { phpName: MrBlobby }
  id:
  name: {type: varchar(32)}
  data: {type: ? }

I have the following questions

  1. What is the type: value for a BLOB field type in YML?
  2. Can I use the normal getter setter methods to get/set the blob data from a MrBlobby object?

The propel documentation says here that the _toString() method needs to be called, but it is not clear if this still applies to Propel 1.4

Solution

  • It should be BLOB or CLOB depending on what is appropriate for your usage. In your case i would think BLOB...

    http://propel.phpdb.org/trac/wiki/Users/Documentation/1.4/Schema-Reference

    As far as setting/getting im not sure as ive never stored an image/gz/etc. in a db when using Propel before so ive never had to use it. However this may answer your questions:

    http://propel.phpdb.org/trac/wiki/Users/Documentation/1.4/LOB-Columns