Re: [appengine-java] Re: passing multiple parameters to JDOQL
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 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 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 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 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 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 rulesList = (List) > 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 > google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com > . > 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 >>> google-appengine-java@googlegroups.com. >>> To unsubscribe from this group, send email to >>> google-appengine-java+unsubscr...@googlegroups.com >>> . >>> 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 >> google-appengine-java@googlegroups.com. >> To unsubscribe from this group, send email to >> google-appengine-java+unsubscr...@googlegroups.com >> . >> 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
Re: [appengine-java] I need to do a cron without 30 sec limit
IMHO the right way depends on the number of items you have to process. :) If the number is not very big, a simple solution is to create 2 servlet (or one with a parameter). S1 - enqueue all the emails. Iterates through your entities and enqueue one task per each email (N email --> N task). Important: enque tasks using the "bulk" enqueue (max 100 task / call). S2 - send the email S1 is called by your CRON S2 is called by Task Queue Important: set the queue rate accordingly to your quota limit. If you have not billing enabled, set 5/m and 1. So you will not exceed the quota limit (8 recipients/minute). Fabrizio On Fri, Jan 21, 2011 at 6:59 PM, Mayumi Liyanage < mayumi.liyan...@coldwin.com> wrote: > Hi, I need to iterate over all the entities in the Datastore and send > out emails once a day asynchronously to the actual app. > Usual way to do this would be to invoke a Servlet using cron which > would iterate over all the entities to send emails out. However, our > data is growing at the rapid rate and sooner or later we will have a > issue with 30 sec limit problem. > What would be the best way to do this operation using app engine > without worrying about 30 sec limit? > > Can we do above using the Mapper API? If so how can we invoke a mapper > from the servlet? > > Thanks. > > -- > 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 > google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com > . > 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] What was your Slim3 Datastore API experience like?
Does anyone have experience to share with using just the datastore API from Slim3 (not the web framework) http://sites.google.com/site/slim3appengine/slim3-datastore/installation I've narrowed down my data store API choice to Objectify or Slim3. I'm leaning toward Slim3 for its global transaction support. (I'm sure I'll eventually need global transactions, eg there is no way to know when in the future if I'll need a transaction between two root entities.) Concerned about - Polluting my datamodel with Slim3 Annotations - Having to run the Annotation pre-processor as part of the IDE (will that work with maven-command line?) - Global transaction performance. The Slim3 site shows much faster times than I'm seeing http://sites.google.com/site/slim3appengine/ Local about 2x slower Entity Groups Local Transaction(millis) Global Transaction(millis) 5 447 781 http://slim3demo.appspot.com/gtx/ vs 3.5x slower 5 107 365 - What happens when a global transaction fails? Can it be detected when it occurs so the user can be notified? - Is it using undocumented Google APIs? - Support/Docs/Examples - digging through the source code to solve a problem is not much fun -- 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] how to query TaskQueue for count of running/pending tasks?
Is it possible to programmatically query the Task Queue API to see how many tasks are currently executing/pending? I don't see any way to do this in the API, and so I resorted to creating objects in the Datastore to represent queued tasks. When run, the tasks then remove their corresponding entry from the Datastore. As you can imagine, it's easy for this to get out of sync. I'd actually be pretty happy just to be able to get a simple count of tasks in the queue for a given queue name. Thanks -- 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] cron job to pull a file into the blobstore
Hi, On a daily basis I need to import a data feed which sits in a CSV file on a server. I wonder if there is some way to use a cron to launch a urlfetch and save that file to the blobstore. Is this possible? Thanks Tobi -- 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] Re: "order by" clause- JPA queries
resolved, was using wrong query and needed to add datastore-index.xml -- 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
[appengine-java] Re: cron job to pull a file into the blobstore
Hi, Yes, you can launch URL fetch to get your file and then store it. 1 limit though: the 10 min processing (the processing limit of a file). You have to be able to do your get in that amount of time minus a bit (to give some time to do the store itself) If your file is not that big, you should rather use the Blob type (< 1 Mbyte) that can go directly into the datastore rather than a blob stored into the blobstore because it's basically prohibited to write to the blobstore from your application. If you really need the blobstore, you have to use the trick explained here (2nd post): http://groups.google.com/group/google-appengine-java/browse_thread/thread/42f1db6e64a8e2e2/cb8652a43a259b7b?lnk=gst&q=blobstore+blob+trick#cb8652a43a259b7b If you really need the blobstore, can't you push from the server where you csv file resides rather than pull from gae ? hope it helps didier On Jan 22, 8:42 pm, Toby wrote: > Hi, > On a daily basis I need to import a data feed which sits in a CSV file > on a server. I wonder if there is some way to use a cron to launch a > urlfetch and save that file to the blobstore. > Is this possible? > > Thanks > Tobi -- 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 google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.