Assignment #3

Fuel Migration Dashboard

You will make a web GUI dashboard for your fuel migrations.

Here are the requirements.

  • Page is available from a link on your group assignment page
  • That page shows the status of all migrations in the system
  • An authenticated user (Milestone 3) can run these migrations up/down or update to current
  • Anyone (no login needed) can see the migration status
  • Anyone can see a div on the page that dynamically shows the create table statement for the table `test` that is being altered (Just for gradingm, see below)

To make this look nice, you will need to invent a naming scheme for all of your migration files and also have fields in that file that specify the version number and a description of the migration. To aid in grading, you will make 3 migrations as follows:

  • Create a table called `test` that has at least 7 columns of varying types (run down drops this table)
  • Remove one of those columns from the table (run down will add it back in)
  • Alter one of the column's types in some significant way (change INT to VARCHAR or similar)

Addendum - Updated April 11

  • Clarification on the showing create table statement, that is only for table `test` and is only for grading THIS assignment.
  • The migration "name" is something like "Adds table test" or "Remove column x from table test"
  • The version number is anything you want, as long as it is sortale and update to current runs migrations in order.