Author Archives: pgfeldman

Phil 2.24.2010

8:00 – 5:30

  • Working on moving scripting framework from sandbox to development – done. Had to upgrade from Jython 2.5.0 to 2.5.1 to work with the javax.script package.
  • Added junit to the ScriptRunner class. What’s happening to me?!
  • Need to add some hooks for slide shows
  • Wrote up a description of current Feldman Project work for Mike Fortier
  • Talked to Dong about the scripting engine. We came up with the idea of a “censor” that would only allow access to specified classes, or even prevent all class access, while placing the allowed “from” clauses in before the code runs…
  • Need to see how to read and publish to URLs.

Dong 02.23.2010

  • added userinfo.xml to set login info; debug only
  • installed and tested DBFormBuilder on laureldemo; wrong database name was specified on install yesterday….
  • created Admin – edgeDemo on the server at laureldemo for demo purpose.
  • mavenized server code – com.fgm.FormBuilder

Phil 2.23.2010

8:00 – 4:30

  • Had a meeting with Anne G – she’d like to write an (marketing-style) article about VISIBILITY. Also, she really likes the idea of slide shows. I’m thinking that these could be stored in the user’s profile XML?
  • Talked to Anita Komlodi about PhD program
  • 2:00 demo at Infotek
  • Breaking out some of Visibility. Utils and DBaccess? Basically the generalized stuff that can be used on other projects
  • Need to add some interfaces to Jython that are set by a properties file
    • Read data from somewhere (i.e. LDAT)
    • Create/Delete/Modify tables – will need some user protections
    • Add data to tables
    • Read from tables
    • Write XML to a named location

Phil 2.22.2010

8:00 – 4:00

  • Terrible traffic today in the neighborhood. Scohol is open on time again
  • Talked to Chris DeVito (Thom’s mom) about building a database that would indicate smuggling flows from documents in the public domain. She’s going to get us a point of contact
  • Demo this morning – need to put in some real (looking) data and re-demo soon
  • Back to Jython. Got some good interprocess communication going!
  • Got a return call from Anita Komlodi (410-455-3206) Hall back tomorrow at 9:30 re HCI PhD

Dong 02.22.2010

  • Alert interface working. Currently just update the timestamp for now. Actual email/scripting interface need to be added.
  • deployed the DBFormBuilder to laureldemo, but database doesn’t want to behaving; straight select sql does not work….
  • demo
  • fixed a bug failing to save the form inputs
  • cleaned up FormViewerCanvas to display data from FormViewerPanel (less code) instead of calling server for more data

Phil 2.19.2010

7:30 – 4:00

Phil 2.18.2010

7:30 – 4:00

  • So I go and deply the new VISIBILITY system and the group dashboards aren’t working. I come back, run the debugger, and find that the TableListNames is null. Turns out I commented it out yesterday when I was working on fixing the AccountsManager problem yesterday. Sigh. Burn a new disk.
  • Pinging Doug Yeager on his Groovy? remote object. Still looking at Jython for the time being.
  • Going to stick with Jython for the time being at any rate. Doug’s code is minimal on the (Non RemoteObject) Java side and doesn’t deal with host access in the ways that we (think?) we need to.

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

Phil 2.17.2010

7:00 – 4:30

  • Meeting with Duncan Witte this morning
  • Changed some of the S2F XML to reflect organizational changes
  • Uploaded the new Visibility code, but will deploy tomorrow
  • Adding role tracking to TrendWidget. If a role is not supported, auto update should be turned off
  • Need to look into Jython scripting support.
  • Found a bug that I had added when I had been messing with getAllUsers(). Fixed.
  • Burning a new disk

Dong 02.17.2010

  • 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

Dong 02.16.2010

  • 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()

Phil 2.16.2010

7:30 – 4:00

  • Swung by the fort. It’s still there and everything is working. Burn a disk and deploy tomorrow. Lots of changes – that should be *fun*
  • Meeting with Duncan Witte tomorrow at 0800. Jim Murphy also wants to come over to Edge to see what we’ve got.
  • Need to make sure that panels don’t load data that the user doesn’t have the role to see.
  • Discovered that the method that we were using for getting role hierarchy information, DbRemoteObjectgetMetaEntryList() was not returning tables that were under the user’s role hierarchy. Switching to UsersAndRoles.getUserTables().

Dong 02.15.2010

  • 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