[Zope] blob and ZMySQLDA

Andy Dustman andy@dustman.net
02 Jan 2002 22:32:36 -0500


On Tue, 2002-01-01 at 16:46, John Hunter wrote:
> 
> I am trying to create a user interface in zope to a mysql database
> that has a BLOB entry.  I would like the user to be able to specify a
> file on the user's filesystem, and put that binary file into the
> database.
> 
> I am not sure how best to do this.  Does anyone have an example of an
> SQL method or external method that takes a file from the users system
> and puts it in as a binary blob into and SQL database?

A BLOB is just a string, as far as MySQLdb is concerned.

> Is it possible to do without first loading entire the contents of the
> file into memory?

Nope.

-- 
Andy Dustman         PGP: 0x930B8AB6
    @       .net     http://dustman.net/andy
You can have my keys when you pry them from my dead, cold neurons.