I have a strange error using Python 3.3.0 and SQLAlchemy 0.8.0:
from sqlalchemy import create_engine, Integer, String, Text, Column, Sequence, DateTime, ForeignKeyfrom sqlalchemy.orm import sessionmaker, relationship, backreffrom sqlalchemy.ext.declarative import declarative_base engine = create_engine("sqlite:///:memory:", echo=True)Session = sessionmaker(bind = engine)Base = declarative_base() class Product(Base): __tablename__ = "products" id = Column(Integer, primary_key=True) name = Column(String(200)) description = Column(Text) Base.metadata.create_all(engine) session = Session() product = Product() product.id = 1 product.name = "Test" product.description = "Test" session.add(product)print(product in session) # Expected true session.commit()print(session.query(Product).all()) # Expected the previous item As commented in code I expected the add method to add the product to the database using an INSERT. But it doesn't nor does it throw an exception. This is the log: 2013-04-16 18:03:14,368 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("products")2013-04-16 18:03:14,369 INFO sqlalchemy.engine.base.Engine ()2013-04-16 18:03:14,371 INFO sqlalchemy.engine.base.Engine CREATE TABLE products ( id INTEGER NOT NULL, name VARCHAR(200), description TEXT, PRIMARY KEY (id)) 2013-04-16 18:03:14,371 INFO sqlalchemy.engine.base.Engine ()2013-04-16 18:03:14,371 INFO sqlalchemy.engine.base.Engine COMMITFalse2013-04-16 18:04:04,706 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)2013-04-16 18:04:04,708 INFO sqlalchemy.engine.base.Engine SELECT products.id AS products_id, products.name AS products_name, products.description AS products_description FROM products2013-04-16 18:04:04,709 INFO sqlalchemy.engine.base.Engine ()[] I already tried several things: - Changing the engine doesn't work: I also tried postgresql. - I tried debugging. When I reach the body of the add method there is nothing to step into. Am I doing something wrong or is this a bug? (Also posted this question on Stack Overflow: http://stackoverflow.com/questions/16041868/sqlalchemy-session-add-doesnt-work ) -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.