public void DeleteHashBinsAndSubfingerprintsOnTrackDelete()
{
TagInfo tagInfo = GetTagInfo();
int releaseYear = tagInfo.Year;
var track = new TrackData(tagInfo.ISRC, tagInfo.Artist, tagInfo.Title, tagInfo.Album, releaseYear, (int)tagInfo.Duration);
var trackReference = trackDao.InsertTrack(track);
var hashData = FingerprintCommandBuilder.Instance
.BuildFingerprintCommand()
.From(GetAudioSamples())
.WithFingerprintConfig(config =>
{
config.Stride = new StaticStride(0);
return(config);
})
.UsingServices(audioService)
.Hash()
.Result;
subFingerprintDao.InsertHashDataForTrack(hashData, trackReference);
var actualTrack = trackDao.ReadTrackByISRC(tagInfo.ISRC);
Assert.IsNotNull(actualTrack);
AssertTracksAreEqual(track, actualTrack);
// Act
int modifiedRows = trackDao.DeleteTrack(trackReference);
Assert.IsNull(trackDao.ReadTrackByISRC(tagInfo.ISRC));
Assert.AreEqual(0, subFingerprintDao.ReadHashedFingerprintsByTrackReference(actualTrack.TrackReference).Count);
Assert.AreEqual(1 + hashData.Count + (25 * hashData.Count), modifiedRows);
}
public void DeleteHashBinsAndSubfingerprintsOnTrackDelete()
{
TagInfo tagInfo = GetTagInfo(1);
var track = new TrackInfo(tagInfo.ISRC, tagInfo.Title, tagInfo.Artist);
var trackReference = trackDao.InsertTrack(track, tagInfo.Duration).TrackReference;
var hashData = FingerprintCommandBuilder.Instance
.BuildFingerprintCommand()
.From(GetAudioSamples())
.WithFingerprintConfig(config =>
{
config.Stride = new StaticStride(0);
return(config);
})
.UsingServices(audioService)
.Hash()
.Result;
subFingerprintDao.InsertHashDataForTrack(hashData, trackReference);
var actualTrack = trackDao.ReadTrackById(tagInfo.ISRC);
actualTrack.Should().NotBeNull();
AssertTracksAreEqual(track, actualTrack);
// Act
int modifiedRows = trackDao.DeleteTrack(trackReference) + subFingerprintDao.DeleteSubFingerprintsByTrackReference(trackReference);
trackDao.ReadTrackById(tagInfo.ISRC).Should().BeNull();
subFingerprintDao.ReadHashedFingerprintsByTrackReference(actualTrack.TrackReference).Should().BeEmpty();
modifiedRows.Should().Be(1 + hashData.Count + (25 * hashData.Count));
}
public async Task DeleteHashBinsAndSubFingerprintsOnTrackDelete()
{
var tagInfo = GetTagInfo();
var track = new TrackInfo(tagInfo.ISRC, tagInfo.Title, tagInfo.Artist);
var trackReference = trackDao.InsertTrack(track, tagInfo.Duration).TrackReference;
var hashData = await FingerprintCommandBuilder.Instance
.BuildFingerprintCommand()
.From(GetAudioSamples())
.WithFingerprintConfig(config =>
{
config.Stride = new StaticStride(0);
return(config);
})
.UsingServices(audioService)
.Hash();
subFingerprintDao.InsertHashDataForTrack(hashData, trackReference);
var actualTrack = trackDao.ReadTrackById(tagInfo.ISRC);
Assert.IsNotNull(actualTrack);
// Act
int modifiedRows = trackDao.DeleteTrack(trackReference) +
subFingerprintDao.DeleteSubFingerprintsByTrackReference(trackReference);
Assert.IsNull(trackDao.ReadTrackById(tagInfo.ISRC));
Assert.IsFalse(subFingerprintDao.ReadHashedFingerprintsByTrackReference(actualTrack.TrackReference).Any());
Assert.AreEqual(1 + hashData.Count + 25 * hashData.Count, modifiedRows);
}
public void DeleteHashBinsAndSubfingerprintsOnTrackDelete()
{
const int StaticStride = 5115;
const int SecondsToProcess = 20;
const int StartAtSecond = 30;
var tagInfo = GetTagInfo();
int releaseYear = tagInfo.Year;
TrackData track = new TrackData(tagInfo.ISRC, tagInfo.Artist, tagInfo.Title, tagInfo.Album, releaseYear, (int)tagInfo.Duration);
var trackReference = trackDao.InsertTrack(track);
var hashData = fingerprintCommandBuilder
.BuildFingerprintCommand()
.From(PathToMp3, SecondsToProcess, StartAtSecond)
.WithFingerprintConfig(config =>
{
config.Stride = new IncrementalStaticStride(StaticStride);
})
.UsingServices(audioService)
.Hash()
.Result;
subFingerprintDao.InsertHashDataForTrack(hashData, trackReference);
var actualTrack = trackDao.ReadTrackByISRC(tagInfo.ISRC);
Assert.IsNotNull(actualTrack);
AssertTracksAreEqual(track, actualTrack);
// Act
int modifiedRows = trackDao.DeleteTrack(trackReference);
Assert.IsNull(trackDao.ReadTrackByISRC(tagInfo.ISRC));
Assert.IsTrue(subFingerprintDao.ReadHashedFingerprintsByTrackReference(actualTrack.TrackReference).Count == 0);
Assert.AreEqual(1 + hashData.Count, modifiedRows);
}
private void InsertHashedFingerprintsForTrack(IEnumerable <HashedFingerprint> hashedFingerprints, IModelReference trackReference)
{
subFingerprintDao.InsertHashDataForTrack(hashedFingerprints, trackReference);
}
public virtual void InsertHashDataForTrack(IEnumerable <HashedFingerprint> hashes, IModelReference trackReference)
{
subFingerprintDao.InsertHashDataForTrack(hashes, trackReference);
}