- 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
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:
spring.jpa.database-platform = org.hibernate.dialect.MySQL5InnoDBDialect hibernate.dialect.storage_engine = innodb
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.