API tools faq
paste
aquaballoon

sh - huree_grade

aquaballoon
Dec 6th, 2011
168
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 6.28 KB | None | 0 0
raw download clone embed print report
  1. #! /bin/bash
  2.  
  3. ./huree_list &
  4.  
  5. while true; do
  6.   choice="$(zenity --width=200 --height=250 --list --column "" --title="Huree ICT - Linux System 2011" \
  7.  "New Entry" \
  8.  "View Data" \
  9.  "Edit Data" \
  10.  "Delete Data" \
  11.  "Exit ")"
  12.  
  13.   case "${choice}" in
  14.     "New Entry" )
  15.  
  16.         zenity --list --separator " " --height=160 --width=1200 --print-column=all --editable --text "New Entry" \
  17.     --column "Key" \
  18.     --column "Name" \
  19.     --column "SID" \
  20.     --column "Email" \
  21.     --column "RE1" \
  22.     --column "RE2" \
  23.     --column "RE3" \
  24.     --column "RE4" \
  25.     --column "PT1" \
  26.     --column "PT2" \
  27.     --column "Test1" \
  28.     --column "Test2" \
  29.     --column "Test3" \
  30.     --column "Test4" \
  31.     --column "HW1" \
  32.     --column "HW2" \
  33.     --column "HW3" \
  34.     --column "HW4" \
  35.     --column "ACT" \
  36.     --column "Total" \
  37.     0 "Name" "SID" "Email" 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0   > tmp
  38.  
  39.     key=$(awk '{print $1}' tmp)
  40.     name=$(awk '{print $2}' tmp)
  41.     sid=$(awk '{print $3}' tmp)
  42.     email=$(awk '{print $4}' tmp)
  43.     re1=$(awk '{print $5}' tmp)
  44.     re2=$(awk '{print $6}' tmp)
  45.     re3=$(awk '{print $7}' tmp)
  46.     re4=$(awk '{print $8}' tmp)
  47.     pt1=$(awk '{print $9}' tmp)
  48.     pt2=$(awk '{print $10}' tmp)
  49.     test1=$(awk '{print $11}' tmp)
  50.     test2=$(awk '{print $12}' tmp)
  51.     test3=$(awk '{print $13}' tmp)
  52.     test4=$(awk '{print $14}' tmp)
  53.     hw1=$(awk '{print $15}' tmp)
  54.     hw2=$(awk '{print $16}' tmp)
  55.     hw3=$(awk '{print $17}' tmp)
  56.     hw4=$(awk '{print $18}' tmp)
  57.     act=$(awk '{print $19}' tmp)
  58.     total=$(awk '{print $5+$6+$7+$8+$9+$10+$11+$12+$13+$14+$15+$16+$17+$18+$19}' tmp)
  59.     #total=$(expr $re1 + $re2 + $re3 + $re4 + $pt1 + $pt2 + $test1 + $test2 + $test3 + $test4 + $hw1 + $hw2 + $hw3 + $hw4 + $act)
  60.  
  61.     sqlite3 huree.db "insert into huree values($key, '$name', '$sid', '$email', $re1, $re2, $re3, $re4, $pt1, $pt2, $test1, $test2, $test3, $test4, $hw1, $hw2, $hw3, $hw4, $act, $total)"
  62.     ;;
  63.  
  64.     "View Data" )
  65.         sqlite3 huree.db "select * from huree " > tmp
  66.  
  67.     key=$(cut -d "|" -f 1 tmp)
  68.     name=$(cut -d "|" -f 2 tmp)
  69.     sid=$(cut -d "|" -f 3 tmp)
  70.     email=$(cut -d "|" -f 4 tmp)
  71.     re1=$(cut -d "|" -f 5 tmp)
  72.     re2=$(cut -d "|" -f 6 tmp)
  73.     re3=$(cut -d "|" -f 7 tmp)
  74.     re4=$(cut -d "|" -f 8 tmp)
  75.     pt1=$(cut -d "|" -f 9 tmp)
  76.     pt2=$(cut -d "|" -f 10 tmp)
  77.     test1=$(cut -d "|" -f 11 tmp)
  78.     test2=$(cut -d "|" -f 12 tmp)
  79.     test3=$(cut -d "|" -f 13 tmp)
  80.     test4=$(cut -d "|" -f 14 tmp)
  81.     hw1=$(cut -d "|" -f 15 tmp)
  82.     hw2=$(cut -d "|" -f 16 tmp)
  83.     hw3=$(cut -d "|" -f 17 tmp)
  84.     hw4=$(cut -d "|" -f 18 tmp)
  85.     act=$(cut -d "|" -f 19 tmp)
  86.     total=$(cut -d "|" -f 20 tmp)
  87.  
  88.     zenity --list --height=360 --width=1230 --separator " "  --text "The list of data" \
  89.     --column "Key" \
  90.     --column "Name" \
  91.     --column "SID" \
  92.     --column "Email" \
  93.     --column "RE1" \
  94.     --column "RE2" \
  95.     --column "RE3" \
  96.     --column "RE4" \
  97.     --column "PT1" \
  98.     --column "PT2" \
  99.     --column "Test1" \
  100.     --column "Test2" \
  101.     --column "Test3" \
  102.     --column "Test4" \
  103.     --column "HW1" \
  104.     --column "HW2" \
  105.     --column "HW3" \
  106.     --column "HW4" \
  107.     --column "ACT" \
  108.     --column "Total" \
  109.     --column "Name" \
  110.     "$key" "$name" "$sid" "$email" "$re1" "$re2" "$re3" "$re4" "$pt1" "$pt2" "$test1" "$test2" "$test3" "$test4" "$hw1" "$hw2" "$hw3" "$hw4" "$act" "$total" "$name"
  111.     ;;
  112.  
  113.     "Edit Data" )
  114.     sqlite3 huree.db "select * from huree " > tmp
  115.     name=$(cut -d "|" -f 2 tmp)
  116.  
  117.     ans=$(zenity --list --height=360 --width=50 --text "Select one to change"  \
  118.     --column "Name" $name )
  119.    
  120.     case $? in
  121.     0)
  122.     sqlite3 huree.db "select * from huree where name='$ans'" > tmp
  123.     key=$(cut -d "|" -f 1 tmp)
  124.     name=$(cut -d "|" -f 2 tmp)
  125.     sid=$(cut -d "|" -f 3 tmp)
  126.     email=$(cut -d "|" -f 4 tmp)
  127.     re1=$(cut -d "|" -f 5 tmp)
  128.     re2=$(cut -d "|" -f 6 tmp)
  129.     re3=$(cut -d "|" -f 7 tmp)
  130.     re4=$(cut -d "|" -f 8 tmp)
  131.     pt1=$(cut -d "|" -f 9 tmp)
  132.     pt2=$(cut -d "|" -f 10 tmp)
  133.     test1=$(cut -d "|" -f 11 tmp)
  134.     test2=$(cut -d "|" -f 12 tmp)
  135.     test3=$(cut -d "|" -f 13 tmp)
  136.     test4=$(cut -d "|" -f 14 tmp)
  137.     hw1=$(cut -d "|" -f 15 tmp)
  138.     hw2=$(cut -d "|" -f 16 tmp)
  139.     hw3=$(cut -d "|" -f 17 tmp)
  140.     hw4=$(cut -d "|" -f 18 tmp)
  141.     act=$(cut -d "|" -f 19 tmp)
  142.     #total=$(cut -d "|" -f 20 tmp)
  143.     total=$(expr $re1 + $re2 + $re3 + $re4 + $pt1 + $pt2 + $test1 + $test2 + $test3 + $test4 + $hw1 + $hw2 + $hw3 + $hw4 + $act)
  144.  
  145.     zenity --list --separator " " --height=160 --width=1200 --print-column=all  --editable --text "Changing Data" \
  146.     --column "Key" \
  147.     --column "Name" \
  148.     --column "SID" \
  149.     --column "Email" \
  150.     --column "RE1" \
  151.     --column "RE2" \
  152.     --column "RE3" \
  153.     --column "RE4" \
  154.     --column "PT1" \
  155.     --column "PT2" \
  156.     --column "Test1" \
  157.     --column "Test2" \
  158.     --column "Test3" \
  159.     --column "Test4" \
  160.     --column "HW1" \
  161.     --column "HW2" \
  162.     --column "HW3" \
  163.     --column "HW4" \
  164.     --column "ACT" \
  165.     --column "Total" \
  166.     "$key" "$name" "$sid" "$email" "$re1" "$re2" "$re3" "$re4" "$pt1" "$pt2" "$test1" "$test2" "$test3" "$test4" "$hw1" "$hw2" "$hw3" "$hw4" "$act" "$total" > tmp
  167.  
  168.     key=$(awk '{print $1}' tmp)
  169.     name=$(awk '{print $2}' tmp)
  170.     sid=$(awk '{print $3}' tmp)
  171.     email=$(awk '{print $4}' tmp)
  172.     re1=$(awk '{print $5}' tmp)
  173.     re2=$(awk '{print $6}' tmp)
  174.     re3=$(awk '{print $7}' tmp)
  175.     re4=$(awk '{print $8}' tmp)
  176.     pt1=$(awk '{print $9}' tmp)
  177.     pt2=$(awk '{print $10}' tmp)
  178.     test1=$(awk '{print $11}' tmp)
  179.     test2=$(awk '{print $12}' tmp)
  180.     test3=$(awk '{print $13}' tmp)
  181.     test4=$(awk '{print $14}' tmp)
  182.     hw1=$(awk '{print $15}' tmp)
  183.     hw2=$(awk '{print $16}' tmp)
  184.     hw3=$(awk '{print $17}' tmp)
  185.     hw4=$(awk '{print $18}' tmp)
  186.     act=$(awk '{print $19}' tmp)
  187.     #total=$(awk '{print $5+$6+$7+$8+$9+$10+$11+$12+$13+$14+$15+$16+$17+$18+$19}' tmp)
  188.     total=$(expr $re1 + $re2 + $re3 + $re4 + $pt1 + $pt2 + $test1 + $test2 + $test3 + $test4 + $hw1 + $hw2 + $hw3 + $hw4 + $act)
  189.  
  190.     sqlite3 huree.db "UPDATE huree SET name='$name', sid='$sid', email='$email', re1=$re1, re2=$re2, re3=$re3, re4=$re4, pt1=$pt1, pt2=$pt2, test1=$test1, test2=$test2, test3=$test3, test4=$test4, hw1=$hw1, hw2=$hw2, hw3=$hw3, hw4=$hw4, act=$act, total=$total WHERE id=$key"
  191.  
  192.  
  193.     ;;
  194.     esac
  195.  
  196.     ;;
  197.  
  198.     "Delete Data" )
  199.     sqlite3 huree.db "select * from huree " > tmp
  200.     name=$(cut -d "|" -f 2 tmp)
  201.  
  202.     ans=$(zenity --list --height=360 --width=50 --text "Select one to delete"  \
  203.     --column "Name" $name )
  204.  
  205.     case $? in
  206.     0)
  207.     zenity  --warning --text "This will delete data!!"
  208.     sqlite3 huree.db "DELETE FROM huree WHERE name='$ans' "
  209.     ;;
  210.     esac
  211.  
  212.     ;;
  213.  
  214.  
  215.      *)
  216.         break
  217.     ;;
  218.    esac
  219. done
  220.    
  221. rm tmp 2> /dev/null
  222.  
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!