BIND 10 #963: Utility to upgrade SQLite schema

[BIND 10 Development]

#963: Utility to upgrade SQLite schema
-------------------------------------+-------------------------------------
                   Reporter:  shane  |                 Owner:  UnAssigned
                       Type:         |                Status:  reviewing
  enhancement                        |             Milestone:
                   Priority:         |  Sprint-20120320
  medium                             |            Resolution:
                  Component:  data   |             Sensitive:  0
  source                             |           Sub-Project:  DNS
                   Keywords:         |  Estimated Difficulty:  0.0
            Defect Severity:  N/A    |           Total Hours:  0
Feature Depending on Ticket:         |
  sqlite schema upgrade              |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
Changes (by stephen):

 * owner:  stephen => UnAssigned
 * status:  assigned => reviewing


Comment:

 Now being done as a separate ticket in an attempt to get the utility
 finished before the end of the sprint.

 Although the idea was to write the update in shell script, Python was used
 to provide some better error handling.  The branch is ready for review
 now, although the documentation has not yet been written  Depending how
 urgent this utility is required, it may be necessary to defer the
 documentation to another ticket.  A description of the operation of the
 utility can be found in the header of the Python file.

 A few points:
 * The utility is named "b10-dbutil" and it is intended to place this in
 the "bin" directory.  A name like "upgrade_database" was avoided because
 of the suggestion that the program would upgrade the database whatever
 flags were supplied. "b10-dbutil" suggests "database utilities" and it
 would be natural to extend this should additional database maintenance
 functionality be required.
 * The tests are written in shell script; some tests (such as comparing two
 database schema) looked a bit awkward in Python.
 * As this is a command-line utility (as opposed to a daemon process), it
 was not felt necessary to use the logging framework for messages.

-- 
Ticket URL: <http://bind10.isc.org/ticket/963#comment:6>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development