查询sqlite3数据库 Query sqlite3 database sql: 查询数据库的sql语句 return: 查询的列表数据数据或者False sql: sql statement for querying the database return: Query list data data or False
(self,sql)
| 74 | return False |
| 75 | |
| 76 | def select_sqlite3(self,sql) -> list: |
| 77 | """ |
| 78 | 查询sqlite3数据库 |
| 79 | Query sqlite3 database |
| 80 | |
| 81 | sql: 查询数据库的sql语句 |
| 82 | return: 查询的列表数据数据或者False |
| 83 | |
| 84 | sql: sql statement for querying the database |
| 85 | return: Query list data data or False |
| 86 | """ |
| 87 | try: |
| 88 | cur = self.cursor.execute(sql) |
| 89 | data = cur.fetchall() |
| 90 | data = self.dict_factory(cur, data) |
| 91 | return data |
| 92 | except Exception as e: |
| 93 | WriteReadFile.Custom_Write_logger(self,"",f"{os.getcwd()}/AiBotRunLOG/{time.strftime(r'%Y-%m-%d',time.localtime(time.time()))}/","SysModeError.log",False,"error",f"{traceback.format_exc()}") |
| 94 | return False |
| 95 | |
| 96 | def close_sqlite3(self) -> bool: |
| 97 | """ |
nothing calls this directly
no test coverage detected