I've accidentally posted this twice. Please have a look at the other
thread:
https://groups.google.com/forum/?fromgroups#!topic/web2py/u5R-vGcP580%5B1-25%5D
I answered your question there (emails are added from within the
application).
On Sunday, 12 August 2012 06:17:15 UTC+12, Anthony wrote:
How are emails added to the database -- does that happen within the
application, or also in a script?
On Saturday, August 11, 2012 12:55:40 AM UTC-4, Florian Letsch wrote:
*My first post somehow didn't make it to the group, I don't know where
it got lost. Sorry if I submit this twice, I have never participated in a
news group before.*
I am trying to set up a background queue for sending email as described
in the web2py book.
http://web2py.com/books/default/chapter/29/8#Sending-messages-using-a-background-task
However, emails are only sent when they have been in the database before
starting the script. Emails I add to the database when the queue is running
do not get picked up for some reason. I got it to work by adding an
additional db.commit() before the select() in every loop run. I assume this
should not be needed. Does anyone have an idea why this is not working
without that additional commit?
import time
while True:
db.commit() # not working without this line
rows = db(db.queue.status=='pending').select()
for row in rows:
if mail.send(to=row.email,
subject=row.subject,
message=row.message):
row.update_record(status='sent')
else:
row.update_record(status='failed')
db.commit()
time.sleep(60) # check every minute
--
