Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In this particular case you are testing controller in isolation from database. ClientService is abstraction over the database, and should be replaced by test double. You injected fake into controller, but still assert real implementation. This makes no sense.</p> <p>Assert the same object, which was injected into controller.</p> <pre><code> interface IClientService { public void GetNumberOfClients(); public IList&lt;Client&gt; GetAllClients(); public void Insert(Client client); } </code></pre> <p>Fake service implementation:</p> <pre><code> class FakeClientService : IClientService { private IList&lt;CLient&gt; rows = new List&lt;CLient&gt;(); public void GetNumberOfClients() { return list.Count; } public IList&lt;Client&gt; GetAllClients() { return list; } public void Insert(Client client) { client.Add(client); } } </code></pre> <p>Test:</p> <pre><code>[Test] public void ClientIsInserted() { ClientController cc = new ClientController(); FakeClientService fakeService = new FakeClientService(); cc.ClientService = fakeService; cc.Create(new FormCollection (){name="John"}); assert.areEqual(1, fakeService.GetNumberOfClients()); assert.areEqual("John", fakeService.GetAllClients()[0].Name); } </code></pre> <p>If you want to check how controller and service work together - create fake for ClientDatabaseClass. It would be like:</p> <pre><code>[Test] public void ClientIsInserted() { ClientController cc = new ClientController(); IClientDatabaseClass databaseFake = new ClientDatabaseClassFake(); ClientService service= new ClientService(); service.Database = databaseFake; cc.ClientService = service; cc.Create(new FormCollection (){name="John"}); assert.areEqual(1, service.GetNumberOfClients()); assert.areEqual("John", service.GetAllClients()[0].Name); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POWhat is the way to go to fake my database layer in a unit test?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USYauheni Sivukha
    1. USYauheni Sivukha
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is the way to go to fake my database layer in a unit test?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSorry, wasn't realy clear about that: The clientservice doesn't connect directly to the DB. It calls a ClientDataClass which will connect to the database. So the ClientDatabaseClass will be replaced with a fake
      singulars
      1. PO
      1. USMichel
    2. COMichel, you need to decide - what do you want to test? If you want to test logic in controller, then the best option would be to replace it's neighbor classes by test doubles. If you want to check how controller and service work together - create fake for ClientDatabaseClass.
      singulars
      1. PO
      1. USYauheni Sivukha
    3. COI want to test the controller. So i want to check if validations go well and if the new client is saved to the database. So to be clear: i'm faking the databaseclasses (where the object is saved to the database) . Say during my test i create a list with clients and i add one, and during my assert in my unit test i want to check if the client was added, i have a new instance of the database class so the original list, with the new client added, is already gone. Do you save the original list on disk or something?
      singulars
      1. PO
      1. USMichel
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload