Community
Participate
Working Groups
Developers should be able to create entity records by selecting 1 or more tables for a database connection defined in the workspace. This function should be exposed via the EGL New Record wizard.
Checked code in CVS under this bug. Known issues: 1) Strings in the new SQL wizard and page have not been NLSed -- need to be added to appropriate properties files. Same is true for new part template defined in plugin.xml of edt.ide.ui. 2) eglx.persistence.sql import statement needs to be added to new record file(s). Not sure where in the code this should be done -- doesn't seem correct to do in the wizard. Should be part of the generator that takes DataTools objects and produces EGL source. 3) Not all column annotation fields in the 0.1 spec are being handled (e.g. insertable , updateable). 4) Wizard does not nicely handle situation where an improperly configured database connection is selected in the Database Tables page. For example, if the password is not specified in the connection settings, selecting the connection from the drop-down results in a Problem occurred dialog being displayed. We really should open the Connection configuration dialog for the connection. 5) "Qualify tables names with schema" checkbox has no effect. Do we still need this? Think so. 6) "Save data source to DD" checkbox has no effect. This will need to be implemented once the design for data sources is finalized. 7) Preferences for how db columns are mapped to EGL types and how column names are formatted are not being honored (see EGLSQLRetrieveUtility.setItemNameControlOptionsBasedOnSQLPreferences)
Will, you are still the owner of this enhancement, would you like to continue working on it or assign the coding work to ZhuZhi while you still work on the design and requirement.
Assign to ZhuZhi.
Implement 1,3,4,5,6,7; for Item 2, need underlying implementation. BindingSQLDatabaseConfiguration EGLDDBindingWizard SQLDatabaseBindingWizardPage EGLDDBindingConfiguration BindingSQLDatabaseConfiguration ServiceBindingWizardPage EGLDDRootHelper RecordFromSqlDatabaseWizard --- add much ServiceOperation ---getEGLDDFileHandle() DBModelingUtil.getDefinition() EGLSQLRetrieveUtility.populateStructureItem EGLSQLRetrieveUtility.resolveToEGLType
fix it
close it
