Dong Shin 04.29.2013

  • debugging Tomcat webapps via Eclipse
  • continue working on FA
    • cleaning up and consolidating database
      • DELETE FROM budget_centers WHERE project_id NOT IN (SELECT uid FROM projects)
      • DELETE FROM budget_amounts WHERE budget_center_id NOT IN (SELECT uid FROM budget_centers)
      • update budget_centers table with budget_amounts data
        • UPDATE budget_centers c1
          INNER JOIN (
          SELECT a.budget_center_id as budget_center_id, begin_year + a.year – 1 AS fiscal_year_new, a.amount AS total_budget_new
          FROM projects p, budget_centers c, budget_amounts a
          WHERE a.amount <> 0
          AND p.uid = c.project_id
          AND c.uid = a.budget_center_id) T ON c1.uid = t.budget_center_id
          SET fiscal_year = t.fiscal_year_new, total_budget = total_budget_new
      • DROP TABLE budget_amounts
      • DELETE o.* FROM `obligations_outlays` o INNER JOIN budget_centers c

        ON o.funding_id = c.uid AND o.year <> c.fiscal_year;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.