forked from coop-cloud/nextcloud
Linus Gasser
4f4ba6db79
This adds an optional eurooffice instance to the recipe. Contrary to the OnlyOffice integration, which is a separate recipe, I choose this way because I suppose that most of the time the eurooffice instance will only be used by Nextcloud. There seems to be an error with the current EuroOffice official image which fails to initialize their database. For this reason it also includes a Postgres and a RabbitMQ service. Both are initialised upon first usage.
74 lines
2.8 KiB
PL/PgSQL
74 lines
2.8 KiB
PL/PgSQL
--
|
|
-- Create schema onlyoffice
|
|
--
|
|
|
|
-- CREATE DATABASE onlyoffice ENCODING = 'UTF8' CONNECTION LIMIT = -1;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for doc_changes
|
|
-- ----------------------------
|
|
CREATE TABLE IF NOT EXISTS "doc_changes" (
|
|
"tenant" varchar(255) COLLATE "default" NOT NULL,
|
|
"id" varchar(255) COLLATE "default" NOT NULL,
|
|
"change_id" int4 NOT NULL,
|
|
"user_id" varchar(255) COLLATE "default" NOT NULL,
|
|
"user_id_original" varchar(255) COLLATE "default" NOT NULL,
|
|
"user_name" varchar(255) COLLATE "default" NOT NULL,
|
|
"change_data" text COLLATE "default" NOT NULL,
|
|
"change_date" timestamp without time zone NOT NULL,
|
|
PRIMARY KEY ("tenant", "id", "change_id")
|
|
)
|
|
WITH (OIDS=FALSE);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for task_result
|
|
-- ----------------------------
|
|
CREATE TABLE IF NOT EXISTS "task_result" (
|
|
"tenant" varchar(255) COLLATE "default" NOT NULL,
|
|
"id" varchar(255) COLLATE "default" NOT NULL,
|
|
"status" int2 NOT NULL,
|
|
"status_info" int4 NOT NULL,
|
|
"created_at" timestamp without time zone DEFAULT NOW(),
|
|
"last_open_date" timestamp without time zone NOT NULL,
|
|
"user_index" int4 NOT NULL DEFAULT 1,
|
|
"change_id" int4 NOT NULL DEFAULT 0,
|
|
"callback" text COLLATE "default" NOT NULL,
|
|
"baseurl" text COLLATE "default" NOT NULL,
|
|
"password" text COLLATE "default" NULL,
|
|
"additional" text COLLATE "default" NULL,
|
|
PRIMARY KEY ("tenant", "id")
|
|
)
|
|
WITH (OIDS=FALSE);
|
|
|
|
CREATE OR REPLACE FUNCTION merge_db(_tenant varchar(255), _id varchar(255), _status int2, _status_info int4, _last_open_date timestamp without time zone, _user_index int4, _change_id int4, _callback text, _baseurl text, OUT isupdate char(5), OUT userindex int4) AS
|
|
$$
|
|
DECLARE
|
|
t_var "task_result"."user_index"%TYPE;
|
|
BEGIN
|
|
LOOP
|
|
-- first try to update the key
|
|
-- note that "a" must be unique
|
|
IF ((_callback <> '') IS TRUE) AND ((_baseurl <> '') IS TRUE) THEN
|
|
UPDATE "task_result" SET last_open_date=_last_open_date, user_index=user_index+1,callback=_callback,baseurl=_baseurl WHERE tenant = _tenant AND id = _id RETURNING user_index into userindex;
|
|
ELSE
|
|
UPDATE "task_result" SET last_open_date=_last_open_date, user_index=user_index+1 WHERE tenant = _tenant AND id = _id RETURNING user_index into userindex;
|
|
END IF;
|
|
IF found THEN
|
|
isupdate := 'true';
|
|
RETURN;
|
|
END IF;
|
|
-- not there, so try to insert the key
|
|
-- if someone else inserts the same key concurrently,
|
|
-- we could get a unique-key failure
|
|
BEGIN
|
|
INSERT INTO "task_result"(tenant, id, status, status_info, last_open_date, user_index, change_id, callback, baseurl) VALUES(_tenant, _id, _status, _status_info, _last_open_date, _user_index, _change_id, _callback, _baseurl) RETURNING user_index into userindex;
|
|
isupdate := 'false';
|
|
RETURN;
|
|
EXCEPTION WHEN unique_violation THEN
|
|
-- do nothing, and loop to try the UPDATE again
|
|
END;
|
|
END LOOP;
|
|
END;
|
|
$$
|
|
LANGUAGE plpgsql;
|