// -------------------------------------------------------------------------------- // void guDbRadios::SetRadioStationsLabels( const guArrayListItems &labelsets ) { wxString query; wxArrayInt Stations; wxArrayInt Labels; int StaIndex; int StaCount; int LaIndex; int LaCount; if( ( StaCount = labelsets.Count() ) ) { for( StaIndex = 0; StaIndex < StaCount; StaIndex++ ) { Stations.Add( labelsets[ StaIndex ].GetId() ); } query = wxT( "DELETE FROM radiosetlabels " \ "WHERE radiosetlabel_stationid IN " ) + ArrayIntToStrList( Stations ); ExecuteUpdate( query ); for( StaIndex = 0; StaIndex < StaCount; StaIndex++ ) { Labels = labelsets[ StaIndex ].GetData(); LaCount = Labels.Count(); for( LaIndex = 0; LaIndex < LaCount; LaIndex++ ) { query = wxString::Format( wxT( "INSERT INTO radiosetlabels( radiosetlabel_labelid, radiosetlabel_stationid ) " \ "VALUES( %u, %u );" ), Labels[ LaIndex ], Stations[ StaIndex ] ); ExecuteUpdate( query ); } } } }
// -------------------------------------------------------------------------------- // void guJamendoLibrary::UpdateAlbumsLabels( const guArrayListItems &labelsets ) { guListItems LaItems; // The ArtistLabels string is the same for all songs so done out of the loop GetLabels( &LaItems, true ); int ItemIndex; int ItemCount = labelsets.Count(); for( ItemIndex = 0; ItemIndex < ItemCount; ItemIndex++ ) { wxArrayInt ItemLabels = labelsets[ ItemIndex ].GetData(); //guLogMessage( wxT( "Artist Labels : '%s'" ), ArtistLabelStr.c_str() ); // Update the Database wxArrayInt ItemIds; ItemIds.Add( labelsets[ ItemIndex ].GetId() ); SetAlbumsLabels( ItemIds, ItemLabels ); } }