addDqlPostgreSQL.html 4.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  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 name="sql" class="sql form-control dbsyncer_textarea_resize_none" maxlength="8192"
  21. dbsyncer-valid="require" rows="10"
  22. th:text="${connector?.config?.sqlTables[0]?.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?.sqlTables[0]?.table}"/>
  37. </div>
  38. <div class="col-sm-6"></div>
  39. </div>
  40. <div class="form-group">
  41. <label class="col-sm-2 control-label">URL <strong class="driverVerifcateRequired">*</strong></label>
  42. <div class="col-sm-10">
  43. <textarea class="form-control dbsyncer_textarea_resize_none" dbsyncer-valid="require" maxlength="1024" name="url" rows="5"
  44. th:text="${connector?.config?.url} ?: 'jdbc:postgresql://127.0.0.1:5432/postgres'"></textarea>
  45. </div>
  46. </div>
  47. <div class="form-group">
  48. <label class="col-sm-2 control-label">架构名 <strong class="driverVerifcateRequired">*</strong></label>
  49. <div class="col-sm-4">
  50. <input class="form-control" dbsyncer-valid="require" maxlength="32" name="schema" placeholder="public"
  51. th:value="${connector?.config?.schema} ?: 'public'" type="text"/>
  52. </div>
  53. <div class="col-sm-6"></div>
  54. </div>
  55. <div class="form-group">
  56. <label class="col-sm-2 control-label">删除Slot <i aria-hidden="true" class="fa fa-question-circle fa_gray"
  57. title="增量同步,停止驱动自动删除Slot"></i></label>
  58. <div class="col-sm-4">
  59. <input id="dropSlotOnCloseSwitch" name="dropSlotOnClose"
  60. th:checked="${#maps.isEmpty(connector?.config?.properties) or connector?.config?.properties?.dropSlotOnClose eq 'true'}"
  61. type="checkbox">
  62. </div>
  63. <label class="col-sm-2 control-label">插件</label>
  64. <div class="col-sm-4">
  65. <select class="form-control select-control" name="pluginName">
  66. <option value="pgoutput" th:selected="${connector?.config?.properties?.pluginName eq 'pgoutput'}">pgoutput</option>
  67. <option value="test_decoding" th:selected="${connector?.config?.properties?.pluginName eq 'test_decoding'}">test_decoding</option>
  68. </select>
  69. </div>
  70. </div>
  71. <div class="form-group">
  72. <label class="col-sm-2 control-label">驱动 </label>
  73. <div class="col-sm-10">
  74. <input class="form-control" name="driverClassName" readonly="true"
  75. th:value="${connector?.config?.driverClassName} ?: 'org.postgresql.Driver'" type="text"/>
  76. </div>
  77. </div>
  78. <script type="text/javascript">
  79. $(function () {
  80. $('#dropSlotOnCloseSwitch').bootstrapSwitch({
  81. onText: "Yes",
  82. offText: "No",
  83. onColor: "success",
  84. offColor: "info",
  85. size: "normal"
  86. });
  87. // 初始化select插件
  88. initSelectIndex($(".select-control"), 1);
  89. })
  90. </script>
  91. </div>
  92. </html>