64bit/Database - Revision history

Dave: /* Milestones */

2020-07-28T20:54:48Z

Milestones

← Older revision		Revision as of 20:54, 28 July 2020
Line 64:		Line 64:
	### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>		### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### issue tracking now [https://trello.com/b/aMQck3ko/db-issue-tracker\|has it's own page]		### issue tracking now [https://trello.com/b/aMQck3ko/db-issue-tracker has it's own page]
	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2:

Dave: /* Milestones */

2020-07-28T20:54:36Z

Milestones

← Older revision		Revision as of 20:54, 28 July 2020
Line 64:		Line 64:
	### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>		### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### issue tracking now [[https://trello.com/b/aMQck3ko/db-issue-tracker\|has it's own page]]		### issue tracking now [https://trello.com/b/aMQck3ko/db-issue-tracker\|has it's own page]
	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2:

Dave: /* Milestones */

2020-07-28T20:54:22Z

Milestones

← Older revision		Revision as of 20:54, 28 July 2020
Line 64:		Line 64:
	### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>		### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### issue tracking now [[~~64bit~~/~~Database~~/~~questions~~\|has it's own page]]		### issue tracking now [[https://trello.com/b/aMQck3ko/db-issue-tracker\|has it's own page]]
	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2:

Dave: /* Milestones */

2020-07-28T20:33:00Z

Milestones

← Older revision		Revision as of 20:33, 28 July 2020
Line 64:		Line 64:
	### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>		### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### fixed: <strike>currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(). Can this be done in an optimized way, via lookup, rather than via iteration?</~~strike>~~		### issue tracking now [[64bit/Database/questions\|has it's own page]]
	~~### in >>MenuItemIndex ValueToPopupItem()<< you did a check for valid integer. in what case is this triggered?~~
	~~### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()~~
	~~### also i would like popup menus within the table view to LOOK like popup menus~~
	~~### when editing, pressing “escape” should cancel the edit~~
	~~### if you select something, then scroll to the bottom of the list, the selected item appears at the bottom of the list~~
	~~### can you explain KJDatabase, line 534, where you hide a selected item from the table view?~~
	~~### when the app first starts up, the table view~~ has ~~"focus" but does not DRAW as if~~ it ~~has focus, it draws as if it does NOT have focus, ie: selected rows draw "gray" instead of the saturated hilight color~~
	~~### why is widget id_20 embedded inside widget_3?~~
	~~### for "every other" row coloring, use OS Accent color as was previously done in CKJController::InitTable_Tracks()~~
	### when clicking to edit anything other than inline text, do NOT select. (the act of clicking on a text will cause the row to select but you may have a multiple selection). when anything does go to edit (eg: a text edit, popup menu, checkbox etc), do NOT deselect any other rows. from the mailing list: "The selection is normally handled by an internally allocated QSelectionModel, which maintains the current item separate from the selections. You can replace the selection model if necessary. In this case, you want the current item to change, but not the selections, depending on which column was clicked, or whatever other condition. You may need to override the view and/or change the selection model to intercept the calls between them. Then you modify the parameters to force them to only change the current."
	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2:

Dave: /* Milestones */

2020-07-28T18:08:34Z

Milestones

← Older revision		Revision as of 18:08, 28 July 2020
Line 57:		Line 57:
	## familiarize self with code base (This may take two weeks!). ask questions.		## familiarize self with code base (This may take two weeks!). ask questions.
	## ensure loading a playlist with hundreds of thousands of items is instant (switching between playlists, remembering previous search)		## ensure loading a playlist with hundreds of thousands of items is instant (switching between playlists, remembering previous search)
	~~### why is widget id_20 embedded inside widget_3?~~
	~~### for "every other" row coloring, use OS Accent color as was previously done in CKJController::InitTable_Tracks()~~
	### fixed: <strike>scroll bar pagination is by (10) instead of by (current number of visible rows - 1)</strike>		### fixed: <strike>scroll bar pagination is by (10) instead of by (current number of visible rows - 1)</strike>
	### fixed: <strike>shows max 60 rows instead of all rows that will fit</strike>		### fixed: <strike>shows max 60 rows instead of all rows that will fit</strike>
