跳至内容
菜单
此问题已终结
2 回复
5728 查看

Dear guys,

I have a scheduler ( ir.cron ) that runs a function that will send email to some users.

Basically, everytime my code send the email to the user, it will write to each object ( email_sent = True ) so that the next time the scheduler run it won't send email to that user again.

But when I check, the database will only be written after the scheduler has finished running( All emails has been sent )

I need it to write to database everytime the email is sent to each user.

Anyone know how to do this?

形象
丢弃
最佳答案

In order to save the save the data between the scheduler run you can use cr.commit() below the code of mail send.

Or

in mail.mail object's send method you can pass auto_commit to True. Here is a sample code

self.pool.get('mail.mail').send(cr, uid, mail_ids, auto_commit=True, raise_exception=False, context=context)
形象
丢弃
编写者 最佳答案

Hi Atul, I can't comment on your submission ( not enough karma ) .

And btw, using cr.commit() actually works. But from what from what I read, it is actually not recommended to be used.

Refer here : https://www.odoo.com/forum/help-1/question/what-is-the-cr-commit-risk-how-to-safe-db-write-60885


I haven't tried the auto_commit = True as I am using ir.mail_server object to send email. Will try later.


Thank you !


形象
丢弃

did you resolved it?

编写者

@Logicious. sorry late reply. Yes I solved it using cr.commit()

相关帖文 回复 查看 活动
1
6月 23
2589
4
3月 22
16783
0
10月 20
3023
1
3月 16
5701
0
3月 15
3222