Can anybody help? Please?

Question

0.00/5 (No votes)

See more:

import sys
import os
import time
import calendar
#import MariaDB
#import phpMyAdmin
import MySQLdb
#import pymysql
import time
from time import *

lt = localtime()


file = open('/sys/bus/w1/devices/28-030797798738/w1_slave')
filecontent = file.read()
file.close()
stringvalue = filecontent.split("\n")[1].split(" ")[9]
temperatur_sensor1 = float(stringvalue[2:]) / 1000
print "hhhhhhh", temperatur_sensor1
connection = MySQLdb.connect (host="localhost", user="Smart", passwd="123456", db="mysql", charset='utf8')

cursor = connection.cursor()
cursor.execute("""CREATE TABLE IF NOT EXISTS temperatur6 (temperatur6 FLOAT(5))""")
print "ggggggg", temperatur_sensor1
cursor.execute("INSERT INTO temperatur6 VALUES ( '%s' ) "),(temperatur_sensor1)
print "ffffff", temperatur_sensor1

connection.commit()
cursor.close();

sys.exit(0)

The Waring is?___________________________________________________________

Test_1.py:37: Warning: Incorrect double value: '%s' for column 'temperatur6' at row 1
  cursor.execute("INSERT INTO temperatur6 VALUES ( '%s' ) "),(temperatur_sensor1)

What I have tried:

I tried almost everythin already. Inset a %d or to delete the '' signs.

Posted 9-Jun-19 4:03am

Member 14488635

Updated 10-Jun-19 0:04am

v3

Add a Solution

Comments

[no name] 9-Jun-19 10:13am

Obsolete after Q Edit~~Your table has one column 'temperatur6', but you try to insert two columns...~~

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2019-06-09T05:03:00

Solution 1

temperatur_sensor1 is a float value, not a string.

Posted 9-Jun-19 5:03am

Richard MacCutchan

Comments

Member 14488635 9-Jun-19 11:12am

Da soll aber eine Dezimalzahl wie z.Bsp: 29.44 rein. Was muss ich denn ändern? Danke!!

[no name] 9-Jun-19 12:03pm

Du solltest in Englisch antworten ;)

Richard MacCutchan 10-Jun-19 3:37am

This is an English language site. If you do not speak reasonable English you can use Google Translate.

Member 14488635 10-Jun-19 5:28am

Sorry. I forgot to write in English.
I just want to know what I have to change in the code program? I am really glueless. Can you give me a hint? Please!

Richard MacCutchan 10-Jun-19 5:36am

Start with the documentation: MySQLdb User’s Guide — MySQLdb 1.2.4b4 documentation[^].

Member 14488635 10-Jun-19 5:39am

Ok. This might be the best. Thank you for your help. Let you know if it was successful. Thankx

Member 14488635 10-Jun-19 6:02am

The print works fine!

Richard MacCutchan 10-Jun-19 6:04am

See my suggestion below.

Member 14488635 10-Jun-19 6:24am

This is the result!
hhhhhhh 20.125
Test_3.py:35: Warning: Table 'temperatur6' already exists
cursor.execute("""CREATE TABLE IF NOT EXISTS temperatur6 (temperatur6 float(5))""")
ggggggg 20.125
Traceback (most recent call last):
File "Test_3.py", line 37, in <module>
cursor.execute("""INSERT INTO temperatur6 VALUES (%s)""", (temperatur_sensor1))
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 207, in execute
args = tuple(map(db.literal, args))
TypeError: argument 2 to map() must support iteration

But it looks better. At least your suggestion was right! Thankx

Richard MacCutchan 10-Jun-19 6:50am

OK, try without the parentheses round the value:

cursor.execute("""INSERT INTO temperatur6 VALUES (%s) """, temperatur_sensor1)

Richard MacCutchan 10-Jun-19 7:53am

My final guess is that the value field needs a comma at the end if there is only one item:

cursor.execute("""INSERT INTO temperatur6 VALUES (%s) """, (temperatur_sensor1,))

Richard MacCutchan · Answer 2 · 2019-06-10T00:04:00

This is a guess as I do not have MySqldb on my system. But looking at the syntax of MySQL statements in the documentation I wonder if your quote characters and parentheses are correct. Try changing the INSERT to:

Python

cursor.execute("""INSERT INTO temperatur6 VALUES (%s) """,(temperatur_sensor1))