I think you need to commit your session data.
Em terça-feira, 16 de abril de 2013, Tim Cooijmans escreveu:
> 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
>
>
--
*Mauricio de Abreu Antunes*
Mobile: (51)930-74-525
Skype: mauricio.abreua
--
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.
