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);
}
