删除 Args: sql: Returns: 影响行数
(self, sql)
| 354 | return self.update(sql) |
| 355 | |
| 356 | def delete(self, sql) -> int: |
| 357 | """ |
| 358 | 删除 |
| 359 | Args: |
| 360 | sql: |
| 361 | |
| 362 | Returns: 影响行数 |
| 363 | |
| 364 | """ |
| 365 | affect_count = None |
| 366 | conn, cursor = None, None |
| 367 | try: |
| 368 | conn, cursor = self.get_connection() |
| 369 | affect_count = cursor.execute(sql) |
| 370 | conn.commit() |
| 371 | except Exception as e: |
| 372 | log.error( |
| 373 | """ |
| 374 | error:%s |
| 375 | sql: %s |
| 376 | """ |
| 377 | % (e, sql) |
| 378 | ) |
| 379 | finally: |
| 380 | self.close_connection(conn, cursor) |
| 381 | |
| 382 | return affect_count |
| 383 | |
| 384 | def execute(self, sql) -> int: |
| 385 | """ |