smd.iotkit2.ch / Mbed 2 deprecated 2-07-04-Uebung

Important changes to repositories hosted on mbed.com

Mbed hosted mercurial repositories are deprecated and are due to be permanently deleted in July 2026.

To keep a copy of this software download the repository Zip archive or clone locally using Mercurial.

It is also possible to export all your personal repositories from the account settings page.

Dependencies:   EthernetInterface TMP175 mbed-rtos mbed

Fork of HTTP_POST by smd.iotkit2.ch

cgi-bin/restsql.txt@14:a93858b247b9, 2016-04-15 (annotated)

Committer:
stefan1691
Date:
Fri Apr 15 18:14:33 2016 +0000
Revision:
14:a93858b247b9
Parent:
10:3a38ba20cb57 
restsql mit HTTP GET

Who changed what in which revision?

UserRevisionLine numberNew contents of line
stefan1691 9:dffb514cde17 1 #!/bin/bash
stefan1691 9:dffb514cde17 2 #
stefan1691 9:dffb514cde17 3 # Mittels HTTP POST in MySQL Schreiben
stefan1691 14:a93858b247b9 4
stefan1691 9:dffb514cde17 5 # HTTP Header fuer Client
stefan1691 9:dffb514cde17 6 echo "Content-type: text/plain"
stefan1691 9:dffb514cde17 7 echo ""
stefan1691 14:a93858b247b9 8
stefan1691 14:a93858b247b9 9 #
stefan1691 14:a93858b247b9 10 ### GET
stefan1691 14:a93858b247b9 11 #
stefan1691 14:a93858b247b9 12 if [ "$REQUEST_METHOD" = "GET" ]
stefan1691 14:a93858b247b9 13 then
stefan1691 14:a93858b247b9 14 export SQL="SELECT * FROM data;"
stefan1691 14:a93858b247b9 15
stefan1691 14:a93858b247b9 16 echo "$SQL"
stefan1691 14:a93858b247b9 17 echo ""
stefan1691 14:a93858b247b9 18 mysql -uwww-data -pmbed sensoren <<EOF
stefan1691 14:a93858b247b9 19 ${SQL}
stefan1691 14:a93858b247b9 20 EOF
stefan1691 14:a93858b247b9 21
stefan1691 14:a93858b247b9 22 fi
stefan1691 14:a93858b247b9 23
stefan1691 9:dffb514cde17 24 #
stefan1691 9:dffb514cde17 25 ### POST
stefan1691 9:dffb514cde17 26 #
stefan1691 9:dffb514cde17 27 if [ "$REQUEST_METHOD" = "POST" ]
stefan1691 9:dffb514cde17 28 then
stefan1691 9:dffb514cde17 29 # Zerlegt den Querystring in Einzelteile
stefan1691 9:dffb514cde17 30 saveIFS=$IFS
stefan1691 9:dffb514cde17 31 IFS='=&'
stefan1691 9:dffb514cde17 32 parm=(`cat -`)
stefan1691 9:dffb514cde17 33 IFS=$saveIFS
stefan1691 14:a93858b247b9 34
stefan1691 9:dffb514cde17 35 printf "write to SQL Database: "
stefan1691 9:dffb514cde17 36 FIELDS=""
stefan1691 9:dffb514cde17 37 DATA=""
stefan1691 9:dffb514cde17 38 for (( index = 0; index < ${#parm[@]}; index += 2 ))
stefan1691 9:dffb514cde17 39 do
stefan1691 9:dffb514cde17 40 if [ ${index} -gt 0 ]
stefan1691 9:dffb514cde17 41 then
stefan1691 9:dffb514cde17 42 FIELDS=${FIELDS}","
stefan1691 9:dffb514cde17 43 DATA=${DATA}","
stefan1691 9:dffb514cde17 44 fi
stefan1691 9:dffb514cde17 45 FIELDS=${FIELDS}${parm[index]}
stefan1691 9:dffb514cde17 46 DATA=${DATA}${parm[index+1]}
stefan1691 9:dffb514cde17 47 done
stefan1691 9:dffb514cde17 48 SQL="INSERT INTO data( ${FIELDS} ) VALUES( ${DATA} );"
stefan1691 9:dffb514cde17 49 echo $SQL
stefan1691 10:3a38ba20cb57 50 mysql -uwww-data -pmbed sensoren <<EOF
stefan1691 9:dffb514cde17 51 ${SQL}
stefan1691 9:dffb514cde17 52 EOF
stefan1691 14:a93858b247b9 53
stefan1691 9:dffb514cde17 54 fi