source:
people/peter.buschman/backup_monitoring/dal/builtins/lookup_table.py@
976
Last change on this file since 976 was 976, checked in by , on Dec 6, 2011 at 10:19:33 AM | |
---|---|
File size: 318 bytes |
Line | |
---|---|
1 | ## |
2 | ## lookup_table - convert first two columns of an SQL query to a lookup table |
3 | ## |
4 | def lookup_table(curs, query): |
5 | |
6 | lookup = ExtendedDict() |
7 | |
8 | curs.execute(query) |
9 | |
10 | for row in curs.fetchall(): |
11 | |
12 | key = row[0] |
13 | value = row[1] |
14 | |
15 | lookup[key] = value |
16 | |
17 | return lookup |
Note:
See TracBrowser
for help on using the repository browser.