SQLAlchemy 删不掉数据

Question

删除代码

  def delete(self,id):
        session = Goods().getsession()
        goodslist = session.query(Goods).filter(Goods.id==id).one()
        print id       
        session.delete()
        session.close()
        
   

调用正常
1319
127.0.0.1 - - [30/Mar/2017 22:22:21] "GET /del?id=1319 HTTP/1.1" 200 -

但是数据却没有删掉

Answer 1

＃ 你没有commit
def delete(self,id):
    session = Goods().getsession()
    goodslist = session.query(Goods).filter(Goods.id==id).one()
    print id       
    session.delete()
    session.commit()
    session.close()

Answer 2

请操作后调用commit方法进行提交即可