Comment 11 for bug 593532

Revision history for this message
rrmckinley (rrmckinley) wrote : Re: [Bug 593532] Re: SQL : Merge query support

Yes, I am finally getting around to side projects again after to much
work. I'll get a patch out this weekend.

On Wed, Sep 1, 2010 at 8:31 AM, Timo Westkämper
<email address hidden> wrote:
> McKinley, any changes to your internet connectivity? I am fixing issues
> to be able to release Querydsl 2.0 in a few weeks. If you want you can
> also post an informal patch as a code snippet or describe how you did
> it.
>
> --
> SQL : Merge query support
> https://bugs.launchpad.net/bugs/593532
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Querydsl: In Progress
>
> Bug description:
> Provide a merge query that will work on DBMSs that do not support merge. It would work by using the data entered into the columns() and values() methods to generate a where clause automatically. An ID would be entered in the key() method and that data would be used to generate the Querydsl list() request. When a list of IDs is returned that list would be used to generate an update statement. The values that are not in the list of IDs would be used to generate an insert statement. The whole operation would return a unified list of IDs from the update command and the insert command. Many times, a merge command is used to insert or update a single record so it is mostly a convenience to write the lookup and update in one command.
> http://www.h2database.com/html/grammar.html#merge
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/querydsl/+bug/593532/+subscribe
>