Das deutsche Python-Forum

Code: Alles auswählen

In [7]: import sqlite3

In [8]: con = sqlite3.connect(":memory:")

In [9]: cursor = con.cursor()

In [10]: cursor.execute("""
   ....: create table score (
   ....: name text,
   ....: points integer,
   ....: primary key(name)
   ....: )
   ....: """)
Out[10]: <sqlite3.Cursor object at 0x01092160>

In [11]: cursor.executemany("insert into score values (?, ?)",
   ....: [("chris", 120), ("alfi hartkor", 142), ("foobar", 50)])
Out[11]: <sqlite3.Cursor object at 0x01092160>

In [12]: res = cursor.execute("select name, points from score order by points")

In [13]: for index, row in enumerate(res):
   ....:     print index, row
   ....:
   ....:
0 (u'foobar', 50)
1 (u'chris', 120)
2 (u'alfi hartkor', 142)

Code: Alles auswählen

db = MySQLdb.connect("localhost","XXXX","XXXX","XXXX")
cursor = db.cursor()

cursor.execute('SELECT playername FROM players ORDER BY score DESC')
result = cursor.fetchall()

cursor.close()
db.close()

for index, row in enumerate(result):
	if row[0] == such_player:
		player_rang = index

Code: Alles auswählen

In [76]: from itertools import ifilter, izip, count

In [77]: from operator import itemgetter

In [78]: row = itemgetter(1)

In [79]: key = itemgetter(0)

In [80]: res = cursor.execute("select name, points from score order by points desc")

In [86]: index, player = ifilter(lambda data: key(row(data)) == "foobar" , izip(count(1), res)).next()

In [87]: index, player
Out[87]: (3, (u'foobar', 50))