public void Insert(Fingerprint fingerprint)
{
fingerprint.Id = PrepareStoredProcedure(SpInsertFingerprint)
.WithParametersFromModel(new FingerprintDto(fingerprint))
.Execute()
.AsScalar<int>();
}
public void InsertFingerprint(Fingerprint fingerprint)
{
fingerprintDao.Insert(fingerprint);
}
public FingerprintDto(Fingerprint fingerprint)
{
Id = fingerprint.Id;
TrackId = fingerprint.TrackId;
TotalFingerprintsPerTrack = fingerprint.TotalFingerprintsPerTrack;
SongOrder = fingerprint.SongOrder;
Signature = ArrayUtils.GetByteArrayFromBool(fingerprint.Signature);
}
public void ReadFingerprintsTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Track t = GetTrack(name);
modelService.InsertTrack(t);
Fingerprint f = new Fingerprint(GenericFingerprint, t.Id, 10);
modelService.InsertFingerprint(f);
var actual = modelService.ReadFingerprints();
Assert.IsTrue(actual.Count >= 1);
}
public void ReadTrackByFingerprintTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Track expectedTrack = GetTrack(name);
modelService.InsertTrack(expectedTrack);
const int FakeId = int.MinValue;
Fingerprint fingerprint = new Fingerprint(GenericFingerprint, expectedTrack.Id, int.MinValue);
modelService.InsertFingerprint(fingerprint);
Assert.AreNotEqual(FakeId, fingerprint.Id);
var list = modelService.ReadTrackByFingerprint(fingerprint.Id);
Track actualTrack = list.FirstOrDefault(temp => temp.Id == expectedTrack.Id);
Assert.IsNotNull(actualTrack);
AssertTracksAreEqual(expectedTrack, actualTrack);
}
public void ReadFingerprintByMultipleTrackIdTest1()
{
string name = MethodBase.GetCurrentMethod().Name;
const int NumberOfTracks = 1153;
const int NumberOfFingerprintsPerTrack = 10;
List<Track> listTrack = new List<Track>();
List<Fingerprint> listOfFingerprints = new List<Fingerprint>();
for (int i = 0; i < NumberOfTracks; i++)
{
Track track0 = GetTrack(name);
listTrack.Add(track0);
modelService.InsertTrack(track0);
for (int j = 0; j < NumberOfFingerprintsPerTrack; j++)
{
Fingerprint f0 = new Fingerprint(GenericFingerprint, track0.Id, 0);
listOfFingerprints.Add(f0);
}
}
modelService.InsertFingerprint(listOfFingerprints);
var dict = modelService.ReadFingerprintsByMultipleTrackId(listTrack, 0);
Assert.AreNotEqual(null, dict);
Assert.AreEqual(NumberOfTracks, dict.Keys.Count);
foreach (Track track in listTrack)
{
Assert.AreEqual(true, dict.ContainsKey(track.Id));
Assert.AreEqual(NumberOfFingerprintsPerTrack, dict[track.Id].Count);
}
}
public void ReadFingerprintByTrackIdTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Track track = GetTrack(name);
modelService.InsertTrack(track);
Fingerprint fingerprint = new Fingerprint(GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(fingerprint);
var list = modelService.ReadFingerprintsByTrackId(track.Id, 0);
Fingerprint expectedFingerprint = list.FirstOrDefault(temp => temp.Id == fingerprint.Id);
Assert.IsNotNull(expectedFingerprint);
Assert.AreEqual(fingerprint.Id, expectedFingerprint.Id);
Assert.AreEqual(fingerprint.Signature.Length, expectedFingerprint.Signature.Length);
for (int i = 0; i < fingerprint.Signature.Length; i++)
{
Assert.AreEqual(fingerprint.Signature[i], expectedFingerprint.Signature[i]);
}
Assert.AreEqual(fingerprint.TrackId, expectedFingerprint.TrackId);
}
public void ReadFingerprintByIdTest()
{
string name = MethodBase.GetCurrentMethod().Name;
const int FakeId = int.MinValue;
Track track = GetTrack(name);
modelService.InsertTrack(track);
Assert.AreNotEqual(FakeId, track.Id);
Fingerprint fingerprint = new Fingerprint(GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(fingerprint);
Assert.AreNotEqual(FakeId, fingerprint.Id);
Fingerprint readFingerprintById = modelService.ReadFingerprintById(fingerprint.Id);
Assert.AreEqual(fingerprint.Id, readFingerprintById.Id);
Assert.AreEqual(fingerprint.Signature.Length, readFingerprintById.Signature.Length);
for (int i = 0; i < fingerprint.Signature.Length; i++)
{
Assert.AreEqual(fingerprint.Signature[i], readFingerprintById.Signature[i]);
}
Assert.AreEqual(fingerprint.TrackId, readFingerprintById.TrackId);
}
public void ReadFingerprintByMultipleTrackIdTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Track track0 = GetTrack(name);
modelService.InsertTrack(track0);
Track track1 = GetTrack(name);
modelService.InsertTrack(track1);
Track track2 = GetTrack(name);
modelService.InsertTrack(track2);
Fingerprint f0 = new Fingerprint(GenericFingerprint, track0.Id, 0);
modelService.InsertFingerprint(f0);
Fingerprint f1 = new Fingerprint(GenericFingerprint, track0.Id, 1);
modelService.InsertFingerprint(f1);
Fingerprint f2 = new Fingerprint(GenericFingerprint, track1.Id, 2);
modelService.InsertFingerprint(f2);
Fingerprint f3 = new Fingerprint(GenericFingerprint, track1.Id, 3);
modelService.InsertFingerprint(f3);
Fingerprint f4 = new Fingerprint(GenericFingerprint, track2.Id, 4);
modelService.InsertFingerprint(f4);
Fingerprint f5 = new Fingerprint(GenericFingerprint, track2.Id, 5);
modelService.InsertFingerprint(f5);
Fingerprint f6 = new Fingerprint(GenericFingerprint, track0.Id, 6);
modelService.InsertFingerprint(f6);
Fingerprint f7 = new Fingerprint(GenericFingerprint, track1.Id, 7);
modelService.InsertFingerprint(f7);
Fingerprint f8 = new Fingerprint(GenericFingerprint, track2.Id, 8);
modelService.InsertFingerprint(f8);
var dict =
modelService.ReadFingerprintsByMultipleTrackId(new List<Track> { track0, track1, track2 }, 0);
Assert.AreNotEqual(null, dict);
Assert.AreEqual(3, dict.Keys.Count);
foreach (var item in dict)
{
Assert.AreEqual(3, item.Value.Count);
}
Assert.AreEqual(true, dict.ContainsKey(track0.Id));
Assert.AreEqual(true, dict.ContainsKey(track1.Id));
Assert.AreEqual(true, dict.ContainsKey(track2.Id));
foreach (var pair in dict)
{
Assert.AreEqual(3, pair.Value.Count);
}
}
public void InsertFingerprintWithBadTrackIdForeignKeyreference()
{
string name = MethodBase.GetCurrentMethod().Name;
Track track = GetTrack(name);
Fingerprint fingerprint = new Fingerprint(GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(fingerprint);
}
public void InsertReadFingerprintTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Track track = GetTrack(name);
modelService.InsertTrack(track);
Fingerprint fingerprint = new Fingerprint(GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(fingerprint);
var allFingerprints = modelService.ReadFingerprints();
List<int> fingerprintIds = allFingerprints.Select(temp => temp.Id).ToList();
Assert.AreEqual(true, fingerprintIds.Contains(fingerprint.Id));
List<Fingerprint> addList = new List<Fingerprint>();
for (int i = 0; i < 10; i++)
{
addList.Add(new Fingerprint(GenericFingerprint, track.Id, 0));
}
modelService.InsertFingerprint(addList);
allFingerprints = modelService.ReadFingerprints();
fingerprintIds.Clear();
fingerprintIds.AddRange(allFingerprints.Select(temp => temp.Id));
foreach (Fingerprint finger in addList)
{
Assert.AreEqual(true, fingerprintIds.Contains(finger.Id));
}
}
public void ReadTrackByFingerprintTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Album album = new Album(int.MinValue, name, 1986);
modelService.InsertAlbum(album);
Track track = new Track(int.MinValue, name, name, album.Id, 360);
modelService.InsertTrack(track);
const int FakeId = int.MinValue;
Fingerprint f = new Fingerprint(FakeId, GenericFingerprint, track.Id, int.MinValue);
modelService.InsertFingerprint(f);
Assert.AreNotEqual(FakeId, f.Id);
var list = modelService.ReadTrackByFingerprint(f.Id);
Track readT = list.FirstOrDefault(temp => temp.Id == track.Id);
Assert.AreNotEqual(null, readT);
Assert.AreEqual(track.Id, readT.Id);
Assert.AreEqual(track.AlbumId, readT.AlbumId);
Assert.AreEqual(track.Artist, readT.Artist);
Assert.AreEqual(track.Title, readT.Title);
Assert.AreEqual(track.TrackLengthSec, readT.TrackLengthSec);
}
public void ReadFingerprintsTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Album album = modelService.ReadUnknownAlbum();
Track t = new Track(0, name, name, album.Id);
modelService.InsertTrack(t);
Fingerprint f = new Fingerprint(0, GenericFingerprint, t.Id, 10);
modelService.InsertFingerprint(f);
var actual = modelService.ReadFingerprints();
Assert.IsTrue(actual.Count >= 1);
}
public void ReadFingerprintByTrackIdTest()
{
string name = MethodBase.GetCurrentMethod().Name;
Album album = new Album(0, name, 1986);
modelService.InsertAlbum(album);
Track track = new Track(0, name, name, album.Id, 360);
modelService.InsertTrack(track);
Fingerprint f = new Fingerprint(0, GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(f);
var list = modelService.ReadFingerprintsByTrackId(track.Id, 0);
Fingerprint readF = list.FirstOrDefault(temp => temp.Id == f.Id);
Assert.AreNotEqual(null, readF);
Assert.AreEqual(f.Id, readF.Id);
Assert.AreEqual(f.Signature.Length, readF.Signature.Length);
for (int i = 0; i < f.Signature.Length; i++)
{
Assert.AreEqual(f.Signature[i], readF.Signature[i]);
}
Assert.AreEqual(f.TrackId, readF.TrackId);
}
public void ReadFingerprintByIdTest()
{
string name = MethodBase.GetCurrentMethod().Name;
const int fakeId = int.MinValue;
Album album = new Album(fakeId, name, 1986);
modelService.InsertAlbum(album);
Assert.AreNotEqual(fakeId, album);
Track track = new Track(fakeId, name, name, album.Id, 360);
modelService.InsertTrack(track);
Assert.AreNotEqual(fakeId, track.Id);
Fingerprint f = new Fingerprint(fakeId, GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(f);
Assert.AreNotEqual(fakeId, f.Id);
Fingerprint readF = modelService.ReadFingerprintById(f.Id);
Assert.AreEqual(f.Id, readF.Id);
Assert.AreEqual(f.Signature.Length, readF.Signature.Length);
for (int i = 0; i < f.Signature.Length; i++)
{
Assert.AreEqual(f.Signature[i], readF.Signature[i]);
}
Assert.AreEqual(f.TrackId, readF.TrackId);
}
public void InsertFingerprintWithBadTrackIdForeignKeyreference()
{
string name = MethodBase.GetCurrentMethod().Name;
Album a = new Album(0, name, 1990);
Track track = new Track(0, name, name, a.Id);
Fingerprint f = new Fingerprint(0, GenericFingerprint, track.Id, 0);
modelService.InsertFingerprint(f);
}
