addDqlPostgreSQL.html 4.5 KB

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