Re: [sqlalchemy] OperationalError with SQLite with simple update query

2016-03-19 Thread Piotr Dobrogost
On Wednesday, March 16, 2016 at 4:41:38 PM UTC+1, Simon King wrote: > > > Hmm, ok. In that case, does it work if you use "TextValue.id.in_(ids)" > rather than Node? I can't tell from your > Yes, this works – see my last post in this thread. > description if the "id" and "value" columns are

Re: [sqlalchemy] OperationalError with SQLite with simple update query

2016-03-19 Thread Piotr Dobrogost
On Wednesday, March 16, 2016 at 3:51:16 PM UTC+1, Simon King wrote: > > On Wed, Mar 16, 2016 at 1:43 PM, Piotr Dobrogost < > p...@2016.groups.google.dobrogost.net > wrote: > >> Hi! >> >> When executing below code >> >> DBSession.query(TextValue).\ >> filter(Node.id.in_(ids)).\ >>

Re: [sqlalchemy] OperationalError with SQLite with simple update query

2016-03-19 Thread Mike Bayer
On 03/16/2016 11:23 AM, Piotr Dobrogost wrote: so TextValue and Node should be implicitly joined according to rules for joined table polymorphism in SA. this is not supported - please read the caveats at

[sqlalchemy] OperationalError with SQLite with simple update query

2016-03-19 Thread Piotr Dobrogost
Hi! When executing below code DBSession.query(TextValue).\ filter(Node.id.in_(ids)).\ update({TextValue.value: appstruct['text_value']}, synchronize_session=False) I get this error: OperationalError: (sqlite3.OperationalError) near "FROM": syntax error

Re: [sqlalchemy] OperationalError with SQLite with simple update query

2016-03-19 Thread Simon King
On Wed, Mar 16, 2016 at 3:23 PM, Piotr Dobrogost < p...@2016.groups.google.dobrogost.net> wrote: > On Wednesday, March 16, 2016 at 3:51:16 PM UTC+1, Simon King wrote: >> >> On Wed, Mar 16, 2016 at 1:43 PM, Piotr Dobrogost < >> p...@2016.groups.google.dobrogost.net> wrote: >> >>> Hi! >>> >>> When