MB_MySQL Class Reference

Main package. More...

List of all members.

Public Member Functions
	connect ($user, $pass)
	Connect to the database.
MB_Artist	getArtist (@args)
	Request artist.
MB_Artist	getArtists (@args)
	Request multiple artists.
MB_Release	getRelease (@args)
	Request release.
MB_Release	getReleases (@args)
	Request multiple releases.
MB_Track	getTrack (@args)
	Request track.
MB_Track	getTracks (@args)
	Request multiple tracks.
Public Attributes
	max_rows
	Default maximum limit.

---

Detailed Description

Main package.

Main package.

---

Member Function Documentation

MB_MySQL::connect	(	$	user,
		$	pass
	)

Connect to the database.

user and pass is the login for MySQL.

MB_Artist MB_MySQL::getArtist

(

@

args

)

Request artist.

    use MB_MySQL;
    $mb = MB_MySQL->new;
    $mb->connect('root', 'pass');

    # request an artist via the artists' GID
    $artist = $mb->getArtist(gid => "b10bbbfc-cf9e-42e0-be17-e2c3e1d2600d");
    print $artist->name;   # The Beatles

    # request artist by name
    $artist = $mb->getArtist(name => "John Mayer");
    print $artist->sortname;   # Mayer, John

    # NOTE: The first artist that matches the criteria will be selected.
    # For selecting multiple artists, see getArtists()

MB_Artist MB_MySQL::getArtists

(

@

args

)

Request multiple artists.

    use MB_MySQL;
    $mb = MB_MySQL->new;
    $mb->connect('root', 'pass');

    # request 10 artists where the artist name contains "ever"
    @artists = $mb->getArtists(name => "%ever%", limit => 10);

    foreach $artist (@artists) {
      print $artist->id . ": " . $artist->name . "\n";
    }

MB_Release MB_MySQL::getRelease

(

@

args

)

Request release.

    use MB_MySQL;
    $mb = MB_MySQL->new;
    $mb->connect('root', 'pass');

    # request a release via it's GID, and then connect to the artist
    $release = $mb->getRelease(gid => "83dcff15-7fd0-4131-95a1-03e54ff886ae");
    $artist = $mb->getArtist(id => $release->artist);
    print $release->name . " by " . $artist->name;   # An Other Cup by Yusuf Islam

    # request release by name
    $release = $mb->getRelease(name => "Meteora");
    print $release->gid;   # dd5fd2b3-576e-4354-bc67-68e6f006fd26

    # NOTE: The first release that matches the criteria will be selected.
    # For selecting multiple releases, see getReleases()

MB_Release MB_MySQL::getReleases

(

@

args

)

Request multiple releases.

    use MB_MySQL;
    $mb = MB_MySQL->new;
    $mb->connect('root', 'pass');

    # request 5 releases where the release name is "Greatest Hits" and find artists
    @releases = $mb->getReleases(name => "Greatest Hits", limit => 5);

    foreach $release (@releases) {
      $artist = $mb->getArtist(id => $release->artist);
      print $release->name . ": " . $artist->name . "\n";
    }

MB_Track MB_MySQL::getTrack

(

@

args

)

Request track.

    use MB_MySQL;
    $mb = MB_MySQL->new;
    $mb->connect('root', 'pass');

    # request a track via it's GID, and then connect to the artist
    $track = $mb->getTrack(gid => "54b30c18-4604-48d4-821b-a58707026b69");
    $artist = $mb->getArtist(id => $track->artist);
    print $track->name . " by " . $artist->name;   # Jack Ball by Squatweiler

    # request track by name
    $track = $mb->getTrack(name => "Joker & The Theif");
    print $track->gid;   # 53efdf67-9db6-4182-883d-39b3ae041ac6

    # NOTE: The first track that matches the criteria will be selected.
    # For selecting multiple track, see getTracks()

MB_Track MB_MySQL::getTracks

(

@

args

)

Request multiple tracks.

    use MB_MySQL;
    $mb = MB_MySQL->new;
    $mb->connect('root', 'pass');

    # request 10 tracks where the track name is "Hello" and find artists
    @tracks = $mb->getTracks(name => "Hello", limit => 10);

    foreach $track (@tracks) {
      $artist = $mb->getArtist(id => $track->artist);
      print $track->name . ": " . $artist->name . "\n";
    }

---

Member Data Documentation

MB_MySQL::max_rows

Default maximum limit.

The default limit if there is no limit set. The default value is 100.

    $mb = MB_MySQL->new;
    $mb->max_rows(50);   # Set the default limit to 50

---

The documentation for this class was generated from the following file:

• doc.cpp

---