package jimm.datavision.testdata.oracle;
import jimm.datavision.testdata.Office;
import jimm.datavision.testdata.Job;
import jimm.datavision.testdata.AggregateTestData;
import java.util.Iterator;
import java.util.Calendar;
class CreateData {
public static void main(String[] args) {
System.out.println("delete from office;");
for (Iterator iter = Office.offices(); iter.hasNext(); ) {
Office o = (Office)iter.next();
System.out.println("insert into office values (" + o.id + ", '"
+ o.name + "', '" + o.abbrev + "', '" + o.fax
+ "', '" + o.email + "', '"
+ (o.visible ? 'Y' : 'N') + "');");
}
System.out.println("delete from jobs;");
for (Iterator iter = Job.jobs(); iter.hasNext(); ) {
Job j = (Job)iter.next();
System.out.println("insert into jobs values (" + j.id + ", '"
+ j.title + "', " + j.fk_office_id + ", '"
+ j.company + "', '" + j.location + "', '"
+ j.description + "', '"
+ (j.visible ? 'Y' : 'N') + "', to_date('"
+ j.post_date.get(Calendar.YEAR) + '-'
+ (j.post_date.get(Calendar.MONTH) + 1) + '-'
+ j.post_date.get(Calendar.DATE)
+ "','yyyy-mm-dd'), "
+ (j.hourly_rate == null ? "NULL"
: j.hourly_rate.toString())
+ ");");
}
System.out.println("delete from aggregate_test;");
for (Iterator iter =
AggregateTestData.aggregateTestData("../aggregate_test.dat");
iter.hasNext(); ) {
AggregateTestData data = (AggregateTestData)iter.next();
System.out.println("insert into aggregate_test values ('" + data.col1()
+ "', '" + data.col2() + "', " + data.value()
+ ");");
}
}
}