Make it Easier to Find Checked Out Releases

[rlhelinski]

• Add a 'checkedout' column to the releases table. This can be true or false.
• Write a script for adding this column to the database
• Add a dialog or a filter to list only checked out releases

[rlhelinski]

A list of all the releases that have ever been checked out can be compiled with: c.cm.executeAndFetch('select distinct(release) from checkout_events')

[rlhelinski]

A list of only releases that are currently checked out can be compiled with:

relIds = c.cm.executeAndFetch('select distinct(release) from checkout_events')
for relId in relIds:
    if c.getCheckOutStatus(relId[0]):
        print (relId[0], c.getReleaseArtist(relId[0]), c.getReleaseTitle(relId[0]), c.getCheckOutStatus(relId[0]))

[rlhelinski]

sqlite> alter table releases add column checkedout REFERENCES checkout_events(ROWID);

Then, to populate this new column as appropriate:

results = c.cm.executeAndFetch('select distinct(release), rowid from checkout_events')
for relId, rowId in results:
    if c.getCheckOutStatus(relId):
        print (relId, rowId, c.getReleaseArtist(relId), c.getReleaseTitle(relId), c.getCheckOutStatus(relId))
        c.cm.execute('update releases set checkedout = % where id = %', (rowId, relId))