Hi Richard,
I was finally able to make this work this way:
filename =
os.path.join(request.folder,'static/images/files/{}'.format(file[1]))
stream = open(filename, 'rb')
db.vendor.insert(default_name = vendor[0], logo=stream)
When I print the path, there is both forward slashes and backslashes in the
path. I'm not sure if that is correct behaviour, but it works.
Any suggestions how you could do this in a better way?
- Marko
torstai 31. maaliskuuta 2016 16.26.09 UTC+3 Richard kirjoitti:
>
> Should be URL('static','images/files/{*0*}'.format(file[1]))
>
> Richard
>
> On Thu, Mar 31, 2016 at 6:34 AM, Marko Seppälä <[email protected]
> <javascript:>> wrote:
>
>> Hi,
>>
>> I want to upload some of the images programmatically from file system,
>> when initializing the database. Not the actual file though, just normal
>> upload so that file stays in file system but it's accessible via database
>> for every user.
>>
>> I tried something like this:
>>
>> db.define_table('image',
>> Field('name'),
>> Field('file', 'upload')
>> )
>>
>> FILES = [
>> ['apple', 'apple.png'],
>> ['dog', 'gog-image.png'],
>> ...
>> ]
>>
>> if db(db.image.id>0).count() == 0:
>> for file in FILES:
>> filename = URL('static','images/files/{}'.format(file[1]))
>> stream = open(filename, 'rb')
>> db.image.insert(name=file[0], file=stream)
>>
>> I'll get an error:
>> * <type 'exceptions.IOError'> [Errno 2] No such file or directory:
>> '/example/static/images/files/apple.png'*
>>
>> It looks like my path is broken and I should use os.path.join etc. to get
>> the whole path. But I couldn't make this work.
>> What is the correct way to set that path? For example, how it is done by
>> web2py since everything works normally if I upload those images via admin
>> interface? I'm working on Windows environment.
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
