Quick update: When I type AudioFile.name it brings back the path, but it 
exposes the full path. There has to be a better way? I hope?

On Tuesday, November 18, 2014 6:55:40 PM UTC-5, LoveWeb2py wrote:
>
> Thanks, Massimo!
>
> In my controller am I right in thinking I can have something like this:
>
> def soundControl():
>     sound = db().select(db.sounds.ALL)
>     query = db(db.sounds.id>0).select().first()
>     AudioFile = db.sounds.filename.retrieve(query.filename)[1]
>     soundToPlay = TAG['audio autoplay'](TAG.source(_src=AudioFile))
>     return dict(sound=soundToPlay)
>
> view:
> {{=sound}}
>
> This is what my HTML looks like and its not working:
>
> <audio source><source src="&lt;open file 
> &#x27;C:\\web2py_src\\web2py\\applications\\soundplayer\\databases\\..\\uploads\\sounds.filename.a503ee3bea631f2e.646f6d696e6174696e672e776176.wav&#x27;,
>  
> mode &#x27;rb&#x27; at 0x0000000009F00C90&gt; 
> <http://127.0.0.1:8000/uct6/board/%3Copen%20file%20'C://web2py_src//web2py//applications//uct6//databases//uploads//sounds.filename.a503ee3bea631f2e.646f6d696e6174696e672e776176.wav',%20mode%20'rb'%20at%200x0000000009F00C90%3E>
> "></source></audio source>'
>
> I'm guessing I need to perform one additional step to reference the actual 
> file name in the database? 
>
>
> On Monday, November 17, 2014 11:45:59 PM UTC-5, Massimo Di Pierro wrote:
>>
>> there is a function db.mytable.myfield.retrieve(row.myfield)
>>
>>
>> On Monday, 10 November 2014 10:51:53 UTC-6, LoveWeb2py wrote:
>>>
>>> Here is the code in the link:
>>> db.define_table('music', Field('name',required=True), 
>>> Field('filename','upload',required=True), auth.signature) " > 
>>> applications/audio/models/db_audio.py echo " response.menu = 
>>> [('Home',0,URL('index'))] # allows to browser, search, and upload new music 
>>> (if logged in) def index(): # tell web2py that links to music files are to 
>>> be # represented as HTML5 audio embedded players from 
>>> gluon.contrib.autolinks import expand_one db.music.filename.represent = 
>>> lambda v,r: \ XML(expand_one(URL('download',args=v),{})) return dict(grid = 
>>> SQLFORM.grid(db.music)) # perform login/logout/registration/etc. def 
>>> user(): return dict(form=auth()) # allow streaming of all files, including 
>>> partial content of music files @cache.action() def download(): return 
>>> response.download(request, db) " > 
>>> applications/audio/controllers/default.py 
>>> After a file is uploaded into the DB. How could I access it via a view 
>>> or controller? I tried using the dal, but it doesn't seem to work. Does my 
>>> question make sense?
>>>
>>> On Wednesday, November 5, 2014 11:19:17 PM UTC-5, LoveWeb2py wrote:
>>>>
>>>> *Hello,*
>>>>
>>>> *I'd like to play an audio file in my view once a certain condition is 
>>>> met.*
>>>>
>>>> *I'm using Massimo's audio setup (thank you, Massimo!!) found here:*
>>>>
>>>> *https://www.reddit.com/r/Python/comments/1r7v23/audio_streaming_app_in_web2py_from_scratch/
>>>>  
>>>> <https://www.reddit.com/r/Python/comments/1r7v23/audio_streaming_app_in_web2py_from_scratch/>*
>>>>
>>>> *How could I stream/play the audio from the database where I uploaded 
>>>> the files. I would post my model/controller but its all in the link above.*
>>>>
>>>

-- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to