myems /
myems-api
| @@ 84-94 (lines=11) @@ | ||
| 81 | cnx.disconnect() |
|
| 82 | ||
| 83 | result = list() |
|
| 84 | if rows is not None and len(rows) > 0: |
|
| 85 | for row in rows: |
|
| 86 | meta_result = {"id": row[0], |
|
| 87 | "user_id": row[1], |
|
| 88 | "user_display_name": user_dict.get(row[1], None), |
|
| 89 | "subject": row[2], |
|
| 90 | "message": row[3].replace("<br>", ""), |
|
| 91 | "created_datetime": row[4].timestamp() * 1000 if isinstance(row[4], datetime) else None, |
|
| 92 | "status": row[5], |
|
| 93 | "reply": row[6]} |
|
| 94 | result.append(meta_result) |
|
| 95 | ||
| 96 | resp.body = json.dumps(result) |
|
| 97 | ||
| @@ 148-157 (lines=10) @@ | ||
| 145 | cnx.disconnect() |
|
| 146 | ||
| 147 | result = list() |
|
| 148 | if rows is not None and len(rows) > 0: |
|
| 149 | for row in rows: |
|
| 150 | meta_result = {"id": row[0], |
|
| 151 | "user_id": row[1], |
|
| 152 | "user_display_name": user_dict.get(row[1], None), |
|
| 153 | "subject": row[2], |
|
| 154 | "message": row[3].replace("<br>", ""), |
|
| 155 | "created_datetime": row[4].timestamp() * 1000 if isinstance(row[4], datetime) else None, |
|
| 156 | "status": row[5]} |
|
| 157 | result.append(meta_result) |
|
| 158 | ||
| 159 | resp.body = json.dumps(result) |
|
| 160 | ||
