public void RemovingItemFromEmptyDatabaseThrowsException() { DatabaseT <int> sut = new DatabaseT <int>(); Exception ex = Assert.Throws <InvalidOperationException>(() => sut.Remove()); Assert.AreEqual(DBEmptyMsg, ex.Message); }
public Controller() { if (_db == null) { _db = DatabaseT.CreateNewObjectOfDatabase(); } _getThings = new GetListsFromDatabase(_db); }
public void FullDatabaseThrowsExceptionWhenAddingMoreItems() { DatabaseT <int> sut = new DatabaseT <int>(Enumerable.Range(0, 16).ToArray()); Exception ex = Assert.Throws <InvalidOperationException>(() => sut.Add(100)); Assert.AreEqual(DBFullMsg, ex.Message); }
public void RemovingItemChangesCount() { DatabaseT <int> sut = new DatabaseT <int>(1); sut.Remove(); Assert.AreEqual(0, sut.Count); }
public void FetchEmptyDatabaseReturnsEmptyCollection() { DatabaseT <int> sut = new DatabaseT <int>(); int[] numbers = new int[0]; int[] returnedCollection = sut.Fetch(); Assert.IsTrue(numbers.SequenceEqual(returnedCollection)); }
public void FetchingDatabaseReturnsCorrectCollection() { DatabaseT <int> sut = new DatabaseT <int>(Enumerable.Range(0, 16).ToArray()); int[] numbers = Enumerable.Range(0, 16).ToArray(); int[] returnedCollection = sut.Fetch(); Assert.IsTrue(numbers.SequenceEqual(returnedCollection)); }
public void InitializingDBOverCapacityThrowsException() { try { DatabaseT <int> sut = new DatabaseT <int>(Enumerable.Range(0, 17).ToArray()); } catch (Exception ex) { Assert.AreEqual(DBFullMsg, ex.Message); return; } Assert.Fail(); }
internal StoreConverter(DatabaseT _db) { db = _db; }
internal GetListsFromDatabase(DatabaseT db) { _db = db; }
public void RemoveLastItemFromDatabase() { DatabaseT <int> sut = new DatabaseT <int>(1, 2, 3); Assert.That(() => sut.Remove() == 3, "Removing last item from Database fails."); }
public void EmptyDatabaseHasZeroCount() { DatabaseT <int> sut = new DatabaseT <int>(); Assert.AreEqual(0, sut.Count, "Database count is not zero when it should be!"); }
public void DatabaseRegistersElements() { DatabaseT <int> sut = new DatabaseT <int>(1, 2, 3, 4, 5); Assert.AreEqual(5, sut.Count, "Registered items count does not match!"); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Form1()); DatabaseT db = new DatabaseT(); db.Connect(); /* * * * Console.WriteLine(" ------------------------------------- 1. Evidence hracu ------------------------------------- "); * * Console.WriteLine("1.a) Zaregistrovani noveho hrace"); * Person p = new Person(); * p.Id = 66; * p.First_Name = "John"; * p.Last_Name = "Test"; * p.Birth_Date = 2001; * p.Role = "Player"; * * p.Game_Id = GameTable.SelectOne(2, db); * p.Team_Id = TeamTable.SelectOne(3, db); * * Console.WriteLine("Pridano "+ PersonTable.Insert(p, db)+" zaznamu"); * * * * Console.WriteLine("1.b) Aktualizace informaci o hraci"); * p.First_Name = "Jack"; * * Console.WriteLine("Upraveno " + PersonTable.Update(p, db) + " zaznamu"); * * /* * // Alternativa * * Person toBeChanged = PersonTable.SelectOne(66); * toBeChanged.First_Name = "Jack"; * PersonTable.Update(toBeChanged, db); * */ /* * Console.WriteLine("1. c) Odstraneni hrace"); * Console.WriteLine("Odstraneno " + PersonTable.Delete(66) +" zaznamu"); * * * Console.WriteLine("1. d) Seznam hracu"); * Collection <Person> pr = PersonTable.Select(); * int i = 0; * foreach(Person w in pr) * { * Console.WriteLine(w.First_Name + " " + w.Last_Name); * i++; * if (i > 5) break; * } * Console.WriteLine("Nalezeno " + pr.Count + " zaznamu."); * * * Console.WriteLine("1. e) Informace o hraci"); * Person ps = PersonTable.SelectOne(2); * Console.WriteLine("Hrac: " + ps.First_Name+" "+ps.Last_Name + " nalezen pod ID:" + ps.Id); * * * Console.WriteLine("1. f) Seznam spoluhracu"); * pr = PersonTable.SelectTeammates(2); * Console.WriteLine("Spoluhraci hrace s ID: 2\n"); * foreach (Person w in pr){ * Console.WriteLine(w.First_Name + " " + w.Last_Name); * } * * * Console.WriteLine("1. g) Prestup"); * Console.WriteLine("Pocet zmenenych radku: "+PersonTable.Prestup(7, 1)); * * * * Console.WriteLine("1. h) Seznam hracu s prijmenim Bluett nebo podobnym"); * pr = PersonTable.SelectByParameter("Bluett", db); * foreach (Person w in pr) * { * Console.WriteLine(w.First_Name + " " + w.Last_Name); * } * Console.WriteLine("Nalezeno " + pr.Count + " zaznamu."); * * * * Console.WriteLine(" ------------------------------------- 2. Evidence tymu ------------------------------------- "); * * Console.WriteLine("2. a) Zaregistrovani noveho tymu"); * Team t = new Team(); * t.Id = 7; * t.Name = "DAIS boys"; * t.Person_Id = null; * t.Organisation_Id = OrganisationTable.SelectOne(2); * t.Game_Id = GameTable.SelectOne(2); * Address a = new Address(); * a.Id = 3; * t.Address_Id = a; * Console.WriteLine("Pridano "+ TeamTable.Insert(t)+" radku"); * * * Console.WriteLine("2. b) Aktualizace informaci o tymu"); * t = TeamTable.SelectOne(7); * t.Name = "DAIS grlz"; * TeamTable.Update(t); * * * * Console.WriteLine("2. c) Odstraneni tymu"); * Console.WriteLine("Odebrano " + TeamTable.Delete(7) + " radku"); * * * Console.WriteLine("2. d) Seznam tymu"); * Collection<Team> tc = TeamTable.Select(); * foreach (Team tt in tc) * { * Console.WriteLine(tt.Name); * } * Console.WriteLine("Nalezeno " + tc.Count + " zaznamu."); * * * Console.WriteLine("2. e) Zmena hry celeho tymu a jeho hracu"); * t = TeamTable.SelectOne(1); * Console.WriteLine("Zmeneno "+(TeamTable.ZmenitHru(t, 2)+1) +" zaznamu"); * * * Console.WriteLine("2. f) Vypis organizace, ktera tym spravuje a vlastni"); * Console.WriteLine("ID organizace: "+ TeamTable.SelectOrganisation(2).Id); * * * Console.WriteLine("2. g) Prirazeni organizace tymu"); * t = TeamTable.SelectOne(3); * t.Organisation_Id = OrganisationTable.SelectOne(2); * Console.WriteLine("Upraveno " + TeamTable.Update(t) + " zaznamu."); * * * Console.WriteLine("2. h) Pocet tymu hrajici danou hru"); * Console.WriteLine("Hru hraje: " + TeamTable.SelectCountGame(1) + " tymu"); * * * Console.WriteLine("2. i) Vypis tymu dle parametru (nazev)"); * tc = TeamTable.SelectByParam("Dignitas", db); * Console.WriteLine("Nalezeno " + tc.Count + " zaznamu."); * * * * * Console.WriteLine(" ------------------------------------- 3. Evidence Organizaci ------------------------------------- "); * * Console.WriteLine("3. a) Zaregistrovani nove organizace"); * Organisation o = new Organisation(); * o.Id = 77; * o.Name = "DAIS ORG"; * o.Person_Id = PersonTable.SelectOne(2); * o.Address_Id = a; * Console.WriteLine("Pridano " + OrganisationTable.Insert(o, db) + " zaznamu"); * * Console.WriteLine("3. b) Aktualizace informaci o organizaci"); * o = OrganisationTable.SelectOne(77); * o.Name = "Nove jmeno organizace"; * Console.WriteLine("Upraveno " + OrganisationTable.Update(o) + " radku"); * * * Console.WriteLine("3. c) Zmena kontaktni osoby / manazera"); * o = OrganisationTable.SelectOne(77); * Person newManager = PersonTable.SelectOne(5); * Console.WriteLine("Upraveno " + OrganisationTable.UpdateManager(o, newManager.Id, true) + " radku"); * * * * Console.WriteLine("3. d) Vypis vsech osob v tymech spadajicich pod organizaci"); * Collection<Person> co = OrganisationTable.SelectPeople(1); * * foreach (Person pp in co) * { * Console.WriteLine(pp.First_Name + " " + pp.Last_Name); * } * Console.WriteLine("Nalezeno " + co.Count + " zaznamu."); * * * * Console.WriteLine("3. e) Pocet tymu v organizaci"); * Console.WriteLine("V organizaci je: " + OrganisationTable.SelectTeamCount(2) + " tymu"); * * * * * Console.WriteLine("3. d) Odstraneni organizace"); * Console.WriteLine("Odstraneno: " + OrganisationTable.Delete(77) + " zaznamu"); * * * * * * * * Console.WriteLine(" ------------------------------------- 4. Evidence zapasu ------------------------------------- "); * * * * Console.WriteLine("4. a) Pridani noveho zapasu"); * * int rowCount = 0; * Match m = new Match(); * m.Id = 7; * m.MNUM = 4; * m.MATCHDATE = "2019-11-09"; * m.Win = "1"; * m.Score = 5; * m.Game_Id = GameTable.SelectOne(2); * m.Event_Id = EventTable.SelectOne(1); * * rowCount+=MatchTable.Insert(m, db); * * m.Id = 8; * m.MNUM = 4; * m.MATCHDATE = "2019-11-09"; * m.Win = "0"; * m.Score = 2; * m.Game_Id = GameTable.SelectOne(2); * m.Event_Id = EventTable.SelectOne(1); * * rowCount += MatchTable.Insert(m, db); * * Console.WriteLine("Zapsano: " + rowCount + " radku"); * * * * Console.WriteLine("4. b) Aktualizace informaci o zapase"); * m.Score = 1; * Console.WriteLine("Zmeneno: " + MatchTable.Update(m, db) + " zaznamu"); * * * * Console.WriteLine("4. c) Smazani zapasu"); * * Console.WriteLine("Zmeneno: " + MatchTable.Delete(4) + " zaznamu"); * * * * * * * Console.WriteLine(" ------------------------------------- 5. Evidence turnaju/lig ------------------------------------- "); * * * Console.WriteLine("5. a) Pridani nove akce"); * Event e = new Event(); * e.Id = 77; * e.Name = "DAIS league"; * e.Organiser = "VSB"; * e.Prizepool = 200; * * Console.WriteLine("Pridano: " + EventTable.PridatAkci(e, db) + " zaznamu"); * * * * Console.WriteLine("5. b) Vypis akci abecedne"); * Collection<Event> ce = EventTable.Select(); * * foreach (Event ee in ce) * { * Console.WriteLine(ee.Name); * } * Console.WriteLine("Nalezeno " + ce.Count + " zaznamu."); * * * Console.WriteLine("5. c) Aktualizace informaci o akci"); * e = EventTable.SelectOne(4); * e.Name = "DAIS VSB league top"; * Console.WriteLine("Upraveno " + EventTable.Update(e) + " zaznamu."); * * * * Console.WriteLine("5. d) Smazani zaznamu"); * Console.WriteLine("Smazano " + EventTable.Delete(4) + " zaznamu."); * * * * Console.WriteLine(" ------------------------------------- 6. Evidence her ------------------------------------- "); * * Console.WriteLine("6. a) Pridani hry"); * Game g = new Game(); * g.Id = 77; * g.Name = "DAIS"; * Console.WriteLine("Pridano " + GameTable.Insert(g, db) + " zaznamu."); * * * Console.WriteLine("6. b) Upraveni hry"); * g = GameTable.SelectOne(77); * g.Name = "DAIS - nove survival RPG"; * Console.WriteLine("Upraveno " + GameTable.Update(g) + " zaznamu."); * * * Console.WriteLine("6. c) Vypis vsech her"); * Collection<Game> cg = GameTable.Select(); * foreach (Game gg in cg) * { * Console.WriteLine(gg.Name); * } * Console.WriteLine("Nalezeno " + cg.Count + " zaznamu."); * * * * * Console.WriteLine("6. d) Odebrani hry"); * Console.WriteLine("Smazano " + GameTable.Delete(77) + " zaznamu."); * * * * * Console.WriteLine(" ------------------------------------- 7. Evidence Uzivatelu ------------------------------------- "); * * Console.WriteLine("7. a) Pridani noveho uzivatele"); * System_user s = new System_user(); * s.Id = 77; * s.Username = "******"; * s.Rights = "User"; * Console.WriteLine("Pridano " + System_userTable.Insert(s, db) + " zaznamu."); * * * * Console.WriteLine("7. c) Upraveni uzivatelskeho profilu"); * s.Username = "******"; * Console.WriteLine("Upraveno " + System_userTable.Update(s) + " zaznamu."); * * Console.WriteLine("7. b) Odebrani uzivatele"); * Console.WriteLine("Smazano " + System_userTable.Delete(77) + " zaznamu."); * */ }