History command

[Adam Connelly]

Create a command to get the history of versions of a database. The usage should be:

dbversion history [options]

If you type diversion history with no options it should list the versions (without tasks) from most recent to oldest:

2.1 Installed - 13/10/2011 10:53:26
2.0 Installed - 12/10/2011 11:59:03
...

If a version has been updated it should show that:

2.1 Installed - 13/10/2011 10:53:26, Updated - 13/10/2011 11:00:45

If the user wants to view information about the tasks that were run for each version they will get output like:

adamconnelly$ ./dbversion.sh history --showTasks
2.0 Installed - 15/10/2011 21:05:14, Updated - 15/10/2011 21:05:14
  ddl.sql - 15/10/2011 21:05:14
1.0 Installed - 15/10/2011 21:04:39, Updated - 15/10/2011 21:04:39
  data/users.sql - 15/10/2011 21:04:39
  data/books.sql - 15/10/2011 21:04:39
  data/authors.sql - 15/10/2011 21:04:39
  schema/ddl.sql - 15/10/2011 21:04:39

Options:

  * Connection string, dialect, etc.
  * -v, --version The version you wish to get the history for.
  * -t, --showTasks A flag indicating whether tasks should also be output.
  * -o, --order [ascending, descending] The order the information should be displayed. Defaults to descending.

[Colin Winning (colinwinning)]

To have an extra option to display the tasks (or last task) run for that version would also be useful.

[Adam Connelly (adam-rpconnelly)]

Sure, do you fancy mocking up what the options could be and roughly
how the output might look?

On 10 Oct 2011, at 21:30, Colin Winning <email address hidden> wrote:

> To have an extra option to display the tasks (or last task) run for that
> version would also be useful.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/838405
>
> Title:
> Current version command
>
> Status in DB Version:
> New
> Status in DB Version trunk series:
> New
>
> Bug description:
> Create a command to get the current version of a database. The usage
> should be:
>
> dbversion current-version [options]
>
> The options will be connection information and any properties.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dbversion/+bug/838405/+subscriptions

[Adam Connelly (adam-rpconnelly)]

Renamed to History Command and added some extra information about how it could work.

[Adam Connelly (adam-rpconnelly)]

I changed the --verbosity switch to -t, --showTasks because I realised it could interfere with the logging verbosity stuff when Colin adds it.