www-apps/liquid_feedback_core: add 4.2.2, drop 4.0.0

Signed-off-by: Alfredo Tupone <tupone@gentoo.org>

6 files changed, 64 insertions, 6 deletions

diff --git a/www-apps/liquid_feedback_core/Manifest b/www-apps/liquid_feedback_core/Manifest
index 9da9f60aed94..c6a235edc4b7 100644
--- a/www-apps/liquid_feedback_core/Manifest
+++ b/www-apps/liquid_feedback_core/Manifest
@@ -1,4 +1,4 @@
 DIST liquid_feedback_core-v2.2.6.tar.gz 127440 BLAKE2B d62ecd8c9947259a7213f92ecaf1491a5e858ff2fdaff5e020fc4ec0c433297d8a7701a812de200130a1ed7f08ded1d9f31d42de7fffa2981361efee0e31646c SHA512 6f680398a7d2e529e642dc94ba16bc1b33d25459ddbf629c06387391ef13c0e212a108cc337cd2bc29505f4f6436b6e92994e63eaa09fe1c07733d2821d9b7f1
 DIST liquid_feedback_core-v3.0.4.tar.gz 142983 BLAKE2B 05e8c1630a8fa3932b4fc291843dd0c45e2333940394a0632309c9041dc850cc894a6cb54fb840329f67812ebcde5d540c338cf27a88ad428aaa066329725409 SHA512 baea8a61c94e640557d0169b6171247ff0303ff1a9c8b587c6769e367cf56805c1a1e660aadf7178d984182be6dde326770240b3ffeda42139c4a94445a2bbf8
 DIST liquid_feedback_core-v3.2.2.tar.gz 162505 BLAKE2B dc6e9d0b8d1e596150520e068e7743a6e839f7e6ffc3c605d090973a179652858c037c4f12c75774d158adfc60484d1ac321350fa7f8d16329043051ae2cd98c SHA512 60a3548008235822e83c6614e990d87200b342d8e5c5fd1ca1f6092bc48d918f9dbfcc130039f4acf2956a19100cc96187ac1c7f5174f7e69a45f651643ab1d9
-DIST liquid_feedback_core-v4.0.0.tar.gz 194817 BLAKE2B d33c4f60371050664e19425b3e344435c2b35d7e48fa682b9857d0bbc22032e59f4811ce41b8cad2f8d325e26a9adbd573bf205289b6f419c32829392014cbdf SHA512 499a60d4d71e85357ffe45fe0cbcd13bdf131f80c2b24e320b06646e56c7cd422e44306132d7fbe3dc22bf1be9af208ef9bfa143142cd2aa0880382dfe874aa4
+DIST liquid_feedback_core-v4.2.2.tar.gz 226473 BLAKE2B 4df49d1e1734c72ac439f772dfa1bf2b10d6cfb739f323735c39b2ed1c28ae19a26a00ad5fb3c55ead74e8d35773bbb39112936f5a4bf3321cd5f1847f7721a2 SHA512 f2542c3c38aa22cd7b8de4a47afb51e851f7f8e4b791d7bf90648e2e8abc6f71f687386f6aa028717c4ef042f3e3366b5458933e43dcf51476b3514f858eb20d
diff --git a/www-apps/liquid_feedback_core/files/lf_update.sh b/www-apps/liquid_feedback_core/files/lf_update.sh
new file mode 100644
index 000000000000..5cd452d81153
--- /dev/null
+++ b/www-apps/liquid_feedback_core/files/lf_update.sh
@@ -0,0 +1,8 @@
+#!/bin/bash
+
+while true; do
+  nice /usr/bin/lf_update dbname=$1
+  nice /usr/bin/lf_update_issue_order dbname=$1
+  nice /usr/bin/lf_update_suggestion_order dbname=$1
+  sleep 5m
+done
diff --git a/www-apps/liquid_feedback_core/files/liquid_feedback_core.confd b/www-apps/liquid_feedback_core/files/liquid_feedback_core.confd
new file mode 100644
index 000000000000..1e1ed6b29296
--- /dev/null
+++ b/www-apps/liquid_feedback_core/files/liquid_feedback_core.confd
@@ -0,0 +1,2 @@
+# name of db for liquid feedback
+dbname=liquid_feedback
diff --git a/www-apps/liquid_feedback_core/files/liquid_feedback_core.initd b/www-apps/liquid_feedback_core/files/liquid_feedback_core.initd
new file mode 100644
index 000000000000..fe97906ee4ee
--- /dev/null
+++ b/www-apps/liquid_feedback_core/files/liquid_feedback_core.initd
@@ -0,0 +1,10 @@
+#!/sbin/openrc-run
+description="liquid feedback updator"
+
+command="/usr/bin/lf_update.sh"
+command_args="$dbname"
+command_background=yes
+command_user="apache:apache"
+error_log=/var/log/liquid_feedback/lf_update.err
+output_log=/var/log/liquid_feedback/lf_update.log
+pidfile=/run/lqfb_core.pid
diff --git a/www-apps/liquid_feedback_core/files/postinstall-en-4.txt b/www-apps/liquid_feedback_core/files/postinstall-en-4.txt
new file mode 100644
index 000000000000..1ce7b7431495
--- /dev/null
+++ b/www-apps/liquid_feedback_core/files/postinstall-en-4.txt
@@ -0,0 +1,32 @@
+To use Liquid Feedback you have to follow these
+simple steps, which have to be done as the postgres system user (or
+which ever is the database superuser):
+
+$ createuser -d apache
+
+$ psql 
+postgres=# ALTER USER apache WITH PASSWORD 'the_new_password';
+
+$ createdb -U apache liquid_feedback
+$ psql -U apache liquid_feedback
+\i /usr/share/liquid_feedback_core/core.sql
+\i /usr/share/liquid_feedback_core/geoindex_install.sql
+INSERT INTO system_setting (member_ttl) VALUES ('1 year');
+INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (false, '1 hour', 20, 6);
+INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (false, '1 day', 80, 12);
+INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (true, '1 hour', 200, 60);
+INSERT INTO contingent (polling, time_frame, text_entry_limit, initiative_limit) VALUES (true, '1 day', 800, 120);
+
+and Create an invite code for an admin user:
+
+$ psql -U liquid_feedback liquid_feedback
+liquid_feedback=# INSERT INTO member (invite_code, admin) VALUES ('sesam', true);
+
+Then you can start the periodic task of liquid_feedback_core by running
+/etc/init.d/liquid_feedback_core restart
+
+and eventually adding this to the default level
+
+rc-update add liquid_feedback_core
+
+For other info look at the README file
diff --git a/www-apps/liquid_feedback_core/liquid_feedback_core-4.0.0.ebuild b/www-apps/liquid_feedback_core/liquid_feedback_core-4.2.2.ebuild
index d80161e4dd89..e7ba5a90feb1 100644
--- a/www-apps/liquid_feedback_core/liquid_feedback_core-4.0.0.ebuild
+++ b/www-apps/liquid_feedback_core/liquid_feedback_core-4.2.2.ebuild
@@ -1,7 +1,7 @@
 # Copyright 1999-2024 Gentoo Authors
 # Distributed under the terms of the GNU General Public License v2
 
-EAPI=7
+EAPI=8
 
 inherit toolchain-funcs
 
@@ -18,13 +18,14 @@ KEYWORDS="~amd64"
 
 DEPEND="dev-db/postgresql:="
 RDEPEND="${DEPEND}
+	acct-user/apache
 	dev-db/pgLatLon"
 
 S=${WORKDIR}/${MY_P}
 
 PATCHES=(
 	"${FILESDIR}"/${PN}-3.0.4-gentoo.patch
-	"${FILESDIR}"/${P}-gentoo.patch
+	"${FILESDIR}"/${PN}-4.0.0-gentoo.patch
 )
 
 src_compile() {
@@ -36,8 +37,13 @@ src_compile() {
 }
 
 src_install() {
-	dobin lf_update lf_update_suggestion_order lf_export
+	dobin lf_update lf_update_issue_order lf_update_suggestion_order lf_export
+	dobin "${FILESDIR}"/lf_update.sh
 	insinto /usr/share/${PN}
-	doins -r {core,init,demo,test}.sql update
-	dodoc README "${FILESDIR}"/postinstall-en.txt
+	doins -r {core,init,demo,test,geoindex_install}.sql update
+	dodoc README "${FILESDIR}"/postinstall-en-4.txt
+	keepdir /var/log/liquid_feedback
+	fowners apache:apache /var/log/liquid_feedback
+	newconfd "${FILESDIR}"/${PN}.confd ${PN}
+	newinitd "${FILESDIR}"/${PN}.initd ${PN}
 }