Add students blueprint using psycopg

2 files changed, 59 insertions, 5 deletions

diff --git a/ustayml/static/logo_pucp.svg b/ustayml/static/img/logo_pucp.svg
index 8ffb164..8ffb164 100644
--- a/ustayml/static/logo_pucp.svg
+++ b/ustayml/static/img/logo_pucp.svg
diff --git a/ustayml/static/style.css b/ustayml/static/style.css
index 1a73cc5..08b5e9f 100644
--- a/ustayml/static/style.css
+++ b/ustayml/static/style.css
@@ -1,13 +1,14 @@
 html {
   font-family: sans-serif;
   background: #eee;
-  padding: 1rem;
+  /* padding: 1rem; */
 }
 
 body {
+  min-width: 480px;
   max-width: 960px;
   margin: 0 auto;
-  background: white;
+  /* background: white; */
 }
 
 h1,
@@ -31,14 +32,21 @@ hr {
 }
 
 nav {
-  background: lightgray;
+  min-height: 80px;
+  background: #042254;    /* PUCP dark blue 1 */
   display: flex;
   align-items: center;
+  justify-content: space-between;
   padding: 0 0.5rem;
 }
 
+nav a,
+nav span {
+  color: white;
+}
+
 nav h1 {
-  flex: auto;
+  /* flex: auto; */
   margin: 0;
 }
 
@@ -54,6 +62,11 @@ nav ul {
   padding: 0;
 }
 
+.pad-navbar-links {
+  margin-left: 2rem;
+  margin-right: 2rem;
+}
+
 nav ul li a,
 nav ul li span,
 header .action {
@@ -62,6 +75,8 @@ header .action {
 }
 
 .content {
+  background: white;
+  margin-top: 1rem;
   padding: 0 1rem 1rem;
 }
 
@@ -76,6 +91,22 @@ header .action {
   margin: 1rem 0 0.25rem 0;
 }
 
+.content > .filters {
+  margin-top: 1em;
+  margin-bottom: 1em;
+}
+
+.content .filters-list {
+  display: flex;
+  flex-direction: row;
+  align-items: flex-end;
+  /* justify-content: center; */
+}
+
+.filters-list select {
+  margin-right: 2em;
+}
+
 .flash {
   margin: 1em 0;
   padding: 1em;
@@ -83,6 +114,29 @@ header .action {
   border: 1px solid #377ba8;
 }
 
+/* students */
+
+.students-table {
+  padding: 2em;
+  width: 100%;
+  border-collapse: collapse;
+}
+
+.students-table th, 
+.students-table td {
+  border: 1px solid #ccc;
+  padding: 0.2em 0.2em;
+}
+
+.report-info {
+  display: flex;
+  justify-content: space-between;
+  padding: 5em;
+  margin-top: 5em;
+}
+
+/* post */
+
 .post > header {
   display: flex;
   align-items: flex-end;
@@ -111,7 +165,7 @@ header .action {
   margin-bottom: 0;
 }
 
-.content form {
+.content .simple-form {
   margin: 1em 0;
   display: flex;
   flex-direction: column;