from sqlalchemy import create_engine
from sqlalchemy.engine.url import URL
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import docker
import time
from conf import Conf
conf = Conf()
DOCKER_NAME = conf.ConfigSectionMap("docker")["database"]
DATABASE_DRIVER = conf.ConfigSectionMap("database")["driver"]
DATABASE_USERNAME = conf.ConfigSectionMap("database")["username"]
DATABASE_PASSWORD = conf.ConfigSectionMap("database")["password"]
DATABASE_HOST = conf.ConfigSectionMap("database")["host"]
DATABASE_PORT = conf.ConfigSectionMap("database")["port"]
DATABASE_DATABASE = conf.ConfigSectionMap("database")["database"]
# start docker-container using (docker-py)
client = docker.from_env()
client.containers.get(DOCKER_NAME).start()
# sleep as container starts up
time.sleep(0.5)
url = URL(DATABASE_DRIVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_HOST,
DATABASE_PORT, DATABASE_DATABASE)
engine = create_engine(url)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
#!/usr/bin/python
import smtplib
from conf import Conf
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
import datetime
import content
conf = Conf()
SERVER = conf.ConfigSectionMap("mail")["server"]
PORT = conf.ConfigSectionMap("mail")["port"]
SENDER = conf.ConfigSectionMap("mail")["sender"]
PASSWORD = conf.ConfigSectionMap("mail")["password"]
RECIPIENT = conf.ConfigSectionMap("mail")["recipient"]
# TODO add logging to file
# setup
server = smtplib.SMTP(SERVER, PORT)
server.connect(SERVER, PORT)
server.starttls()
server.login(SENDER, PASSWORD)
# message
msg = MIMEMultipart('alternative')
# TODO maybe use %B for full month-name?
msg['Subject'] = "Reminder for " + datetime.date.today().strftime("%b %d, %Y")
msg['From'] = SENDER
msg['To'] = RECIPIENT
