www-apps/pydio: version bump 6.2.2 → 6.4.2

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

3 files changed, 101 insertions, 0 deletions

diff --git a/www-apps/pydio/files/6.4.0.mysql b/www-apps/pydio/files/6.4.0.mysql
new file mode 100644
index 0000000..90121d9
--- /dev/null
+++ b/www-apps/pydio/files/6.4.0.mysql
@@ -0,0 +1,21 @@
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS `ajxp_mail_queue` (
+  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
+  `recipient` varchar(255) NOT NULL,
+  `url` text NOT NULL,
+  `date_event` int(11) NOT NULL,
+  `notification_object` longblob NOT NULL,
+  `html` int(1) NOT NULL
+)CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS `ajxp_mail_sent` (
+  `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
+  `recipient` varchar(255) NOT NULL,
+  `url` text NOT NULL,
+  `date_event` int(11) NOT NULL,
+  `notification_object` longblob NOT NULL,
+  `html` int(1) NOT NULL
+)CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+/* SEPARATOR */
+CREATE TRIGGER `mail_queue_go_to_sent` BEFORE DELETE ON `ajxp_mail_queue`
+FOR EACH ROW INSERT INTO ajxp_mail_sent (id,recipient,url,date_event,notification_object,html) VALUES (old.id,old.recipient,old.url,old.date_event,old.notification_object,old.html);
\ No newline at end of file
diff --git a/www-apps/pydio/files/6.4.0.pgsql b/www-apps/pydio/files/6.4.0.pgsql
new file mode 100644
index 0000000..054db1c
--- /dev/null
+++ b/www-apps/pydio/files/6.4.0.pgsql
@@ -0,0 +1,29 @@
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS ajxp_mail_queue (
+ id serial PRIMARY KEY,
+ recipient varchar(255) NOT NULL,
+ url text NOT NULL,
+ date_event integer NOT NULL,
+ notification_object bytea NOT NULL,
+ html integer NOT NULL
+);
+/* SEPARATOR */
+CREATE TABLE IF NOT EXISTS ajxp_mail_sent (
+ id serial PRIMARY KEY,
+ recipient varchar(255) NOT NULL,
+ url text NOT NULL,
+ date_event integer NOT NULL,
+ notification_object bytea NOT NULL,
+ html integer NOT NULL
+);
+/* SEPARATOR */
+CREATE FUNCTION ajxp_send_mail() RETURNS trigger AS $ajxp_send_mail$
+    BEGIN
+        INSERT INTO ajxp_mail_sent (id,recipient,url,date_event,notification_object,html)
+            VALUES (OLD.id,OLD.recipient,OLD.url,OLD.date_event,OLD.notification_object,OLD.html);
+        RETURN OLD;
+    END;
+$ajxp_send_mail$ LANGUAGE plpgsql;
+/* SEPARATOR */
+CREATE TRIGGER mail_queue_go_to_sent BEFORE DELETE ON ajxp_mail_queue
+FOR EACH ROW EXECUTE PROCEDURE ajxp_send_mail();
diff --git a/www-apps/pydio/pydio-6.4.2.ebuild b/www-apps/pydio/pydio-6.4.2.ebuild
new file mode 100644
index 0000000..66e9495
--- /dev/null
+++ b/www-apps/pydio/pydio-6.4.2.ebuild
@@ -0,0 +1,51 @@
+# 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://pyd.io/"
+SRC_URI="http://sourceforge.net/projects/ajaxplorer/files/${PN}/stable-channel/${PV}/${PN}-core-${PV}.tar.gz/download -> ${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_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}"/6.4.0.mysql 6.2
+	webapp_sqlscript postgres "${FILESDIR}"/6.4.0.pgsql 6.2
+
+	webapp_postinst_txt en "${FILESDIR}"/postinst.en.txt
+
+	webapp_src_install
+}