Python Forum
Support required to data log in SQL server single table via raspbeery pi
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Support required to data log in SQL server single table via raspbeery pi
#1
Dear All,
I have a problem while data logging in the single DB table in SQL server. We are not able to do it. When we are running the python code in raspberry pi we are getting the following error msg.

ERROR MESSAGE

Error:
File "./insertDB.py", line 19 //cursor = con.cursor(prepared=True) ^ SyntaxError: invalid syntax
Please anyone help me out.

Py Code:

import serial
import time
import MySQLdb as mdb

arduino = serial.Serial("/dev/ttyACM0")
arduino.baudrate=9600

data = arduino.readline()
time.sleep(1)
data = arduino.readline()
pieces = data.split("\t")

temperature = pieces[0]
humidity = pieces[1]

#This is a comment

con = mdb.connect('localhost', 'root', '12345678', 'testdb');

with con:
  //cursor = con.cursor(prepared=True)
  sql_insert_query = """ INSERT INTO TempDB (temperature, humidity) VALUES (%s,%s)"""
 
  insert_tuple = (temperature, humidity)
  cursor.execute(sql_insert_query, insert_tuple)
  con.commit()
Reply


Messages In This Thread
Support required to data log in SQL server single table via raspbeery pi - by rithikvg - Jun-23-2020, 04:04 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Using pyodbc&pandas to load a Table data to df tester_V 3 830 Sep-09-2023, 08:55 PM
Last Post: tester_V
  Need help on how to include single quotes on data of variable string hani_hms 5 2,054 Jan-10-2023, 11:26 AM
Last Post: codinglearner
  In SQL Server, mix data types. shiv11 0 889 Sep-21-2022, 12:50 PM
Last Post: shiv11
  How to modify python script to append data on file using sql server 2019? ahmedbarbary 1 1,232 Aug-03-2022, 06:03 AM
Last Post: Pedroski55
  panda table data kucingkembar 0 1,133 Mar-01-2022, 10:38 PM
Last Post: kucingkembar
  Sorting table data Blacktime2 1 1,336 Feb-26-2022, 07:05 PM
Last Post: ibreeden
  Strategy on updating edits back to data table and object variables hammer 0 1,207 Dec-11-2021, 02:58 PM
Last Post: hammer
  SQLALCHEMY - Not selecting data from table jamesaarr 4 2,244 Nov-02-2021, 03:02 PM
Last Post: Larz60+
  Presenting multiline data into single line aaronbuhu 1 1,812 Aug-05-2021, 10:57 AM
Last Post: jamesaarr
  How to take the tar backup files form remote server to local server sivareddy 0 1,917 Jul-14-2021, 01:32 PM
Last Post: sivareddy

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020