You're best starting with the declarative usage patterns described in the ORM
tutorial at http://www.sqlalchemy.org/docs/orm/tutorial.html, starting with
http://www.sqlalchemy.org/docs/orm/tutorial.html#creating-table-class-and-mapper-all-at-once-declaratively.
I would declare the class + table + mapping at once, to eliminate any
confusion regarding mapping, which is not a per-usage operation; it is a
permanent operation applied to a model class only once. The mapper() +
Table pattern is not as easy to use and it's being de-emphasized in the
documentation.
The second error implies your class has a method called value() on it which is
conflicting with the mapped attribute of .value.
On Jun 14, 2011, at 12:22 PM, Liju wrote:
I'm new to SQLAlchemy. I wrote a method that retrieves a record,
update the object after incrementing it by 1, and return that record
object to the caller (pyramid view). Following is the test function. I
get following errors :
1) when I call this method multiple times, I get an error that say
ArgumentError: Class 'class 'cas.models.Models'' already has a
primary mapper defined. Use non_primary=True to create a non primary
Mapper. clear_mappers() will remove *all* current mappers from all
classes.
As a resolution i called 'clear_mappers()' before invoking mapper.
2) I cant seem to increment the attribute of an object in orm session.
My understanding is that once a record is retrieved in an ORM session,
Session object keeps track of any changes to the record object and
updates the record when session.flush() is invoked.
But I get error TypeError: unsupported operand type(s) for +:
'instancemethod' and 'int'
Can someone please explain to me what I'm doing wrong ?
class Models(object):pass
def countAndIncrement():
metadata = MetaData('sqlite:///CAS.db')
model_table = Table('models',
metadata,
Column('id',Integer,primary_key=True),
Column('name',String(40)),
Column('value',Integer)
)
clear_mappers()
mapper(Models,model_table) # already a
primary mapper defined error (when I call this function multiple times
Session = sessionmaker()
session = Session()
model = session.query(Models).filter(Models.id==1)
model.value = model.value + 1 #
increment error
session.flush()
session.close()
return model
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.