Sandbox: Difference between revisions
PavanChander (talk | contribs) m (Proposal:Sandbox moved to Sandbox over redirect) |
PavanChander (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
[[Category:Wiki]] |
[[Category:Wiki]] |
||
⚫ | |||
In mbserver's home directory <code>is a directory called ''svn''</code>. This contains the latest MusicBrainz server code at the time of release. To make sure you have an <code>up-to-date</code> copy: |
|||
<pre>mbserver@brainzvm:~$ cd svn/mb_server |
|||
mbserver@brainzvm:~/svn/mb_server$ svn up |
|||
</pre> |
|||
== Tables (H2) == |
|||
===Artists (H3)=== |
|||
The artist index contains the following fields you can search: |
|||
{| border="1" class="wikitable" |
|||
|+ The table's caption! |
|||
! field !! Description |
|||
|- |
|||
! arid |
|||
| artist id |
|||
|- |
|||
! artist |
|||
| artist name |
|||
|- |
|||
! sortname |
|||
| artist sortname |
|||
|- |
|||
! alias |
|||
| the aliases/misspellings for this artist |
|||
|} |
|||
Artist search terms with no fields specified search the ''artist'', ''sortname'' and ''alias'' fields. |
|||
===Releases (H3)=== |
|||
The release index contains these fields: |
|||
{| border=1 class="wikitable" |
|||
|- |
|||
! field''' !! Description |
|||
|- |
|||
| reid || release id |
|||
|- |
|||
| release || release name |
|||
|- |
|||
| arid || artist id |
|||
|- |
|||
| catno || The catalog number for this release |
|||
|- |
|||
| barcode || The barcode in a release event attached to a release |
|||
|} |
|||
⚫ | |||
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim. |
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim. |
||
=== Ordered === |
=== Ordered (H3) === |
||
# Foo |
# Foo |
||
Line 27: | Line 77: | ||
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim. |
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim. |
||
=== Unordered === |
==== Unordered (H4) ==== |
||
* Foo |
* Foo |
||
Line 41: | Line 91: | ||
*## Barbazfoo |
*## Barbazfoo |
||
==== Misc ==== |
===== Misc (H5) ===== |
||
* Baz |
* Baz |
||
Line 47: | Line 97: | ||
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim. |
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim. |
||
== DTs and DDs (H2) == |
|||
===Artists (H3) === |
|||
: '''tori amos''' |
|||
::* search artist, sortname and alias fields |
|||
: '''comment:electronic''' |
|||
::* search for the word ''electronic'' in artist disambiguation (comment) fields |
|||
: '''begin:1984 AND type:group''' |
|||
::* search for all groups formed in 1984 |
|||
===Releases (H3) === |
|||
:'''café del mar''' |
|||
::* search for all ''Café del Mar'' albums |
|||
:'''"the understanding" AND artist:royksopp''' |
|||
::* search for the album ''The Understanding'' by the artist ''Röyksopp'' |
|||
:'''date:1999 AND country:de AND rock''' |
|||
::* search for releases from Germany in 1999 with the word ''rock'' in them |
Revision as of 20:07, 17 May 2010
In mbserver's home directory is a directory called svn
. This contains the latest MusicBrainz server code at the time of release. To make sure you have an up-to-date
copy:
mbserver@brainzvm:~$ cd svn/mb_server mbserver@brainzvm:~/svn/mb_server$ svn up
Tables (H2)
Artists (H3)
The artist index contains the following fields you can search:
field | Description |
---|---|
arid | artist id |
artist | artist name |
sortname | artist sortname |
alias | the aliases/misspellings for this artist |
Artist search terms with no fields specified search the artist, sortname and alias fields.
Releases (H3)
The release index contains these fields:
field | Description |
---|---|
reid | release id |
release | release name |
arid | artist id |
catno | The catalog number for this release |
barcode | The barcode in a release event attached to a release |
Lists (H2)
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim.
Ordered (H3)
- Foo
- Foobar
- Foobarbaz
- Foobarbaz
- Foobar
- FooBaz
- FooBaz
- Foobarbaz
- Foobarbaz
- FooBaz
- Foobar
- Foobar
- Foobar
- Bar
- Barfoo
- Barfoo
- Baz
- Bazbar
- Foobaz
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim.
Unordered (H4)
- Foo
- Foobar
- Foobar
- Foobarbaz
- Foobar
- Bar
- Barbaz
- Barfoobaz
- Barbaz
- Barbazfoo
- Barbazfoo
- Barbaz
Misc (H5)
- Baz
- Bazfoo
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin venenatis, turpis quis rhoncus dignissim, orci tortor faucibus mi, at facilisis augue enim non erat. Aliquam pharetra tincidunt tortor, eu hendrerit ipsum lobortis quis. Mauris at lacus enim.
DTs and DDs (H2)
Artists (H3)
- tori amos
- search artist, sortname and alias fields
- comment:electronic
- search for the word electronic in artist disambiguation (comment) fields
- begin:1984 AND type:group
- search for all groups formed in 1984
Releases (H3)
- café del mar
- search for all Café del Mar albums
- "the understanding" AND artist:royksopp
- search for the album The Understanding by the artist Röyksopp
- date:1999 AND country:de AND rock
- search for releases from Germany in 1999 with the word rock in them