0009120: SQLite function to return IP path from uuid for UPnP files needed

ID	Project	Category	View Status	Date Submitted	Last Update

0009120	MMW v4	Framework: Scripts/Extensions	public	2012-02-10 21:41	2012-02-13 22:22

Reporter	zvezdan	Assigned To
Priority	high	Severity	minor	Reproducibility	always
Status	assigned	Resolution	open

Summary	0009120: SQLite function to return IP path from uuid for UPnP files needed
Description	Paths for files on UPnP are stored in Songs table as uuid://xxxxxx/0/0/yyyy. However, the same paths are displayed in the tracklist as e.g. http://192.168.0.1:5061/0/0/yyyy. It would be nice if you add some function to the SQlite engine so we could get such more readable IP form of paths in SQL queries. For example: IPPath('uuid://xxxxxx/0/0/yyyy') would return 'http://192.168.0.1:5061/0/0/yyyy'
Tags	No tags attached.

Fixed in build

jiri 2012-02-13 08:18 administrator ~0030381	Ludek, any idea how to best handle this? The suggested approach could make sense?

zvezdan 2012-02-13 22:22 updater ~0030402	Well, if it is easier for you, maybe it would be enough just to add one new API method instead of adding function to the SQLite engine. Actually, it would be nice if you add the inverse function as well to get uuif://.../ form from http://.../. And, when you already there, it would be nice if you add one more function to get the server name from some uuid://... address, that server name is as we could see it in the Media Servers node, e.g. WL700gE which is the name of my UPnP server. You see, currently we have 3 different representations of the same file: 1. the Path field in the Songs table has uuid://... 2. the Path column in the tracklist displays http://192.168.0.1:1234/... 3. the Media Server node displays the server name, which is WL700gE in my case.