refresh materialized view

1 files changed, 10 insertions, 1 deletions

diff --git a/indoteknik_custom/models/sale_monitoring_detail.py b/indoteknik_custom/models/sale_monitoring_detail.py
index a393f81d..405b43ef 100755
--- a/indoteknik_custom/models/sale_monitoring_detail.py
+++ b/indoteknik_custom/models/sale_monitoring_detail.py
@@ -1,4 +1,7 @@
 from odoo import fields, models, api, tools
+import logging
+
+_logger = logging.getLogger(__name__)
 
 
 class SaleMonitoringDetail(models.Model):
@@ -19,8 +22,14 @@ class SaleMonitoringDetail(models.Model):
     date_order = fields.Datetime(string="Date Order")
     status = fields.Char(string="Status")
 
+    def refresh_mv(self):
+        _logger.info('Refresh Materialized View Starting...')
+        self.env.cr.execute("REFRESH MATERIALIZED VIEW sale_monitoring_detail")
+        _logger.info("Refresh Materialized View berhasil")
+
     def init(self):
-        tools.drop_view_if_exists(self.env.cr, self._table)
+        # tools.drop_view_if_exists(self.env.cr, self._table)
+        self.env.cr.execute("DROP MATERIALIZED VIEW sale_monitoring_detail CASCADE")
         self.env.cr.execute("""
         CREATE MATERIALIZED VIEW %s AS (
         SELECT