Russian Qt Forum

CREATE OR REPLACE RULE notify_report_rule AS
    ON UPDATE TO report DO 
 NOTIFY report_update;

void slotGetNotify(const QString& notification); //Изменена таблица report в БД

QSqlDatabase::database().driver()->subscribeToNotification("report_update");

connect(QSqlDatabase::database().driver(), SIGNAL(notification(const QString&)), this,
                SLOT( slotGetNotify(const QString&) ) );
//Изменена таблица report в БД

qDebug()

CREATE OR REPLACE FUNCTION report_stamp()
  RETURNS trigger AS
$BODY$
    BEGIN
        -- Check update reportn_report and reportr_report in report table
        IF UPDATE.reportn_report 
        THEN
            NOTIFY virtual;
        END IF;
        IF UPDATE.reportr_report 
        THEN
            NOTIFY virtual; 
        END IF;
              
    END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION report_stamp()
  OWNER TO postgres;

connect(QSqlDatabase::database().driver(), SIGNAL(notification(const QString&)), this,
                SLOT( slotGetNotify(const QString&) ) );

CREATE OR REPLACE FUNCTION report_stamp()
  RETURNS trigger AS
$BODY$
    BEGIN
        -- Check update reportn_report and reportr_report in report table
        IF UPDATE reportn_report 
        THEN
            NOTIFY virtual;
        END IF;
        IF UPDATE reportr_report 
        THEN
            NOTIFY virtual; 
        END IF;
              
    END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  ALTER FUNCTION report_stamp()
  OWNER TO postgres;

CREATE OR REPLACE FUNCTION send_log()
  RETURNS trigger AS
$BODY$
DECLARE
    mstr varchar(30);
    astr varchar(100);
    retstr varchar(254);
BEGIN
    IF  TG_OP = 'INSERT' THEN
        astr = NEW.name;
        mstr := 'Add new report ';
        retstr := mstr || astr;
        NOTIFY virtual;
        --INSERT INTO logs(text,added) values (retstr,NOW());
        RETURN NEW;
    ELSIF TG_OP = 'UPDATE' THEN
        astr = NEW.name;
        mstr := 'Update report ';
        retstr := mstr || astr;
        NOTIFY virtual;
        --INSERT INTO logs(text,added) values (retstr,NOW());
        RETURN NEW;
    ELSIF TG_OP = 'DELETE' THEN
        astr = OLD.name;
        mstr := 'Remove report ';
        retstr := mstr || astr;
        NOTIFY virtual;
        --INSERT INTO logs(text,added) values (retstr,NOW());
        RETURN OLD;
    END IF;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION send_log()
  OWNER TO postgres;


CREATE TRIGGER t_report
  AFTER INSERT OR UPDATE OR DELETE
  ON report
  FOR EACH ROW
  EXECUTE PROCEDURE send_log();