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 <[email protected]> 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
