Hi group,
I am tring to migrate from version *1.3.24* to *1.4.23* of SqlAlchemy,
using *PostgreSQL 10*.
I found that the following code example works with 1.3, but triggers a
traceback with 1.4.
import sqlalchemy
session = ...
metadata = sqlalchemy.MetaData()
s_items = sqlalchemy.Sequence('s_items', start=1, increment=1,
metadata=metadata)
t_items = sqlalchemy.Table('t_items', metadata,
sqlalchemy.Column('id', sqlalchemy.Integer, s_items, primary_key =
True),
)
metadata.drop_all(bind=session.bind)
metadata.create_all(bind=session.bind)
class Item(object):
pass
sqlalchemy.orm.mapper(Item, t_items)
item1 = Item()
item2 = Item()
session.add_all([item1, item2])
session.flush()
This code, with 1.4 only, triggers the following traceback:
Traceback (most recent call last):
File "C:\Python36\lib\site-packages\sqlalchemy\engine\base.py", line
1672, in _execute_context
dialect, self, conn, execution_options, *args, **kw
File "C:\Python36\lib\site-packages\sqlalchemy\engine\default.py", line
999, in _init_compiled
self._process_executemany_defaults()
File "C:\Python36\lib\site-packages\sqlalchemy\engine\default.py", line
1838, in _process_executemany_defaults
if c.default and c.default.is_scalar:
AttributeError: 'Sequence' object has no attribute 'is_scalar'
The only way I found to work around this with version 1.4, is to call *flush
*after each single *add*:
item1 = Item()
session.add(item1)
session.flush()
item2 = Item()
session.add(item2)
session.flush()
But this seems weird, to me.
Am I doing anything wrong?
Thank you very much for any suggestion.
Francesca Leon
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/c049bcf1-ff1c-4d78-b38f-6f2dba1a87e1n%40googlegroups.com.
