Skip ke Konten
Pertanyaan ini telah diberikan tanda
updatesqlcustommoduleodoo12
2 Replies
4607 Tampilan
Avatar
Armel Conrad

Hi everyone,


I'm beginner on Odoo12 and I'm trying to update a data in the database using custom module, but it's not working.

Thanks for your help.


class IrSequence(models.Model):
    _inherit = "ir.sequence"

    @api.model
    def _update_sequence(self):
        cr = self._cr
        cr.execute("SELECT id FROM ir_sequence WHERE name = 'BILL Sequence' LIMIT 1")
        sequence_data = cr.fetchone()

        if sequence_data:
            cr.execute(
                "UPDATE ir_sequence SET name='INV Sequence', implementation='standard', prefix='INV/%(range_year)s/', use_data_range=0 WHERE id = %s",
                (sequence_data[0]))
            return True
Avatar
Buang
Avatar
Alex Lazich
Jawaban Terbai

It looks like you're trying to update the sequence numbering. You can do that through a configuration settings rather than writing a custom module.

It's under the Settings -> Technical -> Sequences & Identifiers -> Sequences menu. Typing in Sequences on the search bar on the home page should bring it up.

Also note that it is usually easier, and safer, to update data through the API instead of directly through the SQL database. 

Avatar
Buang
Avatar
Armel Conrad
Penulis Jawaban Terbai

Thank for your answer. So It's more difficult and dangerous to do it through a custom.

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Using base_external_dbsource in Custom Module.
sql custommodule
Avatar
Avatar
Avatar
2
Jun 22
6435
ir.attachment res_*-fields NULL on save Diselesaikan
ir.attachment custommodule odoo12
Avatar
1
Mar 19
7060
Error: could not serialize access due to concurrent update
update sql serializable
Avatar
Avatar
Avatar
3
Sep 17
23696
sql constraints exception Diselesaikan
database sql constraints odoo12
Avatar
Avatar
2
Sep 21
4792
psycopg2.ProgrammingError When deleting record Diselesaikan
delete psycopg2 custommodule odoo12
Avatar
Avatar
5
Des 19
6239