python + s3 + openpyxl

2021.08.05 - [5. ----- 프로그래머] - python + s3 + openpyxl

import json
import boto3
import os
import openpyxl
import pymysql
import logging
import sys
import rds_config
import datetime
from datetime import date, timedelta
from dateutil.relativedelta import relativedelta
import pytz

from openpyxl import Workbook
from openpyxl.chart import BarChart, Reference


parameter_date = "2021-07"
start_date_tmp = parameter_date+"-01"
start_date = datetime.datetime.strptime(start_date_tmp,'%Y-%m-%d')+relativedelta(months=0)

rds_host  = "test-host"
name = rds_config.db_username
password = rds_config.db_password
db_name = rds_config.db_name
port = 3306

logger = logging.getLogger()
logger.setLevel(logging.INFO)

s3 = boto3.resource('s3')
s3_client = boto3.client('s3')

data_source_bucket = 'report'
data_source_key = "sample.xlsx"

try:
    conn = pymysql.connect(host=rds_host, user=name, passwd=password, db=db_name, connect_timeout=5,charset='utf8')
except pymysql.MySQLError as e:
    logger.error("ERROR: Unexpected error: Could not connect to MySQL instance.")
    logger.error(e)
    sys.exit()

logger.info("SUCCESS: Connection to RDS MySQL instance succeeded")