public void Search(string searchText, int expected) { var connection = Helpers.SetupConnection(); var entryDataAdapter = new EntryDataAdapter(); var phoneBookDataAdapter = new PhoneBookDataAdapter(); var phoneBook = phoneBookDataAdapter.Insert("MyPhoneBook", connection); var myEntry = entryDataAdapter.Insert(new Entry() { Name = "MyEntry", PhoneBookId = phoneBook.Id }, connection); var myOtherEntry = entryDataAdapter.Insert(new Entry() { Name = "MyOtherEntry", PhoneBookId = phoneBook.Id }, connection); var someEntry = entryDataAdapter.Insert(new Entry() { Name = "SomeEntry", PhoneBookId = phoneBook.Id }, connection); var searchResult = entryDataAdapter.Search(searchText, phoneBook.Id, connection); Assert.Equal(expected, searchResult.Count); }
public void CantInsertDuplicates() { var connection = Helpers.SetupConnection(); var dataAdapter = new PhoneBookDataAdapter(); dataAdapter.Insert("MyPhoneBook", connection); Assert.Throws <Exception>(() => dataAdapter.Insert("MyPhoneBook", connection)); }
public void CanInsertAndRetrieve() { var connection = Helpers.SetupConnection(); var dataAdapter = new PhoneBookDataAdapter(); var phoneBook = dataAdapter.Insert("MyPhoneBook", connection); var retrieved = dataAdapter.GetByName("MyPhoneBook", connection); Assert.Equal(phoneBook.Id, retrieved.Id); }
public void GetAll() { var connection = Helpers.SetupConnection(); var dataAdapter = new PhoneBookDataAdapter(); dataAdapter.Insert("MyPhoneBook", connection); dataAdapter.Insert("MyPhoneBook2", connection); dataAdapter.Insert("MyOtherBook", connection); dataAdapter.Insert("PhoneBook", connection); dataAdapter.Insert("XXX", connection); var results = dataAdapter.GetAll(connection); Assert.Equal(5, results.Count); }
public void Search(string searchText, int expected) { var connection = Helpers.SetupConnection(); var dataAdapter = new PhoneBookDataAdapter(); dataAdapter.Insert("MyPhoneBook", connection); dataAdapter.Insert("MyPhoneBook2", connection); dataAdapter.Insert("MyOtherBook", connection); dataAdapter.Insert("PhoneBook", connection); dataAdapter.Insert("XXX", connection); var results = dataAdapter.Search(searchText, connection); Assert.Equal(expected, results.Count); }
public void CanInsertAndRetrieve() { var connection = Helpers.SetupConnection(); var entryDataAdapter = new EntryDataAdapter(); var phonebookDataAdapter = new PhoneBookDataAdapter(); var phoneBook = phonebookDataAdapter.Insert("MyPhoneBook", connection); var entry = entryDataAdapter.Insert(new Entry() { Name = "MyEntry", PhoneNumber = "012 555 55555", PhoneBookId = phoneBook.Id }, connection); var retrieved = entryDataAdapter.Get(entry.Id, connection); Assert.NotNull(retrieved); }