SDatabaseDocController.kt 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. /*
  2. * *********************************************************************************************************************
  3. *
  4. * !!
  5. * .F88X
  6. * X8888Y
  7. * .}888888N;
  8. * i888888N; .:! .I$WI:
  9. * R888888I .'N88~ i8}+8Y&8"l8i$8>8W~'>W8}8]KW+8IIN"8&
  10. * .R888888I .;N8888~ .X8' "8I.!,/8" !%NY8`"8I8~~8>,88I
  11. * +888888N; .8888888Y "&&8Y.}8,
  12. * ./888888N; .R888888Y .'}~ .>}'.`+> i}! "i' +/' .'i~ !11,.:">, .~]! .i}i
  13. * ~888888%: .I888888l .]88~`1/iY88Ii+1'.R$8$8]"888888888> Y8$ W8E X8E W8888'188Il}Y88$*
  14. * 18888888 E8888881 .]W%8$`R8X'&8%++N8i,8N%N8+l8%` .}8N:.R$RE%N88N%N$K$R 188,FE$8%~Y88I
  15. * .E888888I .i8888888' .:$8I;88+`E8R:/8N,.>881.`$8E/1/]N8X.Y8N`"KF&&FK!'88*."88K./$88%RN888+~
  16. * 8888888I .,N888888~ ~88i"8W,!N8*.I88.}888%F,i$88"F88" 888:E8X.>88!i88>`888*.}Fl1]*}1YKi'
  17. * i888888N' I888Y ]88;/EX*IFKFK88X K8R .l8W 88Y ~88}'88E&%8W.X8N``]88!.$8K .:W8I
  18. * .i888888N; I8Y .&8$ .X88! i881.:%888>I88 ;88] +88+.';;;;:.Y88X 18N.,88l .+88/
  19. * .:R888888I
  20. * .&888888I Copyright (c) 2016-2020. 博锐尚格科技股份有限公司
  21. * ~8888'
  22. * .!88~ All rights reserved.
  23. *
  24. * *********************************************************************************************************************
  25. */
  26. package com.persagy.service.mysql.controllers
  27. import com.persagy.service.SObjectService
  28. import com.persagy.service.mysql.models.SColumn
  29. import com.persagy.service.mysql.models.STable
  30. import io.swagger.v3.oas.annotations.Operation
  31. import io.swagger.v3.oas.annotations.tags.Tag
  32. import org.springframework.web.bind.annotation.*
  33. /**
  34. * 数据库设计接口
  35. *
  36. * @author 庞利祥 <sybotan@126.com>
  37. */
  38. @Tag(name = "数据库设计接口")
  39. @RestController
  40. @RequestMapping("/--database-doc--/")
  41. class SDatabaseDocController {
  42. /** 表服务对象 */
  43. private val tableService = SObjectService(STable::class.java)
  44. /** 字段服务对象 */
  45. private val columnService = SObjectService(SColumn::class.java)
  46. /**
  47. * 查询表信息
  48. *
  49. * @param schema 数据库
  50. * @return 字段列表
  51. */
  52. @Operation(summary="查询表信息",description = "")
  53. @RequestMapping(value = ["/table-list"], method = [RequestMethod.GET, RequestMethod.POST])
  54. fun tableList(schema: String): List<Any> {
  55. return tableService.select("schemaName" to schema).exec()
  56. }
  57. /**
  58. * 查询字段信息
  59. *
  60. * @param schema 数据库
  61. * @param table 表名
  62. * @return 字段列表
  63. */
  64. @Operation(summary="查询字段信息", description="")
  65. @RequestMapping(value = ["/column-list"], method = [RequestMethod.GET, RequestMethod.POST])
  66. fun columnList(schema: String, table: String): ArrayList<SColumn> {
  67. val builder = columnService.select("schemaName" to schema, "tableName" to table)
  68. builder.tableName =
  69. "(SELECT *,\n" +
  70. " (SELECT \"description\" FROM \"pg_description\"\n" +
  71. " JOIN \"pg_class\" ON \"pg_description\".\"objoid\" = \"pg_class\".\"oid\"\n" +
  72. " JOIN \"pg_namespace\" ON \"pg_class\".\"relnamespace\" = \"pg_namespace\".\"oid\"\n" +
  73. "WHERE \"relname\" = \"t\".\"table_name\" and \"nspname\"= \"t\".\"table_schema\" and \"objsubid\" = \"t\".\"ordinal_position\")\n" +
  74. "FROM \"information_schema\".\"columns\" t) ct"
  75. return builder.exec()
  76. //return mapper.columnList(schema, table)
  77. }
  78. /**
  79. * 查询表、字段信息
  80. *
  81. * @param schema 字段
  82. * @param table 表名
  83. * @return
  84. */
  85. @Operation(summary="查询字段信息", description="")
  86. @RequestMapping(value = ["/table-info"], method = [RequestMethod.GET, RequestMethod.POST])
  87. fun tableInfo(schema: String, table: String): STable {
  88. val sTable = STable()
  89. sTable.schemaName = schema
  90. sTable.tableName = table
  91. sTable.columnList = columnList(schema, table)
  92. return sTable
  93. }
  94. }