CEZERT

exp(url:https://www.postgresqltutorial.com/postgresql-triggers/creating-first-trigger-postgresql/)

CREATE 2 TABLES

CREATE TABLE employee
(emp_id int4,
employee_name varchar(25),
department_id int4,
salary numeric(7,2));

CREATE TABLE emp_salary_history

CEZERT

from qgis.core import *
from qgis.gui import *
from qgis.utils import *
from PyQt5.QtCore import *
from PyQt5.QtGui import *

app = QgsApplication([], True)
app.setPrefixPath("C:/Program Files/QGIS Brighton/apps/qgis", True)
app.initQgis()
canvas = QgsMapCanvas()

CEZERT

Code du fichier *.

profil.qrc

qrc profil.png

CEZERT

import os
from PyQt5 import uic
from PyQt5.QtWidgets import QWidget, QApplication, QProgressBar
from qgis.core import QgsProcessingAlgorithm
from PyQt5.QtCore import QTimer


os.chdir(r"S:\09-Production\CLIENTS\AIR LIQUIDE\21-0178 TOPO 3D ALFI NORD 2021\Travail\Dao\Outils de traitement\Configurations")

FORM_CLASS, _ = uic.loadUiType("alfi_nord_2022.ui")

CEZERT

# CSV to XLS python
import pandas as pd
import os
from tkinter import Tk, filedialog
import glob
from pathlib import Path

root = Tk()
root.withdraw()
root.attributes('-topmost', True)

CEZERT

-- reference_ef.ef_chantier definition

-- Drop table

-- DROP TABLE reference_ef.ef_chantier;

CREATE TABLE reference_ef.ef_chantier (
	ogc_fid serial4 NOT NULL,
	geom public.geometry(multipolygon, 2154) NULL,
	gml_parent varchar(254) NULL,

CEZERT

Notes

-- Table Rules

-- DROP RULE qualification_trace_insert_ignore ON traitement."Qualification_trace";

CREATE RULE qualification_trace_insert_ignore AS ON INSERT TO "Acapulco"."Qualification_trace" WHERE (EXISTS ( SELECT 1 FROM "Acapulco"."Qualification_trace"

CEZERT

from qgis.core import *
from qgis.gui import *


@qgsfunction(args='auto', group='Custom')
def findreplace(s, feature, value):
    chars = [('Â',  '')
        ,('Ê', 'E')
        ,(' Î', 'I')
        ,('Ô', 'O')

CEZERT

import functools
import time

def slow_down(func):
    """Sleep 1 second before calling the function"""
    @functools.wraps(func)
    def wrapper_slow_down(*args, **kwargs):
        time.sleep(1)
        return func(*args, **kwargs)
    return wrapper_slow_down

CEZERT

import functools

def debug(func):
    """Print the function signature and return value"""
    @functools.wraps(func)
    def wrapper_debug(*args, **kwargs):
        args_repr = [repr(a) for a in args]                      # 1
        kwargs_repr = [f"{k}={v!r}" for k, v in kwargs.items()]  # 2
        signature = ", ".join(args_repr + kwargs_repr)           # 3
        print(f"Calling {func.__name__}({signature})")