コード例 #1
0
 def get_project_colors(cls):
     cursor = Database.find_db()
     # returns project colors by companies
     cursor.execute("SELECT main_color FROM project WHERE name IS NOT NULL ORDER BY name;")
     project_colors = []
     for i in cursor.fetchall():
         project_colors.append(list(i))
     for i, j in enumerate(project_colors):
         project_colors[i][0] = Database.hex_to_rgb(j[0])
     return project_colors
コード例 #2
0
 def get_project_colors(cls):
     cursor = Database.find_db()
     # returns project colors by companies
     cursor.execute("SELECT company_name, main_color FROM project ORDER BY company_name;")
     colors = cursor.fetchall()
     client_colors = []
     for i in colors:
         client_colors.append(list(i))
     for i, j in enumerate(client_colors):
         client_colors[i][1] = Database.hex_to_rgb(j[1])
     return client_colors