I'm trying to insert a list of dictionaries into a table using
bulk_insert_mappings(). When I call it, I get this error:
AttributeError: 'Table' object has no attribute 'mapper'
I'm having trouble (in general) figuring out which of the various ways of
specifying my table(s) are appropriate. I've been doing this (paraphrasing
because I can't copy out of my work env):
import sqlalchemy as sa
import sa.orm
SESSION = sa.orm.sessionmaker()
engine = sa.create_engine(...)
metadata = sa.MetaData(engine)
session = SESSION(bind=engine)
mytable = sa.Table("mytable", metadata, sa.Column(...), ...)
The session object is created within a contextmanager as described here:
http://docs.sqlalchemy.org/en/latest/orm/session_basics.html
It's within the scope of that contextmanager (a couple levels down in the
function call stack) that the call is made:
mytable = metadata.tables['mytable']
session.bulk_insert_mappings(mytable, records)
I clearly must not understand something about the parameter properties
required of that function. The docs state:
*mapper* – a mapped class, or the actual Mapper
<http://docs.sqlalchemy.org/en/latest/orm/mapping_api.html#sqlalchemy.orm.mapper.Mapper>
object, representing the single kind of object represented within the
mapping list.
I thought I had assembled all the bits (engine, session, bound metadata).
What's not mapped about my Table object?
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
