save() of persistent object should fail

#!/usr/bin/env python

from sqlalchemy import *
from sqlalchemy.orm import *

e = create_engine("sqlite://", echo=True)
metadata = MetaData(e)

session = create_session()
transaction = session.create_transaction()

users_table = Table('users', metadata,
    Column('id', Integer, primary_key = True),
    Column('name', Unicode(80)),
)


class User(object):
    def __repr__(self):
        return unicode(self.name)

mapper(User, users_table, 
)


metadata.create_all()


u = User()
u.id = 1
u.name="Foo Bar"

session.save(u)

transaction.commit()


metadata.bind.echo = True
session = create_session()
transaction = session.create_transaction()


foo = session.query(User).filter_by(name='Foo Bar').one()
session.save(foo) # should raise error !
Comments (2)
