Psycopg2 programmingerror can t adapt type dict

In OpenERP while saving data I got this error : ProgrammingError: can't adapt type 'dict' ,I was getting the same error but in my situation the problem happened to be that I had mistakenly used a many2one field in place of a one2many field. Looking at your code, I also see that you may have done the same thing:,The error only appeared for me when I specified a one2many widget for the field in the form view and tried to add a line item and save the form, so I suspect that you were also using a one2many widget in your form view to represent the medical_detail_ids field. Naturally, the one2many widget is not the appropriate widget to use for a many2one, and thus the cryptic error.

I was getting the same error but in my situation the problem happened to be that I had mistakenly used a many2one field in place of a one2many field. Looking at your code, I also see that you may have done the same thing:

'medical_detail_ids': fields.many2one('hr.medical.detail', 'Medical Details')

It appears that you meant to use a one2many field here, so it should look like this:

'medical_detail_ids': fields.one2many('hr.medical.detail', 'employee_id', 'Medical Details')

You would also need to add the following reciprocal field to hr_medical_detail:

'employee_id': fields.many2one('hr.employee', 'Employee')

# If you 're using SQLAlchemy:
# Use "%%"
instead of "%" in your queries, because
# a single "%"
is used in Python string formatting.

# Alternatively escape the SQL properly with sqlalchemy.text(...):
   engine.execute(sqlalchemy.text(sql_query))

Unfortunately, this failed with an error when I tried to commit the event object to the database.,Until I ran into an error when I was inserting data stored in a Pydantic model to my postgres database using SQLAlchemy.,To convert the data from EventSchema to Event, I wrote some glue code:,Another part in my code defined an SQLAlchemy model to persist this incoming information (along with other data not shown here):

# Pydantic class
class EventSchema(BaseModel):
   ip_address: IPvAnyAddress

# SQLAlchemy model
class Event(Base):
   __tablename__ = "event"

id = Column(Integer, primary_key = True)
ip_address = Column(INET)

# Glue code
event_data = EventSchema(ip_address = "127.0.0.1")
event = Event( ** event_data.dict())

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) can 't adapt type '
IPv4Address ' [SQL: INSERT INTO event(ip_address) VALUES( % (ip_address) s) RETURNING event.id]
   [parameters: {
      'ip_address': IPv4Address('127.0.0.1')
   }]
   (Background on this error at: http: //sqlalche.me/e/13/f405)

from psycopg2.extensions
import register_adapter, AsIs
from pydantic.networks
import IPv4Address, IPv6Address

def adapt_pydantic_ip_address(ip):
   return AsIs(repr(ip.exploded))

register_adapter(IPv4Address, adapt_pydantic_ip_address)
register_adapter(IPv6Address, adapt_pydantic_ip_address)

I have JSONB column, but I can't insert because of Can't adapt type 'dict'.,Hello, I have dict and i want to store it in postgresql., In this repository All GitHub ↵ Jump to ↵ , Pricing Plans Compare plans Contact Sales Education

INSERT INTO mail(
   a0, a1, a2, a3, a4, a5, a6, a7
)
VALUES( %
   s, % s, % s, % s, % s, NOW(), % s::int, % s
);
""
"

    json.dumps({}),
       psycopg2.ProgrammingError: can 't adapt type '
    dict '