brmlab

User Tools

Site Tools

You are here: Hackerspace Prague » Projects » UzZas
project:uzzas:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
project:uzzas:start [2018/06/16 20:14] – sachyproject:uzzas:start [2018/06/17 20:53] (current) – sachy
Line 3: Line 3:
 {{template>:project:infobox| {{template>:project:infobox|
 name=UzZas| name=UzZas|
-image= |+image=.:uzzas:plostboros.svg?400 |
 founder=[[user:sachy:start]]| founder=[[user:sachy:start]]|
 interested=[[user:sumie-dh]]| interested=[[user:sumie-dh]]|
Line 11: Line 11:
 ~~META: ~~META:
 status = active status = active
-&relation firstimage = +&relation firstimage = :project:uzzas:plostboros.svg
 ~~ ~~
  
Line 30: Line 30:
   * **(install|-i|--install)** - Install UzZas (create uzzas.db and CRON entry)   * **(install|-i|--install)** - Install UzZas (create uzzas.db and CRON entry)
   * **(ping|-p|--ping)** - Graphical equivalent of -t   * **(ping|-p|--ping)** - Graphical equivalent of -t
-  * **(help|-h|--help)** - help+  * **(help|-h|--help)** - Help 
 +  * **(edit|-e|--edit)** - Edit entry 
 +  * **(clone|-c|--clone|copy|--copy)** - Clone (and modify) entry
  
 ==== Installation ==== ==== Installation ====
  
   - Check if the dependencies are met (bash interpreter, sqlite3). If you want automatic notifications, you need also CRON and zenity.   - Check if the dependencies are met (bash interpreter, sqlite3). If you want automatic notifications, you need also CRON and zenity.
-  - Run "uzzas.sh -i"+  - Download the script and make it executable "chmod +x uzzas.sh". 
 +  - Run "uzzas.sh -i" to create the database and to create crontab entry. 
 + 
 +If you will ever update/modify the uzzas.sh script, do NOT reinstall it.
  
 <code> <code>
Line 115: Line 120:
 0 0
 Not removed! Not removed!
 +</code>
 +
 +==== Editing event ====
 +
 +To edit existing event, run "uzzas.sh -e".
 +
 +<code>
 +$ ./uzzas.sh -e
 +==== Edit entry ====
 +1           krabice 1   plostenka   dugesia   
 +3           krabice 2   plastenka   chcije    
 +5           Plostenkoi  Dugesie     Vymen vodu
 +6           Aquarium    Cutteries   Wipe      
 +7           Aqua2       Modry       Wipe      
 +  Edit: (0 = nothing)
 +7
 +  First time planned to (yyyy-mm-dd):
 +2018-07-16
 +  Repeat each (days):
 +7
 +  Item...:
 +Aqua2
 +  ...containing:
 +Modry
 +  Action/note:
 +Wipe
 +EDIT? (Y/n)
 +
 +Tasks edited!
 +</code>
 +
 +==== Cloning entry ====
 +
 +To clone/copy entry, possibly with modification, run "uzzas.sh -c"
 +
 +<code>
 +$ ./uzzas.sh -c
 +==== Clone entry ====
 +1           krabice 1   plostenka   dugesia   
 +3           krabice 2   plastenka   chcije    
 +5           Plostenkoi  Dugesie     Vymen vodu
 +6           Aquarium    Cutteries   Wipe      
 +7           Aqua2       Modry       Wipe      
 +  Clone: (0 = nothing)
 +7
 +== Edit cloned entry ==
 +  First time planned to (yyyy-mm-dd):
 +2018-08-16
 +  Repeat each (days):
 +7
 +  Item...:
 +Aqua2
 +  ...containing:
 +Modry
 +  Action/note:
 +Wipe
 +COPY? (Y/n)
 +
 +Tasks copied!
 </code> </code>
  
 ===== Source code ==== ===== Source code ====
 +
 +Download the script and make it executable "chmod +x uzzas.sh".
 +
 +Run "uzzas.sh -i" to create the database and to create crontab entry for reminding you.
 +
 +After update of the uzzas.sh script, do NOT reinstall it!
  
 <code bash uzzas.sh> <code bash uzzas.sh>
Line 128: Line 198:
 # Usage: # Usage:
 # #
-#  zazas.sh+#  uzzas.sh
 # #
  
Line 134: Line 204:
 akce="$1" akce="$1"
 db="$dir/uzzas.db" db="$dir/uzzas.db"
- 
-# CREATE TABLE IF NOT EXISTS zas (day TIMESTAMP,increment INTEGER,box TEXT,inside TEXT,note TEXT); 
  
 case "$akce" in case "$akce" in
Line 212: Line 280:
     ;;     ;;
   "ping"|"-p"|"--ping") # Invoked via CRON, display graphical   "ping"|"-p"|"--ping") # Invoked via CRON, display graphical
-    todo=$(echo ".headers on^.width 20 20 40^.mode column^SELECT box,inside,note FROM zas WHERE day=date('now');" | tr '^' '\n' | sqlite3 "$db") +    count=$(sqlite3 "$db" "SELECT count(rowid) FROM zas WHERE day=date('now');") 
-    zenity --width=600 --info --text="$todo" --title="UzZas"+    if [[ "$count" > "0" ]]; then 
 +      boxlen=$(sqlite3 "$db" "SELECT max(length(box)) FROM zas WHERE day=date('now');") 
 +      inslen=$(sqlite3 "$db" "SELECT max(length(inside)) FROM zas WHERE day=date('now');") 
 +      notelen=$(sqlite3 "$db" "SELECT max(length(note)) FROM zas WHERE day=date('now');") 
 +      todo=$(echo ".headers on^.width $boxlen $inslen $notelen^.mode column^SELECT box,inside,note FROM zas WHERE day=date('now');" | tr '^' '\n' | sqlite3 "$db") 
 +      #zenity --width=600 --info --text="$todo" --title="UzZas" 
 +      zenity --info --title="UzZas" --no-wrap --text="<tt>$todo</tt>" 
 +    fi
     ;;     ;;
   "help"|"-h"|"--help")   "help"|"-h"|"--help")
Line 228: Line 303:
     echo "  uzzas.sh ACTION"     echo "  uzzas.sh ACTION"
     echo " "     echo " "
-    echo "  ACTION could b one of:"+    echo "  ACTION could be one of:"
     echo "  (add|-a|--add) - Add new entry"     echo "  (add|-a|--add) - Add new entry"
     echo "  (list|-l|--list) - List all entries sorted by due date"     echo "  (list|-l|--list) - List all entries sorted by due date"
Line 238: Line 313:
     echo "  (ping|-p|--ping) - Graphical equivalent of -t"     echo "  (ping|-p|--ping) - Graphical equivalent of -t"
     echo "  (help|-h|--help) - This help"     echo "  (help|-h|--help) - This help"
 +    echo "  (edit|-e|--edit) - Edit existing entry"
 +    echo "  (clone|-c|--clone) - Clone (and modify) existing entry"
     echo " "     echo " "
     echo "==== See brmlab.cz/project/uzzas/start for more info ===="     echo "==== See brmlab.cz/project/uzzas/start for more info ===="
 +    echo " "
 +    ;;
 +  "edit"|"-e"|"--edit")
 +    echo "==== Edit entry ===="
 +    echo ".mode column^SELECT rowid,box,inside,note FROM zas ORDER BY rowid ASC;" | tr '^' '\n' | sqlite3 "$db"
 +    echo "  Edit: (0 = nothing)"
 +    read edit
 +    if [[ "$edit" > "0" ]]; then
 +      row=$(echo ".mode line^SELECT * FROM zas WHERE rowid=$edit LIMIT 1;" | tr '^' '\n' | sqlite3 "$db")
 +      day=$(echo "$row" | grep -e "^[ ]*day = " | sed -e 's/[ ]*day = //g')
 +      incr=$(echo "$row" | grep -e "^[ ]*increment = " | sed -e 's/[ ]*increment = //g')
 +      box=$(echo "$row" | grep -e "^[ ]*box = " | sed -e 's/[ ]*box = //g')
 +      ins=$(echo "$row" | grep -e "^[ ]*inside = " | sed -e 's/[ ]*inside = //g')
 +      note=$(echo "$row" | grep -e "^[ ]*note = " | sed -e 's/[ ]*note = //g')
 +
 +      echo "  First time planned to (yyyy-mm-dd):"
 +      read -e -i "$day" day
 +      echo "  Repeat each (days):"
 +      read -e -i "$incr" incr
 +      echo "  Item...:"
 +      read -e -i "$box" box
 +      echo "  ...containing:"
 +      read -e -i "$ins" ins
 +      echo "  Action/note:"
 +      read -e -i "$note" note
 +      echo "EDIT? (Y/n)"
 +      read ack
 +
 +      if [[ "$ack" != "n" ]]; then
 +        sqlite3 "$db" "UPDATE zas SET day='$day',box='$box',increment='$incr',inside='$ins',note='$note' WHERE rowid=$edit LIMIT 1;"
 +        echo "Tasks edited!"
 +      else
 +        echo "Edit cancelled!"
 +      fi
 +    else
 +      echo "Invalid value!"
 +    fi
 +    ;;
 +  "clone"|"-c"|"--clone"|"copy"|"--copy")
 +    echo "==== Clone entry ===="
 +    echo ".mode column^SELECT rowid,box,inside,note FROM zas ORDER BY rowid ASC;" | tr '^' '\n' | sqlite3 "$db"
 +    echo "  Clone: (0 = nothing)"
 +    read clone
 +    if [[ "$clone" > "0" ]]; then
 +      row=$(echo ".mode line^SELECT * FROM zas WHERE rowid=$clone LIMIT 1;" | tr '^' '\n' | sqlite3 "$db")
 +      day=$(echo "$row" | grep -e "^[ ]*day = " | sed -e 's/[ ]*day = //g')
 +      incr=$(echo "$row" | grep -e "^[ ]*increment = " | sed -e 's/[ ]*increment = //g')
 +      box=$(echo "$row" | grep -e "^[ ]*box = " | sed -e 's/[ ]*box = //g')
 +      ins=$(echo "$row" | grep -e "^[ ]*inside = " | sed -e 's/[ ]*inside = //g')
 +      note=$(echo "$row" | grep -e "^[ ]*note = " | sed -e 's/[ ]*note = //g')
 +
 +      echo "== Edit cloned entry =="
 +
 +      echo "  First time planned to (yyyy-mm-dd):"
 +      read -e -i "$day" day
 +      echo "  Repeat each (days):"
 +      read -e -i "$incr" incr
 +      echo "  Item...:"
 +      read -e -i "$box" box
 +      echo "  ...containing:"
 +      read -e -i "$ins" ins
 +      echo "  Action/note:"
 +      read -e -i "$note" note
 +      echo "COPY? (Y/n)"
 +      read ack
 +
 +      if [[ "$ack" != "n" ]]; then
 +        sqlite3 "$db" "INSERT INTO zas VALUES (date('$day'),$incr,'$box','$ins','$note');"
 +        echo "Tasks copied!"
 +      else
 +        echo "Copy cancelled!"
 +      fi
 +    else
 +      echo "Invalid value!"
 +    fi
     ;;     ;;
 esac esac
project/uzzas/start.1529180072.txt.gz · Last modified: 2018/06/16 20:14 by sachy