数导入API 完成

rizalgowandy · Jan 18, 2022 · 28ad693 · 28ad693
1 parent c4e2ab2
commit 28ad693
Show file tree

Hide file tree

Showing 3 changed files with 20 additions and 3 deletions.
diff --git a/importer/importer.go b/importer/importer.go
@@ -222,8 +222,24 @@ func (imp *Importer) MappingPreview(src from.Source) *Mapping {
 	// tpl := imp.Fingerprint(src)
 	// 查找已有模板
 
-	// 自动匹配
-	return imp.AutoMapping(src)
+	mapping := imp.AutoMapping(src) // 自动匹配
+
+	// 预设值
+	columns, rows := imp.DataGet(src, 1, 1, mapping)
+	if len(rows) > 0 {
+		row := rows[0]
+		rs := map[string]interface{}{}
+		for i := range row {
+			key := columns[i]
+			value := row[i]
+			rs[key] = value
+		}
+		for i := range mapping.Columns {
+			name := mapping.Columns[i].Field
+			mapping.Columns[i].Value = fmt.Sprintf("%v", rs[name])
+		}
+	}
+	return mapping
 }
 
 // DataSetting 预览数据表格配置

diff --git a/importer/types.go b/importer/types.go
@@ -58,5 +58,6 @@ type Binding struct {
 	Field string   `json:"field"` // 目标字段名称
 	Name  string   `json:"name"`  // 源关联字段名称
 	Axis  string   `json:"axis"`  // 源关联字段坐标
+	Value string   `json:"value"` // 示例数据
 	Rules []string `json:"rules"` // 清洗规则
 }
diff --git a/xiang/apis/import.http.json b/xiang/apis/import.http.json
@@ -3,7 +3,7 @@
   "version": "1.0.0",
   "description": "数据分析接口API",
   "group": "xiang/import",
-  "guard": "-",
+  "guard": "bearer-jwt",
   "paths": [
     {
       "path": "/:name",