
#!/usr/bin/env python
# coding: utf-8
"""
 This program generates ics file for the Japanese Holidays 
 based on the information from Japanese goverment web page.
"""
import urllib.request
from urllib.request import urlopen
# macosではSSL証明書を正しくつかえるように以下の文が必要
import os, certifi
os.environ["SSL_CERT_FILE"]=certifi.where()

import io
from io import StringIO, BytesIO

import pandas

import sqlite3

import icalendar, pytz, datetime, uuid
from icalendar import vBoolean, vCalAddress, vDate, vDatetime,vDuration,vFloat, vFrequency, vInt, vPeriod, vText, vTime, vUri, vUTCOffset, vWeekday

JST = pytz.timezone("Asia/Tokyo")

# note: this csv uses shift-jis encoding.
JHuri="https://www8.cao.go.jp/chosei/shukujitsu/syukujitsu.csv"
# a list of codecs supported by python can be found in https://docs.python.org/ja/3/library/codecs.html


def load_and_save_cvs(cvsuri):
    fn=cvsuri.split("/")[-1]
    with urlopen(cvsuri) as inf , open(fn,"wb") as outf:
        print ("downloading :", fn)
        data=inf.read()
        outf.write(data)

def load_as_dataframe(cvsuri):
    fn=cvsuri.split("/")[-1]
    with urlopen(cvsuri) as inf:
        print ("downloading :", fn)
        data=inf.read().decode("shift_jis") #file encoding in this csv file is shift JIS.
        sio=io.StringIO(data) # store data in to StringIO object. 
        # interprete string in '国民の祝日・休日月日'(the first)  column as datetime. 
        df=pandas.read_csv(sio, # use StringIO object as if it is a open file object.
                           parse_dates=['国民の祝日・休日月日'], # column 0 shoud be read as date
                           infer_datetime_format=True
                          )
        #  df=pandas.read_csv(sio, parse_dates=[0], infer_datetime_format=True)
    print(df.info())
    return df

def load_as_db(cvsuri):
    """
    download csv file then convert to sqlite3 database on memory.
    """
    df=load_as_dataframe(cvsuri) # create dataframe
    db=sqlite3.connect(":memory:") # create sqlite3 database on memory.
    df.to_sql('holidays', db) # write all data to database.
    
    return db


class Calendar(icalendar.Calendar):
    """
    """
    # notify tis event 15 min before event
    alarm_setting=icalendar.Alarm().from_ical(
        "BEGIN:VALARM\n"
        "ACTION:DISPLAY\n"
        "TRIGGER;VALUE=DURATION:-PT15M\n"
        "DESCRIPTION:Default Mozilla Description\n"
        "END:VALARM"
    )
    def __init__(self):
        """
        """
        super(icalendar.Calendar,self).__init__()
        self.add(u"prodid","-//Japanese Holidays/based on Python.iCalendar//")
        self.add(u"Version",2.0)
        self.add(u"Category","Japanese Public Holidays")
        self.add(u"Summary","Official Japanese Public Holidays ")
        self.add_component(self.alarm_setting)
        #self.add_component(icalendar.Timezone.from_ical(
        #    "BEGIN:VTIMEZONE\n"
        #    "TZID:/mozilla.org/20070129_1/Asia/Tokyo\n"
        #    "X-LIC-LOCATION:Asia/Tokyo\n"
        #    "BEGIN:STANDARD\n"
        #    "TZOFFSETFROM:+0900\n"
        #    "TZOFFSETTO:+0900\n"
        #    "TZNAME:JST\n"
        #    "DTSTART:19700101T000000\n"
        #    "END:STANDARD\n"
        #    "END:VTIMEZONE\n")
        #)

    def add_holiday(self, date, name):
        ev=icalendar.Event()
        ev['uid']=uuid.uuid4()
        ev["categories"]=vText("Japanese Public Holidays")
        ev.add(
            'dtstart', 
            vDate(
                datetime.datetime.fromtimestamp(
                   date.timestamp(), 
                 tz=JST)
            ),
            encode=False
        )
        ev.add(
            'dtend', 
            vDate(
                datetime.datetime.fromtimestamp(
                (date + datetime.timedelta(days=1)).timestamp(),
                tz=JST)
            ),
            encode=False
        )
        ev.add(
            'summary', 
            name
        )
        ev.add(
            'description', 
            vText(name, 'utf-8')
        )
        self.add_component(ev)


def main():
    # web上のデータからDataFrameを作成。
    df=load_as_dataframe(JHuri)
    
    cal=Calendar() # Calendar オブジェクトを作成し、DataFrameの休日データを登録
    for id, date, name in df.itertuples():
            cal.add_holiday(date, name)
    #.icsファイルを作成し、データをiCalendar形式で書き出します。
    with open(
            "JapaneseHolidays.ics", 
            mode="w", 
            encoding="utf-8" # for py2app. you need explicitly specify encoding.
    ) as f:
        s=cal.to_ical() # icalendar 形式に変換。
        s=s.decode("utf-8", "replace") # unicodeに変換
        f.write(s) #ファイルに書き出す。


if __name__ == "__main__":
    main()
    print("Done!")

downloading : syukujitsu.csv
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 975 entries, 0 to 974
Data columns (total 2 columns):
 #   Column      Non-Null Count  Dtype         
---  ------      --------------  -----         
 0   国民の祝日・休日月日  975 non-null    datetime64[ns]
 1   国民の祝日・休日名称  975 non-null    object        
dtypes: datetime64[ns](1), object(1)
memory usage: 15.4+ KB
None
Done!

日本の休日¶

利用するモジュール¶

データのダウンロード¶

Calendar オブジェクト¶

プログラムの本体¶

プログラムの実行¶