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

import sqlite3
holidays = [["2018-01-01", "Universal Confraternization"], ["2018-04-21", "Tiradentes"], ["2018-05-01", "Labor Day"], ["2018-09-07", "Independence"], ["2018-10-12", "Patron Saint of Brazil"], ["2018-11-02", "All Souls"], ["2018-11-15", "Proclamation of the Republic"],["2018-12-25", "Christmas"]]
with sqlite3.connect("brazil.db") as connection:
    connection.execute("create table holidays(id integer primary key autoincrement, date_h date, description text)")
    connection.executemany("insert into holidays(date_h, description) values (?,?)", holidays)