On Wed, Mar 16, 2016 at 1:43 PM, Piotr Dobrogost <
[email protected]> wrote:
> 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
> [SQL: u'UPDATE text_values SET value=? FROM nodes WHERE nodes.id IN (?,
> ?, ?, ?)'] [parameters: (u'zzz', u'1685', u'175', u'1688', u'180')]
>
> Does SA construct query which is not valid in SQLite?
> How can I solve this problem?
>
> Regards,
> Piotr Dobrogost
>
>
I'm not sure if sqlite supports multi-table updates. Do you know what sort
of SQL you are expecting to generate here?
(Note that your query appears at least to be missing a join condition
between the TextValue and Node classes)
Simon
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
