if you construct a new Keyword() instance like that, it will be
inserted. youd have to do a session.query(Keyword).select_by
(keyword_name='some_kw') or something similar if you want to get the
existing one first.
to make it more automatic you might want to try putting the check for
existing into a metaclass or a custom __new__() method, perhaps.
On Aug 30, 2006, at 4:13 AM, lazz wrote:
> I follow the many-to-many data mapping.
> And find if I use:
> article.keywords.append(Keyword("some_kw"))
> SA will always add a new row to 'keywords' table whether the keyword
> existed or not.
>
> Is this normal? Or how can I specify an exist keyword to an article?
>
>
> --
> I'm lazy, I'm coding.
> http://lazycoding.blogspot.com/
>
> ----------------------------------------------------------------------
> ---
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
