数据库状态检测
(self, get)
| 465 | |
| 466 | # 数据库状态检测 |
| 467 | def CheckDatabaseStatus(self, get): |
| 468 | """ |
| 469 | 数据库状态检测 |
| 470 | """ |
| 471 | if not hasattr(get, "sid"): |
| 472 | return public.returnMsg(False, "缺少参数！sid") |
| 473 | if not str(get.sid).isdigit(): |
| 474 | return public.returnMsg(False, "参数错误！sid") |
| 475 | sid = int(get.sid) |
| 476 | if sid != 0: |
| 477 | conn_config = public.M("database_servers").where("id=? AND LOWER(db_type)=LOWER('sqlserver')", (sid,)).find() |
| 478 | if not conn_config: |
| 479 | return public.returnMsg(False, "远程数据库信息不存在！") |
| 480 | conn_config["db_name"] = None |
| 481 | sql_server_obj = panelMssql.panelMssql().set_host(conn_config['db_host'], conn_config['db_port'], conn_config.get("db_name"), conn_config['db_user'], conn_config['db_password']) |
| 482 | else: |
| 483 | sql_server_obj = panelMssql.panelMssql() |
| 484 | data = sql_server_obj.query("SELECT name FROM MASTER.DBO.SYSDATABASES ORDER BY name") |
| 485 | db_status = not isinstance(data, bool) |
| 486 | return {"status": True, "msg": "正常" if db_status is True else "异常", "db_status": db_status} |
| 487 | |
| 488 | def check_cloud_database_status(self, conn_config): |
| 489 | """ |