##############################################################################
# Python From Scratch
# Autor: Nilo Ney Coutinho Menezes
# Editora Novatec (c) 2010-2024
# Site: https://pythonfromscratch.com
#
# File: listing\chapter 11\11.1508 - No Title.py
# Description: No Title
##############################################################################

import sqlite3
import datetime
today = datetime.date.today()
today60days = today + datetime.timedelta(days=60)
with sqlite3.connect("brazil.db", detect_types=sqlite3.PARSE_DECLTYPES) as connection:
    connection.row_factory = sqlite3.Row
    for holiday in connection.execute("select * from holidays where date_h >=? anddate_h <= ?", (today, today60days)):
        print(f"{holiday['date_h']:%d/%m} {holiday['description']}")