Line 73:		Line 71:
	### if you select something, then scroll to the bottom of the list, the selected item appears at the bottom of the list		### if you select something, then scroll to the bottom of the list, the selected item appears at the bottom of the list
	### can you explain KJDatabase, line 534, where you hide a selected item from the table view?		### can you explain KJDatabase, line 534, where you hide a selected item from the table view?
			### when the app first starts up, the table view has "focus" but does not DRAW as if it has focus, it draws as if it does NOT have focus, ie: selected rows draw "gray" instead of the saturated hilight color
			### why is widget id_20 embedded inside widget_3?
			### for "every other" row coloring, use OS Accent color as was previously done in CKJController::InitTable_Tracks()
	### when clicking to edit anything other than inline text, do NOT select. (the act of clicking on a text will cause the row to select but you may have a multiple selection). when anything does go to edit (eg: a text edit, popup menu, checkbox etc), do NOT deselect any other rows. from the mailing list: "The selection is normally handled by an internally allocated QSelectionModel, which maintains the current item separate from the selections. You can replace the selection model if necessary. In this case, you want the current item to change, but not the selections, depending on which column was clicked, or whatever other condition. You may need to override the view and/or change the selection model to intercept the calls between them. Then you modify the parameters to force them to only change the current."		### when clicking to edit anything other than inline text, do NOT select. (the act of clicking on a text will cause the row to select but you may have a multiple selection). when anything does go to edit (eg: a text edit, popup menu, checkbox etc), do NOT deselect any other rows. from the mailing list: "The selection is normally handled by an internally allocated QSelectionModel, which maintains the current item separate from the selections. You can replace the selection model if necessary. In this case, you want the current item to change, but not the selections, depending on which column was clicked, or whatever other condition. You may need to override the view and/or change the selection model to intercept the calls between them. Then you modify the parameters to force them to only change the current."
	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)

Dave: /* Milestones */

2020-07-28T15:21:55Z

Milestones

← Older revision		Revision as of 15:21, 28 July 2020
Line 66:		Line 66:
	### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>		### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(). Can this be done in an optimized way, via lookup, rather than via iteration?		### fixed: <strike>currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(). Can this be done in an optimized way, via lookup, rather than via iteration?</strike>
	### in >>MenuItemIndex ValueToPopupItem()<< you did a check for valid integer. in what case is this triggered?		### in >>MenuItemIndex ValueToPopupItem()<< you did a check for valid integer. in what case is this triggered?
	### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()		### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()

Dave: /* Milestones */

2020-07-26T19:37:08Z

Milestones

← Older revision		Revision as of 19:37, 26 July 2020
Line 63:		Line 63:
	### fixed: <strike>dragging thumb to bottom of tall list seems incorrectly calibrated</strike>		### fixed: <strike>dragging thumb to bottom of tall list seems incorrectly calibrated</strike>
	## get rid of "QSortFilterProxyModel" entirely. use "QSqlRelationalTableModel" directly		## get rid of "QSortFilterProxyModel" entirely. use "QSqlRelationalTableModel" directly
	### ~~to fix~~: when sorted by anything other than "PLI", scroll bar has beach balls		### fixed: <strike>when sorted by anything other than "PLI", scroll bar has beach balls</strike>
	### especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder		### fixed: <strike>especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder</strike>
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(). Can this be done in an optimized way, via lookup, rather than via iteration?		### currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(). Can this be done in an optimized way, via lookup, rather than via iteration?

Dave: /* Milestones */

2020-07-26T19:34:38Z

Milestones

