Skip to Content
This question has been flagged
actionattachmentdeletescheduled
3 Replies
9297 Rodiniai
Portretas
Pascal Tremblay

Hello there,

In Odoo 8, if I'm trying to delete the attachment "/sitemap.xml" each day to refresh it.

I'm trying this way but I get an error :


Error is :

2016-12-08 09:07:37,267 14478 ERROR odoo-iv openerp.addons.base.ir.ir_cron: Call of self.pool.get('ir.attachment')._file_delete(cr, uid, *('/', 's', 'i', 't', 'e', 'm', 'a', 'p', '.', 'x', 'm', 'l')) failed in Job 10
Traceback (most recent call last):
    File "/home/odoo-iv/odoo-8.0-20161109/openerp/addons/base/ir/ir_cron.py", line 138, in _callback    getattr(model, method_name)(cr, uid, *args)  
    File "/home/odoo-iv/odoo-8.0-20161109/openerp/api.py", line 268, in wrapper    
    return old_api(self, *args, **kwargs)
TypeError: _file_delete() takes exactly 4 arguments (15 given)


Somebody could help?


EDIT #1

Answer From Axel was right. 

But I think to delete a file, I have to use the unlink function of ir.attachement class. This function needs IDs to delete attachments. See image below, I have deleted two attachments with this action :

But now, big problem... When the new sitemap.xml attachment is recreated, it doesn't have the same id... So the action is unusable. How to overcome this problem?

Portretas
Atmesti
Portretas
Pascal Tremblay
Autorius Best Answer

Here is our solution to this problem.

Since the _file_delete function was not the right method to use to delete an attachment.

Since the unlink method needs an ids list to work.

We had written this method who works well. May be you will have some changes in this method to get it better. We are not very strong in Python...


def delete_sitemap(self, cr, uid):
        id_list = []
        cr.execute("SELECT id FROM ir_attachment WHERE name ilike '%sitemap%'")
        res = cr.fetchall()
        if res:
            for r in res:
                id_list.append(r[0])
                self.unlink(cr, uid, id_list)
                return True
        return False


Portretas
Atmesti
Portretas
Axel Mendoza
Best Answer

Hi Pascal

You just need to put your arguments value as:

("sitemap.xml",)

because in Python a tuple of one element needs a comma after the element to be taken as a tuple, meaning that:

("sitemap.xml") will be taken by Python as "sitemap.xml"

that's why Odoo take the "sitemap.xml" as the arguments tuple due to that strings in Python like many others programming languages could be taken as a list, tuple or array of characters

Portretas
Atmesti
Pascal Tremblay
Autorius

Your answer is good. Thanks. But, I think I used the wrong function. I edit my post.

Related Posts Replies Rodiniai Veikla
How to create a scheduled action with timer
action scheduled
Portretas
Portretas
1
kov. 24
2924
My scheduled actions aren't running Solved
action scheduled
Portretas
1
gruod. 21
15322
Add action to Attachment(s) menu?
action attachment
Portretas
0
kov. 15
5375
Purpose of the Scheduled Action - "Base: Auto-vacuum internal data" ?
action server auto scheduled
Portretas
Portretas
Portretas
Portretas
4
spal. 23
13906
Scheduled Action to Trigger "Compute Price from BOM" Action on All Products Solved
action bom scheduled v13
Portretas
Portretas
Portretas
Portretas
Portretas
4
birž. 23
8358