Dong Shin 05.21.2013

  • deployed new FA and RA, found few problems
    • When Update is clicked and not all fields are filled in, we might what to pop up a dialog box saying that they are not all filled in but allowing for a save
    • Add tooltips to buttons. In particular, we need to be clear about what saves and what cancels without saving.
    • Add a “Select All” to the SQL error dialog, now that we have QUERIES FROM HELL.
    • RA error string: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExceptio: Unknown column ‘c.appropriation’ in ‘where clause’.
  • Continue working on FA/RA
    • setting up relations between projects, budget_centers, obligations_outlays tables
      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio_enh`.`projects` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
        ALTER TABLE `obligations_outlays` ADD FOREIGN KEY ( `project_id` ) REFERENCES `project_portfolio_enh`.`projects` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
        ALTER TABLE `obligations_outlays` ADD FOREIGN KEY ( `funding_id` ) REFERENCES `project_portfolio_enh`.`budget_centers` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
    • found that saving “new” project doesn’t create obligations/outlays data correctly – fixed