@Test
public void testGetAllColumns() {

    final String sql = "select c from Column c order by c.name";
    final List<Column> columnList = new ArrayList<>();
    columnList.add((Column) new ColumnBuilder().name("test_me").build());
    final Query query = mock(Query.class);
    when(persistenceManager.createQuery(sql)).thenReturn(query);
    when(query.getResultList()).thenReturn(columnList);
    final List<? extends Item> allColumns = columnStorage.getAllColumns();
    assertNotNull(allColumns);
    assertEquals(1, allColumns.size());
    assertEquals("test_me", allColumns.get(0).getName());
    verify(persistenceManager, times(1)).createQuery(sql);
    verifyNoMoreInteractions(persistenceManager);
    verify(query, times(1)).getResultList();
    verifyNoMoreInteractions(query);
}