task_manager/edit_task.sh at main · tomikhin/task_manager · GitHub

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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
#!/bin/bash

# To load variables containing user, password and database name for database connection
source config/db_params.sh

# Receive the passed arguments
read input
task_id=$(echo "$input" | grep -oP 'task_id=\K[^&]*')
description=$(echo "$input" | grep -oP 'description=\K[^&]*' | sed 's/+/ /g' | sed 's/%20/ /g')
deadline=$(echo "$input" | grep -oP 'deadline=\K[^&]*' | sed 's/+/ /g' | sed 's/%20/ /g' | sed 's/%3A/:/g')
priority=$(echo "$input" | grep -oP 'priority=\K[^&]*' | sed 's/+/ /g' | sed 's/%20/ /g')


echo "Content-type: text/html"
echo ""


echo "<html>"
echo "<head><title>Task Manager</title></head>"
echo "<body>"
echo "<h3><a href='/index.html'>Task Manager</a></h3>"
echo "<hr>"
echo "<h2>Editing Task #$task_id</h2>"


# Check that all fields are filled in
if [ -z "$description" ] || [ -z "$deadline" ] || [ -z "$priority" ]; then
    echo "<p><font color='red'>Error: All fields must be filled.</font></p>"
    echo "<a href='/cgi-bin/edit_task.sh?task_id=$task_id'>Return to the editing form</a>"
else
    # SQL-query to update task
    mariadb -u "$DB_USER" -p"$DB_PASS" -D "$DB_NAME" -e "UPDATE tasks SET description='$description', deadline='$deadline', priority='$priority' WHERE id=$task_id;"

	# Check if previous command was successful
    if [ $? -eq 0 ]; then
        echo "<p>Task has been successfully updated:</p>"
        echo "<ul>"
        echo "<li>Description: $description</li>"
        echo "<li>Deadline: $deadline</li>"
        echo "<li>Priority: $priority</li>"
        echo "</ul>"
        echo "<a href='/cgi-bin/show_tasks.sh'>Return to the list of tasks</a>"
    else
        echo "<p><font color='red'>Error updating task. Try again.</font></p>"
        echo "<a href='/cgi-bin/edit_task.sh?task_id=$task_id'>Return to the editing form</a>"
    fi
fi

echo "</body>"
echo "</html>"