Re: Mixing OO and DB

From: Robert Martin <unclebob_at_objectmentor.com>
Date: Mon, 3 Mar 2008 19:24:02 -0600
Message-ID: <2008030319240293099-unclebob_at_objectmentorcom>


On 2008-03-03 00:08:43 -0600, Gene Wirchenko <genew_at_ocis.net> said:

> Robert Martin <unclebob_at_objectmentor.com> wrote:
>
> [snip]
>

>> Not if they are explanatory.  Employee.find("Bob") is a lot easier to
>> understand than Select * from Employee_Table where Name = 'Bob';  In
>> any case, once you have the method, you can polymorphically replace it
>> with test methods etc.

>
> Bah! It is just syntactic sugar and not very sweet at that.
>
> Now try finding Bob who works in Accounting:
> select * from employee_table
> where name='Bob' and dept='Accounting';
>
> Your go.
get_accountant("Bob"); or find_by_name_and_department("Bob", "Accounting"); I'm sure you can think of some others that would read nicer than the SQL.
-- 
Robert C. Martin (Uncle Bob)  | email: unclebob_at_objectmentor.com
Object Mentor Inc.            | blog:  www.butunclebob.com
The Agile Transition Experts  | web:   www.objectmentor.com
800-338-6716                  |
Received on Tue Mar 04 2008 - 02:24:02 CET

Original text of this message