exp(url:https://www.postgresqltutorial.com/postgresql-triggers/creating-first-trigger-postgresql/)
CREATE TABLE employee
(emp_id int4,
employee_name varchar(25),
department_id int4,
salary numeric(7,2));
CREATE TABLE emp_salary_history
exp(url:https://www.postgresqltutorial.com/postgresql-triggers/creating-first-trigger-postgresql/)
CREATE TABLE employee
(emp_id int4,
employee_name varchar(25),
department_id int4,
salary numeric(7,2));
CREATE TABLE emp_salary_history
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() |
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") |
# 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) |
-- 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, |
from qgis.core import * | |
from qgis.gui import * | |
@qgsfunction(args='auto', group='Custom') | |
def findreplace(s, feature, value): | |
chars = [('Â', '') | |
,('Ê', 'E') | |
,(' Î', 'I') | |
,('Ô', 'O') |
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 |
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})") |