implemented base interface

[sql.git] / www / templates / main / db_list.tmpl

diff --git a/www/templates/main/db_list.tmpl b/www/templates/main/db_list.tmpl
new file mode 100644 (file)
index 0000000..0a3b3ce
--- /dev/null
+++ b/www/templates/main/db_list.tmpl
@@ -0,0 +1,39 @@
+#extends templates.common.shell
+#from mitsql.interface import display
+
+#def title: Manage Databases
+
+#block body
+
+<table width="100%">
+#if len($db_list) == 0:
+<tr><td width="100%"><em>You have no databases. Add one below.</em></td></tr>
+#else:
+#for name, data in $db_list:
+<tr><td width="100%">
+#echo display.db_list_entry($name, $data.size_tot, $data.size_max)
+</td><td>
+<p>drop</p>
+</td></tr>
+#end for
+#end if
+<tr><td colspan=2>
+<hr />
+</td></tr><tr><td colspan=2>
+#echo display.db_list_entry('TOTAL', $size_tot, $size_max)
+</td></tr>
+</table>
+
+<form method="post" action="create">
+<p align="right">
+    <span style="width: 150px; font-style: italic;">
+    <label for="p1">new database:</label>
+    </span> $user.db_prefix<input type="text" name="db_name" />
+    <input type=submit value="create">
+</p>
+</form>
+
+<h3>Manage Data</h3>
+<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>
+
+#end block body
\ No newline at end of file