def random_person(): c = db.cursor() c.execute("SELECT id FROM people ORDER BY id DESC LIMIT 1") mid, = c.fetchone() c.execute("SELECT name,pic_url FROM people WHERE id > %d LIMIT 1" % \ (random.randint(1,mid),)) person = c.fetchone() return person
def random_word(part='NN'): c = db.cursor() c.execute("SELECT id FROM words WHERE part='%s' ORDER BY id DESC LIMIT 1" % part) mid, = c.fetchone() c.execute("SELECT word FROM words WHERE part='%s' and id >= %d LIMIT 1" % \ (part, random.randint(1, mid))) word, = c.fetchone() return word