Database modification feature request

[quickmic 1342]

duplicate post

Edited October 6, 2018 by quickmic

[quickmic 1342]

Hello

 

I'm not sure if this is possible, but at the moment the kodi-databases includes absolute pathes.

Is it possibe to change it to dynamic?

 

example:

MyMusic.db

Table: path / strPath

http://192.168.0.203:80/emby/Audio/317967/

If I change the port or use the same DB from internet I have to modify the DB. Usually I do this via multiple scripts: (I changed my emby server port from 8096 to 80.)

 

example for Music:

update path set 
strPath = replace(strPath, 'http://192.168.0.203:8096', 'http://192.168.0.203:80')

My idea would be store just "/emby/Audio/317967/" and on query build the path dynamically "http://192.168.0.203:80"+ "/emby/Audio/317967/"

The actual server information is available in "plugin.video.emby/data.json" and updates automatically if I fiddle on the server settings.

 

If dynamic pathes not possible, maybe you can trigger a few scripts if server-settings have changed. I can provide you with all my sql-scripts if required.

Edited October 6, 2018 by quickmic

[Angelblue05 4130]

Why not use the Kodi path substitution instead?

[sualfred 677]

If you also use a remote access to your server from outside of you local network (you said from the internet, so I think this is what you mean):

-> DynDNS service with port forwarding. Or even better a reverse proxy. It's never a good idea to open local services on port 80 to the outside.

Edited October 7, 2018 by sualfred

[quickmic 1342]

Yes, I use reverse proxy from Internet site and only 443 is accessible. Port 80 is just for LAN.

 

...path substitution...

I was not aware that this is possible for my use case. I try it out