Hi,
While using Metamodel, we encountered a scenario in which we have to write
a metamodel query to delete some records using the following *IN *clause
sql -
* delete from <table name> where id in
(<subquery>)*
and we used the following query -
updateableDataContext.executeUpdate(new UpdateScript() {
@Override
public void run(UpdateCallback callback) {
RowDeletionBuilder where = callback.deleteFrom(<table
name>).where(
new FilterItem(<some select item>,
OperatorType.IN, new SelectItem(<some select item>, new
FromItem(<subquery>))));
}});
So can we use IN clause with sub-query to delete records.
Thanks,
Balendra
On 31 March 2014 00:30, Kasper Sørensen <[email protected]>wrote:
> OK, I added a JIRA issue on improving this (METAMODEL-45)
>
>
> 2014-03-25 23:54 GMT+01:00 Tomasz Guziałek <
> [email protected]>:
>
> > +1
> >
> > I was not persistent enough to wait until the test timeouts, it took too
> > long in my case.
> >
> > Regards,
> > Tomasz
> >
> > From: Kasper Sørensen<mailto:[email protected]>
> > Sent: Tuesday, March 25, 2014 10:05 PM
> > To: [email protected]<mailto:
> > [email protected]>
> >
> > Hi guys,
> >
> > Just wanted to take a note the my build is now taking very long to
> complete
> > since the HBase module has unittests that always try to connect to a
> > localhost server. We should definately do like we do in the case of e.g.
> > MongoDB, Salesforce etc. - have a optional properties file for connection
> > information, and in case it is not specified, skip the tests for that
> > particular backend type.
> >
> > Kasper
> >
>
