[web2py] Re: Saving an image from another database into your database
Notice that these two lines:
Field('image_file','blob'),
Field('image_upload','upload',uploadfield= Field('image_file','blob'))
should be
Field('image_file','blob'),
Field('image_upload','upload',uploadfield= 'image_file'),
or simply
Field('image_upload','upload',uploadfield= Field('image_file','blob'))
The blob should be created automatically.
On Thursday, 5 July 2012 06:23:31 UTC-5, RCTYCO wrote:
I am trying to save an image from another database into my
database, essentially i am caching the a copy into my database so I don't
have to query the external site.
I have a link
http://eandata.com/image/products/004/900/000/004900443.jpg.
I want to save the jpg into a blob in my database.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Function. I have this running a module and called when I need to download
the external image.
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
else:
pass # everything is fine
print response.geturl()
print response.info()
print response.read()
f = open(response.read(),'rb')
#stream = open(response,'rb')
return
db.image.insert(url=url,image=db.image.image_upload.store(f,url))
*I am having a problem with my insert statement. I can't seem to figure
out how to save the image into database.* urllib2.urlopen(req) will
download the file and provide a file object. But I don't know if i can just
save the file or do i need to read the file object within
the urllib2.urlopen(req).
I would like the image to be available to be via
http://mydomain.com/myapp/imageLookup?id=2
http://mydomain.com/myapp/imageLookup?id=2
Controller
def imageLookup():
id = request.vars.id
#response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
Do you have any suggestions? The code abo
[web2py] Re: Saving an image from another database into your database
I believe i found my problem. The problem is with MySQL. I noticed in the
MySQL._db._adapter.uploads_in_blob = FALSE.
The database adapter doesn't allow uploads_in_blob. MySQLAdapter* *inherents
the uploads_in_blob of FALSE from BaseAdapter.
Do you know why the uploads_in_blob isn't set to true?
On Friday, July 6, 2012 12:27:41 PM UTC-7, Massimo Di Pierro wrote:
Notice that these two lines:
Field('image_file','blob'),
Field('image_upload','upload',uploadfield= Field('image_file','blob'))
should be
Field('image_file','blob'),
Field('image_upload','upload',uploadfield= 'image_file'),
or simply
Field('image_upload','upload',uploadfield= Field('image_file','blob'))
The blob should be created automatically.
On Thursday, 5 July 2012 06:23:31 UTC-5, RCTYCO wrote:
I am trying to save an image from another database into my
database, essentially i am caching the a copy into my database so I don't
have to query the external site.
I have a link
http://eandata.com/image/products/004/900/000/004900443.jpg.
I want to save the jpg into a blob in my database.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Function. I have this running a module and called when I need to download
the external image.
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
else:
pass # everything is fine
print response.geturl()
print response.info()
print response.read()
f = open(response.read(),'rb')
#stream = open(response,'rb')
return
db.image.insert(url=url,image=db.image.image_upload.store(f,url))
*I am having a problem with my insert statement. I can't seem to figure
out how to save the image into database.* urllib2.urlopen(req) will
download the file and provide a file object. But I don't know if i can just
save the file or do i need to read the file object within
the urllib2.urlopen(req).
I would like the image to be available to be via
http://mydomain.com/myapp/imageLookup?id=2
http://mydomain.com/myapp/imageLookup?id=2
Controller
def imageLookup():
id = request.vars.id
#response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
Do you have any suggestions? The code abo
[web2py] Re: Saving an image from another database into your database
That only sets the default behavior. Only on systems that do not have a
writable filesystem (like on GAE and couchdb) files go in blob by default.
On relational databases, uploads are stored in files, not in blobs (by
default).
On Friday, 6 July 2012 16:22:36 UTC-5, RCTYCO wrote:
I believe i found my problem. The problem is with MySQL. I noticed in the
MySQL._db._adapter.uploads_in_blob = FALSE.
The database adapter doesn't allow uploads_in_blob. MySQLAdapter* *inherents
the uploads_in_blob of FALSE from BaseAdapter.
Do you know why the uploads_in_blob isn't set to true?
On Friday, July 6, 2012 12:27:41 PM UTC-7, Massimo Di Pierro wrote:
Notice that these two lines:
Field('image_file','blob'),
Field('image_upload','upload',uploadfield= Field('image_file','blob'))
should be
Field('image_file','blob'),
Field('image_upload','upload',uploadfield= 'image_file'),
or simply
Field('image_upload','upload',uploadfield= Field('image_file','blob'))
The blob should be created automatically.
On Thursday, 5 July 2012 06:23:31 UTC-5, RCTYCO wrote:
I am trying to save an image from another database into my
database, essentially i am caching the a copy into my database so I don't
have to query the external site.
I have a link
http://eandata.com/image/products/004/900/000/004900443.jpg.
I want to save the jpg into a blob in my database.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Function. I have this running a module and called when I need to
download the external image.
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
else:
pass # everything is fine
print response.geturl()
print response.info()
print response.read()
f = open(response.read(),'rb')
#stream = open(response,'rb')
return
db.image.insert(url=url,image=db.image.image_upload.store(f,url))
*I am having a problem with my insert statement. I can't seem to figure
out how to save the image into database.* urllib2.urlopen(req) will
download the file and provide a file object. But I don't know if i can just
save the file or do i need to read the file object within
the urllib2.urlopen(req).
I would like the image to be available to be via
http://mydomain.com/myapp/imageLookup?id=2
http://mydomain.com/myapp/imageLookup?id=2
Controller
def imageLookup():
id = request.vars.id
#response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
Do you have any suggestions? The code abo
[web2py] Re: Saving an image from another database into your database
I would do:
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
else:
pass # everything is fine
print response.geturl()
print response.info()
# print response.read() # do not read it
# f = open(response.read(),'rb') # response is already a stream
# stream = open(response,'rb')
id =
db.image.insert(url=url,image=db.image.image_upload.store(response,filename=url))
db.commit() # not sure if needed, depends on where executed
return id
then return it with the provided download action or
def imageLookup():
id = request.vars.id
#response.headers['Content-Type']='image/jpeg'
path = os.path.join(request.folder,'uploads',db.image[id].image_file)
return response.stream(open(path,'rb'))
On Thursday, 5 July 2012 06:23:31 UTC-5, RCTYCO wrote:
I am trying to save an image from another database into my
database, essentially i am caching the a copy into my database so I don't
have to query the external site.
I have a link
http://eandata.com/image/products/004/900/000/004900443.jpg.
I want to save the jpg into a blob in my database.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Function. I have this running a module and called when I need to download
the external image.
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
else:
pass # everything is fine
print response.geturl()
print response.info()
print response.read()
f = open(response.read(),'rb')
#stream = open(response,'rb')
return
db.image.insert(url=url,image=db.image.image_upload.store(f,url))
*I am having a problem with my insert statement. I can't seem to figure
out how to save the image into database.* urllib2.urlopen(req) will
download the file and provide a file object. But I don't know if i can just
save the file or do i need to read the file object within
the urllib2.urlopen(req).
I would like the image to be available to be via
http://mydomain.com/myapp/imageLookup?id=2
http://mydomain.com/myapp/imageLookup?id=2
Controller
def imageLookup():
id = request.vars.id
#response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
Do you have any suggestions? The code abo
[web2py] Re: Saving an image from another database into your database
Thank you for the quick response.
I added the lines above : ( id =
db.image.insert(url=url,image=db.image.image_upload.store(response,filename=url))
db.commit() )
It uploaded the information (url and renamed the file) but I don't believe
it upload the image to the database.
This is what it uploaded. Image_file is empty.
id,url,image_upload,image_file
'1', 'http://eandata.com/image/products/000/000/015/000151122.jpg',
'image.image_upload.94df8d0ebb1047e0.303030303030303135313132322e6a7067.jpg',
Null
This is my model.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Any suggestions?
[web2py] Re: Saving an image from another database into your database
I did not know you were storing it in a blob. Try:
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
id =
db.image.insert(url=url,image_uplaod=db.image.image_upload.store(response,filename=url))
db.commit() # not sure if needed, depends on where executed
return id
def imageLookup():
id = request.vars.id
response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
On Thursday, 5 July 2012 14:16:55 UTC-5, RCTYCO wrote:
Thank you for the quick response.
I added the lines above : ( id =
db.image.insert(url=url,image=db.image.image_upload.store(response,filename=url))
db.commit() )
It uploaded the information (url and renamed the file) but I don't believe
it upload the image to the database.
This is what it uploaded. Image_file is empty.
id,url,image_upload,image_file
'1', 'http://eandata.com/image/products/000/000/015/000151122.jpg',
'image.image_upload.94df8d0ebb1047e0.303030303030303135313132322e6a7067.jpg',
Null
This is my model.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Any suggestions?
[web2py] Re: Saving an image from another database into your database
Thanks.
I need to solve the problem of the file not been uploaded to the blob field.
I believe i am doing it correctly.
I defined the model
db.define_table('image',
Field('url','string'),
Field('image_file','blob'),
Field('image_upload','upload',uploadfield='image_file'))
I stepped through the code for the store function
(db.image.image_upload.store(response,filename=url))).
I expect line 7345 to turn out to be true to it eval to false. So my file
is never uploaded to the blob file.
File: gluon.dal
Line 7345: if isinstance(self.uploadfield,Field):
Line 7346:blob_uploadfield_name = self.uploadfield.uploadfield
Line 7347:keys={self.uploadfield.name: newfilename,
Line 7348: blob_uploadfield_name: file.read()}
Line 7349:self.uploadfield.table.insert(**keys)
I am assuming that I am messing up my define_table. Or I am using the wrong
field when i call the store function.
On Thursday, July 5, 2012 7:36:39 PM UTC-7, Massimo Di Pierro wrote:
I did not know you were storing it in a blob. Try:
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
id =
db.image.insert(url=url,image_uplaod=db.image.image_upload.store(response,filename=url))
db.commit() # not sure if needed, depends on where executed
return id
def imageLookup():
id = request.vars.id
response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
On Thursday, 5 July 2012 14:16:55 UTC-5, RCTYCO wrote:
Thank you for the quick response.
I added the lines above : ( id =
db.image.insert(url=url,image=db.image.image_upload.store(response,filename=url))
db.commit() )
It uploaded the information (url and renamed the file) but I don't
believe it upload the image to the database.
This is what it uploaded. Image_file is empty.
id,url,image_upload,image_file
'1', 'http://eandata.com/image/products/000/000/015/000151122.jpg',
'image.image_upload.94df8d0ebb1047e0.303030303030303135313132322e6a7067.jpg',
Null
This is my model.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Any suggestions?
[web2py] Re: Saving an image from another database into your database
Do I have to do something like
db.define_table('image',
Field('url','string'),
Field('image_file','blob'),
Field('image_upload','upload',uploadfield=
Field('image_file','blob'))
Where i provided a filed in the uploadfield
On Thursday, July 5, 2012 10:30:22 PM UTC-7, RCTYCO wrote:
Thanks.
I need to solve the problem of the file not been uploaded to the blob
field.
I believe i am doing it correctly.
I defined the model
db.define_table('image',
Field('url','string'),
Field('image_file','blob'),
Field('image_upload','upload',uploadfield='image_file'))
I stepped through the code for the store function
(db.image.image_upload.store(response,filename=url))).
I expect line 7345 to turn out to be true to it eval to false. So my file
is never uploaded to the blob file.
File: gluon.dal
Line 7345: if isinstance(self.uploadfield,Field):
Line 7346:blob_uploadfield_name = self.uploadfield.uploadfield
Line 7347:keys={self.uploadfield.name: newfilename,
Line 7348: blob_uploadfield_name: file.read()}
Line 7349:self.uploadfield.table.insert(**keys)
I am assuming that I am messing up my define_table. Or I am using the
wrong field when i call the store function.
On Thursday, July 5, 2012 7:36:39 PM UTC-7, Massimo Di Pierro wrote:
I did not know you were storing it in a blob. Try:
def getImage(url,db):
user_agent = 'Mozilla/4.0 (compatible; MSIE 5.5; Windows NT)'
headers = {'User-Agent': user_agent}
req = urllib2.Request(url,,headers)
try:
response = urllib2.urlopen(req)
except urllib2.URLError, e:
if hasattr(e, 'reason'):
print 'We failed to reach a server.'
print 'Reason: ', e.reason
elif hasattr(e, 'code'):
print 'The server couldn\'t fulfill the request.'
print 'Error code: ', e.code
id =
db.image.insert(url=url,image_uplaod=db.image.image_upload.store(response,filename=url))
db.commit() # not sure if needed, depends on where executed
return id
def imageLookup():
id = request.vars.id
response.headers['Content-Type']='image/jpeg'
return db.image[id].image_file
On Thursday, 5 July 2012 14:16:55 UTC-5, RCTYCO wrote:
Thank you for the quick response.
I added the lines above : ( id =
db.image.insert(url=url,image=db.image.image_upload.store(response,filename=url))
db.commit() )
It uploaded the information (url and renamed the file) but I don't
believe it upload the image to the database.
This is what it uploaded. Image_file is empty.
id,url,image_upload,image_file
'1', 'http://eandata.com/image/products/000/000/015/000151122.jpg',
'image.image_upload.94df8d0ebb1047e0.303030303030303135313132322e6a7067.jpg',
Null
This is my model.
Model
db.define_table('image',
Field('url','string'),
Field('image_upload','upload',uploadfield='image_file'),
Field('image_file','blob'))
Any suggestions?
