blob: 049a698788d747b1416d5a6fa68cd232cb1b76f4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
#!/bin/bash
RESULT="$(psql -d sample_database2 -U feideus -c 'SELECT * FROM TEST_TABLE')";
RESULT=$( echo $RESULT | grep -P -o "\- .*" )
RESULT=$( echo $RESULT | cut -d "-" -f 2 )
RESULT=$( echo $RESULT | cut -d "(" -f1 )
IFS=' | ' read -ra array <<< "$RESULT"
SCORE=1
if [ "${array[1]}" = "Moy" ]
then
SCORE=$((SCORE+10))
fi
if [ "${array[2]}" = "t" ]
then
SCORE=$((SCORE+10))
fi
if [[ "${array[0]}" -eq 32767 ]]
then
SCORE=$((SCORE+10))
fi
if [[ ${array[0]} -eq 32767 && "${array[2]}" = "t" && "${array[1]}" = "Moy" ]]
then
SCORE=-1
fi
echo $SCORE
|