#musicbrainz

:P

Looking for some help please. From someone who knows the Database schema.

Ask and I'm sure someone will be able to help :)

Nickii: I’m sorry, this is the room for bullshitting about Steam, apparently. Not talking about Musicbrainz. ;-)

j/k of course.

I'm looking for the Db Table that links A track to it's album.

I am using the raw files.

you mean a track to a medium?

depending on exactly what you're doing, you may need any/all of: track, tracklist, recording, medium, release

I will see if I can give an example...

each medium is linked to a release and to a tracklist; each track is linked to a recording and a tracklist

so it depends what you mean by 'track', by 'album', and by 'link' :)

lol

ACtually... Where can I find the field names in the Tracks table?

reosarevok: your "part-of" relationship thing is done by the way, but I'm not sure if I should release it to the public like this. It adds a "part of <work>" comment to the list dynamically, but doesn't load the ones that already exist in the db

kovacsur, can I get a pastebin version for now? :)

Nickii: make sure you take a look at http://wiki.musicbrainz.org/-/images/5/52/ngs.png

(I agree that loading them would be pretty awesome though for a released one)

Nickii: you'll find that the track names are in the track_name table :)

reosarevok: http://pastebin.com/5xZnWq0V

Awesome :D

4 presents in a day! (2 userscripts, 2 steam games)

I shouldn't go to sleep tonight!

kepstin Thank you.

:p

Nickii: you should probably get yourself a copy of the database to look around in

http://wiki.musicbrainz.org/Image:ngs.png has the relevant chunks of our schema, though

which will probably help you a lot :)

iancorvidae Thank you. I have downloaded a copy of the raw text files from the MusicDb ftp server which I am using.

that doesn't give you the schema or let you query it, etc. :)

I can gift Frozen Synapse to anyone who's interested in that sort of thing/game :)

So I'm sitting here, reading this conversation with Nickii.

My brain realizes something is off, both the capitalization and the fact that I knew nikki already had and used a copy of the MBz DB.

Yet, I just can't figure out what the problem is.

:p

Then my brain catches up with itself and realizes that Nickii != nikki...

heheh

confused me for a bit there, too

VxJasonxV This is my first time here. :-)

So I gathered. Welcome!

The db schema lists "name" as a field but I don't see any Track names in the file i have.

name is a link to the track_name table

so it is a number; the track name is the 'page' column of the track_name row with the corresponding number in the 'id' column

iamcorvidae I know that now but does that mean the schema is out of date?

no, that's how it should be

Oh.

the track_name table is designed to make the same name, used more than once, be stored only once

it's also used by the 'name' column of the 'recording' table, as the image I linked shows

So is trackname.page the Track Title?

Sorry track_name.page

yes, that should be correct

oh, pardon, it's the column 'name'

the image I linked is out of date :)

Thank you, that is what I suspected.

so yeah, track.name points to track_name.id; track_name.name has the actual name

Is the current schema with the field names of each table listed somewhere?

that should be actually correct

it's probably in a sql file in the codebase

lemme look

Thank you again.

So, assuming there is a new schema in place, I am looking for the link between a Track and the album it comes from.

yeah, it's in admin/sql/CreateTables.sql

the image I linked is very close to accurate; that page vs. name difference is the first incorrect thing I've seen

ianmcorvidae: can you add a note indicating that change to the page where that is linked from?

reosarevok: in a few, sure

:)

Nickii: what piece of information are you starting with? A title, a specific recording, what?

and what piece of information do you want to get from this

otherwise it's hard to answer your question :)

stupid idlerpg

iancorvidae I first want to note that I am dealing with the raw text files, not any SQL tables.

the text files are dumped from the SQL tables; the schema's the same :)

In the files that I have, I have files like track,track_name,artist,release etc.

haha, I've “played” one

and I am importing these into MS Access.

yeah, those are the names of the SQL tables those files were dumped from

So, I want to make an MS Access Database from these files.

Although well, I guess it is like Farmville, without the clicking

These files do not have the field names listed so I am goint from research.

going*

yes, the column names are listed in the file admin/sql/CreateTables.sql, in the source code for the server

I will look there first, before I go futher.

(er, some tables will also be listed in admin/sql/vertical/rawdata/CreateTables.sql)

direct link to the file I mentioned: http://git.musicbrainz.org/gitweb/?p=musicbrain...

Where are they on the ftp server?

I can't see /pub/musicbrainz/admin

they aren't on the ftp server, this is from the codebase

you'll need to get them from git

Oh.

These files should be available on the FTP server. :-)

github will turn a git repo into a downloadable bundle for you

generally people don't want them separate from the rest of the codebase, which it's a lot more reasonable to get from git :P

and iirc mbz is on github

it is, under metabrainz/musicbrainz-server (as I recall)

VxJasonxV: yea i thgohut about Nickii != nikki too

heh

ianmcorvidae, indeed

and aw man, all this talk about steam now i wabnt to join and be like a part of stuff

and I made that same mistake. AGAIN

but alas i sucka t games so hard

:/

thankfully it was recently updated, so I saw metabrainz in the sidebar :D

oh and yea

http://www.flickr.com/photos/mayhem/6596198901 <-- are those machines?

yes

CatCat: I think they are the 12 new servers :)

zomg

^ +1

can we please call one of the Perry?!

them*

Lego Harry Potter is amazingly fun.

you know perry

yes, yes it is

it really, really is

ianmorvdae Thank you again.

it's the most fun once you *finally* get a char with dark magic so you can finally get stuff

CatCat, ask ruaok, but I wouldn't say no to it :p

I haven't played any lego games, and I can probably blame pricing on thath

they're about as expensiver as any other game though

also if you buy used they're rather cheap

I mean the steam/EA pricing, as in $=€

we get like lego batman and lego indiana jones at 199 NOK or something

uh o play it as consol though

yeah, I don't have any consoles.

s/o/I/

weirdo :P

jk

or many physical copies of games

haha

but i dont think dollah equals euro??

does for valve

CatCat, tell that to some of the companies that sell games in Steam :p

i don't get it

huh, weird

it gets converted into nok for me anyway

I'm getting a lot of /fast/ 502 errors right now

If it costs $50 in US, it costs �50 in Spain / Estonia sometimes

Which is stupid

even weirder, $=2x$, if you are australian

kepstin: same

so.. whatdoes that mean? if something costs like 3 euro and 3 usd?

i get it for 3 nok or whaat ? XD

and inline searches aren't working for me atm :/