[sqlalchemy] Re: Update multiple rows in SQLite Databse

2020-08-27 Thread William Phillips
My problem seems far from solved. Searching the internet for information on how to apply "unit of work" has proven difficult. I found general references but no practical examples on how to concretely apply the concept. I finally found one practical (but short) explanation at : Link to Unit

Re: [sqlalchemy] How to do a case-insensitive query for association proxy attributes?

2020-08-27 Thread Mike Bayer
On Thu, Aug 27, 2020, at 2:27 PM, Jacob Pavlock wrote: > I have two classes, a Track and an Album. In order to have album fields > easily accessible from a track, I created an association proxy attribute. > > ```python > class Track(MusicItem, Base): > __tablename__ = "tracks" > > _id

[sqlalchemy] How to do a case-insensitive query for association proxy attributes?

2020-08-27 Thread Jacob Pavlock
I have two classes, a Track and an Album. In order to have album fields easily accessible from a track, I created an association proxy attribute. ```python class Track(MusicItem, Base): __tablename__ = "tracks" _id = Column(Integer, primary_key=True) _album_id = Column(Integer,