TableDesig.vue 8.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283
  1. <template>
  2. <div>
  3. <el-button style="margin-top:10px" @click="genEntrty">生成实体类</el-button>
  4. <el-button style="margin-top:10px" @click="genControler">生成接口类</el-button>
  5. <el-table
  6. :data="tableData"
  7. :header-cell-style="headerStyle"
  8. border
  9. stripe
  10. fit
  11. style="width: 100%;margin-top: 25px;"
  12. >
  13. <el-table-column fixed prop="ColumnName" label="字段名" width="150"></el-table-column>
  14. <el-table-column prop="Description" min-width="200" label="说明"></el-table-column>
  15. <el-table-column prop="ColumnType" min-width="120" label="类型"></el-table-column>
  16. <el-table-column prop="CharMaxLength" min-width="60" label="长度"></el-table-column>
  17. <el-table-column prop="Nullable" align="center" label="不是 null"></el-table-column>
  18. <el-table-column prop="Default" min-width="260" label="默认值"></el-table-column>
  19. </el-table>
  20. </div>
  21. </template>
  22. <script>
  23. import Vue from "vue";
  24. import ElementUI from "element-ui";
  25. import Axios from "axios";
  26. import "element-ui/lib/theme-chalk/index.css";
  27. import Opt from "../opt";
  28. import { SStringBuilder } from "@persagy-web/base";
  29. Vue.use(ElementUI);
  30. export default {
  31. data: function() {
  32. return {
  33. tableData: [],
  34. headerStyle: {
  35. backgroundColor: "#e1e4e5",
  36. color: "#2b2b2b",
  37. lineHeight: "30px"
  38. }, // 列表样式
  39. urlObj: {} // 路径参数
  40. };
  41. },
  42. components: {},
  43. created: function() {
  44. this.getData();
  45. this.getUrlData();
  46. },
  47. mounted: function() {
  48. // alert(this.schema);
  49. },
  50. props: ["sys", "schema", "table"],
  51. computed: {},
  52. methods: {
  53. getData() {
  54. Axios.get(
  55. `${Opt.databaseDoc[this.sys]}/--database-doc--/column-list?schema=${
  56. this.schema
  57. }&table=${this.table}`,
  58. {}
  59. ).then(res => {
  60. this.tableData = res.data;
  61. });
  62. },
  63. //生成实体类
  64. genEntrty() {
  65. let strBuild = new SStringBuilder();
  66. const table = this.toHump(this.table);
  67. strBuild.append(
  68. `package cn.sagacloud.server.datacenter.models.entities
  69. import cn.sagacloud.server.datacenter.models.entities.base.BaseInfo
  70. import cn.sagacloud.server.datacenter.models.entities.task.SchemeUtils
  71. import com.alibaba.fastjson.annotation.JSONField
  72. import com.sybotan.service.models.annotations.SCascade
  73. import io.swagger.annotations.ApiModel
  74. import io.swagger.annotations.ApiModelProperty
  75. import javax.persistence.Column
  76. import javax.persistence.Id
  77. import javax.persistence.Table
  78. /**
  79. * 资产信息实体类
  80. *
  81. * @author 自动生成
  82. */
  83. @ApiModel(description = "资产信息实体类")
  84. @Table(name = "${this.schema}.${table}")
  85. open class ${table} : BaseInfo(),Comparator<${table}> {
  86. `
  87. );
  88. this.tableData.forEach(element => {
  89. strBuild.append(` /** ${element.Description} */`);
  90. if (element.Nullable == "YES") {
  91. strBuild.append(
  92. ` @ApiModelProperty(value = "${element.Description}")`
  93. );
  94. } else {
  95. strBuild.append(
  96. ` @ApiModelProperty(value = "${element.Description}", required = true)`
  97. );
  98. }
  99. strBuild.append(` @Column(name = "${element.ColumnName}")`);
  100. strBuild.append(
  101. ` var ${this.toHump(element.ColumnName)}: ${this.typeToName(
  102. element.ColumnType
  103. )}? = null\n`
  104. );
  105. });
  106. strBuild.append(`} // Class ${table}`);
  107. this.download(`${table}.kt`, strBuild.toString());
  108. },
  109. //生成接口类
  110. genControler() {
  111. let strBuild = new SStringBuilder();
  112. const className = `${this.toHump(this.urlObj.urlType)}Controller`;
  113. strBuild.append(`package cn.sagacloud.server.datacenter.controllers
  114. import cn.sagacloud.server.datacenter.models.entities.Property
  115. import cn.sagacloud.server.datacenter.services.PropertyService
  116. import com.sybotan.base.extensions.toJson
  117. import com.sybotan.database.SFilter
  118. import com.sybotan.service.SPageContext
  119. import com.sybotan.service.models.requests.SCountRequest
  120. import com.sybotan.service.models.requests.SCreateRequest
  121. import com.sybotan.service.models.requests.SQueryRequest
  122. import com.sybotan.service.models.requests.SUpdateRequest
  123. import com.sybotan.service.models.responses.SBaseResponse
  124. import com.sybotan.service.models.responses.SCountResponse
  125. import com.sybotan.service.models.responses.SCreateResponse
  126. import com.sybotan.service.models.responses.SQueryResponse
  127. import io.swagger.annotations.Api
  128. import io.swagger.annotations.ApiOperation
  129. import org.slf4j.LoggerFactory
  130. import org.springframework.web.bind.annotation.PostMapping
  131. import org.springframework.web.bind.annotation.RequestBody
  132. import org.springframework.web.bind.annotation.RequestMapping
  133. import org.springframework.web.bind.annotation.RestController
  134. /**
  135. * ${this.urlObj.urlName}接口
  136. *
  137. * @author 自动生成
  138. */
  139. @Api(tags = ["${this.urlObj.urlName}"])
  140. @RestController
  141. @RequestMapping("/object/${this.urlObj.urlType}")
  142. open class ${className} {
  143. companion object {
  144. /** 日志 */
  145. private val logger = LoggerFactory.getLogger(${className}::class.java)
  146. } // Companion object
  147. /**
  148. * 创建${this.urlObj.urlName}
  149. *
  150. * @param request ${this.urlObj.urlName}对象列表
  151. * @return 创建结果信息
  152. */
  153. @ApiOperation(value = "创建${this.urlObj.urlName}信息", notes = "")
  154. @PostMapping(value = ["/create"])
  155. fun create(@RequestBody request: SCreateRequest<${this.typeToName(
  156. this.urlObj.urlType
  157. )}>): SCreateResponse<${this.typeToName(this.urlObj.urlType)}> {
  158. return PropertyService.createList( request)
  159. } // Function create()
  160. /**
  161. * 根据id删除${this.urlObj.urlName}
  162. *
  163. * @param idList id数组
  164. * @return 删除的结果信息
  165. */
  166. @ApiOperation(value = "根据id删除${this.urlObj.urlName}信息", notes = "")
  167. @PostMapping(value = ["/delete"])
  168. fun delete(@RequestBody idList: ArrayList<${this.typeToName(
  169. this.urlObj.urlType
  170. )}>): SBaseResponse {
  171. return PropertyService.deleteByKeysList(idList)
  172. } // Function delete()
  173. /**
  174. * 更新${this.urlObj.urlName}信息
  175. *
  176. * @param request 更新的内容对象
  177. * @return 更新的结果
  178. */
  179. @ApiOperation(value = "更新${this.urlObj.urlName}信息", notes = "")
  180. @PostMapping(value = ["/update"])
  181. fun update(@RequestBody request: SUpdateRequest<${this.typeToName(
  182. this.urlObj.urlType
  183. )}>): SBaseResponse {
  184. return PropertyService.updateList(request)
  185. } // Function update()
  186. /**
  187. * 查询${this.urlObj.urlName}信息
  188. *
  189. * @param request 查询信息条件
  190. * @return 查询结果
  191. */
  192. @ApiOperation(value = "查询${this.urlObj.urlName}信息", notes="")
  193. @PostMapping(value = ["/query"])
  194. fun query(@RequestBody request: SQueryRequest): SQueryResponse<${this.typeToName(
  195. this.urlObj.urlType
  196. )}> {
  197. return PropertyService.pageQuery(request)
  198. } // Function query()
  199. /**
  200. * 根据条件查询统计数量
  201. */
  202. @ApiOperation(value = "根据条件查询统计数量", notes = "")
  203. @PostMapping(value = ["/count"])
  204. fun count(@RequestBody request: SCountRequest): SCountResponse {
  205. return PropertyService.count(request)
  206. } // Function count()
  207. `);
  208. strBuild.append(`} // Class ${className}`);
  209. this.download(`${className}.kt`, strBuild.toString());
  210. },
  211. // 数据包类型到实体类的转换
  212. typeToName(name) {
  213. const obj = {
  214. varchar: "String",
  215. char: "String",
  216. timestamptz: "Date",
  217. timestamp: "Date",
  218. text: "String",
  219. bool: "Boolean",
  220. int4: "Int",
  221. date: "Date",
  222. int2: "Int",
  223. json: "HashMap<String, Any?>",
  224. jsonb: "HashMap<String, Any?>"
  225. };
  226. if (name) {
  227. return obj[name] ? obj[name] : "String";
  228. } else {
  229. return "String";
  230. }
  231. },
  232. //转驼峰
  233. toHump(name) {
  234. return name;
  235. },
  236. // 获取路径名称以及路径type
  237. getUrlData() {
  238. const dataArr = window.location.href.split("#")[1].split("-");
  239. const obj = {
  240. urlType: dataArr[1],
  241. urlName: decodeURIComponent(dataArr[0])
  242. };
  243. this.urlObj = obj;
  244. },
  245. // 下载文件
  246. download(filename, text) {
  247. var element = document.createElement("a");
  248. element.setAttribute(
  249. "href",
  250. "data:text/plain;charset=utf-8," + encodeURIComponent(text)
  251. );
  252. element.setAttribute("download", filename);
  253. element.style.display = "none";
  254. document.body.appendChild(element);
  255. element.click();
  256. document.body.removeChild(element);
  257. }
  258. }
  259. };
  260. </script>
  261. <style scoped>
  262. /deep/ table {
  263. margin: 0;
  264. }
  265. </style>