MyEMS /
myems
| @@ 117-133 (lines=17) @@ | ||
| 114 | rows_spaces = cursor.fetchall() |
|
| 115 | ||
| 116 | result = list() |
|
| 117 | if rows_spaces is not None and len(rows_spaces) > 0: |
|
| 118 | for row in rows_spaces: |
|
| 119 | ||
| 120 | meta_result = {"id": row[0], |
|
| 121 | "name": row[1], |
|
| 122 | "uuid": row[2], |
|
| 123 | "address": row[3], |
|
| 124 | "latitude": row[4], |
|
| 125 | "longitude": row[5], |
|
| 126 | "area": row[6], |
|
| 127 | "store_type": store_type_dict.get(row[7], None), |
|
| 128 | "is_input_counted": bool(row[8]), |
|
| 129 | "contact": contact_dict.get(row[9], None), |
|
| 130 | "cost_center": cost_center_dict.get(row[10], None), |
|
| 131 | "description": row[11], |
|
| 132 | "qrcode": 'store:' + row[2]} |
|
| 133 | result.append(meta_result) |
|
| 134 | ||
| 135 | cursor.close() |
|
| 136 | cnx.close() |
|
| @@ 86-101 (lines=16) @@ | ||
| 83 | rows_spaces = cursor.fetchall() |
|
| 84 | ||
| 85 | result = list() |
|
| 86 | if rows_spaces is not None and len(rows_spaces) > 0: |
|
| 87 | for row in rows_spaces: |
|
| 88 | ||
| 89 | meta_result = {"id": row[0], |
|
| 90 | "name": row[1], |
|
| 91 | "uuid": row[2], |
|
| 92 | "address": row[3], |
|
| 93 | "latitude": row[4], |
|
| 94 | "longitude": row[5], |
|
| 95 | "rated_power": row[6], |
|
| 96 | "contact": contact_dict.get(row[7], None), |
|
| 97 | "cost_center": cost_center_dict.get(row[8], None), |
|
| 98 | "svg": svg_dict.get(row[9], None), |
|
| 99 | "description": row[10], |
|
| 100 | "qrcode": 'windfarm:' + row[2]} |
|
| 101 | result.append(meta_result) |
|
| 102 | ||
| 103 | cursor.close() |
|
| 104 | cnx.close() |
|
