www-apps/pydio: version bump 6.4.2-r1 → 7.0.3

Package-Manager: Portage-2.3.3, Repoman-2.3.1
Manifest-Sign-Key: C6085806

5 files changed, 187 insertions, 4 deletions

diff --git a/www-apps/pydio/Manifest b/www-apps/pydio/Manifest
index d9f3286..9cd24e1 100644
--- a/www-apps/pydio/Manifest
+++ b/www-apps/pydio/Manifest
@@ -1,14 +1,15 @@
 -----BEGIN PGP SIGNED MESSAGE-----
-Hash: SHA512
+Hash: SHA256
 
 DIST pydio-6.2.2.tar.gz 15735734 SHA256 f30a60926ce73737668d9bb64b54564f1dd2de34529466fd4770614928a33c99 SHA512 bb6ae645cb81dcce3c2d747b5fe38f4757cd3ce805662799f3dcb82940ef96ff069fc524a121667c72a1349fce6e0ea950d618d87e3e5638a6d98773764acea7 WHIRLPOOL e100bbb6d5e9af4fd7b11b2aa860dd410b7128213cacacbef515308e3e1550a2ceee163f0acf6f08d8acd6f53d4b91f123826b5eecb9eb72691f6f7a23936988
 DIST pydio-6.4.2.tar.gz 16870682 SHA256 4900fd012dfc681de526bc1198602953d1813d407af62c0260b9f016652c8da3 SHA512 2434fa314cb7ea7f32c48675e2ade3e43bf53e67a775b6f90dbef555d67a7e650f605266680a2b90d235f739bdf66abab9fa7c61ef9c1ce5d6a5ca35d6977fa7 WHIRLPOOL c8cf472199639daef5c06647c704598ac28b8bbccfc0bc18a7d31dfc741928446645da838fbc3a85b674c04187b74abec3fbfe5c9fbd3dd4b0bbd0893bee7267
+DIST pydio-7.0.3.tar.gz 43551245 SHA256 ebc278c0c6dea2551f5a5ba5ef6558f6e67e1955c83a94d5771258b5ea2fc6f4 SHA512 f8b9c3b7e21e30e86c20b3c5d060d09e1e3f259a7390be7f1de88efef2c44e9b19929d66da96ecff816e78330d19c0280e33834cc0c23c6e845f2329fcf875fd WHIRLPOOL 458a0924400eb21fd7a553bb032e83974f406636b93a97dcdd7fa744435b225b4652b13bc51f3d24c9483080a02ba65422676bce54a91528d0e6cfafb4c394b0
 -----BEGIN PGP SIGNATURE-----
 Version: GnuPG v2
 
-iL0EAREKAH0WIQRcpBfyexMbpZPAvpDV+ZXBxghYBgUCWHJ9vV8UgAAAAAAuAChp
+iL0EAREIAH0WIQRcpBfyexMbpZPAvpDV+ZXBxghYBgUCWHLJsF8UgAAAAAAuAChp
 c3N1ZXItZnByQG5vdGF0aW9ucy5vcGVucGdwLmZpZnRoaG9yc2VtYW4ubmV0NUNB
 NDE3RjI3QjEzMUJBNTkzQzBCRTkwRDVGOTk1QzFDNjA4NTgwNgAKCRDV+ZXBxghY
-BqMPAKCah0cUkWqzNSS74wft8+GmvAZryQCfUQrlZVQbeHG3xqsAC8FPqMDnt5w=
-=ohnx
+Bh0nAJ48IYXcu19DmL3wPUJ1/2Xrf8PLdgCeMDuWoNDcmbCjZSSTDbMh1HiMtR0=
+=4st1
 -----END PGP SIGNATURE-----
