Changeset 16

Show
Ignore:
Timestamp:
07/03/07 10:25:10 (5 years ago)
Author:
dlefevre
Message:

audio_ prefix added to the existing tables

Location:
mymrc/trunk/mymrc/src/db
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • mymrc/trunk/mymrc/src/db/audioqueries.py

    r14 r16  
    88     
    99    def allSongs(self): 
    10         query = """SELECT song.id AS id, 
    11        song.path AS path, 
    12        artist.name AS artist, 
    13        song.title AS title, 
    14        album.title AS album, 
    15        song.track_no AS track, 
    16        genre.name AS genre, 
    17        song.time AS time 
    18 FROM song, artist, album, genre 
    19 WHERE song.artist_id = artist.id AND 
    20       song.album_id = album.id AND 
    21       song.genre_id = genre.id 
    22 ORDER BY artist.name, album.title, song.title;""" 
     10        query = """SELECT audio_song.id AS id, 
     11       audio_song.path AS path, 
     12       audio_artist.name AS artist, 
     13       audio_song.title AS title, 
     14       audio_album.title AS album, 
     15       audio_song.track_no AS track, 
     16       audio_genre.name AS genre, 
     17       audio_song.time AS time 
     18FROM audio_song, audio_artist, audio_album, audio_genre 
     19WHERE audio_song.artist_id = audio_artist.id AND 
     20      audio_song.album_id = audio_album.id AND 
     21      audio_song.genre_id = audio_genre.id 
     22ORDER BY audio_artist.name, audio_album.title, audio_song.title;""" 
    2323        return self._iDB.execute(query) 
    2424     
    2525    def albums(self): 
    26         query = """SELECT title FROM album;""" 
     26        query = """SELECT title FROM audio_album;""" 
    2727        return self._iDB.execute(query)   
    2828     
    2929    ## Get all songs from an album 
    3030    def albumSongs(self, aAlbumTitle): 
    31         query = """SELECT song.id AS id, 
    32        song.path AS path, 
    33        artist.name AS artist, 
    34        song.title AS title, 
    35        album.title AS album, 
    36        song.track_no AS track, 
    37        genre.name AS genre, 
    38        song.time AS time 
    39 FROM song, artist, album, genre 
    40 WHERE song.artist_id = artist.id AND 
    41       song.album_id = album.id AND 
    42       song.album_id IN (SELECT id FROM album WHERE title = '%s') AND 
    43       song.genre_id = genre.id 
    44 ORDER BY artist.name, album.title, song.title;""" 
     31        query = """SELECT audio_song.id AS id, 
     32       audio_song.path AS path, 
     33       audio_artist.name AS artist, 
     34       audio_song.title AS title, 
     35       audio_album.title AS album, 
     36       audio_song.track_no AS track, 
     37       audio_genre.name AS genre, 
     38       audio_song.time AS time 
     39FROM audio_song, audio_artist, audio_album, audio_genre 
     40WHERE audio_song.artist_id = audio_artist.id AND 
     41      audio_song.album_id = audio_album.id AND 
     42      audio_song.album_id IN (SELECT id FROM audio_album WHERE title = '%s') AND 
     43      audio_song.genre_id = audio_genre.id 
     44ORDER BY audio_artist.name, audio_album.title, audio_song.title;""" 
    4545        return self._iDB.execute(query%(aAlbumTitle))       
    4646     
    4747    def artists(self): 
    48         query = """SELECT name FROM artist;""" 
     48        query = """SELECT name FROM audio_artist;""" 
    4949        return self._iDB.execute(query)    
    5050     
    5151    ## Get all songs from an artist 
    5252    def artistAllSongs(self, aArtistName): 
    53         query = """ SELECT song.id AS id, 
    54        song.path AS path, 
    55        artist.name AS artist, 
    56        song.title AS title, 
    57        album.title AS album, 
    58        song.track_no AS track, 
    59        genre.name AS genre, 
    60        song.time AS time 
    61 FROM song, artist, album, genre 
    62 WHERE song.artist_id = artist.id AND 
    63       song.artist_id = (SELECT id FROM artist WHERE name = '%s') AND 
    64       song.album_id = album.id AND 
    65       song.genre_id = genre.id 
    66 ORDER BY album.title, song.title;""" 
     53        query = """ SELECT audio_song.id AS id, 
     54       audio_song.path AS path, 
     55       audio_artist.name AS artist, 
     56       audio_song.title AS title, 
     57       audio_album.title AS album, 
     58       audio_song.track_no AS track, 
     59       audio_genre.name AS genre, 
     60       audio_song.time AS time 
     61FROM audio_song, audio_artist, audio_album, audio_genre 
     62WHERE audio_song.artist_id = audio_artist.id AND 
     63      audio_song.artist_id = (SELECT id FROM audio_artist WHERE name = '%s') AND 
     64      audio_song.album_id = audio_album.id AND 
     65      audio_song.genre_id = audio_genre.id 
     66ORDER BY audio_album.title, audio_song.title;""" 
    6767        return self._iDB.execute(query%(aArtistName)) 
    6868     
    … …  
    7070    ## Get the list of all albums from a given artist. 
    7171    def artistAlbums(self, aArtistName): 
    72         query = """SELECT album.title AS album 
    73 FROM artist, album, song 
    74 WHERE song.album_id = album.id AND 
    75       song.artist_id = artist.id AND 
    76       song.artist_id = (SELECT id FROM artist WHERE name = '%s') 
    77 ORDER BY album.title;""" 
     72        query = """SELECT audio_album.title AS album 
     73FROM audio_artist, audio_album, audio_song 
     74WHERE audio_song.album_id = audio_album.id AND 
     75      audio_song.artist_id = audio_artist.id AND 
     76      audio_song.artist_id = (SELECT id FROM audio_artist WHERE name = '%s') 
     77ORDER BY audio_album.title;""" 
    7878        return self._iDB.execute(query%(aArtistName))    
    7979     
    … …  
    8383    #  have any songs anyway 
    8484    def genres(self): 
    85         query = """SELECT genre.name AS genre 
    86 FROM genre 
    87 WHERE id IN (SELECT DISTINCT genre_id FROM song) 
    88 ORDER BY genre.name;""" 
     85        query = """SELECT audio_genre.name AS genre 
     86FROM audio_genre 
     87WHERE id IN (SELECT DISTINCT genre_id FROM audio_song) 
     88ORDER BY audio_genre.name;""" 
    8989        return self._iDB.execute(query) 
    9090     
    … …  
    9292    ## Get all songs from a genre 
    9393    def genreSongs(self, aGenre): 
    94         query = """SELECT song.id AS id, 
    95        song.path AS path, 
    96        artist.name AS artist, 
    97        song.title AS title, 
    98        album.title AS album, 
    99        song.track_no AS track, 
    100        genre.name AS genre, 
    101        song.time AS time 
    102 FROM song, artist, album, genre 
    103 WHERE song.artist_id = artist.id AND 
    104       song.album_id = album.id AND 
    105       song.genre_id = genre.id AND 
    106       song.artist_id = (SELECT id FROM genre WHERE name = '%s') 
    107 ORDER BY album.title, song.title;""" 
     94        query = """SELECT audio_song.id AS id, 
     95       audio_song.path AS path, 
     96       audio_artist.name AS artist, 
     97       audio_song.title AS title, 
     98       audio_album.title AS album, 
     99       audio_song.track_no AS track, 
     100       audio_genre.name AS genre, 
     101       audio_song.time AS time 
     102FROM audio_song, audio_artist, audio_album, audio_genre 
     103WHERE audio_song.artist_id = audio_artist.id AND 
     104      audio_song.album_id = audio_album.id AND 
     105      audio_song.genre_id = audio_genre.id AND 
     106      audio_song.artist_id = (SELECT id FROM audio_genre WHERE name = '%s') 
     107ORDER BY audio_album.title, audio_song.title;""" 
    108108        return self._iDB.execute(query%(aGenre)) 
    109109     
    … …  
    116116    ## Get all available playlists. 
    117117    def playlists(self): 
    118         query="""SELECT name FROM playlist ORDER BY name;""" 
     118        query="""SELECT name FROM audio_playlist ORDER BY name;""" 
    119119        return self._iDB.execute(query) 
    120120     
    … …  
    123123    #  NOTE: this is not tested, just a guess. 
    124124    def playlistSongs(self): 
    125         query="""SELECT song.id AS id, 
    126        song.path AS path, 
    127        artist.name AS artist, 
    128        song.title AS title, 
    129        album.title AS album, 
    130        song.track_no AS track, 
    131        genre.name AS genre, 
    132        song.time AS time 
    133 FROM song, artist, album, genre, playlist_data 
    134 WHERE song.artist_id = artist.id AND 
    135       song.album_id = album.id AND 
    136       song.genre_id = genre.id AND 
    137       song.id = playlist_data.song_id AND 
    138       playlist_data.playlist_id = <ID of the selected playlist> 
    139 ORDER BY artist.name, album.title, song.title;""" 
     125        query="""SELECT audio_song.id AS id, 
     126       audio_song.path AS path, 
     127       audio_artist.name AS artist, 
     128       audio_song.title AS title, 
     129       audio_album.title AS album, 
     130       audio_song.track_no AS track, 
     131       audio_genre.name AS genre, 
     132       audio_song.time AS time 
     133FROM audio_song, audio_artist, audio_album, audio_genre, audio_playlist_data 
     134WHERE audio_song.artist_id = audio_artist.id AND 
     135      audio_song.album_id = audio_album.id AND 
     136      audio_song.genre_id = audio_genre.id AND 
     137      audio_song.id = audio_playlist_data.song_id AND 
     138      audio_playlist_data.playlist_id = <ID of the selected playlist> 
     139ORDER BY audio_artist.name, audio_album.title, audio_song.title;""" 
    140140        return self._iDB.execute(query) 
    141141     
    142142    def songById(self, aId): 
    143         query = """ SELECT path FROM song WHERE id=%s""" %(aId) 
     143        query = """ SELECT path FROM audio_song WHERE id=%s""" %(aId) 
    144144        return self._iDB.execute(query).fetchall() 
    145145 

  • mymrc/trunk/mymrc/src/db/dbdriver.py

    r14 r16  
    66 
    77 
    8 CREATE TABLE artist( 
     8CREATE TABLE audio_artist( 
    99        id integer not null primary key autoincrement, 
    1010        name varchar(100) not null 
    … …  
    1212 
    1313 
    14 CREATE TABLE album( 
     14CREATE TABLE audio_album( 
    1515        id integer not null primary key autoincrement, 
    1616        title varchar(50) not null 
    1717); 
    1818 
    19 CREATE TABLE genre( 
     19CREATE TABLE audio_genre( 
    2020        id integer unique, 
    2121        name varchar(30) not null 
    2222); 
    2323 
    24 CREATE TABLE song( 
    25         id integer not null primary key autoincrement, 
    26         artist_id integer not null references artist default -1, 
     24CREATE TABLE audio_song( 
     25        id integer not null primary key autoincrement, 
     26        artist_id integer not null references audio_artist default -1, 
    2727        title varchar(100) not null, 
    2828        path varchar(255) not null, 
    29         album_id integer not null references album default -1, 
     29        album_id integer not null references audio_album default -1, 
    3030        track_no integer, 
    31         genre_id integer not null references genre default -1, 
     31        genre_id integer not null references audio_genre default -1, 
    3232        time integer 
    3333); 
    3434 
    35 CREATE TABLE playlist( 
     35CREATE TABLE audio_playlist( 
    3636        id integer not null primary key autoincrement, 
    3737        name varchar(30) not null 
    3838); 
    3939 
    40 CREATE TABLE playlist_data( 
     40CREATE TABLE audio_playlist_data( 
    4141        id integer not null primary key autoincrement, 
    4242        playlist_id integer not null references playlist, 
    … …  
    5151-- 
    5252 
    53 INSERT INTO artist(id, name) VALUES(-1, 'Unknown'); 
    54 INSERT INTO album(id, title) VALUES(-1, 'Unknown'); 
    55  
    56 INSERT INTO genre(id, name) VALUES(-1, 'Unknown'); 
    57 INSERT INTO genre(id, name) VALUES(0, 'Blues'); 
    58 INSERT INTO genre(id, name) VALUES(1, 'Classic Rock'); 
    59 INSERT INTO genre(id, name) VALUES(2, 'Country'); 
    60 INSERT INTO genre(id, name) VALUES(3, 'Dance'); 
    61 INSERT INTO genre(id, name) VALUES(4, 'Disco'); 
    62 INSERT INTO genre(id, name) VALUES(5, 'Funk'); 
    63 INSERT INTO genre(id, name) VALUES(6, 'Grunge'); 
    64 INSERT INTO genre(id, name) VALUES(7, 'Hip-Hop'); 
    65 INSERT INTO genre(id, name) VALUES(8, 'Jazz'); 
    66 INSERT INTO genre(id, name) VALUES(9, 'Metal'); 
    67 INSERT INTO genre(id, name) VALUES(10, 'New Age'); 
    68 INSERT INTO genre(id, name) VALUES(11, 'Oldies'); 
    69 INSERT INTO genre(id, name) VALUES(12, 'Other'); 
    70 INSERT INTO genre(id, name) VALUES(13, 'Pop'); 
    71 INSERT INTO genre(id, name) VALUES(14, 'R&B'); 
    72 INSERT INTO genre(id, name) VALUES(15, 'Rap'); 
    73 INSERT INTO genre(id, name) VALUES(16, 'Reggae'); 
    74 INSERT INTO genre(id, name) VALUES(17, 'Rock'); 
    75 INSERT INTO genre(id, name) VALUES(18, 'Techno'); 
    76 INSERT INTO genre(id, name) VALUES(19, 'Industrial'); 
    77 INSERT INTO genre(id, name) VALUES(20, 'Alternative'); 
    78 INSERT INTO genre(id, name) VALUES(21, 'Ska'); 
    79 INSERT INTO genre(id, name) VALUES(22, 'Death Metal'); 
    80 INSERT INTO genre(id, name) VALUES(23, 'Pranks'); 
    81 INSERT INTO genre(id, name) VALUES(24, 'Soundtrack'); 
    82 INSERT INTO genre(id, name) VALUES(25, 'Euro-Techno'); 
    83 INSERT INTO genre(id, name) VALUES(26, 'Ambient'); 
    84 INSERT INTO genre(id, name) VALUES(27, 'Trip-Hop'); 
    85 INSERT INTO genre(id, name) VALUES(28, 'Vocal'); 
    86 INSERT INTO genre(id, name) VALUES(29, 'Jazz+Funk'); 
    87 INSERT INTO genre(id, name) VALUES(30, 'Fusion'); 
    88 INSERT INTO genre(id, name) VALUES(31, 'Trance'); 
    89 INSERT INTO genre(id, name) VALUES(32, 'Classical'); 
    90 INSERT INTO genre(id, name) VALUES(33, 'Instrumental'); 
    91 INSERT INTO genre(id, name) VALUES(34, 'Acid'); 
    92 INSERT INTO genre(id, name) VALUES(35, 'House'); 
    93 INSERT INTO genre(id, name) VALUES(36, 'Game'); 
    94 INSERT INTO genre(id, name) VALUES(37, 'Sound Clip'); 
    95 INSERT INTO genre(id, name) VALUES(38, 'Gospel'); 
    96 INSERT INTO genre(id, name) VALUES(39, 'Noise'); 
    97 INSERT INTO genre(id, name) VALUES(40, 'AlternRock'); 
    98 INSERT INTO genre(id, name) VALUES(41, 'Bass'); 
    99 INSERT INTO genre(id, name) VALUES(42, 'Soul'); 
    100 INSERT INTO genre(id, name) VALUES(43, 'Punk'); 
    101 INSERT INTO genre(id, name) VALUES(44, 'Space'); 
    102 INSERT INTO genre(id, name) VALUES(45, 'Meditative'); 
    103 INSERT INTO genre(id, name) VALUES(46, 'Instrumental Pop'); 
    104 INSERT INTO genre(id, name) VALUES(47, 'Instrumental Rock'); 
    105 INSERT INTO genre(id, name) VALUES(48, 'Ethnic'); 
    106 INSERT INTO genre(id, name) VALUES(49, 'Gothic'); 
    107 INSERT INTO genre(id, name) VALUES(50, 'Darkwave'); 
    108 INSERT INTO genre(id, name) VALUES(51, 'Techno-Industrial'); 
    109 INSERT INTO genre(id, name) VALUES(52, 'Electronic'); 
    110 INSERT INTO genre(id, name) VALUES(53, 'Pop-Folk'); 
    111 INSERT INTO genre(id, name) VALUES(54, 'Eurodance'); 
    112 INSERT INTO genre(id, name) VALUES(55, 'Dream'); 
    113 INSERT INTO genre(id, name) VALUES(56, 'Southern Rock'); 
    114 INSERT INTO genre(id, name) VALUES(57, 'Comedy'); 
    115 INSERT INTO genre(id, name) VALUES(58, 'Cult'); 
    116 INSERT INTO genre(id, name) VALUES(59, 'Gangsta'); 
    117 INSERT INTO genre(id, name) VALUES(60, 'Top 40'); 
    118 INSERT INTO genre(id, name) VALUES(61, 'Christian Rap'); 
    119 INSERT INTO genre(id, name) VALUES(62, 'Pop/Funk'); 
    120 INSERT INTO genre(id, name) VALUES(63, 'Jungle'); 
    121 INSERT INTO genre(id, name) VALUES(64, 'Native American'); 
    122 INSERT INTO genre(id, name) VALUES(65, 'Cabaret'); 
    123 INSERT INTO genre(id, name) VALUES(66, 'New Wave'); 
    124 INSERT INTO genre(id, name) VALUES(67, 'Psychadelic'); 
    125 INSERT INTO genre(id, name) VALUES(68, 'Rave'); 
    126 INSERT INTO genre(id, name) VALUES(69, 'Showtunes'); 
    127 INSERT INTO genre(id, name) VALUES(70, 'Trailer'); 
    128 INSERT INTO genre(id, name) VALUES(71, 'Lo-Fi'); 
    129 INSERT INTO genre(id, name) VALUES(72, 'Tribal'); 
    130 INSERT INTO genre(id, name) VALUES(73, 'Acid Punk'); 
    131 INSERT INTO genre(id, name) VALUES(74, 'Acid Jazz'); 
    132 INSERT INTO genre(id, name) VALUES(75, 'Polka'); 
    133 INSERT INTO genre(id, name) VALUES(76, 'Retro'); 
    134 INSERT INTO genre(id, name) VALUES(77, 'Musical'); 
    135 INSERT INTO genre(id, name) VALUES(78, 'Rock & Roll'); 
    136 INSERT INTO genre(id, name) VALUES(79, 'Hard Rock'); 
    137 INSERT INTO genre(id, name) VALUES(80, 'Folk'); 
    138 INSERT INTO genre(id, name) VALUES(81, 'Folk-Rock'); 
    139 INSERT INTO genre(id, name) VALUES(82, 'National Folk'); 
    140 INSERT INTO genre(id, name) VALUES(83, 'Swing'); 
    141 INSERT INTO genre(id, name) VALUES(84, 'Fast Fusion'); 
    142 INSERT INTO genre(id, name) VALUES(85, 'Bebob'); 
    143 INSERT INTO genre(id, name) VALUES(86, 'Latin'); 
    144 INSERT INTO genre(id, name) VALUES(87, 'Revival'); 
    145 INSERT INTO genre(id, name) VALUES(88, 'Celtic'); 
    146 INSERT INTO genre(id, name) VALUES(89, 'Bluegrass'); 
    147 INSERT INTO genre(id, name) VALUES(90, 'Avantgarde'); 
    148 INSERT INTO genre(id, name) VALUES(91, 'Gothic Rock'); 
    149 INSERT INTO genre(id, name) VALUES(92, 'Progressive Rock'); 
    150 INSERT INTO genre(id, name) VALUES(93, 'Psychedelic Rock'); 
    151 INSERT INTO genre(id, name) VALUES(94, 'Symphonic Rock'); 
    152 INSERT INTO genre(id, name) VALUES(95, 'Slow Rock'); 
    153 INSERT INTO genre(id, name) VALUES(96, 'Big Band'); 
    154 INSERT INTO genre(id, name) VALUES(97, 'Chorus'); 
    155 INSERT INTO genre(id, name) VALUES(98, 'Easy Listening'); 
    156 INSERT INTO genre(id, name) VALUES(99, 'Acoustic'); 
    157 INSERT INTO genre(id, name) VALUES(100, 'Humour'); 
    158 INSERT INTO genre(id, name) VALUES(101, 'Speech'); 
    159 INSERT INTO genre(id, name) VALUES(102, 'Chanson'); 
    160 INSERT INTO genre(id, name) VALUES(103, 'Opera'); 
    161 INSERT INTO genre(id, name) VALUES(104, 'Chamber Music'); 
    162 INSERT INTO genre(id, name) VALUES(105, 'Sonata'); 
    163 INSERT INTO genre(id, name) VALUES(106, 'Symphony'); 
    164 INSERT INTO genre(id, name) VALUES(107, 'Booty Bass'); 
    165 INSERT INTO genre(id, name) VALUES(108, 'Primus'); 
    166 INSERT INTO genre(id, name) VALUES(109, 'Porn Groove'); 
    167 INSERT INTO genre(id, name) VALUES(110, 'Satire'); 
    168 INSERT INTO genre(id, name) VALUES(111, 'Slow Jam'); 
    169 INSERT INTO genre(id, name) VALUES(112, 'Club'); 
    170 INSERT INTO genre(id, name) VALUES(113, 'Tango'); 
    171 INSERT INTO genre(id, name) VALUES(114, 'Samba'); 
    172 INSERT INTO genre(id, name) VALUES(115, 'Folklore'); 
    173 INSERT INTO genre(id, name) VALUES(116, 'Ballad'); 
    174 INSERT INTO genre(id, name) VALUES(117, 'Power Ballad'); 
    175 INSERT INTO genre(id, name) VALUES(118, 'Rhythmic Soul'); 
    176 INSERT INTO genre(id, name) VALUES(119, 'Freestyle'); 
    177 INSERT INTO genre(id, name) VALUES(120, 'Duet'); 
    178 INSERT INTO genre(id, name) VALUES(121, 'Punk Rock'); 
    179 INSERT INTO genre(id, name) VALUES(122, 'Drum Solo'); 
    180 INSERT INTO genre(id, name) VALUES(123, 'A capella'); 
    181 INSERT INTO genre(id, name) VALUES(124, 'Euro-House'); 
    182 INSERT INTO genre(id, name) VALUES(125, 'Dance Hall'); 
     53INSERT INTO audio_artist(id, name) VALUES(-1, 'Unknown'); 
     54INSERT INTO audio_album(id, title) VALUES(-1, 'Unknown'); 
     55 
     56INSERT INTO audio_genre(id, name) VALUES(-1, 'Unknown'); 
     57INSERT INTO audio_genre(id, name) VALUES(0, 'Blues'); 
     58INSERT INTO audio_genre(id, name) VALUES(1, 'Classic Rock'); 
     59INSERT INTO audio_genre(id, name) VALUES(2, 'Country'); 
     60INSERT INTO audio_genre(id, name) VALUES(3, 'Dance'); 
     61INSERT INTO audio_genre(id, name) VALUES(4, 'Disco'); 
     62INSERT INTO audio_genre(id, name) VALUES(5, 'Funk'); 
     63INSERT INTO audio_genre(id, name) VALUES(6, 'Grunge'); 
     64INSERT INTO audio_genre(id, name) VALUES(7, 'Hip-Hop'); 
     65INSERT INTO audio_genre(id, name) VALUES(8, 'Jazz'); 
     66INSERT INTO audio_genre(id, name) VALUES(9, 'Metal'); 
     67INSERT INTO audio_genre(id, name) VALUES(10, 'New Age'); 
     68INSERT INTO audio_genre(id, name) VALUES(11, 'Oldies'); 
     69INSERT INTO audio_genre(id, name) VALUES(12, 'Other'); 
     70INSERT INTO audio_genre(id, name) VALUES(13, 'Pop'); 
     71INSERT INTO audio_genre(id, name) VALUES(14, 'R&B'); 
     72INSERT INTO audio_genre(id, name) VALUES(15, 'Rap'); 
     73INSERT INTO audio_genre(id, name) VALUES(16, 'Reggae'); 
     74INSERT INTO audio_genre(id, name) VALUES(17, 'Rock'); 
     75INSERT INTO audio_genre(id, name) VALUES(18, 'Techno'); 
     76INSERT INTO audio_genre(id, name) VALUES(19, 'Industrial'); 
     77INSERT INTO audio_genre(id, name) VALUES(20, 'Alternative'); 
     78INSERT INTO audio_genre(id, name) VALUES(21, 'Ska'); 
     79INSERT INTO audio_genre(id, name) VALUES(22, 'Death Metal'); 
     80INSERT INTO audio_genre(id, name) VALUES(23, 'Pranks'); 
     81INSERT INTO audio_genre(id, name) VALUES(24, 'Soundtrack'); 
     82INSERT INTO audio_genre(id, name) VALUES(25, 'Euro-Techno'); 
     83INSERT INTO audio_genre(id, name) VALUES(26, 'Ambient'); 
     84INSERT INTO audio_genre(id, name) VALUES(27, 'Trip-Hop'); 
     85INSERT INTO audio_genre(id, name) VALUES(28, 'Vocal'); 
     86INSERT INTO audio_genre(id, name) VALUES(29, 'Jazz+Funk'); 
     87INSERT INTO audio_genre(id, name) VALUES(30, 'Fusion'); 
     88INSERT INTO audio_genre(id, name) VALUES(31, 'Trance'); 
     89INSERT INTO audio_genre(id, name) VALUES(32, 'Classical'); 
     90INSERT INTO audio_genre(id, name) VALUES(33, 'Instrumental'); 
     91INSERT INTO audio_genre(id, name) VALUES(34, 'Acid'); 
     92INSERT INTO audio_genre(id, name) VALUES(35, 'House'); 
     93INSERT INTO audio_genre(id, name) VALUES(36, 'Game'); 
     94INSERT INTO audio_genre(id, name) VALUES(37, 'Sound Clip'); 
     95INSERT INTO audio_genre(id, name) VALUES(38, 'Gospel'); 
     96INSERT INTO audio_genre(id, name) VALUES(39, 'Noise'); 
     97INSERT INTO audio_genre(id, name) VALUES(40, 'AlternRock'); 
     98INSERT INTO audio_genre(id, name) VALUES(41, 'Bass'); 
     99INSERT INTO audio_genre(id, name) VALUES(42, 'Soul'); 
     100INSERT INTO audio_genre(id, name) VALUES(43, 'Punk'); 
     101INSERT INTO audio_genre(id, name) VALUES(44, 'Space'); 
     102INSERT INTO audio_genre(id, name) VALUES(45, 'Meditative'); 
     103INSERT INTO audio_genre(id, name) VALUES(46, 'Instrumental Pop'); 
     104INSERT INTO audio_genre(id, name) VALUES(47, 'Instrumental Rock'); 
     105INSERT INTO audio_genre(id, name) VALUES(48, 'Ethnic'); 
     106INSERT INTO audio_genre(id, name) VALUES(49, 'Gothic'); 
     107INSERT INTO audio_genre(id, name) VALUES(50, 'Darkwave'); 
     108INSERT INTO audio_genre(id, name) VALUES(51, 'Techno-Industrial'); 
     109INSERT INTO audio_genre(id, name) VALUES(52, 'Electronic'); 
     110INSERT INTO audio_genre(id, name) VALUES(53, 'Pop-Folk'); 
     111INSERT INTO audio_genre(id, name) VALUES(54, 'Eurodance'); 
     112INSERT INTO audio_genre(id, name) VALUES(55, 'Dream'); 
     113INSERT INTO audio_genre(id, name) VALUES(56, 'Southern Rock'); 
     114INSERT INTO audio_genre(id, name) VALUES(57, 'Comedy'); 
     115INSERT INTO audio_genre(id, name) VALUES(58, 'Cult'); 
     116INSERT INTO audio_genre(id, name) VALUES(59, 'Gangsta'); 
     117INSERT INTO audio_genre(id, name) VALUES(60, 'Top 40'); 
     118INSERT INTO audio_genre(id, name) VALUES(61, 'Christian Rap'); 
     119INSERT INTO audio_genre(id, name) VALUES(62, 'Pop/Funk'); 
     120INSERT INTO audio_genre(id, name) VALUES(63, 'Jungle'); 
     121INSERT INTO audio_genre(id, name) VALUES(64, 'Native American'); 
     122INSERT INTO audio_genre(id, name) VALUES(65, 'Cabaret'); 
     123INSERT INTO audio_genre(id, name) VALUES(66, 'New Wave'); 
     124INSERT INTO audio_genre(id, name) VALUES(67, 'Psychadelic'); 
     125INSERT INTO audio_genre(id, name) VALUES(68, 'Rave'); 
     126INSERT INTO audio_genre(id, name) VALUES(69, 'Showtunes'); 
     127INSERT INTO audio_genre(id, name) VALUES(70, 'Trailer'); 
     128INSERT INTO audio_genre(id, name) VALUES(71, 'Lo-Fi'); 
     129INSERT INTO audio_genre(id, name) VALUES(72, 'Tribal'); 
     130INSERT INTO audio_genre(id, name) VALUES(73, 'Acid Punk'); 
     131INSERT INTO audio_genre(id, name) VALUES(74, 'Acid Jazz'); 
     132INSERT INTO audio_genre(id, name) VALUES(75, 'Polka'); 
     133INSERT INTO audio_genre(id, name) VALUES(76, 'Retro'); 
     134INSERT INTO audio_genre(id, name) VALUES(77, 'Musical'); 
     135INSERT INTO audio_genre(id, name) VALUES(78, 'Rock & Roll'); 
     136INSERT INTO audio_genre(id, name) VALUES(79, 'Hard Rock'); 
     137INSERT INTO audio_genre(id, name) VALUES(80, 'Folk'); 
     138INSERT INTO audio_genre(id, name) VALUES(81, 'Folk-Rock'); 
     139INSERT INTO audio_genre(id, name) VALUES(82, 'National Folk'); 
     140INSERT INTO audio_genre(id, name) VALUES(83, 'Swing'); 
     141INSERT INTO audio_genre(id, name) VALUES(84, 'Fast Fusion'); 
     142INSERT INTO audio_genre(id, name) VALUES(85, 'Bebob'); 
     143INSERT INTO audio_genre(id, name) VALUES(86, 'Latin'); 
     144INSERT INTO audio_genre(id, name) VALUES(87, 'Revival'); 
     145INSERT INTO audio_genre(id, name) VALUES(88, 'Celtic'); 
     146INSERT INTO audio_genre(id, name) VALUES(89, 'Bluegrass'); 
     147INSERT INTO audio_genre(id, name) VALUES(90, 'Avantgarde'); 
     148INSERT INTO audio_genre(id, name) VALUES(91, 'Gothic Rock'); 
     149INSERT INTO audio_genre(id, name) VALUES(92, 'Progressive Rock'); 
     150INSERT INTO audio_genre(id, name) VALUES(93, 'Psychedelic Rock'); 
     151INSERT INTO audio_genre(id, name) VALUES(94, 'Symphonic Rock'); 
     152INSERT INTO audio_genre(id, name) VALUES(95, 'Slow Rock'); 
     153INSERT INTO audio_genre(id, name) VALUES(96, 'Big Band'); 
     154INSERT INTO audio_genre(id, name) VALUES(97, 'Chorus'); 
     155INSERT INTO audio_genre(id, name) VALUES(98, 'Easy Listening'); 
     156INSERT INTO audio_genre(id, name) VALUES(99, 'Acoustic'); 
     157INSERT INTO audio_genre(id, name) VALUES(100, 'Humour'); 
     158INSERT INTO audio_genre(id, name) VALUES(101, 'Speech'); 
     159INSERT INTO audio_genre(id, name) VALUES(102, 'Chanson'); 
     160INSERT INTO audio_genre(id, name) VALUES(103, 'Opera'); 
     161INSERT INTO audio_genre(id, name) VALUES(104, 'Chamber Music'); 
     162INSERT INTO audio_genre(id, name) VALUES(105, 'Sonata'); 
     163INSERT INTO audio_genre(id, name) VALUES(106, 'Symphony'); 
     164INSERT INTO audio_genre(id, name) VALUES(107, 'Booty Bass'); 
     165INSERT INTO audio_genre(id, name) VALUES(108, 'Primus'); 
     166INSERT INTO audio_genre(id, name) VALUES(109, 'Porn Groove'); 
     167INSERT INTO audio_genre(id, name) VALUES(110, 'Satire'); 
     168INSERT INTO audio_genre(id, name) VALUES(111, 'Slow Jam'); 
     169INSERT INTO audio_genre(id, name) VALUES(112, 'Club'); 
     170INSERT INTO audio_genre(id, name) VALUES(113, 'Tango'); 
     171INSERT INTO audio_genre(id, name) VALUES(114, 'Samba'); 
     172INSERT INTO audio_genre(id, name) VALUES(115, 'Folklore'); 
     173INSERT INTO audio_genre(id, name) VALUES(116, 'Ballad'); 
     174INSERT INTO audio_genre(id, name) VALUES(117, 'Power Ballad'); 
     175INSERT INTO audio_genre(id, name) VALUES(118, 'Rhythmic Soul'); 
     176INSERT INTO audio_genre(id, name) VALUES(119, 'Freestyle'); 
     177INSERT INTO audio_genre(id, name) VALUES(120, 'Duet'); 
     178INSERT INTO audio_genre(id, name) VALUES(121, 'Punk Rock'); 
     179INSERT INTO audio_genre(id, name) VALUES(122, 'Drum Solo'); 
     180INSERT INTO audio_genre(id, name) VALUES(123, 'A capella'); 
     181INSERT INTO audio_genre(id, name) VALUES(124, 'Euro-House'); 
     182INSERT INTO audio_genre(id, name) VALUES(125, 'Dance Hall'); 
    183183""" 
    184184