hi Thanks for replying... so anyone on the group came up with a code which i can use to print the query using these low level apis instead of re-inventing the wheel
Thankx and Regards Vik Founder www.sakshum.com www.sakshum.blogspot.com On Tue, Jan 25, 2011 at 12:42 PM, A. Stevko <[email protected]> wrote: > Sorry Vik, > There is no single string created for prepared queries - the JDO2 standard > d <http://db.apache.org/jdo/api23/apidocs/index.html>oes not allow for > retrieving query information. > http://db.apache.org/jdo/api23/apidocs/javax/jdo/Query.html > > Now if you were working with the low level database api, that Query has the > methods you are looking for > *Query.getFilterPredicates<http://code.google.com/appengine/docs/java/javadoc/com/google/appengine/api/datastore/Query.html#getFilterPredicates()> > *() > > Query.FilterPredicate.*getPropertyName<http://code.google.com/appengine/docs/java/javadoc/com/google/appengine/api/datastore/Query.FilterPredicate.html#getPropertyName()> > *() > *Query.FilterPredicate.getOperator<http://code.google.com/appengine/docs/java/javadoc/com/google/appengine/api/datastore/Query.FilterPredicate.html#getOperator()> > *() > *Query.FilterPredicate.getValue<http://code.google.com/appengine/docs/java/javadoc/com/google/appengine/api/datastore/Query.FilterPredicate.html#getValue()> > *() > > > > On Mon, Jan 24, 2011 at 10:04 PM, Vik <[email protected]> wrote: > >> anyone please some update on this? I am unable to find it by googling >> either... >> >> Thankx and Regards >> >> Vik >> Founder >> www.sakshum.com >> www.sakshum.blogspot.com >> >> >> On Sat, Jan 22, 2011 at 1:59 PM, Vik <[email protected]> wrote: >> >>> any help on this please as it is blocking us to effectively log the >>> queries >>> >>> Thankx and Regards >>> >>> Vik >>> Founder >>> www.sakshum.com >>> www.sakshum.blogspot.com >>> >>> >>> On Fri, Jan 21, 2011 at 9:47 AM, Vik <[email protected]> wrote: >>> >>>> Well That's fine.... But I would be more interested in logging the exact >>>> query fired by engine instead of separately printing individual stuff. >>>> >>>> The individual printing these elements this way is painful as well in >>>> the development process. So, any better way to print the query exactly >>>> fired >>>> by engine? >>>> >>>> >>>> Thankx and Regards >>>> >>>> Vik >>>> Founder >>>> www.sakshum.com >>>> www.sakshum.blogspot.com >>>> >>>> >>>> On Fri, Jan 21, 2011 at 3:49 AM, A. Stevko <[email protected]>wrote: >>>> >>>>> re: how do i print the complete query executed in the logs when >>>>> this approach is used? >>>>> >>>>> Simple. Print the query string and then print the parameters. >>>>> >>>>> >>>>> On Thu, Jan 20, 2011 at 6:35 AM, Vik <[email protected]> wrote: >>>>> >>>>>> hie >>>>>> >>>>>> any updates on this please? >>>>>> >>>>>> Thankx and Regards >>>>>> >>>>>> Vik >>>>>> Founder >>>>>> www.sakshum.com >>>>>> www.sakshum.blogspot.com >>>>>> >>>>>> >>>>>> On Wed, Jan 5, 2011 at 9:58 AM, Vik <[email protected]> wrote: >>>>>> >>>>>>> Hie >>>>>>> >>>>>>> Thanks.. >>>>>>> >>>>>>> This worked for me. But how do i print the complete query executed in >>>>>>> the logs when this approach is used? >>>>>>> >>>>>>> >>>>>>> Thankx and Regards >>>>>>> >>>>>>> Vik >>>>>>> Founder >>>>>>> www.sakshum.com >>>>>>> www.sakshum.blogspot.com >>>>>>> >>>>>>> >>>>>>> On Thu, Dec 30, 2010 at 9:43 PM, Yegor <[email protected]>wrote: >>>>>>> >>>>>>>> > query.declareParameters("Long bind_pocId, Date bind_startDate, >>>>>>>> Date >>>>>>>> > bind_endDate"); >>>>>>>> >>>>>>>> This is correct. However, I personally prefer the shorter form, >>>>>>>> where >>>>>>>> instead of using filter "column == alias" along with >>>>>>>> query.declareParameters("Type alias") you just use filter "column >>>>>>>> == :alias" (note the colon before the alias name). Your query can be >>>>>>>> rewritten as follows: >>>>>>>> >>>>>>>> Query query = pm.newQuery(PocVacationSchedule.class); >>>>>>>> query.setFilter("pocId == :pi && startDate == :sd && endDate == >>>>>>>> :ed"); >>>>>>>> List<PocVacationSchedule> rulesList = (List<PocVacationSchedule>) >>>>>>>> query.execute(pocId, startFrom, endFrom); >>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "Google App Engine for Java" group. >>>>>>>> To post to this group, send email to >>>>>>>> [email protected]. >>>>>>>> To unsubscribe from this group, send email to >>>>>>>> [email protected]<google-appengine-java%[email protected]> >>>>>>>> . >>>>>>>> For more options, visit this group at >>>>>>>> http://groups.google.com/group/google-appengine-java?hl=en. >>>>>>>> >>>>>>>> >>>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Google App Engine for Java" group. >>>>>> To post to this group, send email to >>>>>> [email protected]. >>>>>> To unsubscribe from this group, send email to >>>>>> [email protected]<google-appengine-java%[email protected]> >>>>>> . >>>>>> For more options, visit this group at >>>>>> http://groups.google.com/group/google-appengine-java?hl=en. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> -- A. Stevko >>>>> =========== >>>>> "If everything seems under control, you're just not going fast >>>>> enough." M. Andretti >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Google App Engine for Java" group. >>>>> To post to this group, send email to >>>>> [email protected]. >>>>> To unsubscribe from this group, send email to >>>>> [email protected]<google-appengine-java%[email protected]> >>>>> . >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/google-appengine-java?hl=en. >>>>> >>>> >>>> >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine for Java" group. >> To post to this group, send email to >> [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<google-appengine-java%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/google-appengine-java?hl=en. >> > > > > -- > -- A. Stevko > =========== > "If everything seems under control, you're just not going fast enough." M. > Andretti > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
