Odoo创建序列基于PostgreSQL序列

Question

我正在使用odoo 14，我想自定义sale.order编号生成。所以，我想在PostgreSQL数据库序列对象的基础上创建新的序列(ir.sequence(。

你知道吗？

谢谢你的帮助。

SAAD

Answer 1

来自odoo导入api、字段、模型导入psycopg2

类通风口(models.Model(：_inherit=['销售订单']

company = fields.Char()
name = fields.Char(string='Order Reference')
#Connection a la base de donnees
def open_conn(self):
try:
connection = psycopg2.connect(user="user",
password="xxxxxxxxxxxxxx",
host="192.168.1.1",
port="5432",
database="ventes")
print("Using Python variable in PostgreSQL select Query")
cursor = connection.cursor()
postgreSQL_select_Query = "select nextval('myOdoo')"
cursor.execute(postgreSQL_select_Query)
row = cursor.fetchone()
return  row[0]
except (Exception, psycopg2.Error) as error:
print("Error fetching data from PostgreSQL table", error)
finally:
# closing database connection
if connection:
cursor.close()
connection.close()
print("PostgreSQL connection is closed n")
@api.model
def create(self, vals):
num = self.open_conn()
vals['name'] = num
result = super(ventes, self).create(vals)
return result