Re: [Haskelldb-users] Request for code review: Patch removing "distinct" option, adds "unique" function

[Bjorn B. <bri...@cs...>]

On Dec 21, 2007, at 17:43 , Justin Bailey wrote:

> On Dec 21, 2007 12:26 AM, Bjorn Bringert <bri...@cs...> =20
> wrote:
>
>> Great, thank you! I'm sorry about the complications. I've now pushed
>> your patch.
>>
>>
>> So, what are you working on now?
>>
>
> No problem. I'm interested in using haskelldb to generate SQL for a
> PHP data-access layer, so I've now added named parameters as another
> expression type. PHP's odbc family of functions support "prepared"
> statements with parameters, but they are indicated by position only.
> That means its  very important  that I can get the list of parameters
> in a query in the same order as they will appear in the SQL text.
> Ideally, I could re-use the pretty-printing framework but that is a
> pretty big engineering task. I settled on generating them from the
> intermediate SqlSelect values. Not idea but safe enough.
>
> Things I'd like to do still:
>
>   * Proper joins (starting with inner join)
>   * Representation of foreign-key relationships (ideally extracted =20
> from the DB)
>   * Tests
>
> We'll see how far I get ... Any ideas or suggestions are welcome!

I believe Peter Gammie has some code for foreign key constrains.
Peter: is that ready to be pulled into HaskellDB?

I did some work on the testsuite yesterday. hs-plugins is no longer =20
required to run it, which should make testing much easier.

/Bj=F6rn