4 echo "UPDATE context_trigger_template SET j_template='{$2 }' WHERE name='$1';"
5 echo "INSERT OR IGNORE INTO context_trigger_template (name, j_template) VALUES ('$1', '{$2 }');"
8 echo "CREATE TABLE IF NOT EXISTS context_trigger_template ("
9 echo " name TEXT DEFAULT '' NOT NULL PRIMARY KEY,"
10 echo " j_template TEXT DEFAULT '' NOT NULL);"
12 template_json_file="$1"
16 keyword=`echo $line | awk '{print $1}' | tr -cd '[:alpha:]'`
18 if [[ $keyword = "name" ]]; then
20 if [ -n "$template" ]; then
21 print_sql "$name" "$template"
25 name=`echo $line | tr -d '":,' | awk '{print $2}'`
28 if [[ $keyword = "name" ]] || [[ $keyword = "attributes" ]] || [[ $keyword = "option" ]]; then
29 template="$template $line"
32 done < "$template_json_file"
34 print_sql "$name" "$template"