With the ORM, you'd filter, something like this: .filter(LessonEntity.lesson_id == lesson_id, LessionEntity.device_type_id == device_type_id)
If you were just expecting to find one, you might want to chain .first() onto the end of that. You can delete as normal: session.delete(obj) If you want to delete without checking whether they exist first and avoid shuttling data back and forth from the database to the application, you can use the expression language to issue a DELETE command limited by a WHERE clause. https://docs.sqlalchemy.org/en/13/core/tutorial.html Kind regards, Mike On Tue, 4 Aug 2020 at 10:32, Adam Shock <tanjilhussai...@gmail.com> wrote: > My SQL database has the following: > > > > to query the lesson_id i would do : > lesson = LessonEntity.query.get(lesson_id) > > How can i query the database to check if lesson_id exists on the same > entry as device type and then remove.. > > so for example. if lesson_id matches 107 and the same entry includes > device_type_id = 7 i want to remove this whole entry > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > 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 sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/85301330-9208-4f8e-b1d4-e89ea8942239o%40googlegroups.com > <https://groups.google.com/d/msgid/sqlalchemy/85301330-9208-4f8e-b1d4-e89ea8942239o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Michael Mulqueen *Method B Ltd* m...@method-b.uk / +44 (0)330 223 0864 http://www.method-b.uk/ Method B Limited is registered in England and Wales with the company number 9189496. Registered office: 28-29 Richmond Place, Brighton, East Sussex, England, BN2 9NA -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAHxMHYVRk9bSD31Ut6ppQttPr-A1OQ5E8moW6JbdO_uSN-SV7Q%40mail.gmail.com.