← Older revision		Revision as of 19:34, 26 July 2020
Line 66:		Line 66:
	### especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder		### especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
	### currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID()~~, which works~~. ~~can you please fill~~ in ~~the first one, in the most~~ optimized way ~~you can?~~		### currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(). Can this be done in an optimized way, via lookup, rather than via iteration?
	~~### second~~, ~~in SelectSongTableForScroll(): there's a section i have commented as being "HORRIBLY inefficient". please make that faster~~? ~~there must be a way~~		### in >>MenuItemIndex ValueToPopupItem()<< you did a check for valid integer. in what case is this triggered?
	### when clicking to edit anything other than inline text, do NOT select. (the act of clicking on a text will cause the row to select but you may have a multiple selection). when anything does go to edit (eg: a text edit, popup menu, checkbox etc), do NOT deselect any other rows. from the mailing list: "The selection is normally handled by an internally allocated QSelectionModel, which maintains the current item separate from the selections. You can replace the selection model if necessary. In this case, you want the current item to change, but not the selections, depending on which column was clicked, or whatever other condition. You may need to override the view and/or change the selection model to intercept the calls between them. Then you modify the parameters to force them to only change the current."
	### in >>MenuItemIndex ValueToPopupItem()<< you did a check for valid integer. in what case is this triggered?
	### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()		### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()
	### also i would like popup menus within the table view to LOOK like popup menus, ~~i think i said that before~~?		### also i would like popup menus within the table view to LOOK like popup menus
			### when editing, pressing “escape” should cancel the edit
			### if you select something, then scroll to the bottom of the list, the selected item appears at the bottom of the list
			### can you explain KJDatabase, line 534, where you hide a selected item from the table view?
			### when clicking to edit anything other than inline text, do NOT select. (the act of clicking on a text will cause the row to select but you may have a multiple selection). when anything does go to edit (eg: a text edit, popup menu, checkbox etc), do NOT deselect any other rows. from the mailing list: "The selection is normally handled by an internally allocated QSelectionModel, which maintains the current item separate from the selections. You can replace the selection model if necessary. In this case, you want the current item to change, but not the selections, depending on which column was clicked, or whatever other condition. You may need to override the view and/or change the selection model to intercept the calls between them. Then you modify the parameters to force them to only change the current."
	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2:

Dave: /* Milestones */

2020-07-26T15:32:01Z

Milestones

← Older revision		Revision as of 15:32, 26 July 2020
Line 72:		Line 72:
	### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()		### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()
	### also i would like popup menus within the table view to LOOK like popup menus, i think i said that before?		### also i would like popup menus within the table view to LOOK like popup menus, i think i said that before?


	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2:

Dave: /* Milestones */

2020-07-26T15:31:30Z

Milestones

← Older revision		Revision as of 15:31, 26 July 2020
Line 66:		Line 66:
	### especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder		### especially ensure that "[[User Sort Order]]" scrolls as smoothly as PLI, and that drag and drop works to reorder
	## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)		## custom table view controls (colorized rows, checkbox, popup menu, color picker, star ratings, timecode, date-time)
			### currently on screen is a function PLI_ID_to_ModelRowIndex(), which does the opposite of the below function ModelRowIndex_to_PLI_ID(), which works. can you please fill in the first one, in the most optimized way you can?
			### second, in SelectSongTableForScroll(): there's a section i have commented as being "HORRIBLY inefficient". please make that faster? there must be a way
			### when clicking to edit anything other than inline text, do NOT select. (the act of clicking on a text will cause the row to select but you may have a multiple selection). when anything does go to edit (eg: a text edit, popup menu, checkbox etc), do NOT deselect any other rows. from the mailing list: "The selection is normally handled by an internally allocated QSelectionModel, which maintains the current item separate from the selections. You can replace the selection model if necessary. In this case, you want the current item to change, but not the selections, depending on which column was clicked, or whatever other condition. You may need to override the view and/or change the selection model to intercept the calls between them. Then you modify the parameters to force them to only change the current."
			### in >>MenuItemIndex ValueToPopupItem()<< you did a check for valid integer. in what case is this triggered?
			### why do you prefer using the less optimized method of getting the labelValueI in CustomItemDelegate::paint()
			### also i would like popup menus within the table view to LOOK like popup menus, i think i said that before?


	## optimize initial database load (delete .ksql file, cause rebuild, with large library)		## optimize initial database load (delete .ksql file, cause rebuild, with large library)
	# Section 2:		# Section 2: