from PIL import ImageFont from PIL import Image from PIL import ImageDraw from datamanager import DataManager from graphics import Graphics from due import DueDate db = DataManager() db.create_tables("base_data.sql") data_list = db.run_query("due.sql") new_list = DueDate.time_converter(data_list) return_list = DueDate.make_dict(new_list) Graphics.setup(mode="RGB", size=(1024, 1024), color=(255, 255, 255)) Graphics.make_image(return_list, "due.png")
from PIL import ImageFont from datamanager import DataManager from graphics import Graphics from due import DueDate import psycopg2 import getpass import os from operator import add import random manager = DataManager() manager.create_tables("base_data.sql") clients = manager.run_query("all-client-at-once.sql") clients_colors = manager.run_query("all-client-at-once-color.sql") """Generate picture of all clients""" def hex_to_rgb(clients, clients_colors): clients_rgb = sorted([list(tup) for tup in clients_colors], key=lambda tup: tup[0]) for element in clients_rgb: if element[1] is not None: element[1] = element[1].lstrip("#") element[1] = [int(v, 16) * 17 for v in (char for char in element[1])] else: element[1] = [255, 255, 255] # print(clients_rgb) return clients_rgb