addDqlPostgreSQL.html 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. <!DOCTYPE html>
  2. <html lang="zh-CN"
  3. xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
  4. <div th:fragment="content">
  5. <div class="form-group">
  6. <label class="col-sm-2 control-label">帐号 <strong class="driverVerifcateRequired">*</strong></label>
  7. <div class="col-sm-4">
  8. <input class="form-control" dbsyncer-valid="require" maxlength="32" name="username" placeholder="admin"
  9. th:value="${connector?.config?.username}" type="text"/>
  10. </div>
  11. <label class="col-sm-2 control-label">密码 <strong class="driverVerifcateRequired">*</strong></label>
  12. <div class="col-sm-4 ">
  13. <input class="form-control" dbsyncer-valid="require" maxlength="32" name="password"
  14. th:value="${connector?.config?.password}" type="password"/>
  15. </div>
  16. </div>
  17. <div class="form-group">
  18. <label class="col-sm-2 control-label">SQL <strong class="driverVerifcateRequired">*</strong></label>
  19. <div class="col-sm-10">
  20. <textarea class="form-control dbsyncer_textarea_resize_none" maxlength="8192" dbsyncer-valid="require"
  21. id="sql" name="sql" rows="10"
  22. th:text="${connector?.config?.sql}?:'SELECT T1.* FROM &quot;USER&quot; T1'"></textarea>
  23. </div>
  24. </div>
  25. <div class="form-group">
  26. <div class="col-sm-6"></div>
  27. <div class="col-sm-6 text-right">
  28. <a href="javascript:beautifySql();"><span class="fa fa-magic fa-1x fa-flip-horizontal dbsyncer_pointer"
  29. title="美化SQL"></span>美化SQL</a>
  30. </div>
  31. </div>
  32. <div class="form-group">
  33. <label class="col-sm-2 control-label">主表 <strong class="driverVerifcateRequired">*</strong></label>
  34. <div class="col-sm-4">
  35. <input class="form-control" name="table" type="text" maxlength="32" dbsyncer-valid="require"
  36. placeholder="USER" th:value="${connector?.config?.table}"/>
  37. </div>
  38. <label class="col-sm-2 control-label">主键 <strong class="driverVerifcateRequired">*</strong></label>
  39. <div class="col-sm-4">
  40. <input class="form-control" name="primaryKey" type="text" maxlength="32" dbsyncer-valid="require"
  41. placeholder="ID" th:value="${connector?.config?.primaryKey}"/>
  42. </div>
  43. </div>
  44. <div class="form-group">
  45. <label class="col-sm-2 control-label">URL <strong class="driverVerifcateRequired">*</strong></label>
  46. <div class="col-sm-10">
  47. <textarea class="form-control dbsyncer_textarea_resize_none" dbsyncer-valid="require" maxlength="1024" name="url" rows="5"
  48. th:text="${connector?.config?.url} ?: 'jdbc:postgresql://127.0.0.1:5432/test'"></textarea>
  49. </div>
  50. </div>
  51. <div class="form-group">
  52. <label class="col-sm-2 control-label">架构名 <strong class="driverVerifcateRequired">*</strong></label>
  53. <div class="col-sm-4">
  54. <input class="form-control" dbsyncer-valid="require" maxlength="32" name="schema" placeholder="public"
  55. th:value="${connector?.config?.schema} ?: 'public'" type="text"/>
  56. </div>
  57. <div class="col-sm-6"></div>
  58. </div>
  59. <div class="form-group">
  60. <label class="col-sm-2 control-label">删除Slot <i aria-hidden="true" class="fa fa-question-circle fa_gray"
  61. title="增量同步,停止驱动自动删除Slot"></i></label>
  62. <div class="col-sm-4">
  63. <input id="dropSlotOnCloseSwitch" name="dropSlotOnClose"
  64. th:checked="${#maps.isEmpty(connector?.config?.properties) or connector?.config?.properties?.dropSlotOnClose eq 'true'}"
  65. type="checkbox">
  66. </div>
  67. <label class="col-sm-2 control-label">插件</label>
  68. <div class="col-sm-4">
  69. <select class="form-control select-control" name="pluginName">
  70. <option value="pgoutput" th:selected="${connector?.config?.properties?.pluginName eq 'pgoutput'}">pgoutput</option>
  71. <option value="test_decoding" th:selected="${connector?.config?.properties?.pluginName eq 'test_decoding'}">test_decoding</option>
  72. </select>
  73. </div>
  74. </div>
  75. <div class="form-group">
  76. <label class="col-sm-2 control-label">驱动 </label>
  77. <div class="col-sm-10">
  78. <input class="form-control" name="driverClassName" readonly="true"
  79. th:value="${connector?.config?.driverClassName} ?: 'org.postgresql.Driver'" type="text"/>
  80. </div>
  81. </div>
  82. <script type="text/javascript">
  83. $(function () {
  84. $('#dropSlotOnCloseSwitch').bootstrapSwitch({
  85. onText: "Yes",
  86. offText: "No",
  87. onColor: "success",
  88. offColor: "info",
  89. size: "normal"
  90. });
  91. // 初始化select插件
  92. initSelectIndex($(".select-control"), 1);
  93. })
  94. </script>
  95. </div>
  96. </html>