andersk / sql.git / blame
| Commit | Line | Data |
|---|---|---|
| e4fd5e1b JP |
1 | #extends templates.common.shell |
| 2 | #from mitsql.interface import display | |
| 3 | ||
| 4 | #def title: Manage Databases | |
| 5 | ||
| 6 | #block body | |
| 7 | ||
| 8 | <table width="100%"> | |
| 9 | #if len($db_list) == 0: | |
| 10 | <tr><td width="100%"><em>You have no databases. Add one below.</em></td></tr> | |
| 11 | #else: | |
| 12 | #for name, data in $db_list: | |
| 13 | <tr><td width="100%"> | |
| 14 | #echo display.db_list_entry($name, $data.size_tot, $data.size_max) | |
| 15 | </td><td> | |
| 16 | <p>drop</p> | |
| 17 | </td></tr> | |
| 18 | #end for | |
| 19 | #end if | |
| 20 | <tr><td colspan=2> | |
| 21 | <hr /> | |
| 22 | </td></tr><tr><td colspan=2> | |
| 23 | #echo display.db_list_entry('TOTAL', $size_tot, $size_max) | |
| 24 | </td></tr> | |
| 25 | </table> | |
| 26 | ||
| 27 | <form method="post" action="create"> | |
| 28 | <p align="right"> | |
| 29 | <span style="width: 150px; font-style: italic;"> | |
| 30 | <label for="p1">new database:</label> | |
| 31 | </span> $user.db_prefix<input type="text" name="db_name" /> | |
| 32 | <input type=submit value="create"> | |
| 33 | </p> | |
| 34 | </form> | |
| 35 | ||
| 36 | <h3>Manage Data</h3> | |
| 37 | <p>One interface we recommend for managing SQL data is <a href="https://scripts.mit.edu/~sql/phpMyAdmin/" target="_blank">phpMyAdmin</a>. Feel free to use it after you've created your databases.</p> | |
| 38 | ||
| 39 | #end block body |