| @@ 635-645 (lines=11) @@ | ||
| 632 | cnx.disconnect() |
|
| 633 | raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', |
|
| 634 | description='API.TIMEZONE_NOT_FOUND') |
|
| 635 | if contact_id is not None: |
|
| 636 | cursor.execute(" SELECT name " |
|
| 637 | " FROM tbl_contacts " |
|
| 638 | " WHERE id = %s ", |
|
| 639 | (new_values['data']['contact_id'],)) |
|
| 640 | row = cursor.fetchone() |
|
| 641 | if row is None: |
|
| 642 | cursor.close() |
|
| 643 | cnx.disconnect() |
|
| 644 | raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', |
|
| 645 | description='API.CONTACT_NOT_FOUND') |
|
| 646 | ||
| 647 | if cost_center_id is not None: |
|
| 648 | cursor.execute(" SELECT name " |
|
| @@ 211-221 (lines=11) @@ | ||
| 208 | cnx.disconnect() |
|
| 209 | raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', |
|
| 210 | description='API.TIMEZONE_NOT_FOUND') |
|
| 211 | if contact_id is not None: |
|
| 212 | cursor.execute(" SELECT name " |
|
| 213 | " FROM tbl_contacts " |
|
| 214 | " WHERE id = %s ", |
|
| 215 | (new_values['data']['contact_id'],)) |
|
| 216 | row = cursor.fetchone() |
|
| 217 | if row is None: |
|
| 218 | cursor.close() |
|
| 219 | cnx.disconnect() |
|
| 220 | raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', |
|
| 221 | description='API.CONTACT_NOT_FOUND') |
|
| 222 | ||
| 223 | if cost_center_id is not None: |
|
| 224 | cursor.execute(" SELECT name " |
|
| @@ 471-481 (lines=11) @@ | ||
| 468 | raise falcon.HTTPError(falcon.HTTP_404, title='API.BAD_REQUEST', |
|
| 469 | description='API.SHOPFLOOR_NAME_IS_ALREADY_IN_USE') |
|
| 470 | ||
| 471 | if contact_id is not None: |
|
| 472 | cursor.execute(" SELECT name " |
|
| 473 | " FROM tbl_contacts " |
|
| 474 | " WHERE id = %s ", |
|
| 475 | (new_values['data']['contact_id'],)) |
|
| 476 | row = cursor.fetchone() |
|
| 477 | if row is None: |
|
| 478 | cursor.close() |
|
| 479 | cnx.disconnect() |
|
| 480 | raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', |
|
| 481 | description='API.CONTACT_NOT_FOUND') |
|
| 482 | ||
| 483 | if cost_center_id is not None: |
|
| 484 | cursor.execute(" SELECT name " |
|
| @@ 150-160 (lines=11) @@ | ||
| 147 | raise falcon.HTTPError(falcon.HTTP_404, title='API.BAD_REQUEST', |
|
| 148 | description='API.SHOPFLOOR_NAME_IS_ALREADY_IN_USE') |
|
| 149 | ||
| 150 | if contact_id is not None: |
|
| 151 | cursor.execute(" SELECT name " |
|
| 152 | " FROM tbl_contacts " |
|
| 153 | " WHERE id = %s ", |
|
| 154 | (new_values['data']['contact_id'],)) |
|
| 155 | row = cursor.fetchone() |
|
| 156 | if row is None: |
|
| 157 | cursor.close() |
|
| 158 | cnx.disconnect() |
|
| 159 | raise falcon.HTTPError(falcon.HTTP_404, title='API.NOT_FOUND', |
|
| 160 | description='API.CONTACT_NOT_FOUND') |
|
| 161 | ||
| 162 | if cost_center_id is not None: |
|
| 163 | cursor.execute(" SELECT name " |
|