Category Archives: Dong Shin

Dong 02.18.2010

adjusted query to return list of forms in FormViewer that the user has access to; owned and has user privileges
installed mediaWiki on laureldemo @ http://laureldemo.edge-technologies.com:8080/wiki/ – not sure if we want to use it….
found a project management tool; trac, it looks like what we wanted, but cannot get Python to behave with XAMPP on laureldemo. on hold.
added alert_status, alert_frequency, alert_last_run to forms table for Alert Management
FormAlertMgmtCanvas added to FormMgmtPanel

FormUsersDG is now shared by FormUserMgmtCanvas and FormAddUsersCanvas
status field added to forms table to indicate published/unpublished
FormUserPanel changed to FormMgmtPanel to handle publish/unpublish of the forms addition to the form users management
all panels now are disposed upon logout
fixed a bug not creating user information when all the fields are not filled.
double click enabled for user updates on UserMgmtPanel – brings up Update User Information

FormUsersMgmtCanvas and FormAddUsersCanvas added and quite functional. add and delete users from form
added queries setter to DatabaseSQL.as to support for multiple inserts and others.
combined primary key is needed for proper insertion and deletion for forms_users table
- CREATE TABLE IF NOT EXISTS `forms_users` (
  `forms_id` int(11) NOT NULL,
  `user` varchar(256) NOT NULL,
  PRIMARY KEY (`forms_id`,`user`)
  ) ENGINE=MyISAM DEFAULT CHARSET=armscii8;
- this limits the duplicate records when using INSERT IGNORE, regular INSERT generates error when duplicates are found
created view; view_users, for easy query build
- create view view_users as select db.user as ‘User ID’, full_name as Name, Description, email, contact_information as ‘Contact Info’,
  if (strcmp (grant_priv, ‘Y’), if (strcmp (create_priv, ‘Y’), ‘FORM USER’, ‘FORM OWNER’), ‘ADMIN’) AS ‘User Level’
  from mysql.db LEFT JOIN mysql.user_info on (db.user = user_info.user) WHERE db=’formbuilder’
side-tracked to Visibilit 2 bug tracking…..
- DatabaseIf.getTablesInfo (user) not working properly, removed and put UsersAndRoles.getUserTables()

Presidents’ Day – working at home
added emptyField to DatabaseComboBox to set top of the ComboBox to blank
queries can now be saved to forms_query table from QueryBuilderPanel
clear button added to clean out all query building components (queryFields, queryTextArea, queryResultDG) from QueryBuilderPanel
separated TabNavigator from QueryViewPanel – DatabaseTabNavigator
QueryViewer is operational supporting basic SELECTs saved in form_query table
added owner (user id) field to forms table that is mapped to user logged in when a form is saved.
DBFormBuilder now has DATABASE_TO_INCLUDE and TABLES_TO_IGNORE to filter out unnecessary databases and tables from database tree views
started on FormUserPanel for form users management

cleaned up DataTypes.as
set default data type to VARCHAR in TableMgmtDG
separated all inline item renderers from TableMgmtDG and put in renderers directory
tested IngestManager with Phil’s new changes; seems to be working fine…
having weird problem with TableMgmtDG again….. It seems that the reloading of the same table wipes out the TextInput enable/disable control. Tried various things; cleaning out dataProvider, invalidateEVERYTHING. It looks like the DataGrid controls keeps haunting me. Ugh!
resolved the above problem by setting the enabled property explicitly by looking at the “VARCHAR” in data setter. The problem is that sizeEnabled = true in DataTypes in initialization and the ItemRenderer and DataGrid doesn’t want to create new components for the new data provider if there is existing components! It just replaces the data for existing components and creates new ones if new rows are needed.

Spent some time trouble shooting TableMgmtDG’s ComboBox item renderer; turned out, overriding of data setter and IList(DataGrid(owner).dataProvider).itemUpdated(this.selectedIndex) are required to properly update the datagrid’s all components (item renderers).
Fixed a bug not updating table structrures
Enabled the changing of existing table structure, but decided to leave it for later

validator for date and time format on DataEditorField using 2009-08-24 13:01:36.0 format returned from MySQL
rework CreateTableCanvas and ManageTableCanvas for new layout and added icons
added uid for CreateTableCanvas, but decided to make it invisible for both creation and modification
trouble shooting the TableMgmtDG not working correctly; whenever data type changes, cannot get the size to update correctly.

cleaned up in DBFormBuilder and other panels to use default width and height of 100%
fixed datagrid displaying the columns in wrong order by pre-setting the column headers
need to figure out how to set column header for DatabaseList
basic layout and navigation of data complete for DataEditorPanel
started on DataEditorWindow

added Rebuild Database to main menu
- only accessible through root account
added createDatabase to re-create the database structure
fixed a bug in TableManagement; unable to change field type on new tables
working on table data editor
- DataGrid editor or individual record editor?
- this requires an unique id for each record
- started with individual record editor

added executeMultiple to Query to handle set of SQLs to be executed, this cuts down number of response event handlers.
created SQLIf to generalize SQLs
tested creating and exploring database views…. not very workable on inserting

moved and changed the Form Builder requirements to spreadsheet so it can be tracked easier…
user search added to UserManagement panel and main menu
user registration added
- UserManagement – may not belong here
- LoginScreen
- currently sets the user at User Level.
started on Alerting schema…..

create table to include only formbuilder database
rearrange TableMgmtPanel
copied visibility_dev tables to formbuilder database
reconstructed SQL for retrieving user information to contains LEVELs instead of all different info.
User Management panel is now fully functional
added title to Form Wizard
delete form added to FormViewer