X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fmain%2Fjava%2Fnet%2Fpterodactylus%2Fdemoscenemusic%2Fdata%2FDataManager.java;h=c0001c41050e86a333a847718b39434ad9679987;hb=b2ab3fd2aefa2815f8c55b5b0e8b8d2eb912a192;hp=5f20905ee12d4c6695edc47def6158fbdd1cd3e6;hpb=6f3371253d6a4398abea9fcd9c78a042b80c5af2;p=demoscenemusic.git

diff --git a/src/main/java/net/pterodactylus/demoscenemusic/data/DataManager.java b/src/main/java/net/pterodactylus/demoscenemusic/data/DataManager.java
index 5f20905..c0001c4 100644
--- a/src/main/java/net/pterodactylus/demoscenemusic/data/DataManager.java
+++ b/src/main/java/net/pterodactylus/demoscenemusic/data/DataManager.java
@@ -38,6 +38,7 @@ import net.pterodactylus.util.database.Join.JoinType;
 import net.pterodactylus.util.database.ObjectCreator;
 import net.pterodactylus.util.database.ObjectCreator.StringCreator;
 import net.pterodactylus.util.database.OrderField;
+import net.pterodactylus.util.database.Parameter.IntegerParameter;
 import net.pterodactylus.util.database.Parameter.StringParameter;
 import net.pterodactylus.util.database.Query;
 import net.pterodactylus.util.database.Query.Type;
@@ -392,6 +393,36 @@ public class DataManager {
 	}
 
 	/**
+	 * Saves the given track. This also saves all relationships of the track.
+	 *
+	 * @param track
+	 *            The track to save
+	 * @throws DatabaseException
+	 *             if a database error occurs
+	 */
+	public void saveTrack(Track track) throws DatabaseException {
+		Query query = new Query(Type.UPDATE, "TRACKS");
+		query.addValueField(new ValueField("TRACKS.NAME", new StringParameter(track.getName())));
+		query.addValueField(new ValueField("TRACKS.REMIX", new StringParameter(track.getRemix())));
+		query.addWhereClause(new ValueFieldWhereClause(new ValueField("TRACKS.ID", new StringParameter(track.getId()))));
+		database.update(query);
+		/* store artist information. */
+		track.getArtists(); /* prefetch artists. */
+		query = new Query(Type.DELETE, "TRACK_ARTISTS");
+		query.addWhereClause(new ValueFieldWhereClause(new ValueField("TRACK_ARTISTS.TRACK", new StringParameter(track.getId()))));
+		database.update(query);
+		for (int index = 0; index < track.getArtists().size(); ++index) {
+			query = new Query(Type.INSERT, "TRACK_ARTISTS");
+			query.addValueField(new ValueField("TRACK_ARTISTS.TRACK", new StringParameter(track.getId())));
+			query.addValueField(new ValueField("TRACK_ARTISTS.ARTIST", new StringParameter(track.getArtists().get(index).getId())));
+			query.addValueField(new ValueField("TRACK_ARTISTS.DISPLAY_ORDER", new IntegerParameter(index + 1)));
+			database.insert(query);
+		}
+		/* store properties. */
+		saveProperties(track.getProperties(), "TRACK_PROPERTIES", "TRACK", track.getId());
+	}
+
+	/**
 	 * Returns the derivative with the given ID.
 	 *
 	 * @param id
@@ -471,6 +502,36 @@ public class DataManager {
 	}
 
 	/**
+	 * Saves the given track derivative. As a track derivative does not have any
+	 * attributes of its own only its properties are saved.
+	 *
+	 * @param trackDerivative
+	 *            The track derivative to save
+	 * @throws DatabaseException
+	 *             if a database error occurs
+	 */
+	public void saveTrackDerivate(TrackDerivative trackDerivative) throws DatabaseException {
+		saveProperties(trackDerivative.getProperties(), "TRACK_DERIVATIVE_PROPERTIES", "TRACK_DERIVATIVE", trackDerivative.getId());
+	}
+
+	/**
+	 * Removes the given track derivative and all its properties from the
+	 * database.
+	 *
+	 * @param trackDerivative
+	 *            The track derivative to remove
+	 * @throws DatabaseException
+	 *             if a database error occurs
+	 */
+	public void removeTrackDerivative(TrackDerivative trackDerivative) throws DatabaseException {
+		Query query = new Query(Type.DELETE, "TRACK_DERIVATIVES");
+		query.addWhereClause(new ValueFieldWhereClause(new ValueField("TRACK_DERIVATIVES.ID", new StringParameter(trackDerivative.getId()))));
+		database.update(query);
+		/* remove the properties. */
+		saveProperties(new Properties().set("dirty", "true").removeAll(), "TRACK_DERIVATIVE_PROPERTIES", "TRACK_DERIVATIVE", trackDerivative.getId());
+	}
+
+	/**
 	 * Returns all groups the artist with the given ID belongs to.
 	 *
 	 * @param artistId
@@ -603,6 +664,7 @@ public class DataManager {
 
 		/** Memoizer for the tracks by this artist. */
 		private final Memoizer<Void> tracksMemoizer = new Memoizer<Void>(new Callable<Void>() {
+
 			@Override
 			public Void call() throws DatabaseException {
 				if (!hasValue("tracks")) {
@@ -814,6 +876,7 @@ public class DataManager {
 				}
 				return null;
 			}
+
 		});
 
 		/**