Python_scripts/1_SICEN/refresh_vm.py

12 lines
280 B
Python

#!/usr/bin/env python3
# -*- coding: UTF-8 -*-
from pycen import con_sicen
def refresh_vm():
sql = "REFRESH MATERIALIZED VIEW saisie.vm_synthese_observations WITH DATA;"
with con_sicen.begin() as cnx:
cnx.execute(sql)
if __name__ == "__main__":
refresh_vm()