CellProfiler/CellProfiler — Issue #300: ExportToDatabase: Create view (if appropriate) for separate obj tables
Author: braymp
Created: 2012-03-05 11:27:15+00:00
State: open
Labels: Current, Feature request

If using MySQL or SQLite, and if the user selects "Separate tables per object", ask whether they want a view created post-run.

Check the per-image counts of the objects selected (perhaps for 10 randomly picked images?) If the selected object counts don't match, warn on the object selection setting that the view won't work unless the appropriate objects are picked.

The view should have the standard combined per-obj table name, i.e., "_Per_Object"

If a properties/workspace file is requested, write files for the view with the standard "_Per_Object" nomenclature.

Can use the create_view_from_props_file.py script in the \i\a\scripts folder as a template.