|
|
|
## 1.MYSQL 数据管理概述
|
|
|
|
1. 通过sql语句获取第三方数据库数据
|
|
|
|
2. 对提取的数据进行转换处理
|
|
|
|
## 2.部署
|
|
|
|
1.在sites/default/settings.php里配置相关数据库连接信息
|
|
|
|
|
|
|
|
```
|
|
|
|
$databases['自定义名称']['default'] = array (
|
|
|
|
'database' => 'datbase_name',
|
|
|
|
'username' => 'user',
|
|
|
|
'password' => 'pass',
|
|
|
|
'prefix' => '',
|
|
|
|
'host' => 'localhost',
|
|
|
|
'port' => '3306',
|
|
|
|
'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
|
|
|
|
'driver' => 'mysql',
|
|
|
|
);
|
|
|
|
```
|
|
|
|
|
|
|
|
## 3.配置
|
|
|
|
1. 进入接口管理，添加api，选择mysql
|
|
|
|
2. 配置数据
|
|
|
|
3. 支持token，[api:svc:pm.parser::getQueryData(id)]这个token可以获取到前端传入的数据id参数的值，当前用户名：[current-user:name]
|
|
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
settings:
|
|
|
|
api:
|
|
|
|
etl_config:
|
|
|
|
source:
|
|
|
|
key: default // default替换为settings.php 配置的[自定义名称] 变量
|
|
|
|
fields:
|
|
|
|
- name: name
|
|
|
|
label: name
|
|
|
|
selector: name
|
|
|
|
- name: data
|
|
|
|
label: data
|
|
|
|
selector: data
|
|
|
|
ids:
|
|
|
|
data:
|
|
|
|
type: string
|
|
|
|
sql_query: select name, data from config LIMIT 0,[api:svc:pm.parser::getQueryData(id)] // 支持token，这个token可以获取到前端传入的数据id参数的值
|
|
|
|
plugin: mysql
|
|
|
|
api_id: '16'
|
|
|
|
process:
|
|
|
|
name:
|
|
|
|
- plugin: get
|
|
|
|
source: name
|
|
|
|
mydata:
|
|
|
|
- plugin: get
|
|
|
|
source: data
|
|
|
|
destination:
|
|
|
|
plugin: api_response_data
|
|
|
|
id: api_id_16
|
|
|
|
label: mysql连接示例
|
|
|
|
migration_group: API
|
|
|
|
id: '16'
|
|
|
|
type: mysql
|
|
|
|
status: 1
|
|
|
|
title: mysql连接示例
|
|
|
|
url_alias: "/mysql/demo"
|
|
|
|
access_roles:
|
|
|
|
- authenticated
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
