Databases
StackOverflow2013
Postsdbo
POsqlalchemy tutorial example not working
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsqlalchemy tutorial example not working
    primarykey
    data
    text
    <p>I'm trying to work my way through the example given in the <a href="http://docs.sqlalchemy.org/en/latest/orm/tutorial.html">sqlalchemy tutorial</a> but I'm getting errors. As far as I can tell I'm following the example to the letter. Here's the code that I have from it so far. It fails when I <code>.first()</code> after I query the DB.</p> <p>I'm on version 0.7.5 and python 2.7</p> <pre><code>from sqlalchemy import Column, Integer, String from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker engine = create_engine('sqlite:///:memory:', echo=True) engine.execute("select 1").scalar() # works fine Session = sessionmaker(bind=engine) session = Session() Base = declarative_base() class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) fullname = Column(String) password = Column(String) def __init__(self, name, fullname, password): self.name = name self.fullname = fullname self.password = password def __repr__(self): return "&lt;User('%s','%s', '%s')&gt;" % (self.name, self.fullname, self.password) jeff_user = User("jeff", "Jeff", "foo") session.add(jeff_user) our_user = session.query(User).filter_by(name='jeff').first() # fails here jeff_user.password = "foobar" session.add_all([ User('wendy', 'Wendy Williams', 'foobar'), User('mary', 'Mary Contrary', 'xxg527'), User('fred', 'Fred Flinstone', 'blah')]) session.dirty # shows nothing as dirty session.new # shows nothing as new </code></pre> <p>Here is the error message</p> <pre><code>2012-02-25 17:48:33,879 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2012-02-25 17:48:33,886 INFO sqlalchemy.engine.base.Engine INSERT INTO users (name, fullname, password) VALUES (?, ?, ?) 2012-02-25 17:48:33,886 INFO sqlalchemy.engine.base.Engine ('jeff', 'Jeff', 'foo') 2012-02-25 17:48:33,887 INFO sqlalchemy.engine.base.Engine ROLLBACK Traceback (most recent call last): File "learning_sql.py", line 35, in &lt;module&gt; our_user = session.query(User).filter_by(name='ed').first() # fails here File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2024, in first ret = list(self[0:1]) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1918, in __getitem__ return list(res) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2092, in __iter__ self.session._autoflush() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 983, in _autoflush self.flush() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1559, in flush self._flush(objects) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1630, in _flush flush_context.execute() File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 331, in execute rec.execute(self) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 475, in execute uow File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2291, in _save_obj execute(statement, params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in execute params) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1538, in _execute_clauseelement compiled_sql, distilled_params File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (OperationalError) no such table: users u'INSERT INTO users (name, fullname, password) VALUES (?, ?, ?)' ('jeff', 'Jeff', 'foo') </code></pre> <p>The expected print out is this</p> <pre><code>&gt;&gt;&gt; our_user = session.query(User).filter_by(name='ed').first() BEGIN (implicit) INSERT INTO users (name, fullname, password) VALUES (?, ?, ?) ('ed', 'Ed Jones', 'edspassword') SELECT users.id AS users_id, users.name AS users_name, users.fullname AS users_fullname, users.password AS users_password FROM users WHERE users.name = ? LIMIT 1 OFFSET 0 ('ed',) &gt;&gt;&gt; our_user &lt;User('ed','Ed Jones', 'edspassword')&gt; </code></pre> <p>For some reason my code is causing a ROLLBACK when it should be SELECT.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJeff
    1. USJeff
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POsqlalchemy tutorial example not working
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POsqlalchemy tutorial example not working
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POsqlalchemy tutorial example not working
      1. This table or related slice is empty.
      1. VTUpMod
    1. COpossible duplicate of [Following the official ORM tutorial and I'm running into an error](http://stackoverflow.com/questions/6710278/following-the-official-orm-tutorial-and-im-running-into-an-error)
      singulars
      1. POsqlalchemy tutorial example not working
      1. USChase Sandmann
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload