myems /
myems-api
| @@ 79-96 (lines=18) @@ | ||
| 76 | rows_meters = cursor.fetchall() |
|
| 77 | ||
| 78 | result = list() |
|
| 79 | if rows_meters is not None and len(rows_meters) > 0: |
|
| 80 | for row in rows_meters: |
|
| 81 | energy_category = energy_category_dict.get(row['energy_category_id'], None) |
|
| 82 | cost_center = cost_center_dict.get(row['cost_center_id'], None) |
|
| 83 | energy_item = energy_item_dict.get(row['energy_item_id'], None) |
|
| 84 | master_meter = master_meter_dict.get(row['master_meter_id'], None) |
|
| 85 | meta_result = {"id": row['id'], |
|
| 86 | "name": row['name'], |
|
| 87 | "uuid": row['uuid'], |
|
| 88 | "energy_category": energy_category, |
|
| 89 | "is_counted": True if row['is_counted'] else False, |
|
| 90 | "hourly_low_limit": row['hourly_low_limit'], |
|
| 91 | "hourly_high_limit": row['hourly_high_limit'], |
|
| 92 | "cost_center": cost_center, |
|
| 93 | "energy_item": energy_item, |
|
| 94 | "master_meter": master_meter, |
|
| 95 | "description": row['description']} |
|
| 96 | result.append(meta_result) |
|
| 97 | ||
| 98 | cursor.close() |
|
| 99 | cnx.disconnect() |
|
| @@ 820-836 (lines=17) @@ | ||
| 817 | rows_meters = cursor.fetchall() |
|
| 818 | ||
| 819 | result = list() |
|
| 820 | if rows_meters is not None and len(rows_meters) > 0: |
|
| 821 | for row in rows_meters: |
|
| 822 | energy_category = energy_category_dict.get(row['energy_category_id'], None) |
|
| 823 | cost_center = cost_center_dict.get(row['cost_center_id'], None) |
|
| 824 | energy_item = energy_item_dict.get(row['energy_item_id'], None) |
|
| 825 | meta_result = {"id": row['id'], |
|
| 826 | "name": row['name'], |
|
| 827 | "uuid": row['uuid'], |
|
| 828 | "energy_category": energy_category, |
|
| 829 | "is_counted": True if row['is_counted'] else False, |
|
| 830 | "hourly_low_limit": row['hourly_low_limit'], |
|
| 831 | "hourly_high_limit": row['hourly_high_limit'], |
|
| 832 | "cost_center": cost_center, |
|
| 833 | "energy_item": energy_item, |
|
| 834 | "master_meter": master_meter, |
|
| 835 | "description": row['description']} |
|
| 836 | result.append(meta_result) |
|
| 837 | ||
| 838 | cursor.close() |
|
| 839 | cnx.disconnect() |
|
| @@ 67-82 (lines=16) @@ | ||
| 64 | rows_meters = cursor.fetchall() |
|
| 65 | ||
| 66 | result = list() |
|
| 67 | if rows_meters is not None and len(rows_meters) > 0: |
|
| 68 | for row in rows_meters: |
|
| 69 | energy_category = energy_category_dict.get(row['energy_category_id'], None) |
|
| 70 | energy_item = energy_item_dict.get(row['energy_item_id'], None) |
|
| 71 | cost_center = cost_center_dict.get(row['cost_center_id'], None) |
|
| 72 | meta_result = {"id": row['id'], |
|
| 73 | "name": row['name'], |
|
| 74 | "uuid": row['uuid'], |
|
| 75 | "energy_category": energy_category, |
|
| 76 | "is_counted": True if row['is_counted'] else False, |
|
| 77 | "hourly_low_limit": row['hourly_low_limit'], |
|
| 78 | "hourly_high_limit": row['hourly_high_limit'], |
|
| 79 | "energy_item": energy_item, |
|
| 80 | "cost_center": cost_center, |
|
| 81 | "description": row['description']} |
|
| 82 | result.append(meta_result) |
|
| 83 | ||
| 84 | cursor.close() |
|
| 85 | cnx.disconnect() |
|
