def _auto_init(self):
res = super(IrValues, self)._auto_init()
tools.create_index(self._cr,
'ir_values_key_model_key2_res_id_user_id_idx',
self._table,
['key', 'model', 'key2', 'res_id', 'user_id'])
return res
def init(self):
"""Create index for :meth:`~.move_report_domain`
This method follows the logic of :meth:`~.move_report_domain`, which
returns a domain with either two or three clauses depending on the
value of `~._edi_move_report_via`. To complicate things,
`~._edi_move_report_via` is allowed to be overridden in models
inheriting from this one. This method gets called for each derived
model and creates the appropriate index for each one.
"""
super(EdiMoveReportDocument, self).init()
Move = self.env["stock.move"]
if self._edi_move_report_via is not None:
tools.create_index(
self._cr,
"stock_move_state_picking_type_id_%s_index" %
(self._edi_move_report_via, ),
Move._table,
["state", "picking_type_id", self._edi_move_report_via],
)
else:
tools.create_index(
self._cr,
"stock_move_state_picking_type_id_index",
Move._table,
["state", "picking_type_id"],
)
def _auto_init(self):
res = super(IrTranslation, self)._auto_init()
# Add separate md5 index on src (no size limit on values, and good performance).
tools.create_index(self._cr, 'ir_translation_src_md5', self._table, ['md5(src)'])
tools.create_unique_index(self._cr, 'ir_translation_unique', self._table,
['type', 'name', 'lang', 'res_id', 'md5(src)'])
return res
def _auto_init(self):
res = super(IrTranslation, self)._auto_init()
# Add separate md5 index on src (no size limit on values, and good performance).
tools.create_index(self._cr, 'ir_translation_src_md5', self._table, ['md5(src)'])
tools.create_unique_index(self._cr, 'ir_translation_unique', self._table,
['type', 'name', 'lang', 'res_id', 'md5(src)'])
return res
def init(self):
tools.create_index(
self._cr,
"stock_valuation_layer_usage_index",
self._table,
["stock_valuation_layer_id", "stock_move_id", "stock_move_id"],
)
def init(self):
""" Creates index for model order """
super(SaleOrder, self).init()
tools.create_index(
self._cr,
"sale_order_requested_date_priority_id_index",
self._table,
["requested_date ASC", "priority DESC", "id ASC"],
)
def _auto_init(self):
res = super(IrTranslation, self)._auto_init()
# Add separate md5 index on src (no size limit on values, and good performance).
tools.create_index(self._cr, 'ir_translation_src_md5', self._table, ['md5(src)'])
# Cover 'model_terms' type
tools.create_unique_index(self._cr, 'ir_translation_unique', self._table,
['type', 'name', 'lang', 'res_id', 'md5(src)'])
if not tools.index_exists(self._cr, 'ir_translation_code_unique'):
self._cr.execute("CREATE UNIQUE INDEX ir_translation_code_unique ON ir_translation (type, lang, md5(src)) WHERE type = 'code'")
if not tools.index_exists(self._cr, 'ir_translation_model_unique'):
self._cr.execute("CREATE UNIQUE INDEX ir_translation_model_unique ON ir_translation (type, lang, name, res_id) WHERE type = 'model'")
return res
def _auto_init(self):
res = super(IrTranslation, self)._auto_init()
# Add separate md5 index on src (no size limit on values, and good performance).
tools.create_index(self._cr, 'ir_translation_src_md5', self._table, ['md5(src)'])
# Cover 'model_terms' type
tools.create_unique_index(self._cr, 'ir_translation_unique', self._table,
['type', 'name', 'lang', 'res_id', 'md5(src)'])
if not tools.index_exists(self._cr, 'ir_translation_code_unique'):
self._cr.execute("CREATE UNIQUE INDEX ir_translation_code_unique ON ir_translation (type, lang, md5(src)) WHERE type = 'code'")
if not tools.index_exists(self._cr, 'ir_translation_model_unique'):
self._cr.execute("CREATE UNIQUE INDEX ir_translation_model_unique ON ir_translation (type, lang, name, res_id) WHERE type = 'model'")
if not tools.index_exists(self._cr, 'ir_translation_selection_unique'):
self._cr.execute("CREATE UNIQUE INDEX ir_translation_selection_unique ON ir_translation (type, lang, name, md5(src)) WHERE type IN ('selection', 'constraint', 'sql_constraint')")
return res
def init(self):
""" Creates indexes for _check_resultant_package_level
"""
super(StockMoveLine, self).init()
tools.create_index(
self._cr,
"stock_move_line_state_result_package_id_index",
self._table,
["state", "result_package_id"],
)
tools.create_index(
self._cr,
"stock_move_line_state_u_result_parent_package_id_index",
self._table,
["state", "u_result_parent_package_id"],
)
def init(self):
"""Create index for :meth:`~.pick_report_domain`
This method follows the logic of :meth:`~.pick_report_domain`, which
returns a domain with either two or three clauses depending on the
value of `~._edi_pick_report_via`. To complicate things,
`~._edi_pick_report_via` is allowed to be overridden in models
inheriting from this one. This method gets called for each derived
model and creates the appropriate index for each one.
"""
super(EdiPickReportDocument, self).init()
Picking = self.env['stock.picking']
if self._edi_pick_report_via is not None:
tools.create_index(
self._cr, 'stock_picking_state_picking_type_id_%s_index' %
(self._edi_pick_report_via, ), Picking._table,
['state', 'picking_type_id', self._edi_pick_report_via])
else:
tools.create_index(self._cr,
'stock_picking_state_picking_type_id_index',
Picking._table, ['state', 'picking_type_id'])
def _auto_init(self):
res = super(IrAttachment, self)._auto_init()
tools.create_index(self._cr, 'ir_attachment_res_idx',
self._table, ['res_model', 'res_id'])
return res
def _auto_init(self):
res = super(HolidaysRequest, self)._auto_init()
tools.create_index(self._cr, 'hr_leave_date_to_date_from_index',
self._table, ['date_to', 'date_from'])
return res
def init(self):
tools.create_index(self._cr, 'stock_valuation_layer_index',
self._table, [
'product_id', 'remaining_qty', 'stock_move_id',
'company_id', 'create_date'
])
def _auto_init(self):
res = super(HolidaysRequest, self)._auto_init()
tools.create_index(self._cr, 'hr_leave_date_to_date_from_index',
self._table, ['date_to', 'date_from'])
return res
def init(self):
res = super(Attachment, self).init()
# ir_http._xmlid_to_obj is using this index for multi-website
tools.create_index(self._cr, 'ir_attachment_key_website_idx',
self._table, ['key', 'website_id'])
return res
def _auto_init(self):
res = super(FieldFile, self)._auto_init()
tools.create_index(self._cr, 'muk_dms_file_reference_idx', self._table,
['reference_model', 'reference_id'])
return res
def _auto_init(self):
res = super(IrAttachment, self)._auto_init()
tools.create_index(self._cr, 'ir_attachment_res_idx',
self._table, ['res_model', 'res_id'])
return res
def init(self):
tools.create_index(self._cr, 'account_move_line_move_product_index',
self._table, ['move_id', 'product_id'])
def init(self):
tools.create_index(self._cr, "hr_work_entry_date_start_date_stop_index", self._table, ["date_start", "date_stop"])
def _auto_init(self):
res = super(IrValues, self)._auto_init()
tools.create_index(self._cr, 'ir_values_key_model_key2_res_id_user_id_idx',
self._table, ['key', 'model', 'key2', 'res_id', 'user_id'])
return res
