pgupgrade.js 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. function versionHandler () {
  2. 'use strict';
  3. let obj = JSON.parse(this.responseText);
  4. if(obj.result === 1) {
  5. // Construct version warning/display
  6. let pgVersion = obj.data.installed_version.major + '.' + obj.data.installed_version.minor;
  7. let elem = document.getElementById('psqlVersion');
  8. let html = pgVersion;
  9. if( parseFloat(pgVersion) < parseFloat(obj.data.minimum_supported_version) ) {
  10. elem.classList.add('callout', 'callout-danger');
  11. html += " -- You are using a version of PostgreSQL Server that is no longer supported! Immediate upgrade reccomended.";
  12. }
  13. elem.innerHTML = html;
  14. // Now let's build the table
  15. let rows = '';
  16. for ( var version of Object.keys(obj.data.available_versions) ) {
  17. rows +=
  18. `<tr id="pgVersionRow-${version}">
  19. <td>
  20. <input type="radio" name="selectedVersion" value="${version}"></input>
  21. ${version}
  22. </td>
  23. <td>
  24. Lorem Ipsum
  25. </td>
  26. <td>
  27. Community
  28. </td>
  29. <td>
  30. ${obj.data.available_versions[version].release}
  31. </td>
  32. <td>
  33. ${obj.data.available_versions[version].EOL}
  34. </td>
  35. </tr>`;
  36. }
  37. document.querySelector('#upgradeForm > table > tbody').innerHTML = rows;
  38. } else {
  39. console.log(obj.error);
  40. }
  41. }
  42. var oReq = new XMLHttpRequest();
  43. oReq.addEventListener("load", versionHandler);
  44. oReq.open("GET", "api.cgi?module=Postgres&function=get_postgresql_versions");
  45. oReq.send();