from sqlalchemy import func
from datetime import date
my_data = session.query(MyObject).filter(
func.date(MyObject.date_time) == date.today()
).all()
Example 2: sqlalchemy filter between dates
qry = DBSession.query(User).filter(
and_(User.birthday <= ‘1988-01-17’, User.birthday >= ‘1985-01-17’))
#or same:
qry = DBSession.query(User).filter(User.birthday <= ‘1988-01-17’).
filter(User.birthday >= ‘1985-01-17’)
Example 3: less than date query sqlachemy
current_time = datetime.datetime.utcnow()
ten_weeks_ago = current_time - datetime.timedelta(weeks=10)
subjects_within_the_last_ten_weeks = session.query(Subject).filter(
Subject.time > ten_weeks_ago).all()
from sqlalchemy import distinct, update
from sqlmodel import select, Session
from database.pgdatabase import engine
from models import tenant_model, data_dict_model
from sqlalchemy import update, delete, func, or_
from datetime import date, datetime, timedelta
from typing import List, Optional
ismember_result = session.execute(select(tenant_model.Tenant, tenant_model.TenantPaymentRecord, data_dict_model.DataDictValue).where(tenant_model.Tenant.is_member==True,
tenant_model.Tenant.end_date >= datetime.now(),
tenant_model.Tenant.id == tenant_model.TenantPaymentRecord.tenant_id,
tenant_model.TenantPaymentRecord.pay_way == data_dict_model.DataDictValue.set_code)).all()
nomember_result = session.execute(select(tenant_model.Tenant, tenant_model.TenantPaymentRecord, data_dict_model.DataDictValue).where(tenant_model.Tenant.is_member==True,
tenant_model.Tenant.end_date<datetime.now(),
tenant_model.Tenant.id == tenant_model.TenantPaymentRecord.tenant_id,
tenant_model.TenantPaymentRecord.pay_way == data_dict_model.DataDictValue.set_code)).all()
