witmoca / beats Goto Github PK

It's possible to edit a cell without it being selected (JTable standard behaviour).
This is a little confusing for users, as the difference between user typed characters and auto-complete generated characters aren't shown. This also results in the character selection (containing said auto-complete characters) not being differently coloured.

This makes the CellEditors behaviour seem a bit off, although it is perfectly logical.
The UI just doesn't make it clear enough.

A look into trying to force the table selection might be in order.

• Create Section
• Auto-suggest default values based on current Date & last episodeId (based on todays date, last episodeId)
• Integrate creation of a new episode into archival screen (create episode dialog becomes obsolete)
• Integrate creation of section codes into the archival screen

A 'Catalog' that displays:

• Most populair songs
• Most populair artists

• Search box => uses RowSorter.setRowFilter to display results

Add a popupmenu to the currentqueue that contains actions pertaining to the selected item in the queue

• Row index
• Rowsorter
• Multicolumn priority support for Rowsorter
• Pick and choose the shown columns

Rename the artist (all occurrences)

• Call recovery manager
• Check the arguments for a loadable db
• Create & load the db
• Create the GUI
• Control access to globally required objects

• Add entry toolbar
• display Dialog
• Show Comment
• Show Song stats
• Show Artist stats

• Copy from archive
• Cut from playlist
• Copy from playlist
• Paste to playlist
• Java Clipboard class
• Visible Clipboard (South component ?)

• Detect if artist & song are the database
• Display last time the song was played (ID + date)
• Display last time the artist was played (ID + date + song)
• Display if band is local
• Display the count(title) & count(artistName)

• Create an editor based upon the existing AutoCompletingEditor that extends it by adding a dropdown menu.
• Populate this menu based upon IMatcher data
• Decide if forwardOnly is necessary and whether or not full Substring analysis should be used instead of matching only by the start of the string

Steps to reproduce:

• Import a .wwdb file
• Before the import is completed, click a ui object (another tab on the centerTabbedPane e.g.)
• ConcurrentModificationException is thrown
  This happens, but not consistently. The logical suspect is a race condition

• Rename playlist
• Change playlist order
• Add Playlist
• Delete Playlist

The DB provides lock-file implementation on it's own. So a single instance is practically guaranteed.
But, the second instance should be able to message the first one to open up a new file.

• Built in print of JTable
• Built in print functionality of java
  Combine into a simple playlist printing functionality

A system that

• logs errors
• stops application execution if necessary
• possibly recovers/restarts it
• notifies the user if necessary
• translates ConnectionException to human readable text and dialogs

• Automated Backups
• Reset to backup dialog/tool

When one entry is edited (UPDATE or DELETE) all identical ones follow.

• Move to CurrentQueue (played song)
• Delete

Prefixes in playlists don't get filtered on wwdb1 import

• Detect remaining file after forced shutdown
• Validate & Recover said file
• Notify user of recovery

• Associate .BEATs format on windows with application
• Associate .BEATs format on linux with .jar runnable
• Handle a mulitple application instance scenario by opening the newly loaded file in the existing appwindow instead

Handy tools & on-the-spot fixes

• Refresh Screen (full GUI)
• rename all occurences of an artist
• rename all occurences of a song
• change date belonging to an episode
• check for episodeId continuity

• Filter on playlist entry
• Filter on search

• Using DataFlavor(class, string) create dataflavors for every source (archive, cpp, playlist).
  See https://stackoverflow.com/questions/3060905/how-to-find-out-the-drag-source-component-in-the-drop-target-transferhandler

• Make CCP/DnD operation unacceptable when source and target are the same

• The rowid of the CCP table doesn't get used. Deletion from CCP still happen by (artist,song,comment). Identical entry all get deleted because of this

For example:
DnD'ing from CCPPanel to CCPPanel deletes the dragged objects (being removed in exportDone cleanup)

Unexpected effects also possible with playlists

An unsorted Archive results an a quasi-sorted table.
Users assume that it's sorted, with confusion as a possible consequence.

• Remove unsorted functionality for archive table
• Set the default sortkeys for the archive to {Artist, Episode}

(or combine both and make the table reset to the default sortkeys on left top corner press instead of no sort)

Include an advanced tool (with the necessary warning dialogs!)

• Add a warning that asks that the user save first before starting manual edits in the console
• A JLabel (or other JTextComponent) that explains the use of the console, contains warnings, recommends the use of the Commit Button, links to sqlite.org and contains the names of handy tables/commands such as SQLITE_MASTER, etc..
• (Possibly) include a jdialog that shows all the CREATE TABLE statements used in SQLConnection (put it in a create.sql file and show that?)
• A textfield where SQL Syntax can be inputted
• A JButton that tries to execute said SQL code.
• A JTextArea (within a scrollpane) containing possible output (or error traces)
• A JButton that calls the SQLConnection.Commit() function with parameter DataChangedListener.DataType.ALL_OPTS
• A JDialog warning that opens when the console is close warning that commits MUST happen before closing the console (except on selects, etc). Include the option to cancel the closing of the dialog.

• CurrentQueue Panel
  Toolbar/Popupmenu with:
• Move back to Playlist
• Archive Queue

• Add playlist
• Remove playlist
• Move playlist order

• Create an XMLFileFilter
• Add a private importXMLFile(..) method to importFileAction
• Combine XMLFileFilter & importXMLFile into the actionPerfomed method
• Create a exportFileAction
• Link exportFileAction with export menubutton
• Add a private exportXMLFile(...) method to exportFileAction
• Combine XMLFileFilter & exportXMLFille into the actionPerfomed method

• create autosuggest GUI element
• add playlist.artist suggest functionality
• add playlist.song suggest functionality

The numbered indexes of the archive panel don't get repainted when a search term(rowsorter) changes the amount of rows displayed

• Empty row for inserting new content
• Table sorting (according to all column headers + no sort)
• Row index
• Pick and choose the shown columns

for:

• Archive
• Playlist

Displays the most populair and/or the most recent songs by an artist
Add calls from:

• InfoPanel
• Archive

• Move to another playlist
• Print playlist

• Save to Google Drive
• Load From Google Drive

Additional platforms as needed/on review

Because saving might be done multiple times (and vacuum could change rowid's),
it's best to vacuum a table right before actual use. As the file format doens't use that much space meaning that not a lot of space will be freed anyway, VACUUM before save isn't necessary.

On the other hand, VACUUM before use seems logical. As it restructures fragmented databases so speed is optimized. As the application doesn't execute a lot of DB operations (relatively, at max a couple (tens of) thousands for a session where an import is performed and much less for normal operation) it isn't necessary to do VACUUM more than once per session.

Ending a cellEdit (by way of enter or tab) causes unwanted change of selected item

Probably because of the playlist data being reloaded after change?
Both the row AND cell selected should stay the same (so a tab still goes to the next cell)

• Custom Dialog framework
• Summery View
• Select Episode
• Create Episode
• Select Section