dictionaries

[brecht83]

Hello everybody,

I read data from an MySQL server and it gives me the info as a list dictionaries:

db_ewon =  con.cursor(dictionary=True)
db_ewon.execute("SELECT Name,Id FROM esync_stations")
df_ewon = db_ewon.fetchall()

for x in df_ewon[0:5]:
    print (x)

The result:

{'Name': 'Station1', 'Id':1}
{'Name': 'Station2', 'Id':5}
{'Name': 'Station3', 'Id':3}
{'Name': 'Station4', 'Id':9}
{'Name': 'Station5', 'Id':2}

I want to put all this data in 1 dictionary with the heads: 'Name' and 'Id'
The dictionary looks like this:

new_dict={
    'Station1':1,
    'Station2':5,
    'Station3':3,
    'Station4':9,
    'Station5':2,
}

Can somebody help me please