/** * 获得统计的数据库类型列表 * @return type */ public static function findDatabase() { $databaseLists = DatabaseType::find()->select(['id', 'database_en'])->indexBy('id')->asArray()->all(); $fiArray = []; if ($databaseLists) { foreach ($databaseLists as $key => $value) { $fitArray[$key] = $value['database_en']; } } return $fitArray; }
/** * 查询某个数据库的统计 * @return type */ public function actionDatabase() { $gets = \Yii::$app->request->get(); #获得选择的数据库 if (isset($gets['type'])) { $selectDatabase = \common\models\DatabaseType::findOne($gets['type']); if ($selectDatabase) { return $this->render('database'); } } return $this->redirect('/sql/sqlgraph.html'); }
/** * 处理数据库是否正确 */ public function testDabaseEn() { #判断是否已经存在该库 $countone = DatabaseType::find()->where("database_en=:baseen", [':baseen' => $this->database_en])->count(); if ($countone > 0) { $this->addError('database_en', '当前库已经存在!'); } $countone = SqlTrace::find()->where("databasetype=:baseen", [':baseen' => $this->database_en])->count(); if ($countone == 0) { $this->addError('database_en', '找不到英文标识的日志记录!'); } }