Python-сообщество

 today = date.today()
delta = today + timedelta(days=7)

 class DBContact(Base):
    __tablename__ = 'contacts'
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, nullable=False, index=True)
    surname = Column(String, nullable=False, index=True)
    email = Column(String, nullable=False, index=True)
    phone = Column(String, nullable=False, index=True)
    birthday = Column(String, nullable=False, index=True)
    text = Column(String, nullable=True, index=True)

 current_date = datetime.now().date()
target_date = current_date + timedelta(days=7)
birthdays = session.query(DBContact).filter(
    (extract('month', DBContact.birthday) == current_date.month) &
    (extract('day', DBContact.birthday) >= current_date.day) &
    (extract('day', DBContact.birthday) <= target_date.day)
).all()

 birthday = Column(String, nullable=False, index=True)

 SELECT
	id, "name", surname, email, phone, birthday, "text"
FROM
	contacts
WHERE
	numrange(
		  (SELECT EXTRACT(DOY FROM CURRENT_DATE))
		, (SELECT EXTRACT(DOY FROM CURRENT_DATE))+7
	) @> EXTRACT(DOY FROM TIMESTAMP birthday)

  
import datetime
 
def compare_dates(date1, date2):
    if date1 < date2:
        return -1
    elif date1 == date2:
        return 0
    else:
        return 1
 
def create_date(day, month):
    out = datetime.datetime(datetime.datetime.now().year, month, day)
    return out
 
current_date = datetime.datetime.now().date()
target_date = current_date + datetime.timedelta(days=7)
birthdays = session.query(DBContact).filter(
    compare_dates(
        create_date(
            extract('day', DBContact.birthday),
            extract('month', DBContact.birthday)
        ),
        target_date
    ) <= 0
).all()

  
>>> import this
The Zen of Python, by Tim Peters
Beautiful is better than ugly.
Explicit is better than implicit.
Simple is better than complex.
Complex is better than complicated.
Flat is better than nested.
Sparse is better than dense.
Readability counts.
Special cases aren't special enough to break the rules.
Although practicality beats purity.
Errors should never pass silently.
Unless explicitly silenced.
In the face of ambiguity, refuse the temptation to guess.
There should be one-- and preferably only one --obvious way to do it.
Although that way may not be obvious at first unless you're Dutch.
Now is better than never.
Although never is often better than *right* now.
If the implementation is hard to explain, it's a bad idea.
If the implementation is easy to explain, it may be a good idea.
Namespaces are one honking great idea -- let's do more of those!
>>>