Emania

Funkce na oriznuti

May 17th, 2015
292
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.13 KB | None | 0 0
  1. oriznout() {    #pocet oriznuti dvjslov
  2.         num=$1
  3.         par2="$2"
  4.         echo "num is $num"
  5.         for ((i=1; i<=$num;i++)) ;
  6.         do
  7.                 par2=$(echo "$par2" | grep -o ",[^()]*" | grep -o "[^,][^()]*")
  8.                 par2=$(echo "$par2" | grep -o ",[^()]*" | grep -o "[^,][^()]*")
  9.         done
  10.         dveslova=$(echo "$par2" | grep -o "^[^,]*,[^,]*")
  11.         echo "$dveslova"
  12. }
  13.  
  14. name=$(echo "$par" | grep -o "^[^,]*," | grep -o "[^,]*")   #navic
  15. echo $name
  16.  
  17. author=$(echo "$par" | grep -o "^[^,]*,[^,]*," | grep -o ",[^,]*" | grep -o "[^,]*")    #navic
  18. echo $author
  19.  
  20. #prvni select
  21. SELECT * FROM RECIPES WHERE RECIPES.AUTHOR = $author
  22.  
  23. #druhy select
  24. SELECT RECIPES.NAME, BRIDGE.QUANTITY, DUE FROM RECIPES
  25. JOIN BRIDGE ON (BRIDGE.RECIPE = RECIPES.NAME)
  26. JOIN FRIDGE ON (BRIDGE.INGREDIENT = FRIDGE.NAME)
  27. WHERE DUE <= 'date'         --date is variable
  28. ORDER BY BRIDGE.QUANTITY DESC
  29. LIMIT 1;
  30.  
  31. #treti select
  32. SELECT FRIDGE.INGREDIENT_NAME, (BRIDGE.QUANTITY-FRIDGE.QUANTITY) AS Q FROM BRIDGE
  33. JOIN FRIDGE ON (BRIDGE.INGREDIENT_NAME = FRIDGE.INGREDIENT_NAME)
  34. WHERE (BRIDGE.QUANTITY-FRIDGE.QUANTITY) > 0
  35. GROUP BY Q
Advertisement
Add Comment
Please, Sign In to add comment