laradb

git clone git://bebou.netlib.re/laradb
Log | Files | Refs |

commit 1bc1280be03a683174e906eb0d88a83f12f9154a
parent 391aed89649372af41e3a79b1980289ff2cfa59b
Auterice: vi <vi@bb.re>
Date:   Wed, 30 Oct 2024 13:11:39 +0100

nouveau utils pas encore fini pour créer un tsv des dates en epoch unix et pouvoir faire des calculs précis pour la frise

Diffstat:
M
src/frise.sh
 | 
13
++++++++++++-
A
src/utils/date_epoch.sh
 | 
13
+++++++++++++

2 files changed, 25 insertions(+), 1 deletion(-)
diff --git a/src/frise.sh b/src/frise.sh
@@ -1,12 +1,23 @@
 #!/bin/sh
-# @todo: 
+# @todo: la durée ne  prend en compte que les années et pas les mois/jour
+# tout passer en unix epoch :
+#  date -j +%s 195509030000 #ccddmmjjHHMM 1955 09 03 00:00
+
+
 
 entree(){
 	echo "$line" | cut -d"	" -f $1 | tee $1 
 	#echo "$line" | tsv-select -f $1
 }
+date_normalisation () {
+# nouveau script dans src/utils/
+}
+
+values(){
+}
 
 max=$(bc -e "2012-1955" -e quit)
+min=$() 
 
 
 left(){
diff --git a/src/utils/date_epoch.sh b/src/utils/date_epoch.sh
@@ -0,0 +1,13 @@
+#! /bin/sh 
+# @TODO: apply to both field, and use tsv utils rather than cut to use field header names instead of -f4,5 if
+# one day the start_date and end_date aren't anymore the 4th and 5th field of the tsv (however header names must stay persistent 
+cut -f4 -d"	" src/db.tsv | 
+sed '1d;
+s/-//g; # date 19701210 
+s/^\([0-9]*\)\(.*$\)/\1 #\2/g; # prepare for cleaning with comment
+s/^\(.{2}\).*/\1/; # finale clean 1970 #comment 
+s/^\([0-9]*\)/\100000000/; #adding the zero we need for the date xargs command to work
+s/[0-9]/X/13; #preparation to delete the non-needed zero 
+s/X.[^#]*/ /gw dist/date_epoch.tsv'  #delete the zero and write file to a tsv 
+
+# | xargs date -j +%s # to transform every value into seconds since epoch to bc for the frise