Support for groups

• Queue now uses spring-sessions for session authentication, in combination with redis-server. In application.properties, the following needs to be added:

spring.session.store-type=redis
spring.redis.host=localhost
spring.redis.port=6379

• Closes #76 (closed), #77 (closed), #78 (closed)

• Added support for Groups: On the course page, a Brightspace CSV groups file can be imported

  • Students that do not exist are automatically created
  • Students then enqueue as a group

• Also, I recommend we switch to InnoDB, because MyISAM does not support foreign keys:

To switch to InnoDB:

In application.properties:

spring.jpa.database-platform = org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.dialect.storage_engine = innodb

In MySQL:

SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='MyISAM' AND table_schema = 'queue'

and run the output of this query to convert the tables to the new engine. Finally, run the groups.sql script to convert the queue to the new database schema. Note that it is not trivial to go back to the earlier schema once new data has been inserted.

groups.sql