/demo/exe/templates/website/db_test.tmpl

http://github.com/ThomasLocke/yolk · Go Template · 88 lines · 88 code · 0 blank · 0 comment · 0 complexity · 777d3a9ba8480c04ef6468c19553beaa MD5 · raw file 

    

  1. @@-----------------------------------------------------------------------------
    2. 

  2. @@--                                                                         --
    3. 

  3. @@--                               Yolk                                      --
    4. 

  4. @@--                                                                         --
    5. 

  5. @@--                Copyright (C) 2000-2012, Thomas Løcke                    --
    6. 

  6. @@--                                                                         --
    7. 

  7. @@-- This is free software;  you can redistribute it and/or modify it        --
    8. 

  8. @@-- under terms of the  GNU General Public License  as published by the     --
    9. 

  9. @@-- Free Software  Foundation;  either version 3,  or (at your  option) any --
    10. 

  10. @@-- later version. This library is distributed in the hope that it will be  --
    11. 

  11. @@-- useful, but WITHOUT ANY WARRANTY;  without even the implied warranty of --
    12. 

  12. @@-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                    --
    13. 

  13. @@-- You should have received a copy of the GNU General Public License and   --
    14. 

  14. @@-- a copy of the GCC Runtime Library Exception along with this program;    --
    15. 

  15. @@-- see the files COPYING3 and COPYING.RUNTIME respectively.  If not, see   --
    16. 

  16. @@-- <http://www.gnu.org/licenses/>.                                         --
    17. 

  17. @@--                                                                         --
    18. 

  18. @@-----------------------------------------------------------------------------
    19. 

  19. <!DOCTYPE html>
    20. 

  20. <html>
    21. 

  21.     <head>
    22. 

  22.         <meta charset="utf-8"/>
    23. 

  23.         <link rel="stylesheet" type="text/css" href="/css/index.css"/>
    24. 

  24.         <link rel="icon" href="/images/favicon.ico" type="image/x-icon"/>
    25. 

  25.         <title>
    26. 

  26.             Yolk Web Toolbox
    27. 

  27.         </title>
    28. 

  28.     </head>
    29. 

  29. <body>
    30. 

  30.     <h3>PostgreSQL test</h3>
    31. 

  31.     @@IF@@ @_POSTGRESQL_SETUP_@
    32. 

  32.         <p>
    33. 

  33.             Connection to PostgreSQL database succeeded.
    34. 

  34.         </p>
    35. 

  35.         <p>
    36. 

  36.             The test will now proceed with creating a table, inserting and querying some data and finally dropping the table.
    37. 

  37.         </p>
    38. 

  38.         <h4>Test output</h4>
    39. 

  39.         <ul>
    40. 

  40.             @@TABLE@@
    41. 

  41.                 <li>@_POSTGRESQL_MESSAGES_@</li>
    42. 

  42.             @@END_TABLE@@
    43. 

  43.             @@IF@@ @_POSTGRESQL_SUCCESS_@
    44. 

  44.                 <li class="green">Test successfully completed!</li>
    45. 

  45.             @@ELSE@@
    46. 

  46.                 <li class="red">Test failed!</li>
    47. 

  47.             @@END_IF@@
    48. 

  48.         </ul>
    49. 

  49.     @@ELSE@@
    50. 

  50.         <p>
    51. 

  51.             In order to test if Yolk can connect and interact with a PostgreSQL database, you must create an empty PostgreSQL database and then set the four database parameters in configuration/my_config.ini accordingly:
    52. 

  52.         </p>
    53. 

  53.         <ul>
    54. 

  54.             <li>DB_Host</li>
    55. 

  55.             <li>DB_Name</li>
    56. 

  56.             <li>DB_Password</li>
    57. 

  57.             <li>DB_User</li>
    58. 

  58.         </ul>
    59. 

  59.         <p>
    60. 

  60.            You do not need to create any tables in the DB_Name database.
    61. 

  61.         </p>
    62. 

  62.         <p>
    63. 

  63.             When you've done this, simply refresh this page, or drop this test and go back to the <a href="/">main page</a>.
    64. 

  64.         </p>
    65. 

  65.     @@END_IF@@
    66. 

  66.     <h3>SQLite test</h3>
    67. 

  67.     <p>
    68. 

  68.         Connection to SQLite database succeeded.
    69. 

  69.     </p>
    70. 

  70.     <p>
    71. 

  71.         The test will now proceed with inserting, querying and deleting some data.
    72. 

  72.     </p>
    73. 

  73.     <h4>Test output</h4>
    74. 

  74.     <ul>
    75. 

  75.         @@TABLE@@
    76. 

  76.             <li>@_SQLITE_MESSAGES_@</li>
    77. 

  77.         @@END_TABLE@@
    78. 

  78.         @@IF@@ @_SQLITE_SUCCESS_@
    79. 

  79.             <li class="green">Test successfully completed!</li>
    80. 

  80.         @@ELSE@@
    81. 

  81.             <li class="red">Test failed!</li>
    82. 

  82.         @@END_IF@@
    83. 

  83.     </ul>
    84. 

  84.     <p>
    85. 

  85.         If all went well, go back to the <a href="/">main page</a>. If you have some red output, check the log files, fix the error and try again.
    86. 

  86.     </p>
    87. 

  87. </body>
    88. 

  88. </html>
    89.