source:
people/peter.buschman/backup_monitoring/dal/builtins/lookup_table.py@
1273
| Last change on this file since 1273 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.
