Hmm I guess this is not the place (right thread) to have that topic
covered. I'll reply on your new subject mail thread.


2014-04-10 18:13 GMT+02:00 Balendra Singh <[email protected]>:

> 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
> > >
> >
>

Reply via email to