Re: [Banshee-List] update music library

[Yves Alter <altery ethz ch>]

You might want to try something like this (I don't know if this works
in sqlite though):

UPDATE CoreTracks SET URI = replace(URI, 'file:///media/DATA/daten/',
'file:///media/Daten/')



2009/1/30 Paul Lange <palango gmx de>:
> Am Freitag, den 30.01.2009, 18:52 +0100 schrieb Yves Alter:
>> The Banshee SQLite DB is stored in ~/.config/banshee-1/banshee.db.
>> You'd have to execute a query on it, that replaces the URI of the
>> offending tracks. The URI column is stored in the 'CoreTracks' table.
>> The tool 'sqlitebrowser' allows you to inspect the contents of the DB
>> graphically. But without SQL experience it's probably hard to create a
>> query that suits your needs and you might want to consider changing
>> the values manually, if there are only a few tracks which are affected
>> of this problem. And make a backup of the DB file before you mess
>> around with it :)
>
> I ran this query now: SELECT "Uri" FROM "CoreTracks" WHERE "Uri" LIKE
> "file:///media/DATA%"
>
> And it shows that 1000 songs have the old location in it. (out of
> ~3000).
> So I need some kind of query.
>
> Paul
>
> _______________________________________________
> banshee-list mailing list
> banshee-list gnome org
> http://mail.gnome.org/mailman/listinfo/banshee-list
>
>