diff --git a/www-apps/pydio/files/7.0.1.mysql b/www-apps/pydio/files/7.0.1.mysql
new file mode 100644
index 0000000..fe431c2
--- /dev/null
+++ b/www-apps/pydio/files/7.0.1.mysql
@@ -0,0 +1,60 @@
+/* SEPARATOR */
+DROP TABLE IF EXISTS ajxp_tasks;
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS ajxp_tasks (
+  uid VARCHAR(40) NOT NULL,
+  `type` INTEGER NOT NULL,
+  parent_uid VARCHAR(40) DEFAULT NULL,
+  flags INTEGER NOT NULL,
+  label VARCHAR(255) NOT NULL,
+  user_id VARCHAR(255) NOT NULL,
+  ws_id VARCHAR(32) NOT NULL,
+  status INTEGER NOT NULL,
+  status_msg VARCHAR(500) NOT NULL,
+  progress INTEGER NOT NULL,
+  schedule INTEGER NOT NULL,
+  schedule_value VARCHAR(255) DEFAULT NULL,
+  `action` VARCHAR(255) NOT NULL,
+  parameters MEDIUMBLOB NOT NULL,
+  creation_date INTEGER NOT NULL DEFAULT 0,
+  status_update INTEGER NOT NULL DEFAULT 0,
+  PRIMARY KEY (uid)
+) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+/* SEPARATOR */
+CREATE INDEX ajxp_task_usr_idx ON ajxp_tasks (user_id);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_status_idx ON ajxp_tasks (status);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_type ON ajxp_tasks (type);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_schedule ON ajxp_tasks (schedule);
+/* SEPARATOR */
+DROP TABLE IF EXISTS ajxp_tasks_nodes;
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS `ajxp_tasks_nodes` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `task_uid` varchar(40) NOT NULL,
+  `node_base_url` varchar(255) NOT NULL,
+  `node_path` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`)
+) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+/* SEPARATOR */
+CREATE INDEX ajxp_taskn_tuid_idx ON ajxp_tasks_nodes (task_uid);
+/* SEPARATOR */
+CREATE INDEX ajxp_taskn_base_idx ON ajxp_tasks_nodes (node_base_url);
+/* SEPARATOR */
+CREATE INDEX ajxp_taskn_path_idx ON ajxp_tasks_nodes (node_path);
+/* SEPARATOR */
+DROP TABLE IF EXISTS ajxp_mq_queues;
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS `ajxp_mq_queues` (
+  `channel_name` varchar(255) NOT NULL,
+  `content` LONGBLOB NOT NULL,
+  PRIMARY KEY (`channel_name`)
+) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+/* SEPARATOR */
+DROP TRIGGER IF EXISTS `LOG_UPDATE`;
+/* SEPARATOR */
+CREATE TRIGGER `LOG_UPDATE` AFTER UPDATE ON `ajxp_index`
+FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type)
+  VALUES (new.repository_identifier, new.node_id, old.node_path, new.node_path, CASE old.node_path COLLATE utf8_bin = new.node_path COLLATE utf8_bin WHEN true THEN 'content' ELSE 'path' END);
\ No newline at end of file
diff --git a/www-apps/pydio/files/7.0.1.pgsql b/www-apps/pydio/files/7.0.1.pgsql
new file mode 100644
index 0000000..7ba1c5a
--- /dev/null
+++ b/www-apps/pydio/files/7.0.1.pgsql
@@ -0,0 +1,51 @@
+/* SEPARATOR */
+DROP TABLE IF EXISTS ajxp_tasks;
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS ajxp_tasks (
+    uid VARCHAR(255) NOT NULL ,
+    type INTEGER NOT NULL,
+    parent_uid VARCHAR(255) DEFAULT NULL,
+    flags INTEGER NOT NULL,
+    label VARCHAR(255) NOT NULL,
+    user_id VARCHAR(255) NOT NULL,
+    ws_id VARCHAR(32) NOT NULL,
+    status INTEGER NOT NULL,
+    status_msg VARCHAR(500) NOT NULL,
+    progress INTEGER NOT NULL,
+    schedule INTEGER NOT NULL,
+    schedule_value VARCHAR(255) DEFAULT NULL,
+    action VARCHAR(255) NOT NULL,
+    parameters BYTEA NOT NULL,
+    creation_date INTEGER NOT NULL DEFAULT 0,
+    status_update INTEGER NOT NULL DEFAULT 0,
+    PRIMARY KEY (uid)
+);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_usr_idx ON ajxp_tasks (user_id);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_status_idx ON ajxp_tasks (status);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_type ON ajxp_tasks (type);
+/* SEPARATOR */
+CREATE INDEX ajxp_task_schedule ON ajxp_tasks (schedule);
+/* SEPARATOR */
+DROP TABLE IF EXISTS ajxp_tasks_nodes;
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS ajxp_tasks_nodes (
+  id serial PRIMARY KEY,
+  task_uid VARCHAR(40) NOT NULL,
+  node_base_url VARCHAR(255) NOT NULL,
+  node_path VARCHAR(255) NOT NULL
+);
+/* SEPARATOR */
+CREATE INDEX ajxp_taskn_tuid_idx ON ajxp_tasks_nodes (task_uid);
+/* SEPARATOR */
+CREATE INDEX ajxp_taskn_base_idx ON ajxp_tasks_nodes (node_base_url);
+/* SEPARATOR */
+CREATE INDEX ajxp_taskn_path_idx ON ajxp_tasks_nodes (node_path);
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS ajxp_mq_queues (
+  channel_name varchar(255) NOT NULL,
+  content bytea NOT NULL,
+  PRIMARY KEY (channel_name)
+);
diff --git a/www-apps/pydio/files/7.0.2.mysql b/www-apps/pydio/files/7.0.2.mysql
new file mode 100644
index 0000000..9c9f8e2
--- /dev/null
+++ b/www-apps/pydio/files/7.0.2.mysql
@@ -0,0 +1,6 @@
+/* SEPARATOR */
+DROP TRIGGER IF EXISTS `LOG_UPDATE`;
+/* SEPARATOR */
+CREATE TRIGGER `LOG_UPDATE` AFTER UPDATE ON `ajxp_index`
+FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type)
+VALUES (new.repository_identifier, new.node_id, old.node_path, new.node_path, CASE LENGTH(new.node_path) = LENGTH(old.node_path) AND old.node_path COLLATE utf8_bin = new.node_path COLLATE utf8_bin WHEN true THEN 'content' ELSE 'path' END);
diff --git a/www-apps/pydio/pydio-7.0.3.ebuild b/www-apps/pydio/pydio-7.0.3.ebuild
new file mode 100644
index 0000000..7de6920
--- /dev/null
+++ b/www-apps/pydio/pydio-7.0.3.ebuild
@@ -0,0 +1,65 @@
+# Copyright 1999-2017 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Id$
+
+EAPI=6
+
+inherit webapp
+
+DESCRIPTION="File sharing platform similar to dropbox"
+HOMEPAGE="https://pydio.com/"
+SRC_URI="https://download.pydio.com/pub/core/archives/${PN}-core-${PV}.tar.gz -> ${P}.tar.gz"
+RESTRICTION="mirror"
+
+LICENSE="AGPL-3"
+KEYWORDS="~amd64 ~x86"
+IUSE="+webdav"
+
+DEPEND="webdav? ( dev-php/PEAR-HTTP_WebDAV_Client )"
+RDEPEND="${DEPEND}
+	virtual/httpd-php
+"
+
+S="${WORKDIR}/${PN}-core-${PV}"
+
+src_prepare() {
+	default
+
+	# Fix compatibility with Apache 2.4
+	while read htaccess ; do
+		LC_ALL=C sed -i \
+			-e 's/^[Dd]eny from all/Require all denied/' \
+			-e 's/^[Aa]llow from all/Require all granted/' \
+			-e '/^Order /d' \
+			"${htaccess}"
+	done < <(find "${S}" -name ".htaccess")
+}
+
+src_install() {
+	webapp_src_preinst
+
+	insinto "${MY_HTDOCSDIR}"
+	doins -r "${S}"/*
+
+	insinto "${MY_HTDOCSDIR}"/upgrade-scripts
+	doins "${FILESDIR}"/*.php
+
+	webapp_serverowned -R "${MY_HTDOCSDIR}"/data
+
+	webapp_configfile "${MY_HTDOCSDIR}/base.conf.php"
+	webapp_configfile "${MY_HTDOCSDIR}/conf/bootstrap_"{conf,context,repositories}".php"
+	webapp_configfile "${MY_HTDOCSDIR}/conf/mime.types"
+	webapp_configfile "${MY_HTDOCSDIR}/conf/extensions.conf.php"
+
+	# FIXME: does not fit eclass design
+	#webapp_sqlscript mysql "${MY_HTDOCSDIR}"/plugins/*/create.mysql
+	#webapp_sqlscript postgres "${MY_HTDOCSDIR}"/plugins/*/create.pgsql
+
+	webapp_sqlscript mysql "${FILESDIR}"/7.0.1.mysql 6.4
+	webapp_sqlscript mysql "${FILESDIR}"/7.0.2.mysql 7.0.1
+	webapp_sqlscript postgres "${FILESDIR}"/7.0.1.pgsql 6.4
+
+	webapp_postinst_txt en "${FILESDIR}"/postinst.en.txt
+
+	webapp_src_install
+}