On Tue, 2002-02-05 at 15:18, michael wrote: > Robert Kaye <[EMAIL PROTECTED]> writes: > > On Fri, 2002-01-25 at 16:18, michael wrote: > > > 1. AddFile makes some assumptions that won't work well for my mp3 > > > setup and I'll likely have to roll my own script to populate the db. > > > > What assumptions is it making, and why won't it work for you? > > ok, so here's my weird setup. > I have lots and lots of cd's and not a whole lot of disk space. and I > rip them all with high-quality settings. > so I have a song "foo". it appears on the album "bar". it's also on > the album "the best of bar" and on the compilation "punk bands perform > your favourite polkas". rather than have three identical copies of > the same song on my hard drives, I just have one. those who insist on > havering the album name in the directory path, can accomplish this > with symlinks, but in my case I realized that an album is just a fancy > form of playlist, and store my files under artist-name/track-name.mp3 and > have albums represented as album.m3u.
Ahh, I see what you mean. My philosophy has been that disk space is cheap and my programming time is limited, thus there is no support for that yet. :-) > so based on my rambling above, I discovered that if I have two entries > in "Track" with the same Url and different Album and TrackNum, obs > will deal with it just fine. but I also realized that this goes > against how db's are supposed to work, and so I tried to do things a > bit more "properly" and created a table called "AlbumTracks" which > contains three columns. "Album" is and Id from the Album table, > "Track" is an Id from the Track table, and "TrackNum". > (I was able to populate this with a "select into" from the existing > info in the db.) This is defintely the 'proper' way of doing things -- its the way that I did it in MusicBrainz. > if no one here tells me that I'm completely off my rocker and going > about this totally backwards, I'll finish checking the sql in the > admin/ dir and do an alter table to drop those two fields from the > Track table. if that all works well, I'll post the patch here. > assuming of course that this is something that anyone besides me is > interested in. You're not off your rocker -- I'd like to see those changes, please. > since we're on the subject of duplicate files, and obs seems closely > in touch with freeamp, are there any plans to stick a (relatable?) > fingerprint into the Track table somewhere so that something like > AddFile can make more intelligent decisions about what constitutes a > duplicate entry? I hadn't thought about it, but it should be an easy thing to do. Feel free to do just that. You may want to look at the trmgen utility at mayhem-chaos.sf.net for generating trm ids. -- --ruaok Freezerburn! All else is only icing. -- Soul Coughing Robert Kaye -- [EMAIL PROTECTED] -- http://www.mayhem-chaos.net _______________________________________________ Obs-dev mailing list [EMAIL PROTECTED] http://www.freeamp.org/mailman/listinfo/obs-dev
