Example #1
0
  public void process()
      throws CannotReadException, IOException, TagException, ReadOnlyFileException,
          InvalidAudioFrameException {
    artistSet = new HashSet<>();
    albumSet = new HashSet<>();
    yearSet = new HashSet<>();
    nameSet = new ArrayList<>();

    for (File file : fileArray) {
      MP3File mp3file = (MP3File) AudioFileIO.read(file);
      Tag tag = mp3file.getTag();

      if (!tag.getFirst(FieldKey.YEAR).isEmpty()) {
        yearSet.add(tag.getFirst(FieldKey.YEAR));
      }
      if (tag.getFirst(FieldKey.TITLE).isEmpty()) {
        nameSet.add(file.getName());
      } else {
        nameSet.add(tag.getFirst(FieldKey.TITLE));
      }
      if (tag.getFirst(FieldKey.ALBUM).isEmpty()) {
        albumSet.add(file.getParentFile().getName());
      } else {
        albumSet.add(tag.getFirst(FieldKey.ALBUM));
      }
      if (tag.getFirst(FieldKey.ARTIST).isEmpty()) {
        if (file.getParentFile().getParentFile().exists()) {
          artistSet.add(file.getParentFile().getParentFile().getName());
        } else {
          artistSet.add(file.getParentFile().getName());
        }
      } else {
        artistSet.add(tag.getFirst(FieldKey.ARTIST));
      }

      if (tag.getFirst(FieldKey.DISC_NO).isEmpty()) {
        if (file.getParentFile().getName().toLowerCase().contentEquals("cd")) {}

      } else {
        cd = tag.getFirst(FieldKey.DISC_NO);
      }
    }

    if (artistSet.size() == 1) {
      setTypeFlag(1);
    } else if (artistSet.size() == 2) {
      setTypeFlag(2);
    } else if (artistSet.size() > 2) {
      setTypeFlag(3);
    }

    try {
      parse();
    } catch (SQLException ex) {
      Logger.getLogger(Aggregator.class.getName()).log(Level.SEVERE, null, ex);
    }
  }
Example #2
0
  private void parse()
      throws CannotReadException, IOException, TagException, ReadOnlyFileException,
          InvalidAudioFrameException, SQLException {
    int idLabel = 1;
    int idAlbum = 1;
    int idArtist = 1;

    ArrayList<Integer> arrGenres = null;

    for (File file : fileArray) {
      MP3File mp3file = (MP3File) AudioFileIO.read(file);
      Tag tag = mp3file.getTag();

      Artists artist = new Artists(sqlWorker, tag);

      if (artistSet.size() == 2) {
        artist.setSplit(true);
        artist.setArtistSet(artistSet);
      } else if (artistSet.size() > 2) {
        artist.setVA(true);
      }

      artist.addFromTag();

      try {
        idArtist = artist.getId(tag.getFirst(FieldKey.ARTIST));
        artist.updateImagePath(defaultPersonPicture.getAbsolutePath());
      } catch (NullPointerException e) {
        System.out.println("Aggr !!!!! У исполнителя не заполнен тег");
      }

      Labels label = new Labels(sqlWorker);
      label.addFromTag(tag);
      idLabel = label.getId();

      if (!tag.getFirst(FieldKey.GENRE).isEmpty()) {
        Genres genre = new Genres(sqlWorker);
        genre.addFromTag(tag);
        arrGenres = genre.getGenres();
      }

      if (!tag.getFirst(FieldKey.ALBUM).isEmpty()) {
        setAlbum(new Albums(sqlWorker, idLabel, tag));
        if (artistSet.size() > 1) {
          getAlbum().setVA(true);
        }

        getAlbum().addFromTag();
        idAlbum = getAlbum().getId(tag.getFirst(FieldKey.ALBUM));

        if (arrGenres != null) {
          for (int j = 0; j < arrGenres.size(); j++) {
            try {
              String query =
                  "INSERT INTO albums_has_genres (albums_idalbum, genres_idgenre) "
                      + "VALUES (?, ?)";
              PreparedStatement stmt = sqlWorker.getConnection().prepareStatement(query);
              stmt.setInt(1, idAlbum);
              stmt.setInt(2, arrGenres.get(j));
              stmt.executeUpdate();
            } catch (SQLException e) {
              System.out.println(
                  "##### Ошибка вставки в albums_has_genres. Значения уже существуют");
            }
          }
        }

        try {
          String query =
              "INSERT INTO artist_has_albums (artist_idartist, album_idalbum) " + "VALUES (?, ?)";
          PreparedStatement stmt = sqlWorker.getConnection().prepareStatement(query);
          if (artistSet.size() > 2) {}

          stmt.setInt(1, idArtist);
          stmt.setInt(2, idAlbum);
          stmt.executeUpdate();
        } catch (SQLException e) {
          System.out.println("##### Ошибка вставки в artist_has_albums. Значения уже существуют");
        }
        Songs song = new Songs(sqlWorker, mp3file, idAlbum);
        song.setCd(cd);
        song.addFromTag(tag);
      }
    }
  }