执行数据库的增、删、改 sql：sql语句 param：数据，可以是list或tuple，亦可是None retutn：成功返回True
(self, sql, param=None)
| 28 | self.db.close() |
| 29 | |
| 30 | def execute(self, sql, param=None): |
| 31 | """ |
| 32 | 执行数据库的增、删、改 |
| 33 | sql：sql语句 |
| 34 | param：数据，可以是list或tuple，亦可是None |
| 35 | retutn：成功返回True |
| 36 | """ |
| 37 | # print('sql=', sql, 'param=', param) |
| 38 | try: |
| 39 | if param is None: |
| 40 | self.c.execute(sql) |
| 41 | else: |
| 42 | if type(param) is list: |
| 43 | self.c.executemany(sql, param) |
| 44 | else: |
| 45 | self.c.execute(sql, param) |
| 46 | count = self.db.total_changes |
| 47 | self.db.commit() |
| 48 | except Exception as e: |
| 49 | print('Exception:', e) |
| 50 | return False |
| 51 | if count > 0: |
| 52 | return True |
| 53 | else: |
| 54 | print('删除了0行') |
| 55 | return False |
| 56 | |
| 57 | def query(self, sql, param=None): |
| 58 | """ |
no outgoing calls
no test coverage detected