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
