from datamanager import DataManager from graphics import Graphics from PIL import ImageFont manager = DataManager() manager.run_query('10-biggest-eur-projects-company.sql') def text_size(): x = 0 y = 0 result = [] font_size = 160 for row in enumerate(manager.run_query('10-biggest-eur-projects-company.sql')): print(row) if row[0] % 2 == 1: x = 500 else: x = 0 if row[0] != 0: y += 100 font_size -= 10 text_options = { 'xy': (x, y), 'fill': text_color(row[1][1]), 'font': ImageFont.truetype("SourceSansPro-Regular.otf", font_size), 'text': row[1][0] } print(text_options) result.append(text_options)
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