Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- oriznout() { #pocet oriznuti dvjslov
- num=$1
- par2="$2"
- echo "num is $num"
- for ((i=1; i<=$num;i++)) ;
- do
- par2=$(echo "$par2" | grep -o ",[^()]*" | grep -o "[^,][^()]*")
- par2=$(echo "$par2" | grep -o ",[^()]*" | grep -o "[^,][^()]*")
- done
- dveslova=$(echo "$par2" | grep -o "^[^,]*,[^,]*")
- echo "$dveslova"
- }
- name=$(echo "$par" | grep -o "^[^,]*," | grep -o "[^,]*") #navic
- echo $name
- author=$(echo "$par" | grep -o "^[^,]*,[^,]*," | grep -o ",[^,]*" | grep -o "[^,]*") #navic
- echo $author
- #prvni select
- SELECT * FROM RECIPES WHERE RECIPES.AUTHOR = $author
- #druhy select
- SELECT RECIPES.NAME, BRIDGE.QUANTITY, DUE FROM RECIPES
- JOIN BRIDGE ON (BRIDGE.RECIPE = RECIPES.NAME)
- JOIN FRIDGE ON (BRIDGE.INGREDIENT = FRIDGE.NAME)
- WHERE DUE <= 'date' --date is variable
- ORDER BY BRIDGE.QUANTITY DESC
- LIMIT 1;
- #treti select
- SELECT FRIDGE.INGREDIENT_NAME, (BRIDGE.QUANTITY-FRIDGE.QUANTITY) AS Q FROM BRIDGE
- JOIN FRIDGE ON (BRIDGE.INGREDIENT_NAME = FRIDGE.INGREDIENT_NAME)
- WHERE (BRIDGE.QUANTITY-FRIDGE.QUANTITY) > 0
- GROUP BY Q
Advertisement
Add Comment
Please, Sign In to add comment