sim3x

with open('f.json') as f:
    d = json.loads(f.read())
    l = []
    # l = [y for x in d['items'] for y in x.values()]
    for x in d['items']:
        l += x.values()

random.choice(l)

res = requests.get(url)
doc = lxml.html.parse(res.content)

# python2
# from StringIO import StringIO

from io import StringIO

if res.status_code == 200:
    p = QtGui.QPixmap()
    p.loadFromData(StringIO(res.content))
    img1.setPixmap(p)

sql = "INSERT INTO groups(group_id, group_name, short_link) VALUES (%s, %s, %s)" , (gid, name, screen_name)
print(type(sql))

sql = "INSERT INTO groups(group_id, group_name, short_link) VALUES (%s, %s, %s)" % (gid, name, screen_name)
print(type(sql))

sql = "INSERT INTO groups(group_id, group_name, short_link) VALUES (%s, %s, %s)" 

cursor.execute(sql, (gid, name, screen_name))

sql_prepared_text = "INSERT INTO groups(group_id, group_name, short_link) VALUES (%s, %s, %s)",  (gid, name, screen_name)

cursor.execute(*sql_prepared_text)

try:
    pass
except Exception as e:
    print(e)