cant reproduce, running with Python 3.3.0 here against 0.8.0 I get the INSERT:
PRAGMA table_info("products") 2013-04-16 16:14:41,019 INFO sqlalchemy.engine.base.Engine () 2013-04-16 16:14:41,019 INFO sqlalchemy.engine.base.Engine CREATE TABLE products ( id INTEGER NOT NULL, name VARCHAR(200), description TEXT, PRIMARY KEY (id) ) 2013-04-16 16:14:41,020 INFO sqlalchemy.engine.base.Engine () 2013-04-16 16:14:41,020 INFO sqlalchemy.engine.base.Engine COMMIT True 2013-04-16 16:14:41,021 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2013-04-16 16:14:41,021 INFO sqlalchemy.engine.base.Engine INSERT INTO products (id, name, description) VALUES (?, ?, ?) 2013-04-16 16:14:41,021 INFO sqlalchemy.engine.base.Engine (1, 'Test', 'Test') 2013-04-16 16:14:41,022 INFO sqlalchemy.engine.base.Engine COMMIT 2013-04-16 16:14:41,022 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2013-04-16 16:14:41,022 INFO sqlalchemy.engine.base.Engine SELECT products.id AS products_id, products.name AS products_name, products.description AS products_description FROM products 2013-04-16 16:14:41,023 INFO sqlalchemy.engine.base.Engine () [<__main__.Product object at 0x105c3dbd0>] On Apr 16, 2013, at 2:42 PM, Tim Cooijmans <timcooijm...@gmail.com> wrote: > from sqlalchemy import create_engine, Integer, String, Text, Column, > Sequence, DateTime, ForeignKey > from sqlalchemy.orm import sessionmaker, relationship, backref > from 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 -- 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.