From 6c449119bc7593ade69be36b445a7be63a68ab00 Mon Sep 17 00:00:00 2001
From: V3n3RiX <venerix@redcorelinux.org>
Date: Fri, 29 Sep 2017 20:51:07 +0100
Subject: sisyphusdb : add timestamp column into the database

---
 src/helpers/make_local_csv_post | 6 +++---
 src/helpers/make_local_csv_pre  | 6 +++---
 src/helpers/make_spmsync_csv    | 6 +++---
 3 files changed, 9 insertions(+), 9 deletions(-)

diff --git a/src/helpers/make_local_csv_post b/src/helpers/make_local_csv_post
index cd38974..b6f7200 100755
--- a/src/helpers/make_local_csv_post
+++ b/src/helpers/make_local_csv_post
@@ -3,14 +3,14 @@
 collect_local_portage_database() {
 	for i in $(qlist -ICv); do
 		pushd /var/db/pkg/$i > /dev/null 2>&1
-		echo "$(<CATEGORY),$(sed -re "s/-([0-9])/,\1/" <PF),$(<SLOT),$(sed -e "s/\"//g" -e "s/\'//g" -e "s/\,//g" <DESCRIPTION)" >> /tmp/local_postinst.csv
+		echo "$(<CATEGORY),$(sed -re "s/-([0-9])/,\1/" <PF),$(<SLOT),$(<BUILD_TIME),$(sed -e "s/\"//g" -e "s/\'//g" -e "s/\,//g" <DESCRIPTION)" >> /tmp/local_packages_post.csv
 		popd > /dev/null 2>&1
 	done
-	mv /tmp/local_postinst.csv /var/lib/sisyphus/csv/
+	mv /tmp/local_packages_post.csv /var/lib/sisyphus/csv/
 }
 
 clean_temporary_files() {
-	rm -rf /tmp/local_postinst.csv
+	rm -rf /tmp/local_packages_post.csv
 }
 
 main() {
diff --git a/src/helpers/make_local_csv_pre b/src/helpers/make_local_csv_pre
index 068331e..f6b5cfc 100755
--- a/src/helpers/make_local_csv_pre
+++ b/src/helpers/make_local_csv_pre
@@ -3,14 +3,14 @@
 collect_local_portage_database() {
 	for i in $(qlist -ICv); do
 		pushd /var/db/pkg/$i > /dev/null 2>&1
-		echo "$(<CATEGORY),$(sed -re "s/-([0-9])/,\1/" <PF),$(<SLOT),$(sed -e "s/\"//g" -e "s/\'//g" -e "s/\,//g" <DESCRIPTION)" >> /tmp/local_preinst.csv
+		echo "$(<CATEGORY),$(sed -re "s/-([0-9])/,\1/" <PF),$(<SLOT),$(<BUILD_TIME),$(sed -e "s/\"//g" -e "s/\'//g" -e "s/\,//g" <DESCRIPTION)" >> /tmp/local_packages_pre.csv
 		popd > /dev/null 2>&1
 	done
-	mv /tmp/local_preinst.csv /var/lib/sisyphus/csv/
+	mv /tmp/local_packages_pre.csv /var/lib/sisyphus/csv/
 }
 
 clean_temporary_files() {
-	rm -rf /tmp/local_preinst.csv
+	rm -rf /tmp/local_packages_pre.csv
 }
 
 main() {
diff --git a/src/helpers/make_spmsync_csv b/src/helpers/make_spmsync_csv
index c315bf0..baf419c 100755
--- a/src/helpers/make_spmsync_csv
+++ b/src/helpers/make_spmsync_csv
@@ -3,14 +3,14 @@
 collect_local_portage_database() {
 	for i in $(qlist -ICv); do
 		pushd /var/db/pkg/$i > /dev/null 2>&1
-		echo "$(<CATEGORY),$(sed -re "s/-([0-9])/,\1/" <PF),$(<SLOT),$(sed -e "s/\"//g" -e "s/\'//g" -e "s/\,//g" <DESCRIPTION)" >> /tmp/spmsync.csv
+		echo "$(<CATEGORY),$(sed -re "s/-([0-9])/,\1/" <PF),$(<SLOT),$(<BUILD_TIME),$(sed -e "s/\"//g" -e "s/\'//g" -e "s/\,//g" <DESCRIPTION)" >> /tmp/portage_spmsync.csv
 		popd > /dev/null 2>&1
 	done
-	mv /tmp/spmsync.csv /var/lib/sisyphus/csv/
+	mv /tmp/portage_spmsync.csv /var/lib/sisyphus/csv/
 }
 
 clean_temporary_files() {
-	rm -rf /tmp/spmsync.csv
+	rm -rf /tmp/portage_spmsync.csv
 }
 
 main() {
-- 
cgit v1.2.3