/**
* 获得统计的数据库类型列表
* @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', '找不到英文标识的日志记录！');
}
}
