async def get_available_colours():
conn = await aiomysql.connect(host='127.0.0.1', port=3306,
user='root', password='04062022', db='calathea')
cur = await conn.cursor()
sql = '''
SELECT DISTINCT colour_name
FROM colour_palette INNER JOIN colour
ON colour_palette.colour_id = colour.colour_id
'''
await cur.execute(sql)
r = await cur.fetchall()
print(r)
print(type(r))
await cur.close()
conn.close()
return r