How to do exclude query by python sqlalchemy

The

database is mysql, checked the document and found no exclude, only an except_.
if my table is called table_a, and has a status field, if it is a single field, you can use! = to exclude,
what should I say if it is a scope? For example, if you have a field date, to query all records that are not in a certain time range, you can do this

in the time range.


from datetime import datetime
table_a.query.filter(table_a.date.between(datetime.now()-datetime.timedelta(hours=2), now)))

the above code queries the data from the current time to 2 hours ago. How do I write if I want to query all the data outside this range?
under the guidance of the bosses.

Python sqlalchemy

Mar.15,2021

use NOT BETWEEN . Please refer to SQL syntax, https://www.w3schools.com/sql.

MyModel.query.filter(sqlalchemy.not_(Mymodel.name.between(1, 100)))

-sharp  SYMMETRIC  a > b  a < b
MyModel.query.filter(sqlalchemy.not_(Mymodel.name.between(a, b, symmetric=True)))

all right, thank you

sql to sqlachemy project , you deserve to see

Previous: Mini Program's Text component cannot wrap

Next: Is the _ _ init__ method necessary to call in Python?

Case insensitivity of like query in MySQL5.7
for example, I like % R% answer, the query results include not only R, but also r, which is not what I want, I want to be case-sensitive. I guess it has something to do with the proofreading rules of the table. My table uses utf8mb4 encoding, and the pr...

Mysql mysql-character-set python sqlalchemy

Mar.11,2021
Sqlalchemy query data, sort according to the data in the field (Chinese) to Pinyin (ascending order)
1.sqlalchemy query data, sort according to the data in the field (Chinese) to Pinyin (ascending order) 2. It is known that there are func.convert and sql.func.CONVERT methods in sqlalchemy, and the import method is . from sqlalchemy import func from sq...

Sort-positive-order-reverse-order Hanyu-Pinyin Chinese python sqlalchemy

Mar.24,2021
Should the inner join query be done directly from the database or should it be queried in two stages?
here s the problem. For a detailed description, please see below. how should inner join be used compared with separate queries? should inner join be used or should it be considered on a case-by-case basis? when I have the above doubts, is there an...

Python sqlalchemy sql

Oct.16,2021
How does sqlachemy do the following fuzzy query?
A field in the database table is an interval field in json format, such as [100,200]. How to query the data in the table field interval according to the specified number such as 167? table.query.filter. First find a solution ...

Python sqlalchemy

Jul.15,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c25d5a-47d32.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1c25d5a-47d32.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?