Remarks on Integration:

As discussed earlier, once we have the controller skeleton up (SDA1 Team), each one of you can download a copy and put into your own public_cgi sub-dir. Then, you can do your own independent testing of your executables on your copy of IDEA. Please do careful testing to make sure it is correct.

After that, you should email a copy of the source and executables to the SDA1 group -- who will then "install" your executables into the IDEA project account --- uit2201p.

---

IDEA Database (SDA3 Team)

   % source /opt/oracle/bin/oraenv
   % sqlplus 
       then login with userid and password

   > select table_name from user_tables;      
       {lists out all the tables in the account}
   > select * from names;
       {list all entries in table names}
   > insert into names (userid,username) values (3,'leonghw');
       {insert an entry into the table} 

The SDA3 Team will be responsible for designing the tables in the database and for publishing the schema for these tables, and also populating the tables with records. They may need help from some of the Feature Implementation people...

At the moment, there is a sample table called "Names" with schema {userid,username} and very few records. When I did a query, I got the following:

>select * from names

    USERID USERNAME
---------- --------------------
         1 Samantha
         2 Michael
         3 leonghw 

A Note for the Feature Implementation People:

Since most of the people doing Feature Implementation are familiar with Java, we have provided Java sample program (CheckName.java) to interface with Oracle and doing query. Each of you will need to first establish an Oracle connection via the dbManager (a custom class written for this project). Then, it does an sql query "select * from names", then "catches" the output, and checks the name is in it.

(Of course, to list all entries in the table, you can just also just print out the output is caught. You can use this CheckName.java as a sample to play around with it using other sql queries.)

---

IDEA GUI Generation

After receiving the output from the IDEAFeatureEngine programs, the controller parses the results and then calls the appropriate GUI-generation programs to generate the correct GUI (html page).

In this sample, we provide two mechanisms to do this:

• Using a pre-prepared output page.
  In the sample, we gave four such files
  • results1.html -- used by do_result_1 in sample controller
  • results2.html -- used by do_result_2 in sample controller
  • results3.html -- used by do_result_3 in sample controller
  • results4.html -- used by do_result_4 in sample controller
  In this case, the perl function merely reads in the html file and output it. If there are some results that has to be displayed, the original html file can contain special_tags that can be "replaced" by output strings obtained, before printout out.

• Using a function that will directly print out the html page with the appropriate output string embedded.
  This is illustrated in by do_result_5 in sample controller