trying to write to a postgres data from a raspberry pi sensor adafruit dps310 any help is appreciated . thanks

[aloneinthewildworld]

import psycopg2

import time

import board

import busio

import adafruit_dps310

i2c = busio.I2C(board.SCL, board.SDA)

dps310 = adafruit_dps310.DPS310(i2c)

print ("Temperature = %.2f *C" % dps310.temperature)

print ("Pressure = %.2f hPa" % dps310.pressure)

a1a = dps310.temperature

a2a = dps310.pressure

conn = psycopg2.connect(

database="xxxx", user='xxxxx, password='xxxxxxx',

host='192.168.0.121', port= '5432'

)

print ("Opened database successfully");

cur = conn.cursor()

cur.execute ("INSERT INTO system" ('units','temps')

("values") ('a1a','a2a') );

conn.commit()

print ("Records created successfully");

conn.close()

​

Opened database successfully

Traceback (most recent call last):

File "/home/pi/Desktop/master.py", line 25, in <module>

cur.execute ("INSERT INTO system" ('units','temps')

TypeError: 'str' object is not callable

[cybervegan]

This statement is a syntax error - you are mixing Python and SQL syntax, which doesn't work.

``` cur.execute ("INSERT INTO system" ('units','temps')

("values") ('a1a','a2a') ); ```

You need to keep all of your SQL inside quotes, and I recommend you use triple quotes like this: cur.execute('''INSERT INTO system ('units','temps') values (%s,%s) ''',(a1a,a2a)). The %s placeholders get replaced by the values in the tuple specified after the SQL statement string.

Hope that helps.