On 2009-08-04, Paul Taylor <ij...@fastmail.fm> wrote:
> Bill Moran wrote:
>> In response to Paul Taylor <ij...@fastmail.fm>:
>>
>>   
>>> Bill Moran wrote:
>>>     
>>>> In response to Paul Taylor <ij...@fastmail.fm>:
>>>>
>>>>       
>>>>> Sam Mason wrote:
>>>>>     
>>>>>         
>>>>>> On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote:
>>>>>>           
>>>>>>> Does postgres have an embedded mode to allow a database to be embedded 
>>>>>>> with Java application without requiring seperate db manager, like the 
>>>>>>> derby database does ?
>>>>>>>         

you're looking for an embeddable SQL database written in java?

>>>>> Thats a shame, I wanted to write junit test for a java program that 
>>>>> queried a database, requiring a full database to be available for unit 
>>>>> tests is not really an environment I want to have.

fake it. use canned responses.

>>>> Has it occurred to you that testing a DB client when there's no
>>>> DB isn't really a very accurate or realistic test?
>>>>       
>>> I am testing the code that extracts information from a read only 
>>> database. These are UNIT tests so only interested in getting the right 
>>> results given a particular set of data, anything else is a distraction.
>>>     
>>
>> Then replace the DB client class with a class that returns fabricated
>> data for the purpose of your test.
>>   
> Won't work because I am writing SQL and I want to test the SQL is correct

if you know what SQL it should write compare what is written with what
is expected.




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to