stackoverflow01

SQLAlchemy: about self referential relation (error: no attribute '_sa_instance_state').sql

http://stackoverflow.com/questions/16054472/sqlalchemy-about-self-referential-relation-error-no-attribute-sa-instance-s

## -------------------------------------------------------------------
## generated by doing something like: "kws=DBSession.query(KW).all()"
## -------------------------------------------------------------------

   [sqlalchemy.engine.base.Engine][Dummy-2] SELECT kw_table.id AS kw_table_id, kw_table.name AS kw_table_name 
FROM kw_table
   [sqlalchemy.engine.base.Engine][Dummy-2] ()



## -------------------------------------------------------------------
## generated by adding {"kwyword":"apple","parent":"fruit"}
## -------------------------------------------------------------------

  [sqlalchemy.engine.base.Engine][Dummy-3] SELECT kw_table.id AS kw_table_id, kw_table.name AS kw_table_name 
FROM kw_table
  [sqlalchemy.engine.base.Engine][Dummy-3] ()
  [sqlalchemy.engine.base.Engine][Dummy-3] SELECT kw_table.id AS kw_table_id, kw_table.name AS kw_table_name 
FROM kw_table 
WHERE kw_table.name = %s 
 LIMIT %s
  [sqlalchemy.engine.base.Engine][Dummy-3] ('fruit', 1)
  [sqlalchemy.engine.base.Engine][Dummy-3] INSERT INTO kw_table (name) VALUES (%s)
  [sqlalchemy.engine.base.Engine][Dummy-3] ('fruit',)
  [sqlalchemy.engine.base.Engine][Dummy-3] INSERT INTO kw_table (name) VALUES (%s)
  [sqlalchemy.engine.base.Engine][Dummy-3] ('apple',)
  [sqlalchemy.engine.base.Engine][Dummy-3] INSERT INTO kw2kw_table (child_id, parent_id) VALUES (%s, %s)
  [sqlalchemy.engine.base.Engine][Dummy-3] ((1L, 1L), (2L, 1L))
  [sqlalchemy.engine.base.Engine][Dummy-3] SELECT kw_table.id AS kw_table_id, kw_table.name AS kw_table_name 
FROM kw_table
  [sqlalchemy.engine.base.Engine][Dummy-3] ()



## -------------------------------------------------------------------
## generated by adding {"kwyword":"pie","parent":"" (default to "pie" itself)}
## -------------------------------------------------------------------

  [sqlalchemy.engine.base.Engine][Dummy-5] SELECT kw_table.id AS kw_table_id, kw_table.name AS kw_table_name 
FROM kw_table
  [sqlalchemy.engine.base.Engine][Dummy-5] ()
  [sqlalchemy.engine.base.Engine][Dummy-5] INSERT INTO kw_table (name) VALUES (%s)
  [sqlalchemy.engine.base.Engine][Dummy-5] ('pie',)
  [sqlalchemy.engine.base.Engine][Dummy-5] INSERT INTO kw2kw_table (child_id, parent_id) VALUES (%s, %s)
  [sqlalchemy.engine.base.Engine][Dummy-5] (3L, 3L)
  [sqlalchemy.engine.base.Engine][Dummy-5] SELECT kw_table.id AS kw_table_id, kw_table.name AS kw_table_name 
FROM kw_table
  [sqlalchemy.engine.base.Engine][Dummy-5] ()



## -------------------------------------------------------------------
## -------------------------------------------------------------------
## Finnaly, I couldn't find any row in the KW table( checked with Sequel). 
BTW, there was something wired: when I reload the page continually, 
I could get the rows I just inserted "in turn":

reload: see "kwyword:pie" (no parent though ... parent should be itself)
reload: see ""
reload: see "kwyword":"apple","parent":"fruit"
...